jiantingqi.java~3~

来自「java+sql 图书管理系统」· JAVA~3~ 代码 · 共 317 行

package MyLibraryok.users;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JOptionPane;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.sql.SQLException;
import MyLibraryok.MyMain.MyPassword;
import MyLibraryok.Mydb.Mydb;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Jiantingqi implements ActionListener {

    Usersjiemian jiemian;
    Mydb mydb;
    Feifa feifa;
    public Jiantingqi(Usersjiemian jiemian) {
        this.jiemian = jiemian;
    }

    static String pass1, pass2, pass3, pass4, pass5;

    public void actionPerformed(ActionEvent e) {
        char[] pw1 = jiemian.jPasswordField1.getPassword();
        pass1 = new String(pw1);
        char[] pw2 = jiemian.jPasswordField2.getPassword();
        pass2 = new String(pw2);
        char[] pw3 = jiemian.jPasswordField3.getPassword();
        pass3 = new String(pw3);
        char[] pw4 = jiemian.jPasswordField4.getPassword();
        pass4 = new String(pw4);
        char[] pw5 = jiemian.jPasswordField5.getPassword();
        pass5 = new String(pw5);

        if (e.getSource() == jiemian.jButton1) { ///////判断事件源-----"添加"
            Feifa feifa = new Feifa();
            if (feifa.fname(jiemian.jTextField6.getText())) { ///////非法判断
                jiemian.jTextField6.setText("");
                jiemian.jTextField6.requestFocus();
            } else if (feifa.fname(jiemian.jTextField4.getText())) { ///////非法判断
                jiemian.jTextField4.setText("");
                jiemian.jTextField4.requestFocus();
            } else if (feifa.fdianhua(jiemian.jTextField7.getText())) { //////非法判断
                jiemian.jTextField7.setText("");
                jiemian.jTextField7.requestFocus();
            } else {
                this.tianjia();
            }
        }

        else if (e.getSource() == jiemian.jButton2) { //判断事件源----------刷新
            String ss = "select * from users"; //////////////////调用查询方法
            chazhao(ss);

        } else if (e.getSource() == jiemian.jButton8) { //判断事件源---------“查找”
            Feifa feifa = new Feifa();
            if (feifa.fname(jiemian.jTextField14.getText())) { //非法判断
                jiemian.jTextField14.setText("");
                jiemian.jTextField14.requestFocus();
            } else {

                try {
                    mydb = new Mydb();
                    String ss = "select * from users where 用户名='" +
                                jiemian.jTextField14.getText() + "'";

                    ResultSet resultset2 = mydb.sqlcha(ss);
                    if (resultset2.next()) { /////////将数据库中的信息添加至界面上相对应的组件上
                        jiemian.jTextField14.setText(resultset2.getString(2));
//                        jiemian.jPasswordField3.setText(resultset2.getString(3));
                        jiemian.jTextField9.setText(resultset2.getString(4));
                        jiemian.jTextField11.setText(resultset2.getString(5));
                        jiemian.jchoice3.select(resultset2.getString(6));
                        jiemian.jTextField2.setText(resultset2.getString(7));
                        jiemian.jchoice4.select(resultset2.getString(8));
                    } else { ///////////用户提示
                        JOptionPane.showMessageDialog(null, "没有找到该管理员!!!",
                                "信息提示", 0);
                    }
                } catch (SQLException ee) { /////////////提示
                    JOptionPane.showMessageDialog(null, "请检查数据库是否连接：",
                                                  "信息提示", 0);
                }

            }

        }
        //判断事件源------"修改"
        else if (e.getSource() == jiemian.jButton6) {
            Feifa ff = new Feifa();
            if (jiemian.jTextField14.getText().length() == 0
                || jiemian.jTextField9.getText().length() == 0
                || jiemian.jTextField11.getText().length() == 0
                || pass4.length() == 0
                || pass5.length() == 0
                || jiemian.jTextField2.getText().length() == 0) {
                JOptionPane.showMessageDialog(null, "请添入相关信息：",
                                              "信息提示", 0);
            } else if (ff.fname(jiemian.jTextField14.getText())) { ///////非法判断
                jiemian.jTextField14.setText("");
                jiemian.jTextField14.requestFocus();
            }

            else if (ff.fmima(pass4, pass5)) { ///////非法判断
                jiemian.jTextField4.setText("");
                jiemian.jTextField5.setText("");
                jiemian.jTextField4.requestFocus();
            }

            else if (ff.fdianhua(jiemian.jTextField11.getText())) { //////非法判断                    jiemian.jTextField6.setText("");
                jiemian.jTextField11.setText("");
                jiemian.jTextField11.requestFocus();

            } else {
                JOptionPane.showMessageDialog(null, "您确定要修改吗???", "信息提示", 0);
                this.gai(); //调用修改方法

            }

        }

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

        else if (e.getActionCommand().equals("删除")) {

            int a = jiemian.jTable.getSelectedRow();
            if (a != -1) { /////判断是否选种
                shanchu(a);
            } else {
                JOptionPane.showMessageDialog(null, "请选择相关信息：", "温馨提示：",
                                              0);
            }
        }
    }


//======================================添加方法============================================
    public void tianjia() {
        String str;
        str = "insert into users(用户名,密码,真实姓名,电话,性别,家庭住址,用户类型) values('" +
              jiemian.jTextField6.getText() +
              "','" + new MyPassword().MyPassword(pass1) +
              "','" +
              jiemian.jTextField4.getText() +
              "','" + jiemian.jTextField7.getText() + "','" +
              jiemian.jChoice1.getSelectedItem() + "','" +
              jiemian.jTextField5.getText() +
              "','" + jiemian.jChoice2.getSelectedItem() +
              "')";
        System.out.println(str);

        try {
            mydb = new MyDB();
            mydb.sqlzen(str);
            JOptionPane.showMessageDialog(null, "添加成功", "信息提示", 0);
            jiemian.jTextField6.setText("");
            jiemian.jTextField4.setText("");
            jiemian.jPasswordField1.setText("");
            jiemian.jPasswordField2.setText("");
            jiemian.jTextField5.setText("");
            jiemian.jTextField7.setText("");
            jiemian.jTextField6.requestFocus(); //获取光标

        } catch (SQLException ex) { /////////////异常处理
            System.out.println("检查数据库");
            System.out.println(ex);
        }
    }

    private void jbInit() throws Exception {

    }

//===========================修改方法==========================================================
    public void gai() {
        String string, string2, string3, string4, string5, string6, string7,
                string8;

        string2 = "update users set 用户名='" + jiemian.jTextField14.getText() +
                  "'" + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";
        string6 = "update users set 真实姓名='" + jiemian.jTextField9.getText() +
                  "'";
        string3 = "update users set 密码='" +
                  pass4 +
                  "'" + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";
        string4 = "update users set 电话='" + jiemian.jTextField11.getText() +
                  "'" + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";
        string5 = "update users set 家庭住址='" +
                  jiemian.jTextField2.getText()
                  + "'" + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";

        string7 = "update users set 性别='" + jiemian.jchoice3.getSelectedItem() +
                  "'"
                  + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";
        string8 = "update users set 用户类型 ='" + jiemian.jchoice4.getSelectedItem() +
                  "'"
                  + "where 用户名 = '" + jiemian.jTextField14.getText() +
                  "'";
        System.out.println(string2);
        System.out.println(string3);
        System.out.println(string4);
        System.out.println(string5);
        System.out.println(string6);
        System.out.println(string7);
        System.out.println(string8);
        try {
            mydb = new MyDB();
            mydb.sqlgai(string2);
//            mydb.sqlgai(string3);
            mydb.sqlgai(string4);
            mydb.sqlgai(string5);
            mydb.sqlgai(string7);
            mydb.sqlgai(string7);
            mydb.sqlgai(string8);

            JOptionPane.showMessageDialog(null, "信息修改成功", "信息提示", 0);
            jiemian.jTextField14.setText("");
            jiemian.jPasswordField3.setText("");
            jiemian.jTextField9.setText("");
            jiemian.jPasswordField4.setText("");
            jiemian.jTextField11.setText("");
            jiemian.jPasswordField5.setText("");
            jiemian.jTextField2.setText("");
            jiemian.jTextField14.requestFocus();
        } catch (SQLException ee) { //////////用户提示
            JOptionPane.showMessageDialog(null, "请检查数据库是否连接：",
                                          "信息提示", 0);
            ee.printStackTrace();
        }
    }

////////////////////////////////////////查询方法//////////////////////////////////
    public void chazhao(String s) {
        jiemian.arraylist.clear(); //清除表格
        jiemian.jtablemodle.fireTableStructureChanged();
        MyDB db = new MyDB();
        try {
            ResultSet resultset1 = db.sqlcha(s);
            ResultSet resultset2 = db.sqlcha(s);
            if (resultset1.next()) {
                while (resultset2.next()) { /////////////////////提取数据库的数据
                    ArrayList array = new ArrayList();

                    array.add(resultset2.getString(2));
                    array.add(resultset2.getString(3));
                    array.add(resultset2.getString(4));
                    array.add(resultset2.getString(5));
                    array.add(resultset2.getString(6));
                    array.add(resultset2.getString(7));
                    array.add(resultset2.getString(8));
                    jiemian.arraylist.add(array); ///////加入表格
                    jiemian.jTable.setVisible(true); //////显示
                }
            } else {
                JOptionPane.showMessageDialog(null, "没有任何信息：", "温馨提示：", 0);
            }
        } catch (SQLException ee) {}
    }

//////////////////////删除方法///////////////////////////////////////////////////
    public void shanchu(int a) {
        MyDB mydb;
        int s = JOptionPane.showConfirmDialog(null, "你确定要删除吗？？？", "结束程序",
                                              JOptionPane.YES_NO_OPTION);

        if (s == JOptionPane.YES_OPTION) {
            mydb = new MyDB(); /////////SQL语句
            String srr = "delete users where 用户名='" +
                         String.valueOf(jiemian.jTable.getValueAt(a,0))+"'";

                         try {
                mydb.sqlzen(srr);

            } catch (SQLException ex) {
                ex.getNextException();
            }
            JOptionPane.showMessageDialog(null, "信息已删除：", "温馨提示：", 0);
            jiemian.arraylist.remove(a); //////////刷新表格内容
            jiemian.jtablemodle.fireTableStructureChanged();

        } else { /////提示对话框
            JOptionPane.showMessageDialog(null, "请选择要删除的行：", "温馨提示：", 0);
        }

    }


}