employeeframe.java

酒店管理系统后台数据库存储过程

        this.PanSql.setVisible(false);
        this.PanReg.setVisible(false);
        this.PanRSet.setVisible(true);
        this.PanDel.setVisible(false);

    }
    //显示员工离职面板
    public void btnDel_actionPerformed(ActionEvent e) {
        this.PanSql.setVisible(false);
        this.PanReg.setVisible(false);
        this.PanRSet.setVisible(false);
        this.PanDel.setVisible(true);
    }

    //查询面板的ID输入框的单击事件
       public void txtSql_actionPerformed(ActionEvent e) {
           btnSql_actionPerformed(e);

       }

     //员工信息查询按钮事件
    public void btnSql_actionPerformed(ActionEvent e) {
        //构建表结构
        emdtm = new DefaultTableModel();
        emdtm.addColumn("ID");
        emdtm.addColumn("职务");
        emdtm.addColumn("姓名");
        emdtm.addColumn("性别");
        emdtm.addColumn("民族");
        emdtm.addColumn("年龄");
        emdtm.addColumn("身份证号");
        emdtm.addColumn("籍贯");
        emdtm.addColumn("地址");
        emdtm.addColumn("联系电话");
        emdtm.addColumn("备注");
        this.emTab.setModel(emdtm);
        String sql = "select ID,title,name,sex,nationality,age,IDCard,native,address,phone,remark from employee";
        ResultSet rs = null;
        //构建查询全部的查询语句
        if (this.rdoAll.isSelected()) {
            sql += "";
        }
        //构建查询ID号的查询语句
        if (this.rdoID.isSelected()) {

            if (this.txtSql.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入您要查询的员工ID号！！");
                return;
            }
            sql += " where id = '" + this.txtSql.getText() + "'";
        }
        //构建查询姓名的查询语句
        if (this.rdoName.isSelected()) {
            if (this.txtSql.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入您要查询的员工姓名！！");
                return;
            }

            sql += " where name = '" + this.txtSql.getText() + "'";
        }
        //构建查询籍贯的查询语句
        if (this.rdoNative.isSelected()) {
            if (this.txtSql.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入您要查询的员工籍贯！！");
                return;
            }

            sql += " where native like '%" + this.txtSql.getText() + "%'";
        }
        //构建查询职务的sql语句
        if (this.rdoTitle.isSelected()) {

            if (this.txtSql.getText().equals("")) {
                JOptionPane.showMessageDialog(this, "请输入您要查询的员工职务！！");
                return;
            }

            sql += " where title like '%" + this.txtSql.getText() + "%'";

        }
        rs = dbo.returnQuery(sql);
        try {
            if (rs != null) {
                //向表中添加数据
                while (rs.next()) {
                    Vector v = new Vector();
                    v.add(rs.getString(1));
                    v.add(rs.getString(2));
                    v.add(rs.getString(3));
                    v.add(rs.getString(4));
                    v.add(rs.getString(5));
                    v.add(new Integer(rs.getInt(6)));
                    v.add(rs.getString(7));
                    v.add(rs.getString(8));
                    v.add(rs.getString(9));
                    v.add(rs.getString(10));
                    v.add(rs.getString(11));
                    emdtm.addRow(v);
                }
                this.emTab.setModel(emdtm);
            } else {
                JOptionPane.showMessageDialog(this, "没有找到相关数据，请重新查找！！");
                this.txtSql.setText("");
                this.txtSql.requestFocus();
            }
            rs.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }


     //注册新员工注册按钮事件
    public void btnReg_actionPerformed(ActionEvent e) {
        employee = new EmployeeBean();


        if (this.txtEmID.getText().equals("")) {

            JOptionPane.showMessageDialog(this, "员工ID不能为空！！");
            this.txtEmID.requestFocus();
            return;

        }

        if (this.txtEmName.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "姓名不能为空！！");
            this.txtEmName.requestFocus();
            return;
        }
        if (this.txtEmAge.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "年龄不能为空！！");
            this.txtEmAge.requestFocus();
            return;
        }

        String age = this.txtEmAge.getText();
        for (int i = 0; i < age.length(); i++) {
            if (!Character.isDigit(age.charAt(i))) {
                JOptionPane.showMessageDialog(this, "年龄不能为字符！！请重新输入！！");
                this.txtEmAge.requestFocus();
                return;
            }
        }

        int ageNum = Integer.parseInt(age);
        if (ageNum < 15 || ageNum > 80) {
            JOptionPane.showMessageDialog(this, "年龄不符合实际！！请重新输入！！");
            this.txtEmAge.requestFocus();
            return;
        }
        String id = this.txEmIDNo.getText();
        if (id.length() < 18) {

            JOptionPane.showMessageDialog(this, "身份证号应不能少于18位！！请重新输入！！");
            this.txEmIDNo.requestFocus();
            return;
        }

        if (this.txtEmTitle.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "员工职务不能为空！！请重新输入！！");
            this.txtEmTitle.requestFocus();
            return;
        }

        String query = "select * from employee where id = '" +
                       this.txtEmID.getText() + "'";

        ResultSet rt = dbo.returnQuery(query);
        try {
            if (rt.next()) {
                JOptionPane.showMessageDialog(this,
                                              " 该员工ID已经存在！！请选择其他员工ID号注册！！");
                return;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        //设置employeebean对象
        employee.setId(this.txtEmID.getText());
        employee.setName(this.txtEmName.getText());
        if (this.rdomale.isSelected()) {
            employee.setSex("男");
        } else if (this.rdoFamale.isSelected()) {
            employee.setSex("女");
        }
        employee.setAge(Integer.parseInt(this.txtEmAge.getText()));
        employee.setIdCard(txEmIDNo.getText());
        employee.setNationality(this.txtEmNationality.getText());
        employee.setNative(this.txtEmNative.getText());
        employee.setAdress(this.txtEmAddress.getText());
        employee.setPhone(this.txtEmPhone.getText());
        employee.setTitle(this.txtEmTitle.getText());
        employee.setRemark(this.txtEmRemark.getText());

//        System.out.println(" ID" + this.txtEmID.getText());
//        System.out.println("姓名" + this.txtEmName.getText());
//        System.out.println("男");
//        System.out.println("民族" + this.txtEmNationality.getText());
//        System.out.println("年龄" + this.txtEmAge.getText());
//        System.out.println("身份证号" + txEmIDNo.getText());
//        System.out.println("籍贯" + this.txtEmNative.getText());
//        System.out.println("住址" + this.txtEmAddress.getText());
//        System.out.println("电话" + this.txtEmPhone.getText());
//        System.out.println("职务" + this.txtEmTitle.getText());
//        System.out.println("备注" + this.txtEmRemark.getText());

        //select ID,name,sex,nationality,age,IDCard,native,address,phone,title,remark from employee
        String sql = "insert into employee values ('" + employee.getId() +
                     "','" + employee.getName()
                     + "','" + employee.getSex() + "','" +
                     employee.getNationality() + "','" + employee.getAge() +
                     "','" + employee.getIdCard() + "','"
                     + employee.getNative() + "','" + employee.getAdress()
                     + "','" + employee.getPhone() + "','" + employee.getTitle() +
                     "','" + employee.getRemark() + "')";

//        JOptionPane.showMessageDialog(this, sql);
        if (dbo.updateNoReturn(sql)) {
            JOptionPane.showMessageDialog(this, "成功添加新员工！！");
        }

    }

    // 注册新员工信息退出按钮事件
    public void btnExit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    //员工信息修改面板 查询按钮
    public void btnsqlRs_actionPerformed(ActionEvent e) {
        if (this.txtsqlRs.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "请为输入员工编号！！");
            this.txtsqlRs.requestFocus();
            return;
        }

        String id = this.txtsqlRs.getText();

        String sql = "select * from employee where id = '" + id + "'";
        ResultSet rt = null;
        rt = dbo.returnQuery(sql);
        try {
            if (rt.next()) {
                this.txtIDRs.setText(rt.getString(1));
                this.txtNameRs.setText(rt.getString(2));
                this.txtSexRs.setText(rt.getString(3));
                this.txtNationalityRs.setText(rt.getString(4));
                this.txtAgeRs.setText("" + rt.getInt(5));
                this.txtCarID.setText(rt.getString(6));
                this.txtNativeRs.setText(rt.getString(7));
                this.txtAddressRs.setText(rt.getString(8));
                this.txtPhoneRs.setText(rt.getString(9));
                this.txtTitleRs.setText(rt.getString(10));
                this.txtRemarkRs.setText(rt.getString(11));
            } else {
                JOptionPane.showMessageDialog(this, "没有的得到查询结果！！");
                this.txtsqlRs.setText("");
                this.txtsqlRs.requestFocus();
            }
            rt.close();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

    }

    //修改保存新员工信息
    public void btnSaveRs_actionPerformed(ActionEvent e) {
    if(this.txtIDRs.getText().equals(""))
    {
        JOptionPane.showMessageDialog(this,"员工ID号不能为空！！请重新修改！！");
        return;
    }
    if(this.txtNameRs.getText().equals(""))
  {
      JOptionPane.showMessageDialog(this,"员工姓名不能为空！！请重新修改！！");
      return;
  }
    if(this.txtAgeRs.getText().equals(""))
    {
      JOptionPane.showMessageDialog(this,"员工姓名不能为空！！请重新修改！！");
      return;
    }
    if(this.txtCarID.getText().equals(""))
    {
      JOptionPane.showMessageDialog(this,"员工身份证号不能为空！！请重新修改！！");
      return;
}
  if(this.txtAddressRs.getText().equals(""))
{
JOptionPane.showMessageDialog(this,"员工住址不能为空！！请重新修改！！");
return;
}
  if(this.txtTitleRs.getText().equals(""))
{
JOptionPane.showMessageDialog(this,"员工职务不能为空！！请重新修改！！");
return;
}
  if(this.txtNameRs.getText().equals(""))
{
JOptionPane.showMessageDialog(this,"员工姓名不能为空！！请重新修改！！");
return;
}


        employee = new EmployeeBean();
        employee.setId(this.txtIDRs.getText());
        employee.setName(this.txtNameRs.getText());
        //  employee.setSex(this.txtSexRs.getText());
        // employee.setNationality(this.txtNationalityRs.getText());
        employee.setAge(Integer.parseInt(this.txtAgeRs.getText()));
        // employee.setIdCard( this.txtCarID.getText());
        // employee.setNative( this.txtNativeRs.getText());
        employee.setAdress(this.txtAddressRs.getText());
        employee.setPhone(this.txtPhoneRs.getText());
        employee.setTitle(this.txtTitleRs.getText());
        employee.setRemark(this.txtRemarkRs.getText());