JAVA+MySQL学生成绩管理系统

package GradeManage; import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*; import javax.swing.table.DefaultTableModel; import javax.swing.table.JTableHeader; public class ScoreSectionForm extends JFrame implements ActionListener{ JLabel labClass=new JLabel("\u73ED\u7EA7\uFF1A"); JLabel labLesson=new JLabel("\u79D1\u76EE\uFF1A(Chinese,Math,English)"); JTextField txtClass=new JTextField(20); JTextField txtLesson=new JTextField(20); JButton btnSection1=new JButton("\u4E0D\u53CA\u683C(0-59)"); JButton btnSection2=new JButton("\u4E2D(60-69)"); JButton btnSection3=new JButton("\u826F(70-79)"); JButton btnSection4=new JButton("\u4F18\u79C0(80-89)"); JButton btnSection5=new JButton("\u975E\u5E38\u4F18\u79C0(90-100)"); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); String []str={"班级","姓名","学号","成绩"}; Object[][] data=new Object[50][4]; JTable table=new JTable(data,str); JTableHeader head=table.getTableHeader(); JScrollPane jsp=new JScrollPane(table); //滚动 Statement sql; ResultSet rs; ScoreSectionForm(){ super("分数段查询"); setSize(500,400); setLocation(500,200); labClass.setHorizontalAlignment(SwingConstants.CENTER); pan1.add(labClass); pan1.add(txtClass); labLesson.setHorizontalAlignment(SwingConstants.CENTER); pan1.add(labLesson); pan1.add(txtLesson); pan1.add(btnSection1); pan1.add(btnSection2); pan1.add(btnSection3); pan1.add(btnSection4); pan1.add(btnSection5); pan1.setLayout(new GridLayout(5,2)); //以上3条在第一个面板加入内容 getContentPane().add(pan1,"North"); //把面板1放到窗口顶部 pan2.setLayout(new BorderLayout()); pan2.add(head,"North"); //将表头放在面板3的顶部 pan2.add(jsp,"Center"); //表格放在pan3中间 getContentPane().add(pan2,"Center"); //把面板3整体加入到主窗口中 btnSection1.addActionListener(this); //增加查询按钮的监视器 btnSection2.addActionListener(this); btnSection3.addActionListener(this); btnSection4.addActionListener(this); btnSection5.addActionListener(this); setVisible(true); } public void actionPerformed(ActionEvent ae){ if(ae.getSource()==btnSection1){ int i,j,row; MysqlForm.con=MysqlForm.getConnection(); try{sql=MysqlForm.con.createStatement(); rs=sql.executeQuery("select COUNT(*) as rowcount from stu where class ='"+txtClass.getText()+"'"); //寻找有成绩的行数 rs.next(); //去掉头 row=rs.getInt("rowcount"); rs.close(); data=new Object[row][5]; rs=sql.executeQuery("select class,name,id,"+txtLesson.getText()+" from stu where class = '"+txtClass.getText()+"' and "+txtLesson.getText()+"<60"); i=0; j=0; while(rs.next()){ data[i][j++]=rs.getString("class"); data[i][j++]=rs.getString("name"); data[i][j++]=rs.getString("id"); data[i][j]=new Integer(rs.getInt(txtLesson.getText())); //将数据库中查询到的信息保存到data中 i++; j=0; } pan2.removeAll(); getContentPane().remove(pan2); table=new JTable(data,str); pan2.setLayout(new BorderLayout()); head=table.getTableHeader(); jsp=new JScrollPane(table); pan2.add(head,"North"); pan2.add(jsp,"Center"); getContentPane().add(pan2,"Center"); this.validate(); MysqlForm.closeConnection(); }catch(SQLException e){ } } else if(ae.getSource()==btnSection2){ int i,j,row; MysqlForm.con=MysqlForm.getConnection(); try{sql=MysqlForm.con.createStatement(); rs=sql.executeQuery("select COUNT(*) as rowcount from stu where class ='"+txtClass.getText()+"'"); //寻找有成绩的行数 rs.next(); //去掉头 row=rs.getInt("rowcount"); rs.close(); data=new Object[row][5]; rs=sql.executeQuery("select class,name,id,"+txtLesson.getText()+" from stu where class = '"+txtClass.getText()+"' and "+txtLesson.getText()+">59 and "+txtLesson.getText()+"<70"); i=0; j=0; while(rs.next()){ data[i][j++]=rs.getString("class"); data[i][j++]=rs.getString("name"); data[i][j++]=rs.getString("id"); data[i][j]=new Integer(rs.getInt(txtLesson.getText())); //将数据库中查询到的信息保存到data中 i++; j=0; } pan2.removeAll(); getContentPane().remove(pan2); table=new JTable(data,str); pan2.setLayout(new BorderLayout()); head=table.getTableHeader(); jsp=new JScrollPane(table); pan2.add(head,"North"); pan2.add(jsp,"Center"); getContentPane().add(pan2,"Center"); this.validate(); MysqlForm.closeConnection(); }catch(SQLException e){ } } else if(ae.getSource()==btnSection3){ int i,j,row; MysqlForm.con=MysqlForm.getConnection(); try{sql=MysqlForm.con.createStatement(); rs=sql.executeQuery("select COUNT(*) as rowcount from stu where class ='"+txtClass.getText()+"'"); //寻找有成绩的行数 rs.next(); //去掉头 row=rs.getInt("rowcount"); rs.close(); data=new Object[row][5]; rs=sql.executeQuery("select class,name,id,"+txtLesson.getText()+" from stu where class = '"+txtClass.getText()+"' and "+txtLesson.getText()+">69 and "+txtLesson.getText()+"<80"); i=0; j=0; while(rs.next()){ data[i][j++]=rs.getString("class"); data[i][j++]=rs.getString("name"); data[i][j++]=rs.getString("id"); data[i][j]=new Integer(rs.getInt(txtLesson.getText())); //将数据库中查询到的信息保存到data中 i++; j=0; } pan2.removeAll(); getContentPane().remove(pan2); table=new JTable(data,str); pan2.setLayout(new BorderLayout()); head=table.getTableHeader(); jsp=new JScrollPane(table); pan2.add(head,"North"); pan2.add(jsp,"Center"); getContentPane().add(pan2,"Center"); this.validate(); MysqlForm.closeConnection(); }catch(SQLException e){ } } else if(ae.getSource()==btnSection4){ int i,j,row; MysqlForm.con=MysqlForm.getConnection(); try{sql=MysqlForm.con.createStatement(); rs=sql.executeQuery("select COUNT(*) as rowcount from stu where class ='"+txtClass.getText()+"'"); //寻找有成绩的行数 rs.next(); //去掉头 row=rs.getInt("rowcount"); rs.close(); data=new Object[row][5]; rs=sql.executeQuery("select class,name,id,"+txtLesson.getText()+" from stu where class = '"+txtClass.getText()+"' and "+txtLesson.getText()+">79 and "+txtLesson.getText()+"<90"); i=0; j=0; while(rs.next()){ data[i][j++]=rs.getString("class"); data[i][j++]=rs.getString("name"); data[i][j++]=rs.getString("id");