tushumanage.java

java+sql 图书管理系统

        ResultSet re = mydb.sqlcha(s1);
        while (re.next()) {
            this.jTextRuKuShijian.setText(re.getString(1));
        }

//        jTextRuKuShijian.setText("");
        jTextRuKuShijian.setBounds(new Rectangle(351, 21, 130, 26));
        jPanel4.setBounds(new Rectangle(391, 16, 210, 138));
        jPanel4.setLayout(null);
        jPanel5.setBackground(Color.white);
        jPanel5.setBounds(new Rectangle(390, 159, 211, 63));
        jPanel5.setLayout(null);
        jButton5.setBounds(new Rectangle(24, 25, 73, 31));
        jButton5.setText("新增");
        jButton5.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton5);
        jButton6.setBounds(new Rectangle(114, 26, 73, 29));
        jButton6.setText("删除");
        jButton6.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton6);
        jButton7.setBounds(new Rectangle(24, 67, 73, 29));
        jButton7.setText("编辑");
        jButton7.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton7);
        jButton8.setBounds(new Rectangle(114, 64, 73, 29));
        jButton8.setText("清空");
        jButton8.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton8);
        jButton9.setBounds(new Rectangle(24, 101, 73, 29));
        jButton9.setText("保存");
        jButton9.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton9);
        jButton10.setBounds(new Rectangle(114, 99, 73, 29));
        jButton10.setText("取消");
        jButton10.addActionListener(new TushuManageListener1(this));
        jButton11.setBounds(new Rectangle(129, 22, 73, 29));
        jButton11.setText("查询");
        jButton11.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//        this.getRootPane().setDefaultButton(jButton11);
        jLabel19.setText("书名");
        jLabel19.setBounds(new Rectangle(5, 19, 37, 30));
        jTextShuM.setText("");
        jTextShuM.setBounds(new Rectangle(33, 23, 92, 28));
        jPanel1.setBackground(SystemColor.text);

        //jPanel1.setBounds(new Rectangle(17, 45, 588, 165));
        jPanel1.add(jTextZuoZhe);
        jPanel1.add(jTextTiaoXingMa);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel1);
        // jPanel1.add(jLabel5);
        jPanel1.add(jLabel6);
        jPanel1.add(jTextDingJia);
        //jPanel1.add(jLabel9);
        jPanel1.add(jTextShuLiang);
        //jPanel1.add(jLabel10);
        //jPanel1.add(jLabel11);
        jPanel1.add(jTextLeiBie);
        jPanel1.add(jLabel13);
        jPanel1.add(jTextChuBanShe);
        // jPanel1.add(jLabel14);
        jPanel1.add(jLabel8);
        jPanel1.add(jLabel4);
        jPanel1.add(jTextShuMing);
        jPanel1.add(jTextCunFang);
        jPanel1.add(jLabel3);
        jPanel1.add(jTextBiaoHao);
        jPanel1.add(jTextChuBan);
        // jPanel1.add(jLabel12);
        jPanel1.add(jLabel7);
        jPanel1.add(jTextField1);
        jPanel1.add(jLabel5);
        jButton4.setBounds(new Rectangle(531, 470, 98, 25));
        jButton4.setText("返回");
        jButton4.addActionListener(new TushuManageListener1(this));
//        this.getRootPane().requestFocus();
//       this.getRootPane().setDefaultButton(jButton4);
        jButton1.setBounds(new Rectangle(20, 470, 89, 25));
        jButton1.setText("显示全部");
        this.getRootPane().requestFocus();
        this.getRootPane().setDefaultButton(jButton1);
        jButton1.addActionListener(new TushuManageListener1(this));
        jPanel2.setBackground(Color.white);
        jPanel2.setBounds(new Rectangle(19, 139, 608, 61));
        jPanel2.add(jLabel15);
        jPanel2.add(jTextKuCunTushu);
        jPanel2.add(jLabel16);
        jPanel2.add(jTextJieChunTushu);
        jPanel2.add(jLabel17);
        jPanel2.add(jTextRuKuShijian);
        jPanel2.add(jLabel18);
        jPanel4.add(jButton10);
        jPanel4.add(jButton5);
        jPanel4.add(jButton9);
        jPanel4.add(jButton7);
        jPanel4.add(jButton6);
        jPanel4.add(jButton8);
        jPanel3.add(jPanel5);
        jPanel5.add(jButton11);
        jPanel5.add(jLabel19);
        jPanel5.add(jTextShuM);
        jPanel3.add(jScrollPane1);
//        this.getContentPane().add(tu);
//        tu.add(jPanel1);
//        tu.add(jPanel2);
//        tu.add(jPanel3);
//        tu.add(jPanel4);
//        tu.add(jPanel5);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jLabel10);
        jScrollPane1.getViewport().add(jTable1);

        jPanel1.setLayout(null);
        jPanel2.setLayout(null);
        jPanel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jPanel1.setToolTipText("");
        jPanel1.setBounds(new Rectangle(19, 20, 615, 125));
        jPanel2.setBounds(new Rectangle(19, 158, 614, 65));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel13.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel15.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel16.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel17.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel19.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 1));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jButton10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));

        jTable1.addMouseListener(new TushuManageListener1(this));
        jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        jTextBiaoHao.setEnabled(false);
        jTextZuoZhe.setEnabled(false);
        jTextTiaoXingMa.setEnabled(false);
        jTextShuMing.setEnabled(false);
        jTextDingJia.setEnabled(false);
        jTextLeiBie.setEnabled(false);
        jTextChuBanShe.setEnabled(false);
        jTextCunFang.setEnabled(false);
        jTextKuCunTushu.setEnabled(false);
        jTextJieChunTushu.setEnabled(false);
        jTextRuKuShijian.setEnabled(false);
        jTextShuM.setEnabled(false);
        jTextField1.setEnabled(false);

        this.getContentPane().add(jPanel2);
        this.getContentPane().add(jPanel1);
        Toolkit theKit = this.getToolkit();
        Dimension wndSize = theKit.getScreenSize();

        this.setBounds((wndSize.width - 654) / 2, (wndSize.height - 532) / 2,
                       654, 532);
        String sq = "select *from books";
//         this.setVisible(true);

        bookdo(sq);
    }

//    public static void main(String[] args) {
//        TushuManage tushu = new TushuManage(null);
//
//    }


    public void bookdo(String book) {
        try {

            list.clear();
            Mydb mydb = new Mydb();
            ResultSet re = mydb.sqlcha(book);
            while (re.next()) {
                ArrayList array = new ArrayList();
                array.add(re.getString(1));
                array.add(re.getString(2));
                array.add(re.getString(3));
                array.add(re.getString(4));
                array.add(re.getString(5));
                array.add(re.getString(6));
                array.add(re.getString(7));
                array.add(re.getString(8));
                array.add(re.getString(9));
                array.add(re.getString(10));
                array.add(re.getString(11));
                array.add(re.getString(12));

                list.add(array);
                modle.fireTableDataChanged();
            }
        } catch (SQLException ex) {
        }

    }

}