基于Java的学生信息管理系统

基于Java的学生信息管理系统

简述：

这是一个简单的基于Java和Mysql的学生信息管理系统,主要实现简单的增删改查，

主界面：

import java.awt.*;  
import java.awt.event.*;  
import javax.swing.*;  
public class ZhuJieMian {
   
	public static void main(String[] args){
    
		JFrame jframe = new JFrame("学生管理系统") ; //创建窗体并实例化
		//设置窗体大小
		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是事件源，new ActionListener()是监听器同时也是匿名内部类有了他可以执行后面的方法，程序，只使用一次
		/*匿名内部类
		 * new ActionListener(){
		 *方法只能在类中才能执行所以需要一个类
			public void actionPerformed(ActionEvent e){ 
				Add add = new Add(); 
			} 
		}
		 */
		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();
			}
		});
	}
}

数据库连接：

import java.sql.Connection;
import java.sql.DriverManager;
public class DBconnector {
   
	private static Connection conn=null;
	public static Connection getConn(){
    
		try{
    
			Class.forName("com.mysql.cj.jdbc.Driver"); 
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/studentxitong?useSSL=false&serverTimezone=UTC","root","123456"); 
		}
		catch (Exception b){
    
			b.printStackTrace(); 
		}
		return conn;
	}		
}

添加功能：

import java.sql.*;  
import java.awt.*;  
import java.awt.event.*;  
import javax.swing.*;  
import java.sql.SQLException;
public class Add extends JFrame {
     
	private static final long serialVersionUID =1L; 
	//创建文本标签
	JLabel jlnumber = new JLabel("学号："); 
	JLabel jlname = new JLabel("姓名："); 
	JLabel jlsex = new JLabel("性别："); 
	JLabel jlclass = new JLabel("班级："); 
	JLabel jlnative = new JLabel("籍贯："); 
	//创建文本框 并实例化
	JTextField jtnumber = new JTextField(20);
	JTextField jtname = new JTextField(20); 
	JTextField jtsex = new JTextField(20); 
	JTextField jtclass = new JTextField(20); 
	JTextField jtnative = 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 jpclass = new JPanel(); 
		JPanel jpnative = new JPanel();