数据库+java课设开源

梦里梦外; 2022-12-31 01:20 132阅读 0赞

## 简述：做这个系统的时候因为时间不是很多 ##

## 所以调用了一些网上的界面,直接拿了过来改了下人家的JFrame ##

## 话不多说,代码如下 ##

## 一,连接与核心查询类代码 ##

package daoru;
    
    import java.sql.*;
    
    import javax.swing.JOptionPane;
    import javax.swing.Spring;
    
    //数据库连接程序
    public class MysqlConn { 
    	public static String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
        public static String dbURL="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=学生成绩管理系统";
        public static String userName="sa";
        public static String userPwd="123456789";
    	
    	//设定用户名和密码
        public static String userword;
        public static String pawd;
    	
        //修改或者插入学生信息类时使用的变量
        public static String cname = null;
        public static String cno = null;
        public static String stucredit = null;
        
        //设定学生账户的信息类   
        public static String stuid = null;
        public static String stuname = null;
        public static String stusex = null;
        public static String stunj=null;
        public static String stuzy=null;
    	
       
       
        //计学生人数的变量
    	public static int counter = 0;
    	
    	//学生个人信息的
    	public static String [] stu_sno = new String[10];
    	public static String [] stu_name = new String[10];
    	public static String [] stu_sex = new String[10];
    	public static String [] stu_zy = new String[10];
    	public static String [] stu_nj = new String[10];
    	
    	//统计分数的
    	public static String [] stu_kcbh = new String[10];
    	public static String [] stu_kcmc = new String[10];
    	public static double [] stu_point = new double[10];
    	
    	
    	//课程表类
    	public static String [] c_no = new String[10];
    	public static String [] ct_name = new String[10];
    	public static String [] c_name = new String[10];
    	public static String [] c_rkjs=new String[10];
    	public static double [] credit = new double[10];
    	
    	//执行sql语句与返回sql执行结果
    	public static Connection conn = null;
    	public static PreparedStatement ps = null;
    	public static ResultSet rs = null;
    	
    	//连接数据库
    	public static void ConnectSQL() { 
    		try { 
        		 Class.forName(driverName);
    	         conn=DriverManager.getConnection(dbURL,userName,userPwd);//即验证数据库的账号与密码进行连接
    			System.out.println("The SQL is connected");
    		} catch (Exception e) { 
    			e.printStackTrace();
    		}
    	}
    	
    	// 判断用户是否存在
    	//判断管理员的id是否存在
    	public static boolean queryadm(String id) { 
    		// 创建火箭车
    		try { 
    			ps = conn.prepareStatement("select * from gly where ID = ?");
    			ps.setString(1, id);
    			// ResultSet结果集把ResultSet理解成返回一张表行的结果集
    			rs = ps.executeQuery();
    			if (rs.next()) { //即返回一张表中的所有密码
    				pawd = rs.getString("password");
    				return true;
    			}
    		} catch (Exception e1) { 
    			
    			e1.printStackTrace();
    		}
    		return false;
    	}
    	
    	//判断该学生的学号是否存在
    	public static boolean querystu(String id) { 
    		try { 
    			ps = conn.prepareStatement("select * from Student where sno = ?");
    			ps.setString(1, id);
    			rs = ps.executeQuery();
    			if (rs.next()) { 
    				pawd = rs.getString("sno");
    				return true;
    			}
    		} catch (Exception e1) { 
    		
    			e1.printStackTrace();//查看错误信息的代码
    		}
    		return false;
    	}
    	
    	
    	public static void getdatastu() { 
    		try { 
    			ps = conn.prepareStatement("select * from Student");
    			rs = ps.executeQuery();
    			counter = 0;
    			while(rs.next())	
    			{ 
    				stu_sno[counter] = rs.getString("sno");//学号
    				stu_name[counter] = rs.getString("sname");//姓名
    				stu_sex[counter] = rs.getString("sex");//性别-->即如果用的是String类型就不能用date类型否则会返回不了所需要的值
    				stu_zy[counter] = rs.getString("zy");//专业
    				stu_nj[counter] = rs.getString("nj");//年级
    				counter++;
    			}
    	
    		} catch (Exception e1) { 
    			e1.printStackTrace();
    		}
    	}
    //获取一个学生的成绩类信息-->对接student函数
    	public static void getdatastu(String s) { 
    		
    		try { 
    			ps = conn.prepareStatement("select * from Grade where sno = ?");
    			ps.setString(1, s);
    			rs = ps.executeQuery();
    			counter = 0;
    			while(rs.next())	
    			{ 
    				c_name[counter] = rs.getString("sno");
    				stu_kcbh[counter] = rs.getString("kcbh");
    				stu_kcmc[counter] = rs.getString("kcmc");
    				stu_point[counter] = rs.getDouble("fs");
    				counter++;
    			}
    	
    		} catch (Exception e1) { 
    			e1.printStackTrace();
    		}
    	}
    	//获取所有学生的个人成绩信息
    	public static void getdatagra() { 
    		try { 
    			ps = conn.prepareStatement("select * from Grade where Grade.sno in (select sno from Student)");
    			rs = ps.executeQuery();
    			
    			counter = 0;
    			while(rs.next())	
    			{ 
    				c_name[counter] = rs.getString("sno");
    				stu_kcbh[counter] = rs.getString("kcbh");
    				stu_kcmc[counter] = rs.getString("kcmc");
    				stu_point[counter] = rs.getDouble("fs");
    				counter++;
    			}
    			
    		}catch(Exception e){ 
    			e.printStackTrace();
    		}
    	}
    	
    
    	
    	//增加学生-->有小bug
    	public static void insertstu() { 
    		try{ 
    			ps = conn.prepareStatement("insert into Student values ('"+stuid+"','"+stuname+"','"+stusex+"','"+stunj+"','"+stuzy+"')");
    			ps.executeUpdate();
    			
    			JOptionPane.showMessageDialog(null, "学生记录添加成功!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    				
    		} catch (Exception e1) { 
    			
    			JOptionPane.showMessageDialog(null, "数据添加异常!", "提示消息", JOptionPane.ERROR_MESSAGE);
    			e1.printStackTrace();
    		}
    		
    	}
    
    	public static void deletestu(String stuid2) { 
    		try { 
    			ps = conn.prepareStatement("delete from Student where sno = ? ");
    			ps.setString(1, stuid2);
    			ps.execute();
    			
    			JOptionPane.showMessageDialog(null, "学生记录删除成功!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    			
    		} catch (Exception e1){ 
    			
    			JOptionPane.showMessageDialog(null, "数据删除失败!", "提示消息", JOptionPane.ERROR_MESSAGE);
    			e1.printStackTrace();
    		}
    	}
    
    	
    
    
    
    
    	
    
    	
    
    	public static void getdatacou() { 
    		try { 
    			ps = conn.prepareStatement("select * from Course ");
    			rs = ps.executeQuery();
    			counter = 0;
    			while(rs.next()){ 
    				c_no[counter] = rs.getString("kcbh");
    				c_name[counter] = rs.getString("kcm");
    				c_rkjs[counter] = rs.getString("rkjs");
    				counter++;
    			}
    			
    		}catch (Exception e){ 
    			e.printStackTrace();
    		}
    	}
    //查询课程函数对接功能实现
    	public static boolean querycou(String text) { 
    		try { 
    			ps = conn.prepareStatement("select kcbh from Course where kcbh = ?");
    			ps.setString(1, text);
    			rs = ps.executeQuery();
    			if(rs.next()){ 
    				return true;
    			}
    		}catch(Exception e){ 
    			e.printStackTrace();
    		}
    		return false;
    	}
    //插入课表对接函数
    	public static void insertcou(String cno2, String cname2, String stucredit2) { 
    		try{ 
    			ps = conn.prepareStatement("insert into Course values ('"+ cno2 +"','"+ cname2 +"','"+stucredit2+"')");
    			ps.executeUpdate();
    			
    			JOptionPane.showMessageDialog(null, "课程信息添加成功!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    		}catch(Exception e){ 
    			e.printStackTrace();
    			JOptionPane.showMessageDialog(null, "课程信息添加失败!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    		}
    	}
    
    	
    
    	public static void deletecou(String cno2) { 
    		try { 
    			ps = conn.prepareStatement("delete from Course where kcbh = ?");
    			ps.setString(1, cno2);
    			ps.execute();
    			
    			JOptionPane.showMessageDialog(null, "课程删除成功!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    		}catch(Exception e){ 
    			e.printStackTrace();
    			JOptionPane.showMessageDialog(null, "课程删除失败!", "提示消息", JOptionPane.INFORMATION_MESSAGE);
    		}
    	}
    
    	public static void getdatacou(String cname2) { 
    		try { 
    			ps = conn.prepareStatement("select Cno from 课程 where Cname = ?");
    			ps.setString(1, cname2);
    			rs = ps.executeQuery();
    			
    			if(rs.next()){ 
    				cno = rs.getString("Cno");
    			}
    			
    		}catch (Exception e){ 
    			e.printStackTrace();
    		}
    	}
    }

## 二,界面类代码 ##

①Admin.java管理员界面

//管理员选择学生还是课程的界面
    package SMIS;
    
    import java.awt.event.*;
    
    import javax.swing.*;
    import java.awt.BorderLayout;
    import java.awt.GridLayout;
    import java.awt.GridBagLayout;
    import java.awt.GridBagConstraints;
    import java.awt.Insets;
    import javax.swing.GroupLayout.Alignment;
    import java.awt.Font;
    import ui.Login;
    
    //查询、更新学生信息
    public class Admin extends JFrame { 
    	JButton jb1,jb2 = null;
    	JRadioButton jrb1,jrb2 = null;
    	JLabel jl = null;
    	JPanel jp = null;
    	ButtonGroup bg = null;
    	
    	public Admin() { 
    		getContentPane().setLayout(null);
    		
    		jp = new JPanel();
    		jp.setBounds(125, 184, 386, 190);
    		getContentPane().add(jp);
    		jp.setLayout(null);
    		
    		jl = new JLabel("操作对象");
    		jl.setBounds(29, 48, 60, 37);
    		jp.add(jl);
    		
    		jrb1 = new JRadioButton("学生");//学生
    		jrb1.setBounds(118, 48, 59, 37);
    		jp.add(jrb1);
    		
    		bg = new ButtonGroup();
    		bg.add(jrb1);
    		bg.add(jrb2);
    		
    		jb1 = new JButton("确定");
    		jb1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				if(jrb1.isSelected()){ 
    					Stu st = new Stu();
    				}
    				else{ 
    					Cou co = new Cou();
    				}
    			}
    		});
    		jb1.setBounds(41, 109, 72, 42);
    		jp.add(jb1);
    		
    
    		JButton jb2 = new JButton("退出");
    		jb2.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		jb2.setBounds(267, 109, 76, 42);
    		jp.add(jb2);
    		
    		JRadioButton radioButton = new JRadioButton("课程");
    		radioButton.setBounds(206, 48, 59, 37);
    		jp.add(radioButton);
    		bg.add(radioButton);
    		
    		JButton button = new JButton("返回");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Login l = new Login();
    			}
    		});
    		button.setBounds(154, 109, 72, 42);
    		jp.add(button);
    		
    		JLabel label = new JLabel("欢迎登录学生成绩管理系统！");
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 46));
    		label.setBounds(14, 55, 604, 60);
    		getContentPane().add(label);
    		
    		//给窗口设置标题
    		this.setTitle("学生成绩管理系统-管理员");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

②COU.java

//课程界面类
    package SMIS;
    
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import java.awt.Font;
    import javax.swing.JPanel;
    import javax.swing.JButton;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import daoru.MysqlConn;
    import SMIS.Admin;
    import SMIS.Cou;
    import gn.InsertCou;
    import gn.InsertStu;
    import gn.Delete;
    import gn.QueryCou;
    import gn.QueryStu;
    import gn.JudgeNum;//统计数目功能
    import SMIS.Stu;
    import SMIS.Student;
    
    public class Cou extends JFrame { 
    	public Cou() { 
    		getContentPane().setLayout(null);
    		
    		JPanel panel = new JPanel();
    		panel.setBounds(152, 59, 329, 302);
    		getContentPane().add(panel);
    		panel.setLayout(null);
    		
    		JLabel label = new JLabel("请选择您要进行的操作");
    		label.setBounds(69, 5, 191, 41);
    		panel.add(label);
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JButton button = new JButton("查询课程信息");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				QueryCou qc = new QueryCou();
    			}
    		});
    		button.setBounds(94, 59, 140, 47);
    		panel.add(button);
    		
    		JButton button_1 = new JButton("添加课程信息");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				InsertCou ic = new InsertCou();
    			}
    		});
    		button_1.setBounds(94, 119, 140, 47);
    		panel.add(button_1);
    		
    		JButton button_3 = new JButton("删除课程信息");
    		button_3.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Delete dc = new Delete();
    			}
    		});
    		button_3.setBounds(94, 182, 140, 47);
    		panel.add(button_3);
    		
    		JButton button_4 = new JButton("返回");
    		button_4.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Admin ad = new Admin();
    			}
    		});
    		button_4.setBounds(202, 389, 94, 41);
    		getContentPane().add(button_4);
    		
    		JButton button_5 = new JButton("退出");
    		button_5.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_5.setBounds(345, 389, 94, 41);
    		getContentPane().add(button_5);
    		
    		//给窗口设置标题
    		this.setTitle("学生信息管理系统-管理员");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

③Stu.java

//管理员管理的学生界面类
    package SMIS;
    
    import javax.swing.*;
    import java.awt.BorderLayout;
    import java.awt.Font;
    import java.awt.GridLayout;
    import java.awt.Color;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import SMIS.Admin;
    import SMIS.Cou;
    import gn.InsertCou;
    import gn.InsertStu;
    import gn.Delete;
    import gn.QueryCou;
    import gn.QueryStu;
    import gn.JudgeNum;//统计数目功能
    
    
    
    //查询、插入、修改、删除学生信息
    public class Stu extends JFrame{ 
    	public Stu() { 
    		getContentPane().setLayout(null);
    		
    		JPanel panel = new JPanel();
    		panel.setBounds(151, 27, 330, 305);
    		getContentPane().add(panel);
    		panel.setLayout(null);
    		
    		JLabel label = new JLabel("请选择您要进行的操作");
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label.setBounds(69, 13, 191, 41);
    		panel.add(label);
    		
    		JButton button = new JButton("查询学生信息");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				QueryStu qs = new QueryStu();
    			}
    		});
    		button.setBounds(91, 67, 143, 50);
    		panel.add(button);
    		
    		JButton button_1 = new JButton("添加学生信息");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				InsertStu is = new InsertStu();
    			}
    		});
    		button_1.setBounds(91, 128, 143, 50);
    		panel.add(button_1);
    		
    		
    		
    		JButton button_3 = new JButton("删除学生信息");
    		button_3.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Delete ds = new Delete();
    			}
    		});
    		button_3.setBounds(91, 185, 143, 50);
    		panel.add(button_3);
    		
    		JPanel panel_1 = new JPanel();
    		panel_1.setBounds(179, 367, 272, 49);
    		getContentPane().add(panel_1);
    		panel_1.setLayout(null);
    		
    		JButton button_4 = new JButton("返回");
    		button_4.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Admin ad = new Admin();
    			}
    		});
    		button_4.setBounds(41, 5, 76, 40);
    		panel_1.add(button_4);
    		
    		JButton button_5 = new JButton("退出");
    		button_5.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_5.setBounds(146, 5, 76, 40);
    		panel_1.add(button_5);
    		
    		//给窗口设置标题
    		this.setTitle("学生信息管理系统-管理员");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

④Student.java

package SMIS;
    
    import javax.swing.JFrame;
    import javax.swing.JButton;
    import java.awt.BorderLayout;
    import javax.swing.JScrollPane;
    import javax.swing.JTable;
    import javax.swing.table.DefaultTableModel;
    import javax.swing.JLabel;
    import java.awt.Font;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import javax.swing.JTextArea;
    import javax.swing.JFormattedTextField;
    import daoru.MysqlConn;
    import SMIS.Admin;
    import SMIS.Cou;
    import gn.InsertCou;
    import gn.InsertStu;
    
    import gn.Delete;
    import gn.QueryCou;
    import gn.QueryStu;
    import gn.JudgeNum;//统计数目功能
    import ui.Login;
    
    
    public class Student extends JFrame { 
    	private JTable table;
    	public Student() { 
    		getContentPane().setLayout(null);
    		
    		JButton btnNewButton = new JButton("查成绩");
    		btnNewButton.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				MysqlConn.ConnectSQL();
    				MysqlConn.getdatastu(MysqlConn.userword);
    				
    				for(int i = 0; i < MysqlConn.counter; i++){ 
    					table.setValueAt(MysqlConn.c_name[i], i, 0);
    					table.setValueAt(MysqlConn.stu_kcbh[i], i, 1);
    					table.setValueAt(MysqlConn.stu_kcmc[i], i, 2);
    					table.setValueAt(MysqlConn.stu_point[i], i, 3);
    				}
    				
    			}
    		});
    		btnNewButton.setBounds(161, 162, 97, 37);
    		getContentPane().add(btnNewButton);
    		
    		JScrollPane scrollPane = new JScrollPane();
    		scrollPane.setBounds(39, 212, 560, 152);
    		getContentPane().add(scrollPane);
    		
    		table = new JTable();
    		table.setModel(new DefaultTableModel(
    			new Object[][] { 
    				{ null, null, null, null},
    				{ null, null, null, null},
    				{ null, null, null, null},
    				{ null, null, null, null},
    			},
    			new String[] { 
    				"学号", "课程编号", "课程名称", "分数"
    			}
    		));
    		table.setRowHeight(30);
    		scrollPane.setViewportView(table);
    		
    		
    		
    		JButton button = new JButton("退出");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button.setBounds(383, 162, 97, 37);
    		getContentPane().add(button);
    		
    		JLabel label_4 = new JLabel("欢迎登录学生成绩管理系统");
    		label_4.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 46));
    		label_4.setBounds(14, 29, 604, 117);
    		getContentPane().add(label_4);
    		
    		JButton button_1 = new JButton("返回");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Login l = new Login();
    			}
    		});
    		button_1.setBounds(272, 162, 97, 37);
    		getContentPane().add(button_1);
    		
    		this.setTitle("学生成绩管理系统-学生");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

## 三,UI界面 ##

//登录界面类
    package ui;
    
    import java.awt.*;//提供GUI的设计工具
    import java.awt.event.*;//提供awt组件事件的监听以及相应
    import javax.swing.*;//配置选定功能的实现与框架功能
    import daoru.MysqlConn;
    import SMIS.Admin;
    import SMIS.Cou;
    import gn.InsertCou;
    import gn.InsertStu;
    import gn.Delete;
    import gn.QueryCou;
    import gn.QueryStu;
    import gn.JudgeNum;//统计数目功能
    import SMIS.Stu;
    import SMIS.Student;
    
    
    
    public class Login extends JFrame implements ActionListener { 
    
    	//定义登录界面的组件
    	JButton jb1,jb2,jb3=null;
    	JRadioButton jrb1,jrb2,jrb3=null;
    	JPanel jp4=null;
        JTextField jtf=null;
    	JLabel jlb1,jlb2,jlb3=null;
    	JPasswordField jpf=null;
    	ButtonGroup bg=null;	
    	
    	public static void main(String[] args) { 
    		Login ms=new Login();	
    	}
    	//构造函数
    	public Login()
    	{ 
    		bg=new ButtonGroup();
    		jp4=new JPanel();
    		jp4.setBounds(0, 0, 0, 0);
    		getContentPane().setLayout(null);
    		getContentPane().add(jp4);
    		
    		jlb1=new JLabel("用户名：");
    		jlb1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		jlb1.setBounds(181, 92, 83, 37);//x,y,width,height
    		getContentPane().add(jlb1);
    		
    		jtf=new JTextField(12);
    		jtf.setBounds(265, 92, 133, 37);
    		getContentPane().add(jtf);
    		
    		jlb2=new JLabel("密 码：");
    		jlb2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		jlb2.setBounds(181, 161, 83, 37);
    		getContentPane().add(jlb2);
    		
    		jpf = new JPasswordField(12);
    		jpf.setBounds(265, 161, 133, 37);
    		getContentPane().add(jpf);
    		
    		jlb3=new JLabel("权 限：");
    		jlb3.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		jlb3.setBounds(181, 227, 83, 37);
    		getContentPane().add(jlb3);
    		
    		jrb1=new JRadioButton("管理员");
    		jrb1.setBounds(265, 227, 73, 37);
    		getContentPane().add(jrb1);
    		bg.add(jrb1);
    		
    		jrb3=new JRadioButton("学生",true);
    		jrb3.setBounds(349, 227, 59, 37);
    		getContentPane().add(jrb3);
    		bg.add(jrb3);
    		
    		jb1=new JButton("登录");
    		jb1.setBounds(181, 311, 76, 40);
    		getContentPane().add(jb1);
    		jb2=new JButton("重置");
    		jb2.setBounds(265, 311, 76, 40);
    		getContentPane().add(jb2);
    		jb3=new JButton("退出");
    		jb3.setBounds(349, 311, 76, 40);
    		getContentPane().add(jb3);
    		jb3.addActionListener(this);//退出键的监听
    		jb2.addActionListener(this);//重置的监听
    		//设置监听
    		jb1.addActionListener(this);//登录的监听实现
    		//给窗口设置标题
    		this.setTitle("学生成绩管理系统-登录");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    	
    	@Override
    	public void actionPerformed(ActionEvent e) { 
    
    		if(e.getActionCommand()=="退出")
    		{ 
    			System.exit(0);
    		}else if(e.getActionCommand()=="登录")
    		{ 
    			if(!jtf.getText().isEmpty() && !String.valueOf(jpf.getPassword()).isEmpty())
    			{ 
    				
    				MysqlConn.ConnectSQL();
    				if(jrb1.isSelected())//选择管理员进行登录
    				{ 
    					if(MysqlConn.queryadm(jtf.getText()))
    					{ 
    						this.adminlogin();//调用这个里面的adminlogin函数
    					}
    				}else if(jrb3.isSelected())//选择学生进行登录
    				{ 
    					
    					if(MysqlConn.querystu(jtf.getText()))
    					{ 
    						MysqlConn.userword = jtf.getText();
    						
    						this.stulogin();
    					}
    				}
    			}else if(jtf.getText().isEmpty())//即没有输入进行输入的状况提示
    			{ 
    				JOptionPane.showMessageDialog(null,"请输入用户名","提示消息",JOptionPane.WARNING_MESSAGE);
    			    this.clear();
    			}else if(String.valueOf(jpf.getPassword()).isEmpty())	
    			{ 
    				JOptionPane.showMessageDialog(null,"请输入密码","提示消息",JOptionPane.WARNING_MESSAGE);
    			    this.clear();
    			}
    		}else if(e.getActionCommand()=="重置")
    		{ 
    			this.clear();
    		}			
    	}
    	
    	//清空文本框和密码框
    	public void clear()
    	{ 
    		jtf.setText("");
    		jpf.setText("");
    	}
    	
    	//管理员登录
    	public void adminlogin(){ 
    		if(MysqlConn.pawd.equals(String.valueOf(jpf.getPassword())))
    		{ 
    			JOptionPane.showMessageDialog(null,"登录成功！","提示消息",JOptionPane.WARNING_MESSAGE);
    			this.clear();
    			//关闭当前界面
    			dispose();
    			//创建一个新界面
    			Admin ad=new Admin();
    		}else if(jtf.getText().isEmpty()&&String.valueOf(jpf.getPassword()).isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入用户名和密码！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else if(jtf.getText().isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入用户名！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else if(String.valueOf(jpf.getPassword()).isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入密码！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else
    		{ 
    			JOptionPane.showMessageDialog(null,"用户名或者密码错误！\n请重新输入","提示消息",JOptionPane.ERROR_MESSAGE);
    		    //清空输入框
    			this.clear();
    		}
    	}
    	
    	
    	//学生登录
    	public void stulogin(){ 
    		if(MysqlConn.pawd.equals(String.valueOf(jpf.getPassword())))
    		{ 
    			JOptionPane.showMessageDialog(null,"登录成功！","提示消息",JOptionPane.WARNING_MESSAGE);
    			this.clear();
    			//关闭当前界面
    			dispose();
    			//创建一个新界面
    			Student stu = new Student();
    		}else if(jtf.getText().isEmpty()&&String.valueOf(jpf.getPassword()).isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入用户名和密码！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else if(jtf.getText().isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入用户名！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else if(String.valueOf(jpf.getPassword()).isEmpty())
    		{ 
    			JOptionPane.showMessageDialog(null,"请输入密码！","提示消息",JOptionPane.WARNING_MESSAGE);
    		}else
    		{ 
    			JOptionPane.showMessageDialog(null,"用户名或者密码错误！\n请重新输入","提示消息",JOptionPane.ERROR_MESSAGE);
    		    //清空输入框
    			this.clear();
    		}
    	}
    }

## 四,功能 ##

①Delete.java

//删除学号与课程号的类
    package gn;
    
    import javax.swing.*;
    import java.awt.BorderLayout;
    import java.awt.FlowLayout;
    import javax.swing.GroupLayout.Alignment;
    import java.awt.Font;
    import java.awt.GridLayout;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import daoru.MysqlConn;
    import SMIS.Stu;
    import SMIS.Student;
    import SMIS.Admin;
    import SMIS.Cou;
    
    public class Delete extends JFrame { 
    	private JTextField textField;
    	public Delete() { 
    		getContentPane().setLayout(null);
    		JPanel panel = new JPanel();
    		panel.setBounds(152, 103, 321, 162);
    		getContentPane().add(panel);
    		panel.setLayout(null);
    		
    		JLabel label = new JLabel("请输入要删除的学号/课程号:");
    		label.setBounds(0, 5, 321, 37);
    		panel.add(label);
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		//定义文本框类
    		textField = new JTextField();
    		textField.setBounds(72, 66, 159, 32);
    		panel.add(textField);
    		textField.setColumns(10);
    		//定义按钮类
    		JRadioButton rdbtnNewRadioButton = new JRadioButton("学生");
    		rdbtnNewRadioButton.setBounds(31, 107, 59, 37);
    		panel.add(rdbtnNewRadioButton);
    		
    		
    		
    		ButtonGroup bg = new ButtonGroup();
    		JRadioButton radioButton_1 = new JRadioButton("课程");
    		radioButton_1.setBounds(121, 107, 59, 37);
    		panel.add(radioButton_1);
    		bg.add(radioButton_1);
    		
    		JPanel panel_1 = new JPanel();
    		panel_1.setBounds(141, 302, 343, 52);
    		getContentPane().add(panel_1);
    		
    		JButton button = new JButton("确定");
    		button.setBounds(8, 5, 76, 40);
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				MysqlConn.ConnectSQL();
    				if(textField.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入学号或课程号!","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else if(!JudgeNum.judge(textField.getText(), textField.getText().length())){ 
    					JOptionPane.showMessageDialog(null, "学号或课程号仅由数字组成，您输入的学号或课程号形式有误!\n请重新输入", "提示消息", JOptionPane.ERROR_MESSAGE);
    				}else if(!rdbtnNewRadioButton.isSelected()&& !radioButton_1.isSelected()){ 
    					JOptionPane.showMessageDialog(null,"请选择学生或课程!","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else if(rdbtnNewRadioButton.isSelected()){ 
    					if(!MysqlConn.querystu(textField.getText())){ 
    						JOptionPane.showMessageDialog(null,"您输入的学号有误!\n请重新输入","提示消息",JOptionPane.ERROR_MESSAGE);
    					}else{ 
    						int option = JOptionPane.showConfirmDialog(null, "您确定删除该学生吗？", "提示消息", JOptionPane.OK_CANCEL_OPTION);
    						if(option == JOptionPane.OK_OPTION){ 
    							MysqlConn.stuid = textField.getText();
    							
    							//执行删除操作
    							MysqlConn.deletestu(MysqlConn.stuid);
    						}else { 
    							textField.setText("");
    						}
    					}
    				}else{ 
    					if(!MysqlConn.querycou(textField.getText())){ 
    						JOptionPane.showMessageDialog(null,"您输入的课程号有误!\n请重新输入","提示消息",JOptionPane.ERROR_MESSAGE);
    					}else{ 
    						int option = JOptionPane.showConfirmDialog(null, "您确定删除该课程吗？", "提示消息", JOptionPane.OK_CANCEL_OPTION);
    						if(option == JOptionPane.OK_OPTION){ 
    							MysqlConn.cno = textField.getText();
    							MysqlConn.deletecou(MysqlConn.cno);
    						}else { 
    							textField.setText("");
    						}
    					}
    				}
    			}
    		});
    		panel_1.setLayout(null);
    		panel_1.add(button);
    		
    		JButton button_1 = new JButton("返回");
    		button_1.setBounds(176, 5, 76, 40);
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Admin ad = new Admin();
    			}
    		});
    		
    		JButton button_2 = new JButton("重置");
    		button_2.setBounds(92, 5, 76, 40);
    		button_2.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				textField.setText("");
    			}
    		});
    		panel_1.add(button_2);
    		panel_1.add(button_1);
    		
    		JButton button_3 = new JButton("退出");
    		button_3.setBounds(260, 5, 76, 40);
    		button_3.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		panel_1.add(button_3);
    		
    		this.setTitle("学生成绩管理系统-管理员-删除学生/课程");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

②InsertCou.java

//插入课程类
    package gn;
    
    import javax.swing.JFrame;
    import javax.swing.JPanel;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    
    import java.awt.Font;
    import javax.swing.JTextField;
    import javax.swing.JButton;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import daoru.MysqlConn;
    import SMIS.Stu;
    import SMIS.Student;
    import SMIS.Admin;
    import SMIS.Cou;
    
    
    public class InsertCou extends JFrame { 
    	private JTextField textField;
    	private JTextField textField_1;
    	private JTextField textField_2;
    	public InsertCou() { 
    		getContentPane().setLayout(null);
    		
    		JPanel panel = new JPanel();
    		panel.setBounds(134, 49, 379, 265);
    		getContentPane().add(panel);
    		panel.setLayout(null);
    		
    		JLabel label = new JLabel("请填写您要添加的课程信息：");
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label.setBounds(79, 14, 238, 36);
    		panel.add(label);
    		
    		JLabel label_1 = new JLabel("课程号:");
    		label_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label_1.setBounds(104, 76, 77, 41);
    		panel.add(label_1);
    		
    		textField = new JTextField();
    		textField.setBounds(181, 80, 110, 34);
    		panel.add(textField);
    		textField.setColumns(10);
    		
    		JLabel label_2 = new JLabel("课程名:");
    		label_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label_2.setBounds(105, 137, 77, 41);
    		panel.add(label_2);
    		
    		textField_1 = new JTextField();
    		textField_1.setColumns(10);
    		textField_1.setBounds(180, 137, 110, 34);
    		panel.add(textField_1);
    		
    		JLabel label_3 = new JLabel("任课教师:");
    		label_3.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label_3.setBounds(104, 199, 77, 41);
    		panel.add(label_3);
    		
    		textField_2 = new JTextField();
    		textField_2.setColumns(10);
    		textField_2.setBounds(181, 201, 110, 34);
    		panel.add(textField_2);
    		
    		JButton button = new JButton("确定");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				MysqlConn.ConnectSQL();
    				if(textField.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入课程号!", "提示消息", JOptionPane.WARNING_MESSAGE);
    				}else if(!JudgeNum.judge(textField.getText(), textField.getText().length())){ 
    					JOptionPane.showMessageDialog(null,"课程号仅由数字组成，您输入的课程号形式有误!\n请重新输入", "提示消息", JOptionPane.WARNING_MESSAGE);
    				}else if(MysqlConn.querycou(textField.getText())){ 
    					JOptionPane.showMessageDialog(null,"该课程已存在!\n请重新输入", "提示消息", JOptionPane.WARNING_MESSAGE);
    				}else if(textField_1.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入课程名!", "提示消息", JOptionPane.WARNING_MESSAGE);
    				}else if(textField_2.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入任课教师!", "提示消息", JOptionPane.WARNING_MESSAGE);
    				}else{ 
    					MysqlConn.cno = textField.getText();
    					MysqlConn.cname = textField_1.getText();
    					MysqlConn.stucredit = textField_2.getText();
    					
    					MysqlConn.insertcou(MysqlConn.cno,MysqlConn.cname,MysqlConn.stucredit);
    				}
    			}
    		});
    		button.setBounds(146, 345, 78, 41);
    		getContentPane().add(button);
    		
    		JButton button_1 = new JButton("重置");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				textField.setText("");
    				textField_1.setText("");
    				textField_2.setText("");
    			}
    		});
    		button_1.setBounds(237, 344, 78, 41);
    		getContentPane().add(button_1);
    		
    		JButton button_2 = new JButton("返回");
    		button_2.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Cou co = new Cou();
    			}
    		});
    		button_2.setBounds(330, 344, 78, 41);
    		getContentPane().add(button_2);
    		
    		JButton button_3 = new JButton("退出");
    		button_3.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_3.setBounds(423, 343, 78, 41);
    		getContentPane().add(button_3);
    		
    		//给窗口设置标题
    		this.setTitle("学生成绩管理系统-管理员-添加课程信息");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

③InsertStu.java

//插入学生的类
    package gn;
    
    import javax.swing.*;
    import java.awt.BorderLayout;
    import java.awt.Font;
    import java.awt.event.ActionListener;
    import java.sql.Date;
    import java.awt.event.ActionEvent;
    import java.awt.FlowLayout;
    import javax.swing.GroupLayout.Alignment;
    import daoru.MysqlConn;
    import SMIS.Stu;
    import SMIS.Student;
    import SMIS.Admin;
    import SMIS.Cou;
    
    
    public class InsertStu extends JFrame { 
    	private JTextField textField;
    	private JTextField textField_1;
    	private JTextField textField_2;
    	private JTextField textField_3;
    	public InsertStu() { 
    		getContentPane().setLayout(null);
    		
    		JPanel panel = new JPanel();
    		panel.setBounds(40, 12, 554, 397);
    		getContentPane().add(panel);
    		panel.setLayout(null);
    		
    		
    		
    		
    		JComboBox comboBox_4 = new JComboBox();
    		comboBox_4.setModel(new DefaultComboBoxModel(new String[] { "计算机科学与技术", "软件工程","测控技术与仪器","自动化","电子信息与工程"}));
    		comboBox_4.setBounds(196, 220, 200, 24);
    		panel.add(comboBox_4);
    		
    		
    		
    		
    		
    		JLabel label_4 = new JLabel("专业:");
    		label_4.setBounds(137, 218, 54, 24);
    		panel.add(label_4);
    		label_4.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JLabel label = new JLabel("学号：");
    		label.setBounds(137, 61, 54, 24);
    		panel.add(label);
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JComboBox comboBox_2 = new JComboBox();//年级对应的代码
    		comboBox_2.setModel(new DefaultComboBoxModel(new String[] { "2020", "2019", "2018", "2017", "2016"}));
    		comboBox_2.setBounds(196, 176, 70, 29);
    		panel.add(comboBox_2);
    		
    	
    		
    		JLabel label_3 = new JLabel("年级：");
    		label_3.setBounds(137, 176, 90, 24);//利用4个坐标进行控制代
    		panel.add(label_3);
    		label_3.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JRadioButton radioButton_1 = new JRadioButton("女");
    		radioButton_1.setBounds(270, 134, 47, 33);
    		panel.add(radioButton_1);
    		radioButton_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JRadioButton radioButton = new JRadioButton("男");
    		radioButton.setBounds(196, 134, 47, 33);
    		panel.add(radioButton);
    		radioButton.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    
    		ButtonGroup bg = new ButtonGroup();
    		bg.add(radioButton);
    		bg.add(radioButton_1);
    		
    		JLabel label_2 = new JLabel("性别：");
    		label_2.setBounds(137, 137, 54, 24);
    		panel.add(label_2);
    		label_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		textField_1 = new JTextField();//第一个文本框
    		textField_1.setBounds(196, 61, 121, 24);
    		panel.add(textField_1);
    		textField_1.setColumns(10);
    		
    		JLabel label_1 = new JLabel("姓名：");
    		label_1.setBounds(137, 100, 54, 24);
    		panel.add(label_1);
    		label_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		textField = new JTextField();//第二个文本框
    		textField.setBounds(196, 99, 121, 24);
    		panel.add(textField);
    		textField.setColumns(10);
    		
    		JLabel label_8 = new JLabel("请填写您要添加的学生信息：");
    		label_8.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label_8.setBounds(142, 18, 235, 30);
    		panel.add(label_8);
    		
    		JPanel panel_1 = new JPanel();//
    		panel_1.setBounds(109, 422, 416, 37);
    		getContentPane().add(panel_1);
    		
    		JButton button = new JButton("确定");//确定按钮
    		button.setBounds(51, 5, 63, 27);
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				MysqlConn.ConnectSQL();
    				if(textField_1.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入学号!","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else if(MysqlConn.querystu(textField_1.getText())){ 
    					JOptionPane.showMessageDialog(null,"该学号已存在!\n请重新输入","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else if(!JudgeNum.judge(textField_1.getText(), textField_1.getText().length())){ 
    					JOptionPane.showMessageDialog(null, "学号仅由数字组成，您输入的学号形式有误!\n请重新输入", "提示消息", JOptionPane.ERROR_MESSAGE);
    				}else if(textField.getText().isEmpty()){ 
    					JOptionPane.showMessageDialog(null,"请输入姓名!","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else if(!radioButton.isSelected() && !radioButton_1.isSelected()){ 
    					JOptionPane.showMessageDialog(null,"请选择性别!","提示消息",JOptionPane.WARNING_MESSAGE);
    				}else{ //获取5个文本框与下拉框中的功能,且进行插入到内容中
    					MysqlConn.stuid = textField_1.getText();//获取三个文本框的内容
    					MysqlConn.stuname = textField.getText();
    					if(radioButton.isSelected())
    						MysqlConn.stusex = "男";
    					else
    						MysqlConn.stusex = "女";
    					MysqlConn.stunj = (String) comboBox_2.getSelectedItem();
    					MysqlConn.stuzy = (String) comboBox_4.getSelectedItem();
    					
    					//把学生信息插入到数据库中
    					MysqlConn.insertstu();
    				}
    			}
    		});
    		panel_1.setLayout(null);
    		panel_1.add(button);
    		
    		JButton button_1 = new JButton("返回");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Stu st = new Stu();
    			}
    		});
    		button_1.setBounds(203, 5, 63, 27);
    		panel_1.add(button_1);
    		
    		JButton button_2 = new JButton("退出");
    		button_2.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_2.setBounds(280, 5, 63, 27);
    		panel_1.add(button_2);
    		
    		JButton button_3 = new JButton("重置");
    		button_3.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				textField.setText("");
    				textField_1.setText("");
    				textField_2.setText("");
    				textField_3.setText("");
    			}
    		});
    		button_3.setBounds(126, 5, 63, 27);
    		panel_1.add(button_3);
    		
    		this.setTitle("学生成绩管理系统-管理员-添加学生信息");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    	
    
    }

④JudgeNum.java

//判断是否是数字的类-->用于课程号处
    package gn;
    
    public class JudgeNum { 
    	
    	public static boolean judge(String s,int len){ 
    		for(int i = 0; i < len; i++){ 
    			if(!Character.isDigit(s.charAt(i))){ 
    				return false;
    			}
    		}
    		return true;
    	}
    	
    	public static boolean judge(String s){ 
    		try{ 
    			Float.valueOf(s);
    			return true;
    		}catch(Exception e){ 
    			e.printStackTrace();
    		}
    		return false;
    	}
    	
    	
    }

⑤QueryCou.java

//查询课程的类
    package gn;
    
    import javax.swing.JFrame;
    import javax.swing.JLabel;
    import javax.swing.JOptionPane;
    
    import java.awt.Font;
    import javax.swing.JScrollPane;
    import javax.swing.JTable;
    import javax.swing.table.DefaultTableModel;
    import javax.swing.JButton;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import daoru.MysqlConn;
    import SMIS.Stu;
    import SMIS.Student;
    import SMIS.Admin;
    import SMIS.Cou;
    
    public class QueryCou extends JFrame { 
    	private JTable table;
    	public QueryCou() { 
    		getContentPane().setLayout(null);
    		
    		JScrollPane scrollPane = new JScrollPane();
    		scrollPane.setBounds(54, 148, 525, 180);
    		getContentPane().add(scrollPane);
    		
    		table = new JTable();
    		table.setRowHeight(30);
    		table.setModel(new DefaultTableModel(
    			new Object[][] { 
    				{ null, null, null},
    				{ null, null, null},
    				{ null, null, null},
    				{ null, null, null},
    				{ null, null, null},
    			},
    			new String[] { 
    				"课程号", "课程名", "任课教师"
    			}
    		));
    		table.getColumnModel().getColumn(0).setPreferredWidth(100);
    		scrollPane.setViewportView(table);
    		
    		MysqlConn.ConnectSQL();
    		MysqlConn.getdatacou();
    		
    		if(MysqlConn.counter == 0){ 
    			JOptionPane.showMessageDialog(null, "课程还未导入!", "提示消息", JOptionPane.ERROR_MESSAGE);
    		}
    			
    		for(int i = 0; i < MysqlConn.counter; i++){ 
    			table.setValueAt(MysqlConn.c_no[i], i, 0);
    			table.setValueAt(MysqlConn.c_name[i], i, 1);
    			table.setValueAt(MysqlConn.c_rkjs[i], i, 2);
    		}
    		
    		JLabel label = new JLabel("所有课程信息如下：");
    		label.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		label.setBounds(235, 76, 164, 45);
    		getContentPane().add(label);
    		
    		JButton button = new JButton("返回");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Cou co = new Cou();
    			}
    		});
    		button.setBounds(199, 367, 89, 36);
    		getContentPane().add(button);
    		
    		JButton button_1 = new JButton("退出");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_1.setBounds(362, 367, 89, 36);
    		getContentPane().add(button_1);
    		
    		//给窗口设置标题
    		this.setTitle("学生成绩管理系统-管理员-查询课程信息");
    		//设置窗体大小
    		this.setSize(650,520);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

⑥Query.java

//查询学生成绩与学生信息的类
    package gn;
    
    import javax.swing.*;
    import javax.swing.table.DefaultTableModel;
    
    import java.awt.Font;
    import java.awt.event.ActionListener;
    import java.awt.event.ActionEvent;
    import daoru.MysqlConn;
    import SMIS.Stu;
    import SMIS.Student;
    import SMIS.Admin;
    import SMIS.Cou;
    
    
    public class QueryStu extends JFrame{ 
    	private JTable table;
    	private JTable table_1;
    	public QueryStu() { 
    		getContentPane().setLayout(null);
    		
    		JPanel panel_1 = new JPanel();
    		panel_1.setBounds(0, 34, 882, 226);
    		getContentPane().add(panel_1);
    		panel_1.setLayout(null);
    		
    		JLabel label_1 = new JLabel("所有学生个人信息");
    		label_1.setBounds(365, 15, 151, 24);
    		panel_1.add(label_1);
    		label_1.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JScrollPane scrollPane = new JScrollPane();
    		scrollPane.setBounds(0, 52, 882, 152);
    		panel_1.add(scrollPane);
    		
    		table = new JTable();
    		table.setRowHeight(30);
    		scrollPane.setViewportView(table);
    		table.setModel(new DefaultTableModel(
    			new Object[][] { 
    				{ null, null, null, null, null, null, null, null},
    				{ null, null, null, null, null, null, null, null},
    				{ null, null, null, null, null, null, null, null},
    				{ null, null, null, null, null, null, null, null},
    			},
    			new String[] { 
    				"学号", "姓名", "性别", "专业", "年级","","",""
    			}
    		));
    		table.getColumnModel().getColumn(5).setPreferredWidth(100);
    		
    		JPanel panel_2 = new JPanel();
    		panel_2.setBounds(156, 286, 642, 295);
    		getContentPane().add(panel_2);
    		panel_2.setLayout(null);
    		
    		JScrollPane scrollPane_1 = new JScrollPane();
    		scrollPane_1.setBounds(0, 37, 642, 242);
    		panel_2.add(scrollPane_1);
    		
    		table_1 = new JTable();
    		table_1.setRowHeight(30);
    		scrollPane_1.setViewportView(table_1);
    		table_1.setModel(new DefaultTableModel(
    			new Object[][] { 
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    				{ null, null, null, null, null, null},
    			},
    			new String[] { 
    				"学号", "课程编号", "课程名称", "分数", "", ""
    			}
    		));
    		
    		MysqlConn.ConnectSQL();
    		MysqlConn.getdatastu();//调用读取学生信息的函数
    		if(MysqlConn.counter == 0){ 
    			JOptionPane.showMessageDialog(null, "学生信息还未导入!", "提示消息", JOptionPane.ERROR_MESSAGE);
    		}
    		//返回学生信息的所有信息
    		for(int i = 0; i < MysqlConn.counter; i++){ 
    			table.setValueAt(MysqlConn.stu_sno[i], i, 0);
    			table.setValueAt(MysqlConn.stu_name[i], i, 1);
    			table.setValueAt(MysqlConn.stu_sex[i], i, 2);
    			table.setValueAt(MysqlConn.stu_zy[i], i, 3);
    			table.setValueAt(MysqlConn.stu_nj[i], i, 4);
    		}
    		
    		MysqlConn.getdatagra();
    		if(MysqlConn.counter == 0){ 
    			JOptionPane.showMessageDialog(null, "学生成绩还未导入!", "提示消息", JOptionPane.ERROR_MESSAGE);
    		}
    		for(int i = 0; i < MysqlConn.counter; i++){ 
    			table_1.setValueAt(MysqlConn.c_name[i], i, 0);
    			table_1.setValueAt(MysqlConn.stu_kcbh[i], i, 1);
    			table_1.setValueAt(MysqlConn.stu_kcmc[i], i, 2);
    			table_1.setValueAt(MysqlConn.stu_point[i], i, 3);
    		}
    		
    		JLabel label_2 = new JLabel("所有学生成绩信息");
    		label_2.setBounds(201, 0, 167, 34);
    		panel_2.add(label_2);
    		label_2.setFont(new Font("Microsoft YaHei UI", Font.PLAIN, 18));
    		
    		JButton button = new JButton("返回");
    		button.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				dispose();
    				Stu st = new Stu();
    			}
    		});
    		button.setBounds(329, 603, 85, 37);
    		getContentPane().add(button);
    		
    		JButton button_1 = new JButton("退出");
    		button_1.addActionListener(new ActionListener() { 
    			public void actionPerformed(ActionEvent e) { 
    				System.exit(0);
    			}
    		});
    		button_1.setBounds(520, 603, 85, 37);
    		getContentPane().add(button_1);
    		
    		this.setTitle("学生成绩管理系统-管理员-查询学生信息");
    		//设置窗体大小
    		this.setSize(900,700);
    		//设置窗体初始位置
    		this.setLocation(200, 150);
    		//设置当关闭窗口时，保证JVM也退出
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    		//显示窗体
    		this.setVisible(true);
    		//窗体大小可变
    		this.setResizable(true);
    	}
    }

# 最终界面类 #

①登录界面  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70][]  
②  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70 1]  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70 2][]

其余类就不完全演示了

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70]: /images/20221120/9aec629da29a4a9f88dd2a77be32e54f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201227142617995.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2020122714263434.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMzOTQyMDQw,size_16,color_FFFFFF,t_70