java 研究生初试录取系统

package Graduate; import java.util.Vector; import java.awt.*; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.*; import javax.swing.*; public class PostGrad extends JFrame implements ActionListener { //rowData用于存放行数据： //columnName用于存放列数据; Vector rowData,columnName; JTable j = null ;//初试合格JTable JTable jt1 = null;//考生基本信息JTable JTable jt2 = null; JScrollPane jsp =null ; //选项文本框 JComboBox jc1 = null;//报考年度 JComboBox jc2 = null;//报考专业 JComboBox jc3 = null;//是否应届 JComboBox jc4 = null;//报考年度（录取线） //按钮 JButton bn1 = null;//查询成绩 JButton bn2 = null;//增加考生 JButton bn3 = null;//显示所有 JButton bn4 = null;//设定录取线 //文本框 JTextField jf1 = null ; JTextField jf2 = null ; JTextField jf3 = null ; JTextField jf4 = null ; JTextField jf5 = null ; JTextField jf6 = null ; JTextField jf7 = null ; JTextField jf8 = null ; JTextField jf9 = null ; JTextField jf10 = null ; JTextField jf11 = null ; //设置选项卡; private JTabbedPane pane = new JTabbedPane(); //考生基本信息界面 public Component createMsg() { JPanel jp = new JPanel (); JScrollPane jsp1 =null; //设置空布局 jp.setLayout(null); //初始化选择文本框 jc1 = new JComboBox(new String[]{"2010","2011","2012","2013","2014"}); jc2 = new JComboBox(new String[]{"计算机","金融管理","护专","应用数学"}); jc3 = new JComboBox(new String[]{"是","否"}); //初始化标签 JLabel jb1 = new JLabel(" 准考证号"); JLabel jb2 = new JLabel(" 考生姓名"); JLabel jb3 = new JLabel(" 报考年度"); JLabel jb4 = new JLabel(" 报考专业"); JLabel jb5 = new JLabel(" 是否应届"); JLabel jb6 = new JLabel(" 政治成绩"); JLabel jb7 = new JLabel(" 数学成绩"); JLabel jb8 = new JLabel(" 英语成绩"); JLabel jb9 = new JLabel(" 专业基础"); //单行文本框 jf1= new JTextField(10);//准考证号 jf2= new JTextField(10);//姓名 jf6= new JTextField(10);//政治 jf7= new JTextField(10);//数学 jf8= new JTextField(10);//外语 jf9= new JTextField(10);//专业基础 //操作按钮 bn1 = new JButton("查询成绩"); //bn1.setActionCommand("Search"); bn1.addActionListener(this); bn2 = new JButton("增加考生"); bn2.addActionListener(this); bn3 = new JButton("显示所有"); bn3.addActionListener(this); //按钮定位 jp.add(bn1); bn1.setBounds(0, 90, 140, 30); jp.add(bn2); bn2.setBounds(140, 90, 140,30); jp.add(bn3); bn3.setBounds(280, 90, 140,30); jp.add(jb1); jb1.setBounds(0, 0, 140, 30); jp.add(jf1); jf1.setBounds(140, 0, 140, 30); jp.add(jb2); jb2.setBounds(280, 0, 140, 30); jp.add(jf2); jf2.setBounds(420, 0, 140, 30); jp.add(jb3); jb3.setBounds(560, 0, 130, 30); jp.add(jc1); jc1.setBounds(700, 0, 130, 30); //第二行 jp.add(jb4); jb4.setBounds(0, 30, 140, 30); jp.add(jc2); jc2.setBounds(140, 30, 140, 30); jp.add(jb5); jb5.setBounds(280, 30, 140, 30); jp.add(jc3); jc3.setBounds(420, 30, 140, 30); jp.add(jb6); jb6.setBounds(560, 30, 130, 30); jp.add(jf6); jf6.setBounds(700, 30, 130, 30); //第三行 jp.add(jb7); jb7.setBounds(0, 60, 140, 30); jp.add(jf7); jf7.setBounds(140, 60, 140, 30); jp.add(jb8); jb8.setBounds(280, 60, 140, 30); jp.add(jf8); jf8.setBounds(420, 60, 140, 30); jp.add(jb9); jb9.setBounds(560, 60, 130, 30); jp.add(jf9); jf9.setBounds(700, 60, 130, 30); MsgModel m1 = new MsgModel("select * from ExamStud where Eno = '421121101'"); jt1 = new JTable(m1);//考生基本信息JTable jsp1 = new JScrollPane(jt1); jsp1.setBounds(0, 120, 830, 200); jp.add(jsp1); return jp; } //初试合格考生界面 public Component createWin() { JPanel jp0 = new JPanel(); jp0.setLayout(null); MsgModel m =new MsgModel("select * from ExamStud"); j = new JTable(m); jsp= new JScrollPane(j); jsp.setBounds(5, 10, 820, 400); jp0.add(jsp); return jp0; } //国家最低录取线界面 public Component createLev() { jc4 = new JComboBox(new String[]{"2010","2011","2012","2013","2014"}); JPanel jp = new JPanel (); JScrollPane jsp2 =null; bn4 = new JButton("设定国家最低录取线"); bn4.addActionListener(this); jp.setLayout(null); JLabel jb1 = new JLabel(" 报考年度"); JLabel jb2 = new JLabel(" 政治最低分"); JLabel jb3 = new JLabel(" 数学最低分"); JLabel jb4 = new JLabel(" 英语最低分"); JLabel jb5 = new JLabel(" 专业最低分"); JLabel jb6 = new JLabel(" 总分最低分"); jf10= new JTextField(10); jf3= new JTextField(10); jf4= new JTextField(10); jf5= new JTextField(10); jf11= new JTextField(10); jp.add(bn4); bn4.setBounds(5, 70, 175, 30); jp.add(jb1); jb1.setBounds(0, 0, 140, 30); jp.add(jc4); jc4.setBounds(140, 0, 140, 30); jp.add(jb2); jb2.setBounds(280, 0, 140, 30); jp.add(jf10); jf10.setBounds(420, 0, 140, 30); jp.add(jb3); jb3.setBounds(560, 0, 130, 30); jp.add(jf3); jf3.setBounds(700, 0, 130, 30); //第二行 jp.add(jb4); jb4.setBounds(0, 30, 140, 30); jp.add(jf4); jf4.setBounds(140, 30, 140, 30); jp.add(jb5); jb5.setBounds(280, 30, 140, 30); jp.add(jf5); jf5.setBounds(420, 30, 140, 30); jp.add(jb6); jb6.setBounds(560, 30, 130, 30); jp.add(jf11); jf11.setBounds(700, 30, 130, 30); LevelModel lm = new LevelModel("select * from ScoreLev"); jt2 = new JTable(lm); jsp2 = new JScrollPane(jt2); jsp2.setBounds(5, 110, 825, 350); jp.add(jsp2); return jp; } //构造函数 public PostGrad() { setTitle("研究生初试录取系统"); pane.addTab("考生基本信息", createMsg()); pane.addTab("初试合格考生", createWin()); pane.addTab("国家最低录取线",createLev()); add(pane); this .setSize(840,500); this .setResizable(false); this .setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this .setVisible(true); } public static void main(String[] args) { try { PostGrad pg = new PostGrad(); } catch(NullPointerException e) { System.out.print("加载错误！"); } } @Override public void actionPerformed(ActionEvent e) { //查询按钮触发 if(e.getSource()== bn1) { String Eno = this.jf1.getText().trim(); if(Eno.equals("") )//用户未输入时弹出提示框； { JOptionPane.showMessageDialog(this,"请通过准考证号查询！"); } else { String sql = "select * from ExamStud where Eno ='" + Eno +"'"; MsgModel msg = new MsgModel(sql); jt1.setModel(msg); } } //增加考生按钮触发 if(e.getSource()== bn2) { String no =this.jf1.getText().trim(); String name =this.jf2.getText().trim(); String enter =(String)(this.jc1.getSelectedItem()); String major =(String)(this.jc2.getSelectedItem()); String fresh =(String)(this.jc3.getSelectedItem()); String polity =this.jf6.getText().trim(); String math =this.jf7.getText().trim(); String english=this.jf8.getText().trim(); String base =this.jf9.getText().trim(); if(no.equals("")||name.equals("")||polity.equals("")||math.equals("")||english.equals("")||base.equals("")) { JOptionPane.showMessageDialog(this,"请添加完整信息！"); } else { int p = Integer.parseInt(polity); int m = Integer.parseInt(math); int en = Integer.parseInt(english); int b = Integer.parseInt(base); String sql = "insert into ExamStud values('"+no+"'"+","+"'"+name+"'"+","+"'"+enter+"'"+","+"'"+major+"'"+","+"'"+fresh+"'" +","+p+","+m+","+en+","+b+")"; MsgModel msg = new MsgModel(sql); jt1.setModel(msg); JOptionPane.showMessageDialog(this,"添加成功！"); //显示添加的记录 String sql1 = "select * from ExamStud where Eno ='" + no +"'";