在eclipse中实现基于Mysql8.0版本下java学生信息管理系统

在eclipse中实现基于Mysql8.0版本下java学生信息管理系统开发小型的学生信息管理系统。（1）用JAVA开发该系统的前端（2）连接数据库（3）要求该系统有对数据库的增、删、改、查和测试的功能。一、主界面EX12_5_StudentManagement.javapackage exp6;import java.sql.*;import java.awt.*;import javax.sw

与月亮决战到底

3929人浏览 · 2021-12-13 21:39:17

与月亮决战到底 · 2021-12-13 21:39:17 发布

在eclipse中实现基于Mysql8.0版本下java学生信息管理系统

开发小型的学生信息管理系统。

（1）用JAVA开发该系统的前端

（2）连接数据库

（3）要求该系统有对数据库的增、删、改、查和测试的功能。

一、主界面

EX12_5_StudentManagement.java

package exp6;
import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;
import javax.swing.JOptionPane;


public class EX12_5_StudentManagement extends JFrame implements ActionListener{
    JMenuBar bar = null;
    JMenu menu1,menu2,menu3,menu4,menu5;//    菜单栏
    JMenuItem item1,item2,item3,item4,item5;//  项目栏  
    EX12_6_StudentAdd zengjia;
    EX12_7_StudentQuery chaxun;
    EX12_8_StudentUpdate gengxin;  //.............................
    EX12_9_StudentDelete shanchu;  //.............................
    //JDBCTest ceshi;//...........................................自己添加
     
    EX12_5_StudentManagement(){
        super("学 生 信 息 管 理 系 统");
        zengjia = new EX12_6_StudentAdd();
        chaxun = new EX12_7_StudentQuery();
        gengxin = new EX12_8_StudentUpdate();  // ....................
        shanchu = new EX12_9_StudentDelete();   //.....................
        //ceshi = new JDBCTest();//             自己添加
        bar = new JMenuBar();
        menu1 = new JMenu("信息录入");
        menu2 = new JMenu("信息查询");
        menu3 = new JMenu("信息更新");
        menu4 = new JMenu("信息删除");
        menu5 = new JMenu("退出系统");
        item1 = new JMenuItem("录  入");
        item2 = new JMenuItem("查  询");
        item3 = new JMenuItem("更  新");
        item4 = new JMenuItem("删  除");
        item5 = new JMenuItem("退  出");
        menu1.add(item1);
        menu2.add(item2);
        menu3.add(item3);
        menu4.add(item4);
        menu5.add(item5);
        bar.add(menu1);
        bar.add(menu2);
        bar.add(menu3);
        bar.add(menu4);
        bar.add(menu5);
        setJMenuBar(bar);
        item1.addActionListener(this);
        item2.addActionListener(this);
        item3.addActionListener(this);
        item4.addActionListener(this);
        item5.addActionListener(this);
                    
        JLabel label = new JLabel("学生信息管理系统",JLabel.CENTER);
        label.setFont(new Font("学生信息管理系统",0,35));
        String s = " ";
        Font f = new Font(s,Font.BOLD,60);
        label.setBackground(new Color(0,255,255));
        label.setForeground(new Color(255,128,255));
        add(label,"Center");
        setVisible(true);
        setSize(350,300);
    }
    public void actionPerformed(ActionEvent e){
        if(e.getSource() == item1){
            this.getContentPane().removeAll();
            this.getContentPane().add(zengjia,"Center");
            this.getContentPane().repaint();
            this.getContentPane().validate();
            
        }
        if(e.getSource() == item2){
            this.getContentPane().removeAll();
            this.getContentPane().add(chaxun,"Center");
            this.getContentPane().repaint();
            this.getContentPane().validate();
            
        }
        
        
        if(e.getSource() == item3){
            this.getContentPane().removeAll();
            this.getContentPane().add(gengxin,"Center");
            this.getContentPane().repaint();
            this.getContentPane().validate();
            
        
    }
        if(e.getSource() == item4){
            this.getContentPane().removeAll();
            this.getContentPane().add(shanchu,"Center");
            this.getContentPane().repaint();
            this.getContentPane().validate();
        }
    if(e.getSource() == item5){
        
        System.exit(0);
    }
    }
    public static void main(String args[]){
        EX12_5_StudentManagement stuM = new EX12_5_StudentManagement();
        stuM.setVisible(true);
        
        stuM.addWindowListener(new WindowAdapter(){
            public void windowClosing(WindowEvent e){
                System.exit(0);
            }
        });
        }
    }

二、信息录入界面

EX12_6_StudentAdd zengjia.java

EX12_6_StudentAdd zengjia.java

package exp6;

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;
import javax.swing.JOptionPane;

public class EX12_6_StudentAdd extends JPanel implements ActionListener{
  Connection con; //与特定数据库的连接（会话）。
  Statement sql; //用于执行静态 SQL 语句并返回它所生成结果的对象。
  JButton b1,b2;
  JTextField tf1,tf2,tf3,tf4,tf5,tf6;
  Box baseBox,bv1,bv2;
  EX12_6_StudentAdd(){
   try{                                        //错误处理机制
    Class.forName("com.mysql.cj.jdbc.Driver");    //通过 Class.forName为数据库管理系统加载一个JDBC驱动程序。
    }
   catch(ClassNotFoundException e){}        //如果加载驱动失败 控制台抛出异常
    try{                                    //如果加载驱动成功， 调用驱动连接特定数据库
     con=DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
     sql=con.createStatement();      //调取con成员方法获取Statement对象
    }
    catch(SQLException ee){}
    
    //设置面板布局 为边框布局
   setLayout(new BorderLayout());
   JPanel p1=new JPanel();
   JPanel p2=new JPanel();
   tf1=new JTextField(16);
   tf2=new JTextField(16);
   tf3=new JTextField(16);
   tf4=new JTextField(16);
   tf5=new JTextField(16);
   tf6=new JTextField(16);
   b1=new JButton("录入");  
   b2=new JButton("重置");
   b1.addActionListener(this);
   b2.addActionListener(this);
   p1.add(b1);
   p1.add(b2);
   bv1=Box.createVerticalBox();
   bv1.add(new JLabel("学号"));
   bv1.add(Box.createVerticalStrut(8));
   bv1.add(new JLabel("姓名"));
   bv1.add(Box.createVerticalStrut(8));
   bv1.add(new JLabel("性别"));
   bv1.add(Box.createVerticalStrut(8));
   bv1.add(new JLabel("地址"));
   bv1.add(Box.createVerticalStrut(8));
   bv1.add(new JLabel("电话"));
   bv1.add(Box.createVerticalStrut(8));
   bv1.add(new JLabel("专业"));
   bv1.add(Box.createVerticalStrut(8));
   bv2=Box.createVerticalBox();
   bv2.add(tf1);
   bv2.add(Box.createVerticalStrut(8));
   bv2.add(tf2);
   bv2.add(Box.createVerticalStrut(8));
   bv2.add(tf3);
   bv2.add(Box.createVerticalStrut(8));
   bv2.add(tf4);
   bv2.add(Box.createVerticalStrut(8));
   bv2.add(tf5);
   bv2.add(Box.createVerticalStrut(8));
   bv2.add(tf6);
   bv2.add(Box.createVerticalStrut(8));
   baseBox=Box.createHorizontalBox();
   baseBox.add(bv1);
   baseBox.add(Box.createHorizontalStrut(10));
   baseBox.add(bv2);
   p2.add(baseBox);
   add(p1,"South");
   add(p2,"Center");
   setSize(350,300);
   setBackground(Color.pink);
  }
  public void actionPerformed(ActionEvent e){
   if(e.getSource()==b1){
    try{ insert();}
    catch(SQLException ee){}
    JOptionPane.showMessageDialog(this,"数据已入库!","提示对话框",JOptionPane.INFORMATION_MESSAGE);
   }
   else if(e.getSource()==b2){
       tf1.setText(" ");
       tf2.setText(" ");
       tf3.setText(" ");
       tf4.setText(" ");
       tf5.setText(" ");
       tf6.setText(" ");
   }
  }
  public void insert() throws SQLException{
   String s1="'"+tf1.getText().trim()+"'";
   String s2="'"+tf2.getText().trim()+"'";
   String s3="'"+tf3.getText().trim()+"'";
   String s4="'"+tf4.getText().trim()+"'";
   String s5="'"+tf5.getText().trim()+"'";
   String s6="'"+tf6.getText().trim()+"'";
   
    con=DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
   
    String temp="INSERT INTO student VALUES ("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";
    sql.executeUpdate(temp);
   con.close();
  }
}

三、查询界面

EX12_7_StudentQuery chaxun.java

package exp6;

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;

//query  查询
public class EX12_7_StudentQuery extends JPanel implements ActionListener{
	Connection con;
	Statement sql;
	JTextField t1,t2,t3,t4,t5,t6;
	JButton b;
	Box baseBox,bv1,bv2;
	int flag = 0;
	EX12_7_StudentQuery(){
		try{
			Class.forName("com.mysql.cj.jdbc.Driver");
		}
		catch(ClassNotFoundException e){}
		try{
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
			sql = con.createStatement();
		}
		catch(SQLException ee){}
		
		setLayout (new BorderLayout());
		b = new JButton("查询");
		b.setBackground(Color.orange);
		b.addActionListener(this);
		t1 = new JTextField(8);
		t2 = new JTextField(16);
		t3 = new JTextField(16);
		t4= new JTextField(16);
		t5 = new JTextField(16);
		t6 = new JTextField(16);
		t2.setEditable(false);
		t3.setEditable(false);
		t4.setEditable(false);
		t5.setEditable(false);
		t6.setEditable(false);
		JPanel p1 = new JPanel(),p2 = new JPanel();
		p1.add(new JLabel("请输入学号："));
		p1.add(t1);
		p1.add(b);
		bv1 = Box.createVerticalBox();
		bv1.add(new JLabel("姓名"));
		bv1.add(Box.createVerticalStrut(8));
		bv1.add(new JLabel("性别"));
		bv1.add(Box.createVerticalStrut(8));
		bv1.add(new JLabel("地址"));
		bv1.add(Box.createVerticalStrut(8));
		bv1.add(new JLabel("电话"));
		bv1.add(Box.createVerticalStrut(8));
		bv1.add(new JLabel("专业"));
		bv1.add(Box.createVerticalStrut(8));
		bv2 = Box.createVerticalBox();
		bv2.add(t2);
		bv2.add(Box.createVerticalStrut(8));
		bv2.add(t3);
		bv2.add(Box.createVerticalStrut(8));
		bv2.add(t4);
		bv2.add(Box.createVerticalStrut(8));
		bv2.add(t5);
		bv2.add(Box.createVerticalStrut(8));
		bv2.add(t6);
		bv2.add(Box.createVerticalStrut(8));
		baseBox = Box.createHorizontalBox();
		baseBox.add(bv1);
		baseBox.add(Box.createHorizontalStrut(10));
		baseBox.add(bv2);
		p2.add(baseBox);
		add(p1,"North");
		add(p2,"Center");
		setSize(350,300);
		setBackground(Color.white);
	}
	public void actionPerformed(ActionEvent e){
		flag = 0;
		try{query();}
		catch(SQLException ee){}
	}
	public void query() throws SQLException{
		String num,name,gender,address,phone,major;
		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
		num = t1.getText().trim();
		ResultSet rs = sql.executeQuery("SELECT* FROM student WHERE id = '"+ num +"'");		
	
		if(rs.next()){
			name = rs.getString("name");
			gender = rs.getString("gender");
			address = rs.getString("address");
			phone = rs.getString("phone");
			major = rs.getString("major");
			t2.setText(name);
			t3.setText(gender);
			t4.setText(address);
			t5.setText(phone);
			t6.setText(major);
			flag = 1;			
		}else{
			JOptionPane.showMessageDialog(this,"没有该学生!","提示对话框",JOptionPane.INFORMATION_MESSAGE);
		}
		con.close();
		if(flag == 0){t1.setText("没有该学生");}		
	}
}

四、更新界面

EX12_8_StudentUpdate gengxin.java

package exp6;

import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.*;

import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class EX12_8_StudentUpdate extends JPanel implements ActionListener{
	Connection con;
	Statement sql;
	JTextField t1,t2,t3,t4,t5,t6;
	JButton b1,b2,b3;
	Box baseBox,bv1,bv2;
	EX12_8_StudentUpdate(){
		try{
			Class.forName("com.mysql.cj.jdbc.Driver");
		}
		catch(ClassNotFoundException e){}
		try{
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
			sql = con.createStatement();
		}
		catch(SQLException ee){}
		//设置面板布局 为边框布局
		   setLayout(new BorderLayout());
		   JPanel p1=new JPanel();
		   JPanel p2=new JPanel();
		   t1=new JTextField(16);
		   t2=new JTextField(16);
		   t3=new JTextField(16);
		   t4=new JTextField(16);
		   t5=new JTextField(16);
		   t6=new JTextField(16);
		   b1=new JButton("查询");
		   b2=new JButton("更新");
		   b3=new JButton("取消");
		   b1.addActionListener(this);
		   b2.addActionListener(this);
		   b3.addActionListener(this);
		   p1.add(b1);
		   p1.add(b2);
		   p1.add(b3);
		   bv1=Box.createVerticalBox();
		   bv1.add(new JLabel("学号"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv1.add(new JLabel("姓名"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv1.add(new JLabel("性别"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv1.add(new JLabel("地址"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv1.add(new JLabel("电话"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv1.add(new JLabel("专业"));
		   bv1.add(Box.createVerticalStrut(8));
		   bv2=Box.createVerticalBox();
		   bv2.add(t1);
		   bv2.add(Box.createVerticalStrut(8));
		   bv2.add(t2);
		   bv2.add(Box.createVerticalStrut(8));
		   bv2.add(t3);
		   bv2.add(Box.createVerticalStrut(8));
		   bv2.add(t4);
		   bv2.add(Box.createVerticalStrut(8));
		   bv2.add(t5);
		   bv2.add(Box.createVerticalStrut(8));
		   bv2.add(t6);
		   bv2.add(Box.createVerticalStrut(8));
		   baseBox=Box.createHorizontalBox();
		   baseBox.add(bv1);
		   baseBox.add(Box.createHorizontalStrut(10));
		   baseBox.add(bv2);
		   p2.add(baseBox);
		   add(p1,"South");
		   add(p2,"Center");
		   setSize(350,300);
		   setBackground(Color.pink);
		  
	}

	
	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if(e.getSource()==b1) {
			try {
				String num,name,gender,address,phone,major;
				con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
				num=t1.getText().trim();
				ResultSet rs = sql.executeQuery("SELECT* FROM student WHERE id = '"+ num +"'");	
				if(rs.next()) {
					//num=rs.getString("id");
					name=rs.getString("name");
					gender=rs.getString("gender");
					address=rs.getString("address");
					phone=rs.getString("phone");
					major=rs.getString("major");
				//if(num.equals(t1.getText().trim())) {
					t2.setText(name);
					t3.setText(gender);
					t4.setText(address);
					t5.setText(phone);
					t6.setText(major);
					//break;
				//}
			}else {
				JOptionPane.showMessageDialog(this,"没有该学生!","提示对话框",JOptionPane.INFORMATION_MESSAGE);
			}
				con.close();
		}
			catch(SQLException ee) {}
	}
		if(e.getSource()==b2) {
			try {
				update();
			}catch(SQLException ee) {}
		}
		if(e.getSource()==b3) {
			t2.setText("");
			t3.setText("");
			t4.setText("");
			t5.setText("");
			t6.setText("");
		}
		
     }
	public void update() throws SQLException{
		String s1="'"+t1.getText().trim()+"'";
		String s2="'"+t2.getText().trim()+"'";
		String s3="'"+t3.getText().trim()+"'";
		String s4="'"+t4.getText().trim()+"'";
		String s5="'"+t5.getText().trim()+"'";
		String s6="'"+t6.getText().trim()+"'";
		String test ="UPDATE student SET name ="+s2+",gender="+s3+",address="+s4+",phone="+s5+",major="+s6+" WHERE id="+s1;
		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
		sql.executeUpdate(test);
		JOptionPane.showMessageDialog(this,"修改成功！","提示对话框",JOptionPane.INFORMATION_MESSAGE);
		con.close();
	}
}

五、删除界面

EX12_9_StudentDelete shanchu.java

package exp6;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class EX12_9_StudentDelete extends JPanel implements ActionListener{
	Connection con;
	Statement sql;
	JTextField t1,t2,t3,t4,t5,t6;
	JButton b,b1,b2;
	Box baseBox,bv1,bv2;
	EX12_9_StudentDelete(){
		try{
			Class.forName("com.mysql.cj.jdbc.Driver");
		}
		catch(ClassNotFoundException e){}
		try{
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
			sql = con.createStatement();
		}
		catch(SQLException ee){}
		//设置面板布局 为边框布局
		   setLayout(new BorderLayout());
		   JPanel p1=new JPanel();
		   JPanel p2=new JPanel();
		   t1=new JTextField(16);
		   t2=new JTextField(16);
		   t3=new JTextField(16);
		   t4=new JTextField(16);
		   t5=new JTextField(16);
		   t6=new JTextField(16);
		   b=new JButton("删除");  
		   b.addActionListener(this);
		   p1.add(new JLabel("请输入要删除的学生学号："));
		   p1.add(t1);
		   p1.add(b);
		   add(p1,"North");
		   add(p2,"Center");
		   setSize(350,300);
		   setBackground(Color.pink);
		  
	}
	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if(e.getSource()==t1) {
			try {
				delete();
			}catch(SQLException ee) {}
		}else if(e.getSource()==b) {
			try {
				delete();
			}catch(SQLException ee) {}
	    int n=JOptionPane.showConfirmDialog(this, "确定要删除该学生的信息？","确定",JOptionPane.YES_NO_CANCEL_OPTION);	
	    if(n==JOptionPane.YES_OPTION) {
	    	try {
	    		String s1=""+t1.getText().trim()+"";
	    		String test="DELETE FROM student WHERE id="+s1;
	    		System.out.println(test);
	    		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
	    		sql.executeUpdate(test);
	    		JOptionPane.showMessageDialog(this,"已经删除成功！","提示对话框",JOptionPane.INFORMATION_MESSAGE);
	    		con.close();
	    	}catch(SQLException ee) {}
	    	
	        }else if(n==JOptionPane.NO_OPTION) {
	        	
	        }
		}
	}
	 
	public void delete() throws SQLException{
		String num,name,gender,address,phone,major;
		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/university?characterEncoding=utf8","root","123456");
		num=t1.getText().trim();
		ResultSet rs = sql.executeQuery("SELECT* FROM student WHERE id = '"+ num +"'");	
		if(rs.next()) {
			num=rs.getString("id");
			name=rs.getString("name");
			gender=rs.getString("gender");
			address=rs.getString("address");
			phone=rs.getString("phone");
			major=rs.getString("major");
		if(num.equals(t1.getText().trim())) {
			t2.setText(name);
			t3.setText(gender);
			t4.setText(address);
			t5.setText(phone);
			t6.setText(major);
		}
	}else {
		JOptionPane.showMessageDialog(this,"没有该学生!","提示对话框",JOptionPane.INFORMATION_MESSAGE);
	}
		con.close();
      }
}

六、JDBC连接测试类

package exp6;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBCTest {

	public static Connection getConnection() {
		String driver = "com.mysql.cj.jdbc.Driver"; 
		String url = "jdbc:mysql://localhost:3306/university"; 
		String username = "root";
		String pwd = "123456";
		try {
			Class.forName(driver); 
			Connection conn = DriverManager.getConnection(url, username, pwd);
																			
			return conn;
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
			return null;
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		}
	}

	public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs) {
		try {
			if (rs != null) {
				rs.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if (ps != null) {
				ps.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			if (conn != null) {
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) throws SQLException {

		Connection cc = JDBCTest.getConnection();

		if (!cc.isClosed())

		System.out.println("Succeeded connecting to the Database!");
		Statement statement = cc.createStatement(); 
	

 		String sql = "select * from student";
		ResultSet rs = statement.executeQuery(sql); 
		while (rs.next()) { 
			System.out.println(rs.getString("id") + "");
			
		}

	}
}

注意:在实现用java连接数据库前先创建好相关的数据库。

CSDN开发云

本社区面向用户介绍CSDN开发云部门内部产品使用和产品迭代功能，产品功能迭代和产品建议更透明和便捷

更多推荐

一键获取在线AI Rag大模型知识库

CSDN开发云

大模型快速构建AI智能客服

CSDN开发云

测试

产品介绍简介 Cloudpods 是一款简单、可靠的企业IaaS资源管理软件。帮助未云化企业全面云化IDC物理资源，提升企业IT管理效率。 Cloudpods 帮助客户在一个地方管理所有云计算资源。统一管理异构IT基础设施资源，极大简化多云架构复杂度和难度，帮助企业轻松驾驭多云环境。产品特色产品特色包括：开源：零门槛，线上快速获取和安装，核心代码完全托管于Github，迭代速度快；多云