tianjialist.java

java+sql 图书管理系统

package MyLibraryok.readers;


import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.sql.SQLException;
import MyLibraryok.Mydb.Mydb;


class Tianjialist implements ActionListener {


    Jiemian jiemian;
    Feifa feifa;
    String s1;
    Mydb mydb;


    public Tianjialist(Jiemian jiemian) {
        this.jiemian = jiemian;
    }

    public void actionPerformed(ActionEvent e) {
        //判断事件源--------"添加"
        if (e.getActionCommand().equals("添加")) {
            Feifa feifa = new Feifa();
            if (jiemian.jTextField2.getText().length() > 0) {
                JOptionPane.showMessageDialog(null,
                        "读者编号为自动增长，勿填！请输入其它信息！", "信息提示", 0);
                jiemian.jTextField2.setText("");
            } else if (jiemian.jTextField3.getText().length() == 0 ||
                       jiemian.jTextField5.getText().length() == 0 ||
                       jiemian.jTextField6.getText().length() == 0) {
                JOptionPane.showMessageDialog(null,
                                              "请输入相关信息！", "信息提示", 0);
            } else if (feifa.ftiaoxingma(jiemian.jTextField1.getText().trim())) {
                jiemian.jTextField1.setText("");
                jiemian.jTextField1.requestFocus();
            } else if (feifa.fname(jiemian.jTextField3.getText().trim())) { ///////非法判断
                jiemian.jTextField3.setText("");
                jiemian.jTextField3.requestFocus(); //获取光标
            } else if (feifa.fzhengjian(jiemian.jTextField5.getText().trim())) { ///////非法判断
                jiemian.jTextField5.setText("");
                jiemian.jTextField5.requestFocus(); //获取光标
            } else if (feifa.fdianhua(jiemian.jTextField6.getText().trim())) { //////非法判断
                jiemian.jTextField6.setText("");
                jiemian.jTextField6.requestFocus(); //获取光标
            } else {
                this.tianjia(); //调用添加方法
            }

        } else if (e.getActionCommand().equals("查找")) { //判断事件源---------“查找”
            Feifa feifa = new Feifa();

            if (jiemian.jTextField1.getText().length() > 0) {
                if (feifa.ftiaoxingma(jiemian.jTextField1.getText().trim())) {
                    jiemian.jTextField1.setText("");
                    jiemian.jTextField1.requestFocus();
                } else {
                    String s1 = "select * from reader where 借书证条形码 = '" +
                                jiemian.jTextField1.getText() + "'";
                    chazhao(s1);
                }
            } else if (jiemian.jTextField2.getText().length() > 0) {
                if (feifa.fbianhao(jiemian.jTextField2.getText().trim())) { //非法判断
                    jiemian.jTextField2.setText("");
                    jiemian.jTextField2.requestFocus(); //获取光标
                } else {
                    String scs = "select * from reader where 读者编号 = '" +
                                 jiemian.jTextField2.getText() + "'";
                    chazhao(scs); //执行查找方法
                }

            } else if (jiemian.jTextField3.getText().length() > 0) {
                if (feifa.fname(jiemian.jTextField3.getText().trim())) { //非法判断
                    jiemian.jTextField3.setText("");
                    jiemian.jTextField3.requestFocus(); //获取光标
                } else {
                    String ss = "select * from reader where 读者姓名 = '" +
                                jiemian.jTextField3.getText() + "'";
                    chazhao(ss);
                }
            }

        }

        else if (e.getActionCommand().equals("清空")) { //判断事件源-------------“清空”
            jiemian.jTextField1.setText("");
            jiemian.jTextField2.setText("");
            jiemian.jTextField3.setText("");
            jiemian.jTextField4.setText("");
            jiemian.jChoice1.select("男");
            jiemian.jChoice2.select("身份证");
            jiemian.jTextField5.setText("");
            jiemian.jTextField6.setText("");
            jiemian.jTextField1.requestFocus(); //获取光标

        }
        //判断事件源------"修改"
        else if (e.getActionCommand().equals("修改")) {
            Feifa ff = new Feifa();
            System.out.println(jiemian.jTextField3.getText());
            System.out.println(jiemian.jTextField5.getText().trim());
            if (jiemian.jTextField3.getText().length() == 0
                || jiemian.jTextField5.getText().length() == 0 ||
                jiemian.jTextField6.getText().length() == 0) {
                JOptionPane.showMessageDialog(null, "请填写相关信息！！！",
                                              "信息提示", 0);
            } else if (ff.fname(jiemian.jTextField3.getText().trim())) { ///////非法判断
                jiemian.jTextField3.setText("");
                jiemian.jTextField3.requestFocus(); //获取光标
            } else if (ff.fzhengjian(jiemian.jTextField5.getText().trim())) { ///////非法判断
                jiemian.jTextField5.setText("");
                jiemian.jTextField5.requestFocus(); //获取光标
            } else if (ff.fdianhua(jiemian.jTextField6.getText().trim())) { //////非法判断                    jiemian.jTextField6.setText("");
                jiemian.jTextField6.setText("");
                jiemian.jTextField6.requestFocus(); //获取光标
            } else {
                int c = JOptionPane.showConfirmDialog(null, "你确定要修改吗???",
                        "信息提示",
                        JOptionPane.YES_NO_OPTION);
                if (c == JOptionPane.YES_OPTION) {
                    this.gai(); //调用修改方法

                }

            }
        }
        //判断事件源"退出"
        else if (e.getActionCommand().equals("退出")) {
            int s = JOptionPane.showConfirmDialog(null, "你确定要结束吗???",
                                                  "结束程序",
                                                  JOptionPane.YES_NO_OPTION);
            if (s == JOptionPane.YES_OPTION) { //判断是否退出
                jiemian.dispose();
            }
        }
    }


//======================================添加方法============================================
    public void tianjia() {
        String str;
        str =
                "insert into reader(借书证条形码,读者姓名,性别,联系电话,证件类型,证件号码,所在班级)values('" +
                jiemian.jTextField1.getText() + "','" +
                jiemian.jTextField3.getText() +
                "','" +
                jiemian.jChoice1.getSelectedItem() + "','" +
                jiemian.jTextField6.getText() +
                "','" + jiemian.jChoice2.getSelectedItem() +
                "','" + jiemian.jTextField5.getText() + "','" +
                jiemian.jTextField4.getText() +
                "')";
        System.out.println(str);
        mydb = new Mydb(); //连接驱动数据库
        try {
            mydb.sqlzen(str);
        } catch (SQLException ex) {
        }
        JOptionPane.showMessageDialog(null, "添加成功", "信息提示", 0);
        jiemian.jTextField1.setText("");
        jiemian.jTextField2.setText("");
        jiemian.jTextField3.setText("");
        jiemian.jTextField4.setText("");
        jiemian.jChoice1.select("男");
        jiemian.jChoice2.select("身份证");
        jiemian.jTextField5.setText("");
        jiemian.jTextField6.setText("");
        jiemian.jTextField1.requestFocus(); //获取光标
    }

//===========================修改方法==========================================================
    public void gai() {
        String string2;

        string2 = "update reader set 读者姓名='" + jiemian.jTextField3.getText() +
                  "', 性别='" + jiemian.jChoice1.getSelectedItem() +
                  "', 联系电话='" +
                  jiemian.jTextField6.getText() +
                  "',证件类型='" + jiemian.jChoice2.getSelectedItem()
                  + "',证件号码='" + jiemian.jTextField5.getText() + "',所在班级='" +
                  jiemian.jTextField4.getText() +
                  "'where 读者编号 = '" + jiemian.jTextField2.getText() +
                  "'";

        System.out.println(string2);

        try {
            //执行修改
            mydb = new Mydb();
            mydb.sqlgai(string2);

            JOptionPane.showMessageDialog(null, "信息修改成功！！！", "信息提示", 0);
            jiemian.jTextField1.setText("");
            jiemian.jTextField2.setText("");
            jiemian.jTextField3.setText("");
            jiemian.jTextField4.setText("");
            jiemian.jChoice1.select("男");
            jiemian.jChoice2.select("身份证");
            jiemian.jTextField5.setText("");
            jiemian.jTextField6.setText("");
            jiemian.jTextField1.requestFocus(); //获取光标
        } catch (SQLException ee) { //////////用户提示
            JOptionPane.showMessageDialog(null, "请检查数据库是否连接：",
                                          "信息提示", 0);
            ee.printStackTrace();
        }
    }

//================查找方法====================================================================
    public void chazhao(String s) {
        try {
            mydb = new Mydb();
            ResultSet resultset1 = mydb.sqlcha(s);
            ResultSet resultset2 = mydb.sqlcha(s);
            if (resultset1.next()) {
                while (resultset2.next()) { //将数据库中的信息添加至界面上相对应的组件上
                    jiemian.jTextField2.setText(resultset2.getString(1));
                    jiemian.jTextField1.setText(resultset2.getString(2));
                    jiemian.jTextField3.setText(resultset2.getString(3));
                    jiemian.jChoice1.select(resultset2.getString(4));
                    jiemian.jTextField6.setText(resultset2.getString(5));
                    jiemian.jChoice2.select(resultset2.getString(6));
                    jiemian.jTextField5.setText(resultset2.getString(7));
                    jiemian.jTextField4.setText(resultset2.getString(8));

                }
            } else { ///////////用户提示
                JOptionPane.showMessageDialog(null, "没有找到该读者！！！",
                                              "信息提示", 0);
            }
        } catch (SQLException ee) { /////////////提示
            JOptionPane.showMessageDialog(null, "请检查数据库是否连接：",
                                          "信息提示", 0);
        }

    }
}