AI 助理
备案控制台
开发者社区 云计算 文章 正文

Eclipse+Java+Swing实现学生宿舍管理系统（下）

2022-05-25 301
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： Eclipse+Java+Swing实现学生宿舍管理系统

MainFrm2.java

package com.sjsq.view;
import javax.swing.JDesktopPane;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
/**
 * 
 * 学生主页面
 * 
 * @author shuijianshiqing
 *
 * @date 2020-09-01 07:52
 *
 */
public class MainFrm2 extends javax.swing.JFrame {
  private JMenu jMenu1;
  private JMenu jMenu3;
  private JMenu jMenu2;
  private JMenuBar jMenuBar1;
  private JMenuItem jMenuItem1;
  private JMenuItem jMenuItem2;
  private JMenuItem jMenuItem3;
  private JMenuItem jMenuItem4;
  private JMenuItem jMenuItem5;
  private JMenuItem jMenuItem6;
  private JDesktopPane table;
  /**
   * 创建窗体
   */
  public MainFrm2() {
    initComponents();
    // 设置位置
    setBounds(100, 200, 1050, 650);
    // 居中显示
    this.setLocationRelativeTo(null);
  }
  /**
   * 初始化窗体
   */
  private void initComponents() {
    table = new JDesktopPane();
    jMenuBar1 = new JMenuBar();
    jMenu1 = new JMenu();
    jMenuItem2 = new JMenuItem();
    jMenuItem3 = new JMenuItem();
    jMenu2 = new JMenu();
    jMenuItem1 = new JMenuItem();
    jMenuItem4 = new JMenuItem();
    jMenu3 = new JMenu();
    jMenuItem5 = new JMenuItem();
    jMenuItem6 = new JMenuItem();
    setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
    setTitle("学生信息管理学生页面");
    // 设置导航栏
    jMenu1.setText("学生入住");
    jMenuItem2.setText("办理入住");
    jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem2ActionPerformed(evt);
      }
    });
    jMenu1.add(jMenuItem2);
    jMenuItem3.setText("信息修改");
    jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem3ActionPerformed(evt);
      }
    });
    jMenu1.add(jMenuItem3);
    jMenuBar1.add(jMenu1);
    jMenu2.setText("信息查询");
    jMenuItem1.setText("寝室查询");
    jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem1ActionPerformed(evt);
      }
    });
    jMenu2.add(jMenuItem1);
    jMenuItem4.setText("人员查询");
    jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem4ActionPerformed(evt);
      }
    });
    jMenu2.add(jMenuItem4);
    jMenuBar1.add(jMenu2);
    jMenu3.setText("帮助服务");
    jMenuItem5.setText("关于系统");
    jMenu3.add(jMenuItem5);
    jMenuItem6.setText("退出系统");
    jMenuItem6.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jMenuItem6ActionPerformed(evt);
      }
    });
    jMenu3.add(jMenuItem6);
    jMenuBar1.add(jMenu3);
    setJMenuBar(jMenuBar1);
    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addComponent(table, javax.swing.GroupLayout.DEFAULT_SIZE, 400, Short.MAX_VALUE));
    layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addComponent(table, javax.swing.GroupLayout.DEFAULT_SIZE, 277, Short.MAX_VALUE));
    pack();
  }
  // 事件监控
  private void jMenuItem6ActionPerformed(java.awt.event.ActionEvent evt) {
    int a = JOptionPane.showConfirmDialog(null, "确定要退出？");
    if (a == 0) {
      this.dispose();
    }
  }
  private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {
    RoomSearchInterFrm roomSearch = new RoomSearchInterFrm();
    roomSearch.setVisible(true);
    this.table.add(roomSearch);
  }
  private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {
    StudentSearchInterFrm StudentSearch = new StudentSearchInterFrm();
    StudentSearch.setVisible(true);
    this.table.add(StudentSearch);
  }
  private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {
    StudentModifyInterFrm StudentModify = new StudentModifyInterFrm();
    StudentModify.setVisible(true);
    this.table.add(StudentModify);
  }
  private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {
    StudentAddInterFrm Student = new StudentAddInterFrm();
    Student.setVisible(true);
    this.table.add(Student);
  }
  // 主函数
  public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
      public void run() {
        new MainFrm2().setVisible(true);
      }
    });
  }
}

RoomAddInterFrm.java

package com.sjsq.view;
import java.sql.Connection;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.JButton;
import com.sjsq.dao.RoomDao;
import com.sjsq.model.Room;
import com.sjsq.util.DMUtil;
/**
 * 
 * 房间信息添加
 * 
 * @author shuijianshiqing
 *
 * @date 2020-09-01 20:51
 *
 */
public class RoomAddInterFrm extends javax.swing.JInternalFrame {
  private JTextField dm_leader;
  private JTextField dm_number;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JButton jb_add;
  private JButton jb_reset;
  DMUtil dmutil = new DMUtil();
  RoomDao roomdao = new RoomDao();
  public RoomAddInterFrm() {
    initComponents();
    this.setLocation(200, 50);
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    dm_number = new JTextField();
    jLabel2 = new JLabel();
    dm_leader = new JTextField();
    jb_add = new JButton();
    jb_reset = new JButton();
    jLabel3 = new JLabel();
    setClosable(true);
    setIconifiable(true);
    setTitle("宿舍添加");
    jLabel1.setText("宿舍号：");
    jLabel2.setText("寝室长：");
    jb_add.setText("添加");
    jb_add.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_addActionPerformed(evt);
      }
    });
    jb_reset.setText("重置");
    jb_reset.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_resetActionPerformed(evt);
      }
    });
    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(150, 150, 150)
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup().addComponent(jLabel2)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(dm_leader, javax.swing.GroupLayout.DEFAULT_SIZE, 121, Short.MAX_VALUE))
            .addGroup(layout.createSequentialGroup().addComponent(jLabel1)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(dm_number, javax.swing.GroupLayout.DEFAULT_SIZE, 121, Short.MAX_VALUE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
                layout.createSequentialGroup().addComponent(jb_add).addGap(18, 18, 18)
                    .addComponent(jb_reset)))
        .addGap(4, 4, 4).addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 170,
            javax.swing.GroupLayout.PREFERRED_SIZE)
        .addGap(25, 25, 25)));
    layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup()
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING).addGroup(layout
            .createSequentialGroup().addGap(29, 29, 29)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel1).addComponent(dm_number, javax.swing.GroupLayout.PREFERRED_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(70, 70, 70)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel2).addComponent(dm_leader, javax.swing.GroupLayout.PREFERRED_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 91, Short.MAX_VALUE)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jb_reset).addComponent(jb_add)))
            .addGroup(javax.swing.GroupLayout.Alignment.LEADING,
                layout.createSequentialGroup().addGap(27, 27, 27).addComponent(jLabel3,
                    javax.swing.GroupLayout.PREFERRED_SIZE, 222,
                    javax.swing.GroupLayout.PREFERRED_SIZE)))
        .addContainerGap(40, Short.MAX_VALUE)));
    pack();
  }
  private void jb_addActionPerformed(java.awt.event.ActionEvent evt) {
    String name = dm_number.getText();
    String leader = dm_leader.getText();
    Room room = new Room(name, leader);
    Connection con = null;
    try {
      con = dmutil.getCon();
      int a = roomdao.roomAdd(con, room);
      if (a == 1) {
        JOptionPane.showMessageDialog(null, "添加成功！");
        this.resetValue();
      } else {
        JOptionPane.showMessageDialog(null, "添加失败！");
      }
    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, "添加失败！");
      e.printStackTrace();
    } finally {
      try {
        dmutil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void resetValue() {
    this.dm_leader.setText("");
    this.dm_number.setText("");
  }
  private void jb_resetActionPerformed(java.awt.event.ActionEvent evt) {
    this.dm_number.setText("");
    this.dm_leader.setText("");
  }
}

RoomDeleteInterFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTable;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import com.sjsq.dao.RoomDao;
import com.sjsq.model.Room;
import com.sjsq.util.DMUtil;
import com.sjsq.util.StringUtil;
/**
 * 
 * 删除房间信息
 * 
 * @author shuijianshiqing
 *
 * @date 2020-09-01 20:40
 *
 */
public class RoomDeleteInterFrm extends javax.swing.JInternalFrame {
  // 定义变量
  private JLabel jLabel1;
  private JScrollPane jScrollPane1;
  private JButton jb_delete;
  private JButton jb_exit;
  private JButton jb_search;
  private JTextField roomNum;
  private JTable table;
  DMUtil dmutil = new DMUtil();
  RoomDao roomdao = new RoomDao();
  // 构造函数
  public RoomDeleteInterFrm() {
    initComponents();
    this.setLocation(200, 50);
    this.fillTable(new Room());
  }
  // 填充表格
  private void fillTable(Room room) {
    DefaultTableModel dtm = (DefaultTableModel) table.getModel();
    dtm.setRowCount(0);
    Connection con = null;
    try {
      con = dmutil.getCon();
      ResultSet rs = roomdao.roomList(con, room);
      while (rs.next()) {
        Vector v = new Vector();
        v.add(rs.getString("id"));
        v.add(rs.getString("member"));
        v.add(rs.getString("leader"));
        dtm.addRow(v);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dmutil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  // 初始化
  private void initComponents() {
    jLabel1 = new JLabel();
    roomNum = new JTextField();
    jb_search = new JButton();
    jScrollPane1 = new JScrollPane();
    table = new JTable();
    jb_delete = new JButton();
    jb_exit = new JButton();
    setClosable(true);
    setIconifiable(true);
    setTitle("房间删除");
    jLabel1.setText("房间号：");
    jb_search.setText("查询");
    jb_search.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_searchActionPerformed(evt);
      }
    });
    table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "寝室号 ", "寝室长" }) {
      boolean[] canEdit = new boolean[] { false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    jScrollPane1.setViewportView(table);
    jb_delete.setText("删除");
    jb_delete.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_deleteActionPerformed(evt);
      }
    });
    jb_exit.setText("退出");
    jb_exit.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_exitActionPerformed(evt);
      }
    });
    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addGap(64, 64, 64).addComponent(jLabel1).addGap(18, 18, 18)
            .addComponent(roomNum, javax.swing.GroupLayout.PREFERRED_SIZE, 142,
                javax.swing.GroupLayout.PREFERRED_SIZE)
            .addGap(29, 29, 29).addComponent(jb_search).addContainerGap(41, Short.MAX_VALUE))
        .addGroup(layout.createSequentialGroup().addGap(76, 76, 76).addComponent(jb_delete)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 123, Short.MAX_VALUE)
            .addComponent(jb_exit).addGap(86, 86, 86))
        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
            layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 379,
                    javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap()));
    layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(28, 28, 28)
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jb_search)
            .addComponent(jLabel1).addComponent(roomNum, javax.swing.GroupLayout.PREFERRED_SIZE,
                javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
        .addGap(18, 18, 18)
        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 216,
            javax.swing.GroupLayout.PREFERRED_SIZE)
        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 20, Short.MAX_VALUE)
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jb_delete)
            .addComponent(jb_exit))
        .addGap(27, 27, 27)));
    pack();
  }
  private void jb_deleteActionPerformed(java.awt.event.ActionEvent evt) {
    int row = this.table.getSelectedRow();
    String member = (String) this.table.getValueAt(row, 1);
    if (StringUtil.isEmpty(member)) {
      JOptionPane.showMessageDialog(null, "请选择要删除的记录!");
      return;
    }
    int n = JOptionPane.showConfirmDialog(null, "确定要删除这条记录么");
    if (n == 0) {
      Connection con = null;
      try {
        con = dmutil.getCon();
        Room room = new Room(member);
        int deleteNum = roomdao.roomDelete(con, room);
        if (deleteNum == 1) {
          JOptionPane.showMessageDialog(null, "删除成功");
          this.roomNum.setText("");
          this.fillTable(new Room());
        } else {
          JOptionPane.showMessageDialog(null, "删除失败");
        }
      } catch (Exception e) {
        JOptionPane.showMessageDialog(null, "删除失败");
        e.printStackTrace();
      } finally {
        try {
          dmutil.closeCon(con);
        } catch (Exception e) {
          e.printStackTrace();
        }
      }
    }
  }
  private void jb_exitActionPerformed(java.awt.event.ActionEvent evt) {
    int a = JOptionPane.showConfirmDialog(null, "确认要退出？");
    if (a == 0) {
      this.dispose();
    }
  }
  private void jb_searchActionPerformed(java.awt.event.ActionEvent evt) {
    String member = roomNum.getText();
    Room room = new Room(member);
    this.fillTable(room);
  }
}

RoomManagerInterFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTextField;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import com.sjsq.dao.RoomDao;
import com.sjsq.model.Room;
import com.sjsq.util.DMUtil;
public class RoomManagerInterFrm extends javax.swing.JInternalFrame {
  private JTextField idTxt;
  private JLabel jLabel1;
  private JLabel jLabel2;
  private JLabel jLabel3;
  private JLabel jLabel4;
  private JPanel jPanel1;
  private JScrollPane jScrollPane1;
  private javax.swing.JButton jb_exit;
  private javax.swing.JButton jb_modify;
  private javax.swing.JButton jb_search;
  private JTextField roomNum;
  private JTextField roomleader;
  private JTextField roomnumber;
  private JTable table;
  DMUtil dmutil = new DMUtil();
  RoomDao roomdao = new RoomDao();
  public RoomManagerInterFrm() {
    initComponents();
    this.setLocation(200, 50);
    this.fillTable(new Room());
  }
  private void fillTable(Room room) {
    DefaultTableModel dtm = (DefaultTableModel) table.getModel();
    dtm.setRowCount(0);
    Connection con = null;
    try {
      con = dmutil.getCon();
      ResultSet rs = roomdao.roomList(con, room);
      while (rs.next()) {
        Vector v = new Vector();
        v.add(rs.getString("id"));
        v.add(rs.getString("member"));
        v.add(rs.getString("leader"));
        dtm.addRow(v);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dmutil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    roomNum = new JTextField();
    jb_search = new javax.swing.JButton();
    jScrollPane1 = new JScrollPane();
    table = new JTable();
    jPanel1 = new JPanel();
    jLabel2 = new JLabel();
    idTxt = new JTextField();
    jLabel3 = new JLabel();
    roomnumber = new JTextField();
    jb_modify = new javax.swing.JButton();
    jb_exit = new javax.swing.JButton();
    jLabel4 = new JLabel();
    roomleader = new JTextField();
    setClosable(true);
    setIconifiable(true);
    setTitle("宿舍信息修改");
    jLabel1.setText("寝室号：");
    jb_search.setText("查询");
    jb_search.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_searchActionPerformed(evt);
      }
    });
    table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "寝室号", "寝室长" }) {
      boolean[] canEdit = new boolean[] { 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);
    jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("表单操作"));
    jLabel2.setText("编号：");
    idTxt.setEditable(false);
    jLabel3.setText("寝室号：");
    jb_modify.setText("修改");
    jb_modify.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_modifyActionPerformed(evt);
      }
    });
    jb_exit.setText("退出");
    jb_exit.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_exitActionPerformed(evt);
      }
    });
    jLabel4.setText("寝室长：");
    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(39, 39, 39).addComponent(jb_modify)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 162, Short.MAX_VALUE)
            .addComponent(jb_exit).addGap(64, 64, 64))
        .addGroup(jPanel1Layout.createSequentialGroup().addGap(21, 21, 21)
            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                .addComponent(jLabel4).addComponent(jLabel2))
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                .addComponent(roomleader)
                .addComponent(idTxt, javax.swing.GroupLayout.DEFAULT_SIZE, 92, Short.MAX_VALUE))
            .addGap(18, 18, 18).addComponent(jLabel3).addGap(10, 10, 10)
            .addComponent(roomnumber, javax.swing.GroupLayout.DEFAULT_SIZE, 116, Short.MAX_VALUE)
            .addGap(62, 62, 62)));
    jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
            .addGap(19, 19, 19)
            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel2)
                .addComponent(idTxt, javax.swing.GroupLayout.PREFERRED_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jLabel3).addComponent(roomnumber, javax.swing.GroupLayout.PREFERRED_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(33, 33, 33)
            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jLabel4).addComponent(roomleader, javax.swing.GroupLayout.PREFERRED_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 60, Short.MAX_VALUE)
            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jb_modify).addComponent(jb_exit))
            .addContainerGap()));
    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup().addGap(41, 41, 41).addComponent(jLabel1).addGap(18, 18, 18)
            .addComponent(roomNum, javax.swing.GroupLayout.DEFAULT_SIZE, 173, Short.MAX_VALUE)
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED).addComponent(jb_search)
            .addGap(80, 80, 80))
        .addGroup(layout.createSequentialGroup().addContainerGap()
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.LEADING, 0,
                    javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING,
                    javax.swing.GroupLayout.DEFAULT_SIZE, 379, Short.MAX_VALUE))
            .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
    layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(18, 18, 18)
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jLabel1)
            .addComponent(jb_search).addComponent(roomNum, javax.swing.GroupLayout.PREFERRED_SIZE,
                javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
        .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 111,
            javax.swing.GroupLayout.PREFERRED_SIZE)
        .addGap(18, 18, 18).addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
            javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
        .addContainerGap()));
    pack();
  }
  private void jb_searchActionPerformed(java.awt.event.ActionEvent evt) {
    String member = roomNum.getText();
    Room room = new Room(member);
    this.fillTable(room);
  }
  private void jb_modifyActionPerformed(java.awt.event.ActionEvent evt) {
    String roomNumber = roomnumber.getText();
    String roomLeader = roomleader.getText();
    String id = idTxt.getText();
    Connection con = null;
    try {
      con = dmutil.getCon();
      Room room = new Room(id, roomNumber, roomLeader);
      int a = roomdao.roomModify(con, room);
      if (a == 1) {
        JOptionPane.showMessageDialog(null, "修改成功！");
        resetValue();
        this.fillTable(new Room());
        return;
      } else {
        JOptionPane.showMessageDialog(null, "修改失败!");
      }
    } catch (Exception e) {
      JOptionPane.showMessageDialog(null, "修改失败!");
      e.printStackTrace();
    }
  }
  public void resetValue() {
    roomnumber.setText("");
    roomleader.setText("");
    idTxt.setText("");
  }
  private void jb_exitActionPerformed(java.awt.event.ActionEvent evt) {
    int result = JOptionPane.showConfirmDialog(null, "是否退出系统");
    if (result == 0) {
      this.dispose();
    }
  }
  private void tableMousePressed(java.awt.event.MouseEvent evt) {
    int row = table.getSelectedRow();
    idTxt.setText(table.getValueAt(row, 0) + "");
    roomnumber.setText(table.getValueAt(row, 1) + "");
    roomleader.setText(table.getValueAt(row, 2) + "");
  }
}

RoomSearchInterFrm.java

package com.sjsq.view;
import java.sql.Connection;
import java.sql.ResultSet;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JTable;
import com.sjsq.dao.RoomDao;
import com.sjsq.model.Room;
import com.sjsq.util.DMUtil;
public class RoomSearchInterFrm extends javax.swing.JInternalFrame {
  private JLabel jLabel1;
  private JScrollPane jScrollPane1;
  private JButton jb_search;
  private JTextField roomNumTxt;
  private JTable table;
  DMUtil dmutil = new DMUtil();
  RoomDao roomdao = new RoomDao();
  public RoomSearchInterFrm() {
    initComponents();
    this.setLocation(200, 50);
  }
  private void fillTable(Room room) {
    DefaultTableModel dtm = (DefaultTableModel) table.getModel();
    dtm.setRowCount(0);
    Connection con = null;
    try {
      con = dmutil.getCon();
      ResultSet rs = roomdao.roomList(con, room);
      while (rs.next()) {
        Vector v = new Vector();
        v.add(rs.getString("id"));
        v.add(rs.getString("member"));
        v.add(rs.getString("leader"));
        dtm.addRow(v);
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      try {
        dmutil.closeCon(con);
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }
  private void initComponents() {
    jLabel1 = new JLabel();
    roomNumTxt = new JTextField();
    jb_search = new JButton();
    jScrollPane1 = new JScrollPane();
    table = new JTable();
    setClosable(true);
    setIconifiable(true);
    setTitle("寝室查询");
    jLabel1.setText("寝室号：");
    jb_search.setText("查询");
    jb_search.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        jb_searchActionPerformed(evt);
      }
    });
    table.setModel(new javax.swing.table.DefaultTableModel(new Object[][] {
    }, new String[] { "编号", "寝室号", "寝室长" }) {
      boolean[] canEdit = new boolean[] { false, false, false };
      public boolean isCellEditable(int rowIndex, int columnIndex) {
        return canEdit[columnIndex];
      }
    });
    jScrollPane1.setViewportView(table);
    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup()
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
            .createSequentialGroup().addGap(46, 46, 46).addComponent(jLabel1).addGap(28, 28, 28)
            .addComponent(roomNumTxt, javax.swing.GroupLayout.PREFERRED_SIZE, 132,
                javax.swing.GroupLayout.PREFERRED_SIZE)
            .addGap(18, 18, 18).addComponent(jb_search))
            .addGroup(layout.createSequentialGroup().addContainerGap().addComponent(jScrollPane1,
                javax.swing.GroupLayout.PREFERRED_SIZE, 379, javax.swing.GroupLayout.PREFERRED_SIZE)))
        .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
    layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup(layout
        .createSequentialGroup().addGap(23, 23, 23)
        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE).addComponent(jb_search)
            .addComponent(roomNumTxt, javax.swing.GroupLayout.PREFERRED_SIZE,
                javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
            .addComponent(jLabel1))
        .addGap(18, 18, 18)
        .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 292, Short.MAX_VALUE)
        .addContainerGap()));
    pack();
  }
  private void jb_searchActionPerformed(java.awt.event.ActionEvent evt) {
    String member = roomNumTxt.getText();
    Room room = new Room(member);
    this.fillTable(room);
  }
}


四、其他

1.其他系统实现


JavaSwing系统系列实现

Java+Swing实现斗地主游戏

Java+Swing实现图书管理系统

Java+Swing实现医院管理系统

Java+Swing实现考试管理系统

Java+Swing实现酒店管理系统

Java+Swing实现超市管理系统

Java+Swing实现网上订餐系统

Java+Swing实现电影购票系统

Java+Swing实现仓库管理系统1

Java+Swing实现仓库管理系统2

Java+Swing实现进销存管理系统

Java+Swing实现通讯录管理系统

Java+Swing实现停车场管理系统

Java+Swing实现员工工资管理系统

Java+Swing实现学生宿舍管理系统

Java+Swing实现学生选课管理系统

Java+Swing实现学生成绩管理系统

Java+Swing实现学校教材管理系统

Java+Swing实现学校教务管理系统

Java+Swing实现企业人事管理系统

Java+Swing实现电子相册管理系统

Java+Swing实现学生信息管理系统1

Java+Swing实现学生信息管理系统2

Java+Swing实现自助取款机(ATM)系统


JavaSwing+Txt系统系列实现

Java+Swing实现超市管理系统-TXT存储信息

Java+Swing实现宠物商店管理系统-TXT存储信息

Java+Swing实现自助取款机(ATM)系统-TXT存储信息


Java+JSP系统系列实现

Java+JSP实现学生图书管理系统

Java+JSP实现学生信息管理系统

Java+JSP实现用户信息管理系统


Java+Servlet+JSP系统系列实现

Java+Servlet+JSP实现航空订票系统

Java+Servlet+JSP实现新闻发布系统

Java+Servlet+JSP实现图书管理系统

Java+Servlet+JSP实现停车场管理系统

Java+Servlet+JSP实现房屋租赁管理系统

Java+Servlet+JSP实现学生选课管理系统

Java+Servlet+JSP实现宠物诊所管理系统

Java+Servlet+JSP实现学生宿舍管理系统

Java+Servlet+JSP实现学生信息管理系统

Java+Servlet+JSP实现学生成绩管理系统1

Java+Servlet+JSP实现学生成绩管理系统2


Java+SSM系统系列实现

Java+SSM+JSP实现图书管理系统

Java+SSM+JSP实现宠物商城系统

Java+SSM+JSP实现超市订单系统

Java+SSM+JSP实现网上考试系统

Java+SSM+JSP实现学生成绩管理系统

Java+SSM+JSP实现学生信息管理系统

Java+SSM+Bootstrap+Maven实现网上书城系统

Java+SSM+Bootstrap+Maven实现学校教务管理系统


Java+SSH系统系列实现

Java+SSH+Bootstrap实现在线考试系统

Java+SSH+JSP实现医院在线挂号系统


Java+Springboot系统系列实现

Java+Springboot+H-ui+Maven实现营销管理系统

Java+Springboot+Bootstrap+Maven实现网上商城系统

Java+Springboot+Bootstrap+Maven实现景区旅游管理系统


2.获取源码


点击以下链接获取源码

Java+Swing+Mysql实现学生宿舍管理系统源码


3.备注


如有侵权请联系我删除。


4.鸡汤


积极的思考，积极的生活，积极的展望！


文章标签：
存储
关键词：
Java系统
Eclipse java
Java swing
Java eclipse
Java swing系统
水坚石青
目录
相关文章
听白
|
1月前
|
Java Android开发
Eclipse Java 构建路径
Eclipse Java 构建路径
听白
33 3
小蜗牛耶
|
5月前
|
JavaScript Java 测试技术
基于Java的人事管理系统设计和实现(源码+LW+部署讲解)
基于Java的人事管理系统设计和实现(源码+LW+部署讲解)
小蜗牛耶
110 7
小蜗牛耶
|
5月前
|
JavaScript Java 测试技术
基于Java的儿童福利院管理系统设计和实现(源码+LW+部署讲解)
基于Java的儿童福利院管理系统设计和实现(源码+LW+部署讲解)
小蜗牛耶
107 7
Jay17
|
4月前
|
Java 网络安全 开发工具
新手入门Java。如何下载Eclipse、写出最基本的“Hello word”以及如何连接github并且上传项目。
新手入门Java。如何下载Eclipse、写出最基本的“Hello word”以及如何连接github并且上传项目。
Jay17
64 0
程序员小李_lys
|
5月前
|
Java 关系型数据库 MySQL
班级通讯录管理系统（Java+MySQL）
构建了一个Java Swing应用，搭配MySQL，实现班级通讯录管理。系统具备管理员登录、班级与学生信息的增删改查功能，每个班级窗口独立且自适应布局。利用GBK编码处理中文，JDBC连接数据库，优化窗口复用和代码结构，数据变更实时同步。示例截图展示详细界面。
程序员小李_lys
157 0
班级通讯录管理系统（Java+MySQL）
源码宝
|
5月前
|
JavaScript 前端开发 Java
Java数字化产科管理系统源码，多家医院应用案例，可直接上项目
Java开发的数字化产科管理系统，已在多家医院实施，支持直接部署。系统涵盖孕产全程，包括门诊、住院、统计和移动服务，整合高危管理、智能提醒、档案追踪等功能，与HIS等系统对接。采用前后端分离架构，Java语言，Vue前端，若依框架，MySQL数据库。优势在于提升就诊效率，降低漏检率，自动报表生成，减少重复工作，支持数据研究，并实现医院与卫计委平台的数据互通，打造全生育周期健康服务。
源码宝
71 4
杰哥在此
|
5月前
|
存储 Oracle Java
Java面试题：描述如何使用Eclipse或IntelliJ IDEA进行Java开发？
Java面试题：描述如何使用Eclipse或IntelliJ IDEA进行Java开发？
杰哥在此
56 0
weixin_836869520
|
5月前
|
监控 Java 决策智能
使用Java实现智能物流管理系统
使用Java实现智能物流管理系统
weixin_836869520
101 0
Damon小智
|
7月前
|
Java Maven Android开发
在Eclipse里配置Maven插件
Maven是一款比较常用的Java开发拓展包，它相当于一个全自动jar包管理器，会导入用户开发时需要使用的相应jar包。使用Maven开发Java程序，可以极大提升开发者的开发效率。下面我就跟大家介绍一下如何在Eclipse里安装和配置Maven插件。
Damon小智
171 0
程序三两行
|
7月前
|
XML Java Maven
eclipse 、idea 安装activiti插件
eclipse 、idea 安装activiti插件
程序三两行
180 0

热门文章

最新文章

  • 1
    【Java多数据源实现教程】实现动态数据源、多数据源切换方式（上）
  • 2
    Java-学习笔记-8-接口
  • 3
    java中的工厂模式
  • 4
    超简单的java爬虫
  • 5
    Java 学习路线 2024 最新版！
  • 6
    迅速了解多例模式竞争者-枚举 | 带你学《Java面向对象编程》之七十四
  • 7
    带你读《Java程序设计与计算思维》之三：流程控制
  • 8
    java源码 - ReentrantLock
  • 9
    Java Poi 创建与读取Excel
  • 10
    关于《Java数字图像处理-编程技巧与应用实践》一书 源代码
  • 1
    Eclipse或STS里如何跟踪jar包里的源代码代码
    105
  • 2
    STS(eclipse)批量修改文件里的某个内容
    64
  • 3
    解决Eclipse中文乱码
    95
  • 4
    建立ubuntu下基于eclipse的android开发环境
    58
  • 5
    如何在Eclipse中查看Android源码或者第三方组件包源码（转）
    58
  • 6
    在Eclipse配置安装Android详细教程(新手)
    173
  • 7
    【Eclipse安装及使用(面向小白)】
    131
  • 8
    eclipse安装教程
    103
  • 9
    双击eclipse提示an error has occurred See the log file E:\javatool\eclipse-mars-2\configuration\156991769
    84
  • 10
    【eclipse】pom.xml 红叉的解决办法
    145

    • 相关课程

    更多
  • Java面试疑难点解析 - 面试技巧及语言基础
  • Java面试疑难点解析 - Java Web开发
  • Java面试疑难点解析 - 系统架构及项目设计
  • Java编程入门
  • Java面向对象编程
  • Java高级编程

    • 相关电子书

    更多
  • Spring Cloud Alibaba - 重新定义 Java Cloud-Native
  • The Reactive Cloud Native Arch
  • JAVA开发手册1.5.0

    • 相关实验场景

    更多
  • 阿里云平台上进行Java程序的编译与运行
  • 使用Java面向对象编写网络通信程序应用
  • 手动部署Java Web环境（Alibaba Cloud Linux 2）
  • 搭建Java Web开发环境（Anolis OS）
  • RocketMQ中使用Java客户端发送消息和消费的应用
  • 部署基于Dragonwell的Java运行环境

    • 推荐镜像

    更多
  • eclipse
  • maven
  • msys2
    • 下一篇
    DataWorks