基于java mysql_Java 基于MySQL数据库的简单学生管理系统

因为实验室要交作业然后就做了一个学生管理系统  贴个代码纪念一下~

做的太急界面什么的也比较差

还有一些小细节没有完善不过还是能实现主要的功能的~

Window是主界面

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class Window {

public static void main(String[] args){

JFrame jframe = new JFrame("学生管理系统") ; //window

Dimension d = new Dimension(400,300);

Point p = new Point (250,350);

jframe.setSize(d);

jframe.setLocation(p);

jframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jframe.setVisible(true);

JButton button1 = new JButton("添加");

JButton button2 = new JButton("修改");

JButton button3 = new JButton("查询");

JButton button4 = new JButton("删除");

JButton button5 = new JButton("浏览");

FlowLayout flow = new FlowLayout(FlowLayout.LEFT,10,10);

JPanel panel = new JPanel(flow);

panel.add(button1);

panel.add(button2);

panel.add(button3);

panel.add(button4);

panel.add(button5);

jframe.add(panel);

button1.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Add add = new Add();

}

});

button2.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Change change = new Change();

}

});

button3.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Ask ask = new Ask();

}

});

button4.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Delete delete = new Delete();

}

});

button5.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Look look = new Look();

}

});

}

}

Add是添加

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import com.mysql.jdbc.Driver;

import First.Window;

public class Add extends JFrame {

private static final long serialVersionUID = -1928970409928880648L;

JLabel jlnumber = new JLabel("学号：");

JLabel jlname = new JLabel("姓名：");

JLabel jlsex = new JLabel("性别：");

JLabel jlbirthday = new JLabel("出生日期：");

JLabel jldepartment = new JLabel("学院：");

JTextField jtnumber = new JTextField("",20);

JTextField jtname = new JTextField("",20);

JTextField jtsex = new JTextField("",20);

JTextField jtbirthday = new JTextField("",20);

JTextField jtdepartment = new JTextField("",20);

JButton buttonadd = new JButton("添加");

JButton buttonreturn = new JButton("返回");

public Add() {

JPanel jpnumber = new JPanel();

JPanel jpname = new JPanel();

JPanel jpsex = new JPanel();

JPanel jpbirthday = new JPanel();

JPanel jpdepartment = new JPanel();

JPanel jpforbutton = new JPanel(new GridLayout(1,1));

jpnumber.add(jlnumber);

jpnumber.add(jtnumber);

jpname.add(jlname);

jpname.add(jtname);

jpsex.add(jlsex);

jpsex.add(jtsex);

jpbirthday.add(jlbirthday);

jpbirthday.add(jtbirthday);

jpdepartment.add(jldepartment);

jpdepartment.add(jtdepartment);

jpforbutton.add(buttonadd);

jpforbutton.add(buttonreturn);

buttonadd.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

//Add

Connection conn = null;

Statement stat = null;

PreparedStatement ps=null;

String sql = "INSERT INTO student(number,name,sex,birthday,department) "

+ "values(?,?,?,?,?)";

try{

Class.forName("Driver");

System.out.println("JBDC 加载成功!");

}catch(Exception a){

System.out.println("JBDC 狗带!");

a.printStackTrace();

}

try{

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

ps=conn.prepareStatement(sql);

ps.setString(1,jtnumber.getText());

ps.setString(2,jtname.getText());

ps.setString(3,jtsex.getText());

ps.setString(4,jtbirthday.getText());

ps.setString(5,jtdepartment.getText());

ps.executeUpdate();

//System.out.println("MySQL 连接成功!");

//stat = conn.createStatement();

//stat.executeUpdate(sql);

//System.out.println("插入数据成功!");

}catch (SQLException b){

b.printStackTrace();

}finally{

try{

conn.close();

System.out.println("MySQL 关闭成功");

}catch (SQLException c){

System.out.println("MySQL 关闭失败 ");

c.printStackTrace();

}

}

}}

);

buttonreturn.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Window window = new Window();

}

});

this.setTitle("添加学生信息");

this.setLayout(new GridLayout(9,1));

this.add(jpnumber);

this.add(jpname);

this.add(jpsex);

this.add(jpbirthday);

this.add(jpdepartment);

this.add(jpforbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}

Ask是查询

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import First.Window;

public class Ask extends JFrame {

private static final long serialVersionUID = -1928970409928880648L;

JLabel jlnumber = new JLabel("学号：");

JLabel jlname = new JLabel("姓名：");

JLabel jlsex = new JLabel("性别：");

JLabel jlbirthday = new JLabel("出生日期：");

JLabel jldepartment = new JLabel("学院：");

JTextField jtnumber = new JTextField("",20);

JLabel jname = new JLabel();

JLabel jsex = new JLabel();

JLabel jbirthday = new JLabel();

JLabel jdepartment = new JLabel();

JButton buttonask = new JButton("查询");

JButton buttonreturn = new JButton("返回");

public Ask() {

JPanel jpnumber = new JPanel();

JPanel jpname = new JPanel();

JPanel jpsex = new JPanel();

JPanel jpbirthday = new JPanel();

JPanel jpdepartment = new JPanel();

JPanel jpforbutton = new JPanel(new GridLayout(1,1));

jpnumber.add(jlnumber);

jpnumber.add(jtnumber);

jpname.add(jlname);

jpname.add(jname);

jpsex.add(jlsex);

jpsex.add(jsex);

jpbirthday.add(jlbirthday);

jpbirthday.add(jbirthday);

jpdepartment.add(jldepartment);

jpdepartment.add(jdepartment);

jpforbutton.add(buttonask);

jpforbutton.add(buttonreturn);

buttonask.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Connection conn = null;

ResultSet res = null;

Statement stat = null;

String sql = "SELECT number,name,sex,birthday,department FROM student;";

try{

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

}catch(Exception d){

System.out.println("jdbc fall");

d.printStackTrace();

}

try{

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

stat=conn.createStatement();

res=stat.executeQuery(sql);

while (res.next())

{

if (res.getString(1).equals(jtnumber.getText()))

{

jname.setText(res.getString(2));

jsex.setText(res.getString(3));

jbirthday.setText(res.getString(4));

jdepartment.setText(res.getString(5));

break;

}

}

}catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

finally{

try{

conn.close();

}catch(SQLException ar){

ar.printStackTrace();

}

}}}

);

buttonreturn.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Window window = new Window();

}

});

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

this.setLayout(new GridLayout(9,1));

this.add(jpnumber);

this.add(jpname);

this.add(jpsex);

this.add(jpbirthday);

this.add(jpdepartment);

this.add(jpforbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}

Change是修改

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import First.Window;

public class Change extends JFrame {

private static final long serialVersionUID = -1928970409928880648L;

JLabel jlnumber = new JLabel("学号：");

JLabel jlname = new JLabel("姓名：");

JLabel jlsex = new JLabel("性别：");

JLabel jlbirthday = new JLabel("出生日期：");

JLabel jldepartment = new JLabel("学院：");

JTextField jtnumber = new JTextField("",20);

JTextField jtname = new JTextField("",20);

JTextField jtsex = new JTextField("",20);

JTextField jtbirthday = new JTextField("",20);

JTextField jtdepartment = new JTextField("",20);

JButton buttonchange = new JButton("修改");

JButton buttonreturn = new JButton("返回");

public Change() {

JPanel jpnumber = new JPanel();

JPanel jpname = new JPanel();

JPanel jpsex = new JPanel();

JPanel jpbirthday = new JPanel();

JPanel jpdepartment = new JPanel();

JPanel jpforbutton = new JPanel(new GridLayout(1,1));

jpnumber.add(jlnumber);

jpnumber.add(jtnumber);

jpname.add(jlname);

jpname.add(jtname);

jpsex.add(jlsex);

jpsex.add(jtsex);

jpbirthday.add(jlbirthday);

jpbirthday.add(jtbirthday);

jpdepartment.add(jldepartment);

jpdepartment.add(jtdepartment);

jpforbutton.add(buttonchange);

jpforbutton.add(buttonreturn);

buttonchange.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

String number = jtnumber.getText();

String name = jtname.getText();

String sex = jtsex.getText();

String birthday = jtbirthday.getText();

String department = jtdepartment.getText();

Connection conn = null;

ResultSet res = null;

Statement stat = null;

String sql = "SELECT number,name,sex,birthday,department FROM student;";

try{

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

}catch(Exception d){

System.out.println("jdbc fall");

d.printStackTrace();

}

try{

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

stat=conn.createStatement();

res=stat.executeQuery(sql);

while (res.next())

{

//change

if (res.getString(1).equals(jtnumber.getText()))

{

try{

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

}catch(Exception d){

System.out.println("jdbc fall");

d.printStackTrace();

}

String sql2="UPDATE student SET name='"+name+"' WHERE number='"+jtnumber.getText()+"'";

String sql3="UPDATE student SET sex='"+sex+"' WHERE number='"+jtnumber.getText()+"'";

String sql4="UPDATE student SET birthday='"+birthday+"' WHERE number='"+jtnumber.getText()+"'";

String sql5="UPDATE student SET department='"+department+"' WHERE number='"+jtnumber.getText()+"'";

try {

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

stat=conn.createStatement();

stat.executeUpdate(sql2);

stat.executeUpdate(sql3);

stat.executeUpdate(sql4);

stat.executeUpdate(sql5);

} catch (SQLException g) {

// TODO Auto-generated catch block

g.printStackTrace();

}try{

stat.close();

conn.close();

}catch(SQLException ar){

ar.printStackTrace();

}

break;

}

//change end

}

}catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

finally{

try{

conn.close();

}catch(SQLException ar){

ar.printStackTrace();

}

}

}

});

buttonreturn.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Window window = new Window();

}

});

this.setTitle("修改学生信息");

this.setLayout(new GridLayout(9,1));

this.add(jpnumber);

this.add(jpname);

this.add(jpsex);

this.add(jpbirthday);

this.add(jpdepartment);

this.add(jpforbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}

Delete是删除

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import First.Window;

public class Delete extends JFrame {

private static final long serialVersionUID = -1928970409928880648L;

JLabel jlnumber = new JLabel("学号：");

JTextField jtnumber = new JTextField("",20);

JButton buttondelete = new JButton("删除");

JButton buttonreturn = new JButton("返回");

public Delete() {

JPanel jpnumber = new JPanel();

JPanel jpforbutton = new JPanel(new GridLayout(1,1));

jpnumber.add(jlnumber);

jpnumber.add(jtnumber);

jpforbutton.add(buttondelete);

jpforbutton.add(buttonreturn);

buttondelete.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

String number = jtnumber.getText();

Connection conn = null;

ResultSet res = null;

Statement stat = null;

String sql = "DELETE FROM student WHERE number='"+number+"'";

try{

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

}catch(Exception a){

a.printStackTrace();

}

try{

conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

stat = conn.createStatement();

stat.executeUpdate(sql);

}catch(SQLException h){

h.printStackTrace();

}finally{

try{

conn.close();

System.out.println("close success!");

}catch(SQLException j){

System.out.println("close go die!");

j.printStackTrace();

}

}

}

});

buttonreturn.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Window window = new Window();

}

});

this.setTitle("删除学生信息");

this.setLayout(new GridLayout(9,1));

this.add(jpnumber);

this.add(jpforbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}

Look是浏览

package First;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.util.*;

import First.Window;

public class Look extends JFrame {

private static final long serialVersionUID = -1928970409928880648L;

Connection conn = null;

PreparedStatement ps = null;

ResultSet res = null;

//JButton buttonlook = new JButton("浏览");

//JButton buttonreturn = new JButton("返回");

JTable jtable;

JScrollPane jscrollpane = new JScrollPane();

Vector columnNames = null;

Vector rowData = null;

public Look() {

JPanel jpforbutton = new JPanel(new GridLayout(1,1));

columnNames = new Vector();

columnNames.add("学号");

columnNames.add("姓名");

columnNames.add("性别");

columnNames.add("出生日期");

columnNames.add("学院");

rowData = new Vector();

//jpforbutton.add(buttonlook);

//jpforbutton.add(buttonreturn);

try {

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

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/javaStu","root","123");

ps = conn.prepareStatement("SELECT * FROM student");

res = ps.executeQuery();

while (res.next())

{

Vector hang = new Vector();

hang.add(res.getString(1));

hang.add(res.getString(2));

hang.add(res.getString(3));

hang.add(res.getString(4));

hang.add(res.getString(5));

rowData.add(hang);

}

System.out.println("load ok!");

}catch (Exception q){

q.printStackTrace();

System.out.println("go die");

}finally{

try{

res.close();

ps.close();

conn.close();

System.out.println("close ok");

}catch (SQLException o){

o.printStackTrace();

System.out.println("go die 2");

}

}

jtable = new JTable(rowData,columnNames);

jscrollpane = new JScrollPane(jtable);

this.add(jscrollpane);

this.setTitle("浏览学生信息");

this.setLayout(new GridLayout(2,5));

this.add(jpforbutton);

this.setLocation(300,300);

this.setSize(500,300);

this.setVisible(true);

this.setResizable(false);

}

}

一些运行的界面~