mysql+Java实现的学生宿舍信息管理系统.rar

/* * StudentModifyInterFrm.java * * Created on __DATE__, __TIME__ */ package com.DMView; import java.sql.Connection; import java.sql.ResultSet; import java.util.Vector; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import com.DMModel.Room; import com.DMModel.Student; import com.DMUtil.DMUtil; import com.Dao.RoomDao; import com.Dao.StudentDao; public class StudentModifyInterFrm extends javax.swing.JInternalFrame { DMUtil dmutil = new DMUtil(); RoomDao roomdao = new RoomDao(); StudentDao studentdao = new StudentDao(); /** Creates new form StudentModifyInterFrm */ public StudentModifyInterFrm() { initComponents(); this.setLocation(160, 50); this.fillTable(new Student()); this.fillRoom(); this.jb_man.setSelected(true); } public void fillRoom() { Connection con = null; Room room = new Room(); try { con = dmutil.getCon(); ResultSet rs = roomdao.roomList(con, room); Room room2 = new Room(); room2.setMember("请选择..."); room2.setId(-1 + ""); this.jcb_room.addItem(room2); while (rs.next()) { room = new Room(); room.setId(rs.getInt("id") + ""); room.setMember(rs.getString("member")); room.setLeader(rs.getString("leader")); this.jcb_room.addItem(room); } } catch (Exception e) { e.printStackTrace(); } finally { try { dmutil.closeCon(con); } catch (Exception e) { e.printStackTrace(); } } } private void fillTable(Student student) { DefaultTableModel dtm = (DefaultTableModel) table.getModel(); dtm.setRowCount(0); Connection con = null; try { con = dmutil.getCon(); ResultSet rs = studentdao.StudentSearch(con, student); while (rs.next()) { Vector v = new Vector(); v.add(rs.getString("id")); v.add(rs.getString("name")); v.add(rs.getString("sex")); v.add(rs.getString("yuanxi")); v.add(rs.getString("classroom")); v.add(rs.getString("member")); v.add(rs.getString("bed")); dtm.addRow(v); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { try { dmutil.closeCon(con); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } //GEN-BEGIN:initComponents // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { buttonGroup1 = new javax.swing.ButtonGroup(); jLabel1 = new javax.swing.JLabel(); nameTxt = new javax.swing.JTextField(); jLabel2 = new javax.swing.JLabel(); classTxt = new javax.swing.JTextField(); jLabel3 = new javax.swing.JLabel(); yuanxiTxt = new javax.swing.JTextField(); jLabel4 = new javax.swing.JLabel(); bedTxt = new javax.swing.JTextField(); jLabel5 = new javax.swing.JLabel(); jb_man = new javax.swing.JRadioButton(); jb_women = new javax.swing.JRadioButton(); jLabel6 = new javax.swing.JLabel(); jcb_room = new javax.swing.JComboBox(); jScrollPane1 = new javax.swing.JScrollPane(); table = new javax.swing.JTable(); jb_modify = new javax.swing.JButton(); jButton2 = new javax.swing.JButton(); jLabel7 = new javax.swing.JLabel(); idTxt = new javax.swing.JTextField(); setClosable(true); setIconifiable(true); setTitle("学生信息修改"); jLabel1.setText("姓名："); jLabel2.setText("班级："); jLabel3.setText("院系："); jLabel4.setText("床号："); jLabel5.setText("性别："); buttonGroup1.add(jb_man); jb_man.setText("男"); buttonGroup1.add(jb_women); jb_women.setText("女"); jLabel6.setText("寝室号："); table.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]; } }); table.addMouseListener(new java.awt.event.MouseAdapter() { public void mousePressed(java.awt.event.MouseEvent evt) { tableMousePressed(evt); } }); jScrollPane1.setViewportView(table); jb_modify.setIcon(new javax.swing.ImageIcon("C:\\Users\\T001\\Desktop\\学生宿舍管理系统\\icon\\modify.png")); jb_modify.setText("修改"); jb_modify.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jb_modifyActionPerformed(evt); } }); jButton2.setIcon(new javax.swing.ImageIcon("C:\\Users\\T001\\Desktop\\学生宿舍管理系统\\icon\\exit.png")); jButton2.setText("退出"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jLabel7.setText("编号："); idTxt.setEditable(false); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGap(32, 32, 32) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(nameTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(bedTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 84, javax.swing.GroupLayout.PREFERRED_SIZE))) .addGap(18, 18, 18) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addGap(8, 8, 8) .addComponent(jLabel5) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jb_man, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jb_women, javax.swing.GroupLayout.DEFAULT_SIZE, 99, Short.MAX_VALUE) .addGap(18, 18, 18) .addComponent(jLabel6) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jcb_room, 0, 160, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup() .addGap(4, 4, 4) .addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(classTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18) .addComponent(jLabel3) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(yuanxiTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jLabel7) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(idTxt, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE))) .addGap(49, 49, 49)) .addGroup(layout.createSequentialGroup() .addContainerGap() .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 621, Short.MAX_VALUE) .addContainerGap()) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addContainerGap(217, Short.MAX_VALUE) .addComponent(jb_modify) .addGap(119, 119, 119) .addComponent(jButton2) .addGap(151, 151, 151)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addGroup(layout.createParallelGroup(javax.swing.GroupLa