(高分)急求连接数据库的JAVA学生信息管理系统源代码

你要连的数据库是SQL 还是ORACLE

但是代码都查不多

下面的是连接SQL数据库的代码

你需要先创建个数据库,还有表,表的字段是登陆名和密码

下面的"SA" 是登陆名 "111111" 是密码

ORACLE 和这个查不多

import java.sql.*//做数据库时候必须要引入的包

import com.microsoft.jdbc.sqlserver.SQLServerDriver

public class DBFactory {

Connection Conn=null

PreparedStatement Stmt=null

ResultSet Rs=null

String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"

String OracleUserName="sa"

String OracleUserPwd="111111"

String ConnUrl="jdbc:sqlserver://localhost:1433databaseName=news"

public Connection getConnection()

{

try {

Class.forName(driverName)

} catch (ClassNotFoundException ex) {

System.out.println("加载驱动程序有错误")

}

try {

Conn = DriverManager.getConnection(ConnUrl, OracleUserName,OracleUserPwd)

} catch (SQLException ex1) {

System.out.print("取得连接的时候有错误，请核对用户名和密码")

}

return Conn

}

这个是连接ORACLE数据库代码

import java.sql.*

import oracle.jdbc.driver.OracleDriver

public class DBFactory {

Connection Conn=null

PreparedStatement Stmt=null

ResultSet Rs=null

String driverName="oracle.jdbc.driver.OracleDriver"

String OracleUserName="scott"

String OracleUserPwd="tiger"

String ConnUr1="jdbc:oracle:thin:@locahost:1521:Ora"

public Connection getConnection()

{

try {

Class.forName(driverName)

} catch (ClassNotFoundException ex) {

System.out.println("加载驱动程序有错误")

}

try {

Conn = DriverManager.getConnection(ConnUr1, OracleUserName,OracleUserPwd)

} catch (SQLException ex1) {

System.out.print("取得连接时有错误，请核对用户名和密码")

}

return Conn

}

希望能追加分数谢谢！

import java.awt.BorderLayout

import java.awt.CardLayout

import java.awt.Container

import java.awt.Font

import java.awt.event.ActionEvent

import java.awt.event.ActionListener

import javax.swing.Icon

import javax.swing.ImageIcon

import javax.swing.JButton

import javax.swing.JFrame

import javax.swing.JLabel

import javax.swing.JMenu

import javax.swing.JMenuBar

import javax.swing.JMenuItem

import javax.swing.JPanel

import javax.swing.JToolBar

import javax.swing.SwingConstants

public class MainFrame extends JFrame implements ActionListener{

InsertPanel ip = null

SelectPanel sp = null

JPanel pframe

JButton jb1,jb2,jb3

JMenuItem jm11,jm21,jm22,jm23,jm31,jm32,jm41,jm42

CardLayout clayout

public MainFrame(String s){

super(s)

JMenuBar mb = new JMenuBar()

this.setJMenuBar(mb)

JMenu m1 = new JMenu("系统")

JMenu m2 = new JMenu("基本信息")

JMenu m3 = new JMenu("成绩")

JMenu m4 = new JMenu("奖惩")

mb.add(m1)

mb.add(m2)

mb.add(m3)

mb.add(m4)

jm11 = new JMenuItem("退出系统")

jm21 = new JMenuItem("输入")

jm22 = new JMenuItem("查询")

jm23 = new JMenuItem("更改")

jm31 = new JMenuItem("输入成绩")

jm32 = new JMenuItem("查询成绩")

jm41 = new JMenuItem("奖励")

jm42 = new JMenuItem("处分")

m1.add(jm11)

m2.add(jm21)

m2.add(jm22)

m2.add(jm23)

m3.add(jm31)

m3.add(jm32)

m4.add(jm41)

m4.add(jm42)

Icon i1 = new ImageIcon()

Icon i2 = new ImageIcon()

Icon i3 = new ImageIcon()

jb1 = new JButton(i1)

jb1.setToolTipText("输入")

jb2 = new JButton(i2)

jb2.setToolTipText("查询")

jb3 = new JButton(i3)

jb3.setToolTipText("退出")

JToolBar tb = new JToolBar("系统工具")

tb.add(jb1)

tb.add(jb2)

tb.add(jb3)

add(tb,BorderLayout.NORTH)

jm11.addActionListener(this)

jm21.addActionListener(this)

jm22.addActionListener(this)

jb1.addActionListener(this)

jb2.addActionListener(this)

jb3.addActionListener(this)

clayout = new CardLayout()

pframe = new JPanel(clayout)

add(pframe)

JPanel mainp = new JPanel(new BorderLayout())

JLabel mainl = new JLabel("学生信息管理平台",SwingConstants.CENTER)

mainl.setFont(new Font("serif",Font.BOLD,30))

mainp.add(mainl)

pframe.add(mainp,"main")

clayout.show(pframe, "main")

}

public void actionPerformed(ActionEvent e){

if(e.getSource() == jm21 || e.getSource() == jb1){

if(ip == null){

ip= new InsertPanel()

pframe.add(ip,"insert")

}

clayout.show(pframe, "insert")

this.setTitle("输入学生信息")

}

else if(e.getSource() == jm22 || e.getSource() == jb2){

if(sp == null){

sp= new SelectPanel()

pframe.add(sp,"select")

}

clayout.show(pframe, "select")

this.setTitle("查询学生信息")

}

else if(e.getSource() == jm11 || e.getSource() == jb3){

System.exit(0)

}

}

}

第二个：

import javax.swing.JFrame

public class MainTest {

public static void main(String [] args){

MainFrame f = new MainFrame("学生信息管理平台")

f.setSize(400,300)

f.setLocation(350,250)

f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)

f.setVisible(true)

}

}

第二个：

import java.sql.Connection

import java.sql.DriverManager

public class MySQLConnection {

static Connection getCon(){

Connection con = null

try{

Class.forName("com.mysql.jdbc.Driver")

con = DriverManager.getConnection("jdbc:mysql://localhost/test","root","123")

}

catch(Exception e){

System.out.println("建立数据库连接遇到异常！")

}

return con

}

}

第四个：

import java.awt.BorderLayout

import java.awt.GridLayout

import java.awt.event.ActionEvent

import java.awt.event.ActionListener

import javax.swing.JButton

import javax.swing.JLabel

import javax.swing.JOptionPane

import javax.swing.JPanel

import javax.swing.JTextField

import javax.swing.SwingConstants

public class SelectPanel extends JPanel implements ActionListener{

JButton jb

JTextField jt

JTextField jt1,jt2,jt3,jt4

public SelectPanel(){

JLabel jl = new JLabel("请输入学号:",SwingConstants.CENTER)

jt = new JTextField()

jb = new JButton("确定")

JPanel jp1 = new JPanel(new GridLayout(1,3))

jp1.add(jl)

jp1.add(jt)

jp1.add(jb)

JLabel j1,j2,j3,j4

j1 = new JLabel("学号:",SwingConstants.CENTER)

j2 = new JLabel("姓名:",SwingConstants.CENTER)

j3 = new JLabel("性别:",SwingConstants.CENTER)

j4 = new JLabel("年龄:",SwingConstants.CENTER)

jt1 = new JTextField(6)

jt1.setEditable(false)

jt2 = new JTextField(6)

jt2.setEditable(false)

jt3 = new JTextField(6)

jt3.setEditable(false)

jt4 = new JTextField(6)

jt4.setEditable(false)

JPanel jp2 = new JPanel(new BorderLayout())

JPanel jp3 = new JPanel(new GridLayout(4,2))

jp2.add(new JLabel(""),BorderLayout.NORTH)

jp3.add(j1)

jp3.add(jt1)

jp3.add(j2)

jp3.add(jt2)

jp3.add(j3)

jp3.add(jt3)

jp3.add(j4)

jp3.add(jt4)

jp2.add(jp3)

this.setLayout(new BorderLayout())

add(jp1,BorderLayout.NORTH)

add(jp2)

jb.addActionListener(this)

}

public void actionPerformed(ActionEvent e){

if(e.getSource() == jb){

String stuNo = jt.getText().trim()

Student s = new Student()

boolean b = true

try{

b = s.selectByStuNo(stuNo)

}

catch(Exception ex){

System.out.println("查询学生信息遇到异常!")

}

if(b){

jt1.setText(s.getStuNo())

jt2.setText(s.getName())

jt3.setText(s.getGender())

int a = s.getAge()

Integer i = new Integer(a)

jt4.setText(i.toString())

}

else{

JOptionPane.showMessageDialog(null, "无此学生!")

}

}

}

}

第五个：

import javax.swing.JFrame

public class SelectTest {

public static void main(String [] args){

JFrame f = new JFrame("查询学生信息")

SelectPanel p = new SelectPanel()

f.add(p)

f.setSize(400,300)

f.setLocation(300,250)

f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)

f.setVisible(true)

}

}

第六个：

import java.sql.Connection

import java.sql.ResultSet

import java.sql.Statement

public class Student {

String stuNo

String name

String gender

int age

public Student(){}

public Student(String stuNo,String name,String gender, int age){

this.stuNo = stuNo

this.name = name

this.gender = gender

this.age = age

}

public String getStuNo(){

return stuNo

}

public void setStuNo(String stuNo){

this.stuNo = stuNo

}

public String getName(){

return name

}

public void setName(String name){

this.name = name

}

public String getGender(){

return gender

}

public void setGender(String gender){

this.gender = gender

}

public int getAge(){

return age

}

public void setAge(int age){

this.age = age

}

public boolean insertStudent(){

boolean b = true

try{

Connection con = MySQLConnection.getCon()

Statement statement = con.createStatement()

String sql = "insert into student values('" + stuNo + "','" + name +"','" + gender + "'," + age + ")"

sql = new String(sql.getBytes("gb2312"),"ISO8859_1")

statement.executeUpdate(sql)

con.close()

}

catch(Exception e){

b = false

System.out.println("插入数据库遇到异常！")

}

return b

}

public boolean selectByStuNo(String stuNo)throws Exception{

boolean b = true

Connection con = MySQLConnection.getCon()

Statement statement = con.createStatement()

String sql = "select * from student where stuNo =" + stuNo

ResultSet rs = statement.executeQuery(sql)

if(rs != null &&rs.next()){

String no = rs.getString(1)

this.setStuNo(no)

String n = rs.getString(2)

n = new String(n.getBytes("ISO8859_1"),"gb2312")

this.setName(n)

String g = rs.getString(3)

g = new String (g.getBytes("ISO8859_1"),"gb2312")

this.setGender(g)

this.setAge(rs.getInt(4))

b = true

}

rs.close()

statement.close()

con.close()

return b

}

}

数据库你自己弄吧，我没时间弄了！初学得多动手哦

---