Swing框架的学生管理系统实现班级、学生、年级

/* * StudentInteFrm.java * * Created on __DATE__, __TIME__ */ package com.lq.view; import java.sql.Connection; import java.sql.ResultSet; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import com.lq.dao.ClassDao; import com.lq.dao.StudentDao; import com.lq.moder.Student; import com.lq.util.DbUtil; import com.lq.util.StringUtil; import com.lq.moder.Class; /** * * @author __USER__ */ public class StudentInteFrm extends javax.swing.JInternalFrame { DbUtil dbUtil = new DbUtil(); int id = -1; /** Creates new form StudentInteFrm */ public StudentInteFrm() { initComponents(); this.setLocation(250, 250); fillTable(new Student()); cshCom(); fillCom(); } private void cshCom() { Class class1 = new Class(); class1.setId(-1); class1.setClasName("请选择...."); gradeCom.addItem(class1); } private void fillCom() { Connection con = null; ClassDao classDao = null; Class class1 = null; try { con = dbUtil.getCon(); classDao = new ClassDao(); ResultSet rest = classDao.classNameList(con); while (rest.next()) { class1 = new Class(); class1.setId(rest.getInt("id")); class1.setClasName(rest.getString("className")); gradeCom.addItem(class1); classC.addItem(class1); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dbUtil.Close(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } private void fillTable(Student student) { Connection con = null; DefaultTableModel defaultTableModel = (DefaultTableModel) studentTable .getModel(); defaultTableModel.setRowCount(0); try { con = dbUtil.getCon(); StudentDao studentDao = new StudentDao(); ResultSet rest = studentDao.studentList(con, student); while (rest.next()) { Vector v = new Vector(); v.add(rest.getString("stuNumber")); v.add(rest.getString("stuName")); v.add(rest.getString("birthday")); v.add(rest.getString("place")); v.add(rest.getString("className")); v.add(rest.getString("stuDesc")); v.add(rest.getInt("id")); defaultTableModel.addRow(v); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); JOptionPane.showMessageDialog(null, "初始化失败"); } finally { try { dbUtil.Close(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } //GEN-BEGIN:initComponents // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); studentTable = new javax.swing.JTable(); jPanel1 = new javax.swing.JPanel(); jLabel1 = new javax.swing.JLabel(); stuidTxt = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); nameTxt = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); gradeCom = new javax.swing.JComboBox(); referJB = new javax.swing.JButton(); placeTxt = new javax.swing.JTextField(); jPanel2 = new javax.swing.JPanel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jLabel8 = new javax.swing.JLabel(); jLabel9 = new javax.swing.JLabel(); jLabel10 = new javax.swing.JLabel(); stuIdT = new javax.swing.JTextField(); nameT = new javax.swing.JTextField(); placeT = new javax.swing.JTextField(); birthdayT = new javax.swing.JTextField(); classC = new javax.swing.JComboBox(); jScrollPane2 = new javax.swing.JScrollPane(); descT = new javax.swing.JTextArea(); deleteJB = new javax.swing.JButton(); fixJB = new javax.swing.JButton(); setIconifiable(true); studentTable.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { }, new String [] { "学号", "姓名", "出生日期", "籍贯", "班级", "备注", "编号" } ) { boolean[] canEdit = new boolean [] { false, false, false, false, false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit [columnIndex]; } }); studentTable.addMouseListener(new java.awt.event.MouseAdapter() { public void mousePressed(java.awt.event.MouseEvent evt) { studentTableMousePressed(evt); } }); jScrollPane1.setViewportView(studentTable); jPanel1.setToolTipText(""); jLabel1.setText("\u5b66\u53f7\uff1a"); jLabel2.setText("\u59d3\u540d\uff1a"); jLabel3.setText("\u7c4d\u8d2f\uff1a"); jLabel4.setText("\u73ed\u7ea7\uff1a"); referJB.setText("\u67e5\u8be2"); referJB.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { referJBActionPerformed(evt); } }); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(35, 35, 35) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1) .addComponent(jLabel2)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(nameTxt) .addComponent(stuidTxt, javax.swing.GroupLayout.DEFAULT_SIZE, 76, Short.MAX_VALUE)) .addGap(27, 27, 27) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel3) .addComponent(jLabel4)) .addGap(41, 41, 41) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(placeTxt) .addComponent(gradeCom, 0, 80, Short.MAX_VALUE)) .addGap(57, 57, 57) .addComponent(referJB, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(260, 260, 260)) ); jPanel1Layout.setVerticalGroup( jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup() .addGap(16, 16, 16) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(jLabel1) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(stuidTxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel3) .addComponent(placeTxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(39, 39, 39) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(nameTxt, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel4) .addComponent(referJB) .addComponent(gradeCom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap(69, Short.MAX_VALUE)) ); jLabel5.setText("\u5b66\u53f7\uff1a"); jLabel6.setText("\u59d3\u540d\uff1a"); jLabel7.setText("\u7c4d\u8d2f\uff1a"); jLabel8.setText("\u51fa\u751f\u65e5\u671f\uff1a"); jLabel9.setText("\u73ed\u7ea7\uff1a"); jLabel10.setText("\u5907\u6ce8\uff1a"); descT.setColumns(20); descT.setRows(5); jScrollPane2.setViewportView(descT); deleteJB.setText("\u5220\u9664"); deleteJB.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { deleteJBActionPerformed(evt); } }); fixJB.setText("\u4fee\u6539"); fixJB.addActionListener(new java.awt.event.ActionListener() { public vo