tushumanagelistener1.java

java+sql 图书管理系统

                tu1.jButton7.setEnabled(true);
                tu1.jButton8.setEnabled(true);
                tu1.jButton9.setEnabled(true);
                tu1.jButton10.setEnabled(true);

                tu1.jTextZuoZhe.setText("");
                tu1.jTextTiaoXingMa.setText("");
                tu1.jTextShuMing.setText("");
                tu1.jTextDingJia.setText("");
                tu1.jTextLeiBie.setText("");
                tu1.jTextChuBanShe.setText("");
                tu1.jTextCunFang.setText("");
                tu1.jTextJieChunTushu.setText("");
                tu1.jTextField1.setText("");


            }
        }
        /***********************************************清空按钮的监听***********************************************************/
        else if (e.getActionCommand().equals("清空")) {
            if (e.getActionCommand().equals("清空")) {
                JOptionPane.showConfirmDialog(null, "您确定要清空吗？", "温馨提示",
                                              JOptionPane.YES_NO_OPTION);
            }

            tu1.jTextBiaoHao.setText("");
            tu1.jTextTiaoXingMa.setText("");
            tu1.jTextShuMing.setText("");
            tu1.jTextZuoZhe.setText("");
            tu1.jTextDingJia.setText("");
            tu1.jTextCunFang.setText("");
            tu1.jTextLeiBie.setText("");
            tu1.jTextChuBanShe.setText("");
            tu1.jTextKuCunTushu.setText("");
            tu1.jTextJieChunTushu.setText("");
            tu1.jTextRuKuShijian.setText("");
            tu1.jTextField1.setText("");

        }

        /***************************************************新增按钮的监听****************************************************/
        else if (e.getActionCommand().equals("新增")) {

            tu1.jTextBiaoHao.setText("");
            tu1.jTextZuoZhe.setEnabled(true);
            tu1.jTextTiaoXingMa.setEnabled(true);
            tu1.jTextShuMing.setEnabled(true);
            tu1.jTextDingJia.setEnabled(true);
            tu1.jTextLeiBie.setEnabled(true);
            tu1.jTextChuBanShe.setEnabled(true);
            tu1.jTextCunFang.setEnabled(true);
             tu1.jTextKuCunTushu.setEnabled(true);
           tu1.jTextKuCunTushu.setEnabled(true);
 //          tu1.jTextJieChunTushu.setEnabled(true);
//            tu1.jTextRuKuShijian.setEnabled(true);
            tu1.jTextField1.setEnabled(true);
            // tu.jTextBiaoHao.equals(true);
            tu1.jTextBiaoHao.setSelectionStart(0);
            tu1.jButton5.setEnabled(false);
            tu1.jButton6.setEnabled(false);
            tu1.jButton7.setEnabled(false);
            tu1.jButton8.setEnabled(false);
            tu1.jButton9.setEnabled(true);
            tu1.jButton10.setEnabled(true);
            tu1.jTextTiaoXingMa.requestFocus(); //光标定位到条形码这个文本框
            tu1.jTextBiaoHao.setText("");
            tu1.jTextTiaoXingMa.setText("");
            tu1.jTextShuMing.setText("");
            tu1.jTextZuoZhe.setText("");
            tu1.jTextDingJia.setText("");
            tu1.jTextCunFang.setText("");
            tu1.jTextLeiBie.setText("");
            tu1.jTextChuBanShe.setText("");
            tu1.jTextKuCunTushu.setText("");
            tu1.jTextJieChunTushu.setText("");
 //           tu1.jTextRuKuShijian.setText("");
            tu1.jTextField1.setText("");

        } else if (e.getActionCommand().equals("保存")) { //当按“保存”健时，实现监听

            String strBH = tu1.jTextBiaoHao.getText();
            String strTXM = tu1.jTextTiaoXingMa.getText();
            String strSN = tu1.jTextShuMing.getText();
            String strDJ = tu1.jTextDingJia.getText();
            String strCF = tu1.jTextCunFang.getText();
            String strLB = tu1.jTextLeiBie.getText();
            String strCBS = tu1.jTextChuBanShe.getText();
            String strZZ = tu1.jTextZuoZhe.getText();
            String strZT = tu1.jTextField1.getText();
           String strKCTS = tu1.jTextKuCunTushu.getText();
            String strRKSJ = tu1.jTextRuKuShijian.getText();

            //*在全局new一个非法类，在这里调用判断//


             if (fei.feifatiaoxingma(strTXM)) {
                 tu1.jTextTiaoXingMa.setText("");
                 tu1.jTextTiaoXingMa.requestFocus();
             } else if (fei.feifamingcheng(strSN)) {
                 tu1.jTextShuMing.setText("");
                 tu1.jTextShuMing.requestFocus();
             } else if (fei.feifazuozhe(strZZ)) {
                 tu1.jTextZuoZhe.setText("");
                 tu1.jTextZuoZhe.requestFocus();
             } else if (fei.feifajiage(strDJ)) {
                 tu1.jTextDingJia.setText("");
                 tu1.jTextDingJia.requestFocus();

             } else if (fei.feifaleibie(strLB)) {
                 tu1.jTextLeiBie.setText("");
                 tu1.jTextLeiBie.requestFocus();
             } else if (fei.feifachubanshe(strCBS)) {
                 tu1.jTextChuBanShe.setText("");
                 tu1.jTextChuBanShe.requestFocus();

            }
 //                 else if(fei.feifarukushijian(strRKSJ)){
//                 tu1.jTextRuKuShijian.setText("");
//                 tu1.jTextRuKuShijian.requestFocus();
//             }

             else {

                 String sss = null;
                 try {
                     Mydb mydb = new Mydb();
                     sss =
                             "insert into books(条形码,图书名称,作者,定价,存放位置,类别,出版社,状态,库存图书,录入时间) values('" +
                             strTXM + "','" +
                             strSN + "','" +
                             strZZ + "'," +
                             strDJ + ",'" +
                             strCF + "','" +
                             strLB + "','" +
                             strCBS + "','" +
                             strZT + "','" +
                             strKCTS+"','"+
                             strRKSJ+
                             "')";
                     mydb.sqlzen(sss);
                     String sq = "select *from books";
                     tu1.bookdo(sq);
                 } catch (SQLException ex) {
                     ex.printStackTrace();
                     System.out.println("ghgjhy212254654" + ex.getMessage());
                 }
                 JOptionPane.showMessageDialog(null, "添加成功",
                                               "图书管理系统",
                                               JOptionPane.OK_OPTION); //然则弹出相应对话框

                 tu1.jButton5.setEnabled(true);
                 tu1.jButton6.setEnabled(true);
                 tu1.jButton7.setEnabled(true);
                 tu1.jButton8.setEnabled(true);
                 tu1.jButton9.setEnabled(false);
                 tu1.jButton10.setEnabled(false);

             }

        }
    }

////////////////////////////////////////////////Jtable中鼠标双击事件/////////////////////////////////////////////////////
    public void mouseClicked(MouseEvent e) {
        if (e.getClickCount() == 2) {
            as = tu1.jTable1.getSelectedRow();
            ks = String.valueOf(tu1.modle.getValueAt(as, 0));
            try {
                Mydb mydb = new Mydb();
                String dda = "select *from books where 图书编号=" + ks;
                ResultSet dr = mydb.sqlcha(dda);
                if (dr.next()) {
                    tu1.jTextBiaoHao.setText(dr.getString(1));
                    tu1.jTextTiaoXingMa.setText(dr.getString(2));
                    tu1.jTextShuMing.setText(dr.getString(3));
                    tu1.jTextDingJia.setText(dr.getString(5));
                    tu1.jTextLeiBie.setText(dr.getString(4));
                    tu1.jTextZuoZhe.setText(dr.getString(6));
                    tu1.jTextChuBanShe.setText(dr.getString(7));
                    tu1.jTextCunFang.setText(dr.getString(8));
                    tu1.jTextKuCunTushu.setText(dr.getString(9));
                    tu1.jTextJieChunTushu.setText(dr.getString(10));
                    tu1.jTextRuKuShijian.setText(dr.getString(11));
                    tu1.jTextField1.setText(dr.getString(12));
                }
            } catch (SQLException E) {
                E.printStackTrace();
            }

        }
    }

    public void mouseEntered(MouseEvent e) {
    }

    public void mouseExited(MouseEvent e) {
    }

    public void mousePressed(MouseEvent e) {
    }

    public void mouseReleased(MouseEvent e) {
    }


}