Java宿舍物品管理系统，采用swing实现

package com.lyx.ks;

/*
 * To change this template, choose Tools | Templates and open the template in
 * the editor.
 */
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;

import java.awt.event.WindowEvent;
import java.io.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.Timer;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author Administrator
 */
public class MainFrame extends javax.swing.JFrame {

    /**
     * Creates new form MainFrame
     */
    public MainFrame() {

        initComponents();
        setTitle("Dormitory Management System");
        this.setLocationRelativeTo(null); //中间显示
        this.setIconImage(new ImageIcon(getClass().getResource("logo1.jpg")).getImage());//logo设置
        jLabel2.setText("当前使用人数：" + jTable1.getRowCount() + "");
        this.repaint();
        Timer t = new Timer(100, new ActionListener() {

            @Override
            public void actionPerformed(ActionEvent e) {
                Date d = new Date();
                SimpleDateFormat f = new SimpleDateFormat("HH:mm:ss");
                String s = f.format(d);
                jLabel4.setText(s);
            }
        });
        t.start();
//        setDefaultCloseOperation(DO_NOTHING_ON_CLOSE);
        
        addWindowListener(new WindowAdapter() {
            @Override
            public void windowClosing(WindowEvent e) {
                int option = JOptionPane.showConfirmDialog(
                        MainFrame.this, "确定退出系统? ", "", JOptionPane.YES_NO_OPTION);
                if (option == JOptionPane.YES_OPTION) {
                    if (e.getWindow() == MainFrame.this) {
                        System.exit(0);
                    } else {
                        return;
                    }
                }
            }
        });


    }

    /**
     * This method is called from within the constructor to initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is always
     * regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

        jMenuItem2 = new javax.swing.JMenuItem();
        jLabel5 = new javax.swing.JLabel();
        jLabel1 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jButton5 = new javax.swing.JButton();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jButton6 = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jLabel6 = new javax.swing.JLabel();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem4 = new javax.swing.JMenuItem();
        jMenuItem5 = new javax.swing.JMenuItem();
        jMenuItem6 = new javax.swing.JMenuItem();
        jMenuItem3 = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();

        jMenuItem2.setText("jMenuItem2");

        jLabel5.setText("jLabel5");

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                formMouseClicked(evt);
            }
        });

        jLabel1.setFont(new java.awt.Font("楷体", 1, 36)); // NOI18N
        jLabel1.setText("宿舍物品管理系统");

        jTable1.setBorder(javax.swing.BorderFactory.createEtchedBorder(javax.swing.border.EtchedBorder.RAISED));
        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "学号", "姓名", "储物柜号", "物品"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        dataModel = (DefaultTableModel)jTable1.getModel();
        //通过getModel方法获取表格使用的数据模型
        //dataModel是一个没有定义的变量，需要声明一下，由于他需要在AddFrame
        //类中被使用，所以声明的时候把它声明为全局的。
        //我们希望以打开MainFrame窗口就能看到当前数据库中所有的记录，所以下面是相应的数据库操作
        com.lyx.ks.DBAccess databaseHelper = new com.lyx.ks.DBAccess();
        //要操作数据库了，先定义一个数据库帮助类
        ResultSet rs1= databaseHelper.find("select stu_info.xuehao,xingming,wupinhao,wupin from stu_info right join pack_info on stu_info.xuehao=pack_info.xuehao");
        //从数据库中查找出stu_info表格的所有记录，返回到rs中
        try {
            while(rs1.next()){
                Vector aRow = new Vector();
                aRow.add(rs1.getString(1));
                aRow.add(rs1.getString(2));
                aRow.add(rs1.getString(3));
                aRow.add(rs1.getString(4));
                //一行数据已经准备好，下面把它添加到dataModel中，这样表格就显示出来了
                dataModel.addRow(aRow);
            }
        } catch (SQLException ex) {

        }
        databaseHelper.closeDB();
        jScrollPane1.setViewportView(jTable1);

        jButton1.setText("查 询");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jButton2.setText("修 改");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actio