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);
		
	}
	
	
}

一些运行的界面~