java swing 超小型学生管理项目

import javax.swing.JPanel; import javax.swing.JFrame; import java.awt.Dimension; import javax.swing.JComboBox; import java.awt.Rectangle; import java.sql.Statement; import java.sql.ResultSet; import java.util.Vector; import javax.swing.ButtonGroup; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.ListSelectionModel; import javax.swing.event.ListSelectionEvent; import javax.swing.event.ListSelectionListener; import javax.swing.table.DefaultTableModel; import javax.swing.JTextField; import java.awt.Point; import javax.swing.JButton; import javax.swing.JRadioButton; public class EditScor extends JFrame { private static final long serialVersionUID = 1L; private JPanel jContentPane = null; private JComboBox jComboBox = null; private JLabel jLabel = null; private JScrollPane jScrollPane = null; private JTable jTable = null; private DefaultTableModel tableModel; static Sql da; static Statement stmt; private JLabel jLabel1 = null; private JTextField jTextField = null; private JLabel jLabel2 = null; private JTextField jTextField1 = null; private JButton jButton = null; private JRadioButton jRadioButton = null; private JRadioButton jRadioButton1 = null; private ButtonGroup group = null; static private String f = new String("All"); // @jve:decl-index=0: private JRadioButton jRadioButton2 = null; /** * This is the default constructor */ public EditScor() { super(); da = new Sql("Database.mdb");//链接数据库，数据库文件在同一目录下 stmt=da.getStatement();//取得一个该数据库Statement initialize(); } protected void finalize() throws Throwable { super.finalize(); // other finalization code... da.end(); } /** * This method initializes this * * @return void */ private void initialize() { this.setSize(484, 371); this.setContentPane(getJContentPane()); this.setTitle("学生成绩编辑查看"); } /** * This method initializes jContentPane * * @return javax.swing.JPanel */ private JPanel getJContentPane() { if (jContentPane == null) { jLabel2 = new JLabel(); jLabel2.setBounds(new Rectangle(20, 97, 46, 34)); jLabel2.setText("分数"); jLabel1 = new JLabel(); jLabel1.setBounds(new Rectangle(21, 52, 47, 31)); jLabel1.setText("学号"); jLabel = new JLabel(); jLabel.setBounds(new Rectangle(21, 8, 48, 32)); jLabel.setText("科目"); jContentPane = new JPanel(); jContentPane.setLayout(null); jContentPane.add(getJComboBox(), null); jContentPane.add(jLabel, null); jContentPane.add(getJScrollPane(), null); jContentPane.add(jLabel1, null); jContentPane.add(getJTextField(), null); jContentPane.add(jLabel2, null); jContentPane.add(getJTextField1(), null); jContentPane.add(getJButton(), null); jContentPane.add(getJRadioButton(), null); jContentPane.add(getJRadioButton1(), null); jContentPane.add(getJRadioButton2(), null); group = new ButtonGroup(); group.add(getJRadioButton()); group.add(getJRadioButton1()); group.add(getJRadioButton2()); } return jContentPane; } /** * This method initializes jComboBox * * @return javax.swing.JComboBox */ private JComboBox getJComboBox() { if (jComboBox == null) { Vector items=new Vector(); items.add("All"); items.add("Compiler"); items.add("DataBase"); items.add("Network"); jComboBox = new JComboBox(items); jComboBox.setBounds(new Rectangle(75, 15, 87, 20)); jComboBox.addItemListener(new java.awt.event.ItemListener() { public void itemStateChanged(java.awt.event.ItemEvent e) { f=jComboBox.getSelectedItem().toString(); getJTable(); } }); } return jComboBox; } /** * This method initializes jScrollPane * * @return javax.swing.JScrollPane */ private JScrollPane getJScrollPane() { if (jScrollPane == null) { jScrollPane = new JScrollPane(); jScrollPane.setBounds(new Rectangle(179, 14, 280, 320)); jScrollPane.setViewportView(getJTable()); } return jScrollPane; } /** * This method initializes jTable * * @return javax.swing.JTable */ private JTable getJTable() { Vector cell ; Vector row = new Vector(); String[] tableHeads = {"ID","姓名","科目", "分数"}; Vector tableHeadName = new Vector(); if (jTable == null) { jTable =new JTable(); jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); jTable.setSize(new Dimension(200, 100)); tableModel =new DefaultTableModel() { /** * */ private static final long serialVersionUID = 1L; public boolean isCellEditable(int row, int column) { return false; } }; jTable.getSelectionModel().addListSelectionListener(new ListSelectionListener() { public void valueChanged(ListSelectionEvent arg0) { // TODO Auto-generated method stub if(jTable.getSelectedRow()!=-1){ jTextField.setText(jTable.getValueAt(jTable.getSelectedRow(), 0).toString()); jTextField1.setText(jTable.getValueAt(jTable.getSelectedRow(), 3).toString()); //jTextField2.setText(jTable.getValueAt(jTable.getSelectedRow(), 2).toString()); } }}); for (int i = 0; i < tableHeads.length; i++) { tableHeadName.add(tableHeads[i]); } try{ ResultSet rs=stmt.executeQuery("select * from courses order by [course],[scorse] DESC"); while(rs.next()) { cell = new Vector(); cell.add(rs.getString(2)); cell.add(""); cell.add(rs.getString(3)); cell.add(rs.getString(4)); row.add(cell); } }catch(Exception e) { e.printStackTrace(); } try{ for(int i=0;i<row.size();i++) { String s="select * from students where [number]='"+((Vector)row.get(i)).get(0).toString()+"'"; ResultSet rs1=stmt.executeQuery(s); if(rs1.next()) ((Vector)row.get(i)).set(1, rs1.getString(3)); } }catch(Exception e) { e.printStackTrace(); } tableModel.setDataVector(row, tableHeadName); jTable.setModel(tableModel); }else { row.clear(); tableHeadName.clear(); String s; for (int i = 0; i < tableHeads.length; i++) { tableHeadName.add(tableHeads[i]); } try{ if(f.equals("All")) { s="select * from courses order by [course],[scorse] DESC"; } else { s="select * from courses where [course]='"+f+"' order by [scorse] DESC"; } ResultSet rs=stmt.executeQuery(s); while(rs.next()) { cell = new Vector(); cell.add(rs.getString(2)); cell.add(""); cell.add(rs.getString(3)); cell.add(rs.getString(4)); row.add(cell); } }catch(Exception e) { e.printStackTrace(); } try{ for(int i=0;i<row.size();i++) { String s1="select * from students where [number]='"+((Vector)row.get(i)).get(0).toString()+"'"; ResultSet rs1=stmt.executeQuery(s1); if(rs1.next()) ((Vector)row.get(i)).set(1, rs1.getString(3)); } }catch(Exception e) { e.printStackTrace(); } tableModel.setDataVector(row, tableHeadName); } return jTable; } /** * This method initializes jTextField * * @return javax.swing.JTextField */ private JTextField getJTextField() { if (jTextField == null) { jTextField = new JTextField(); jTextField.setLocation(new Point(76, 56)); jTextField.setEditable(true); jTextField.setSize(new Dimension(86, 25)); } return jTextField; } /** * This method initializes jTextField1 * * @return javax.swing.JTextField */ private JTextField getJTextFi