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

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

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


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


文章标签：
存储
关键词：
Eclipse java
Java系统
Java swing
Java eclipse
Java swing系统
水坚石青
目录
相关文章
源码星辰
|
10天前
|
运维 自然语言处理 供应链
Java云HIS医院管理系统源码 病案管理、医保业务、门诊、住院、电子病历编辑器
通过门诊的申请，或者直接住院登记，通过”护士工作站“分配患者，完成后，进入医生患者列表，医生对应开具”长期医嘱“和”临时医嘱“，并在电子病历中，记录病情。病人出院时，停止长期医嘱，开具出院医嘱。进入出院审核，审核医嘱与住院通过后，病人结清缴费，完成出院。
源码星辰
35 3
东方睿赢
|
14天前
|
Java 数据库连接 数据库
深入探讨Java连接池技术如何通过复用数据库连接、减少连接建立和断开的开销，从而显著提升系统性能
在Java应用开发中，数据库操作常成为性能瓶颈。本文通过问题解答形式，深入探讨Java连接池技术如何通过复用数据库连接、减少连接建立和断开的开销，从而显著提升系统性能。文章介绍了连接池的优势、选择和使用方法，以及优化配置的技巧。
东方睿赢
16 1
程序员皮皮林
|
15天前
|
JavaScript Java 项目管理
Java毕设学习 基于SpringBoot + Vue 的医院管理系统 持续给大家寻找Java毕设学习项目（附源码）
基于SpringBoot + Vue的医院管理系统，涵盖医院、患者、挂号、药物、检查、病床、排班管理和数据分析等功能。开发工具为IDEA和HBuilder X，环境需配置jdk8、Node.js14、MySQL8。文末提供源码下载链接。
程序员皮皮林
102 0
高端源码库
|
18天前
|
移动开发 前端开发 JavaScript
java家政系统成品源码的关键特点和技术应用
家政系统成品源码是已开发完成的家政服务管理软件，支持用户注册、登录、管理个人资料，家政人员信息管理，服务项目分类，订单与预约管理，支付集成，评价与反馈，地图定位等功能。适用于各种规模的家政服务公司，采用uniapp、SpringBoot、MySQL等技术栈，确保高效管理和优质用户体验。
高端源码库
30 1
最好zzz
|
20天前
|
XML JSON 监控
告别简陋：Java日志系统的最佳实践
【10月更文挑战第19天】 在Java开发中，`System.out.println()` 是最基本的输出方法，但它在实际项目中往往被认为是不专业和不足够的。本文将探讨为什么在现代Java应用中应该避免使用 `System.out.println()`，并介绍几种更先进的日志解决方案。
最好zzz
44 1
1554023534442740
|
25天前
|
Java 关系型数据库 API
介绍一款Java开发的企业接口管理系统和开放平台
YesApi接口管理平台Java版，基于Spring Boot、Vue.js等技术，提供API接口的快速研发、管理、开放及收费等功能，支持多数据库、Docker部署，适用于企业级PaaS和SaaS平台的二次开发与搭建。
1554023534442740
81 5
Svan.
|
29天前
|
前端开发 Java 数据库连接
基于Java的校车管理系统（下）
基于Java的校车管理系统（下）
Svan.
16 0
飞翔的佩奇
|
6月前
|
Java
Java Swing猜英文单词游戏(java+面向对象编程+swing+awt+io流)
Java Swing猜英文单词游戏(java+面向对象编程+swing+awt+io流)
飞翔的佩奇
82 0
dituinao技术
|
Oracle 安全 Java
Java GUI框架选择什么？Swing，SWT，AWT，SwingX，JGoodies，JavaFX，Apache Pivot？
Java GUI框架选择什么？Swing，SWT，AWT，SwingX，JGoodies，JavaFX，Apache Pivot？
dituinao技术
1464 0
程序员诗人
|
Java Spring
[SOLVED] Caused by: java.awt.HeadlessException when trying to create a SWING/AWT frame from Sprin...
[SOLVED] Caused by: java.awt.HeadlessException when trying to create a SWING/AWT frame from Spring Boot In Spring Boot, when y...
程序员诗人
1367 0

热门文章

最新文章

  • 1
    JAVA SERVLET 属性范围样例
  • 2
    java Redis工具类
  • 3
    Java开发数据库设计的14个技巧，你知道几个？
  • 4
    Java杂记9—NIO
  • 5
    Java程序性能优化20
  • 6
    16.2. jps - Java Virtual Machine Process Status Tool
  • 7
    Java——基于java自身包实现消息系统间的通信（TCP/IP+BIO）
  • 8
    Java接口签名(Signature)实现方案
  • 9
    Java的几种创建实例方法的性能对比
  • 10
    Java多线程初学者指南（9）：为什么要进行数据同步
  • 1
    解决Eclipse中文乱码
    70
  • 2
    建立ubuntu下基于eclipse的android开发环境
    46
  • 3
    如何在Eclipse中查看Android源码或者第三方组件包源码（转）
    53
  • 4
    在Eclipse配置安装Android详细教程(新手)
    154
  • 5
    【Eclipse安装及使用(面向小白)】
    117
  • 6
    eclipse安装教程
    87
  • 7
    双击eclipse提示an error has occurred See the log file E:\javatool\eclipse-mars-2\configuration\156991769
    76
  • 8
    【eclipse】pom.xml 红叉的解决办法
    121
  • 9
    eclipse的详细安装教程
    85
  • 10
    修改Eclipse新建jsp文件的默认编码
    56

    • 相关课程

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

    • 相关电子书

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

    • 相关实验场景

    更多
  • 基于ECS搭建Java Web开发环境
  • 使用Aliyun Java Intializr进行项目开发
  • 搭建Java Web开发环境
  • 部署基于Dragonwell的Java运行环境
  • 阿里云平台上进行Java程序的编译与运行

    • 推荐镜像

    更多
  • eclipse
  • maven
  • libreoffice
    • 下一篇
    阿里云OSS设置跨域访问