edit_doctor.java

在个一个诊所系统,实现数据的查询和删除等的操作.

    Column column10 = new Column();
    JComboBox jComboBox1 = new JComboBox();
    JLabel jLabel3 = new JLabel();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    Column column11 = new Column();
    Column column12 = new Column();
    Column column13 = new Column();
    Column column14 = new Column();
    Column column15 = new Column();
    Column column16 = new Column();
    JLabel jLabel7 = new JLabel();
    JButton jch = new JButton();
    JTextField cdoctor = new JTextField();
    JLabel jLabel8 = new JLabel();
    JPanel jPanel1 = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton show = new JButton();
    JPanel jPanel2 = new JPanel();
    JLabel jLabel9 = new JLabel();
    JComboBox jComboBox2 = new JComboBox();
    JPanel jPanel3 = new JPanel();
    public void jdbTable1_mouseClicked(MouseEvent e) {
        x=1;
        n=jdbTable1.getSelectedRow();
        //id=(String)jdbTable1.getValueAt(n,0);
        id=""+jdbTable1.getValueAt(n,0);
        jTname.setText((String)jdbTable1.getValueAt(n,1));
        jComboBox1.setSelectedItem((String)jdbTable1.getValueAt(n,2));
        jTphonenumber.setText(""+jdbTable1.getValueAt(n,3));
        jTemail.setText((String)jdbTable1.getValueAt(n,4));
    }

    public void jBorder_actionPerformed(ActionEvent e) {

        if(x==-1)
        {
            JOptionPane.showMessageDialog(null,"请选择你要修改的一条信息！");
        }
        else if(jTname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改的姓名！");
            jTname.requestFocus();
        }
        else if(jComboBox1.getSelectedItem().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请选择你要修改的医生专业！");
            jComboBox1.requestFocus();
        }
        else if(!jPasswordField1.getText().equals(jPasswordField2.getText()))
        {
            JOptionPane.showMessageDialog(null,"两次输入的密码不一致，请重新输入！");
            jPasswordField1.setText("");
            jPasswordField2.setText("");
            jPasswordField1.requestFocus();
        }
        else if(jTphonenumber.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请输入你要修改的医生电话号码！");
            jTphonenumber.requestFocus();
        }
        else if(Phone()==false)
        {
            JOptionPane.showMessageDialog(null, "你输的电话号码有误，请重新输入！");
            jTphonenumber.setText("");
            jTphonenumber.requestFocus();
        }
        else if(jTemail.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请输入你要修改的电子邮件！");
            jTemail.requestFocus();
        }
        else
{
            String s = jTemail.getText();
            checkEmailID che = new checkEmailID(s);
          if(!che.f)
          {
            jTemail.setText("");
            jTemail.requestFocus();
          }
        else
        {
            edit_doctor();
        }
}
}



public boolean Phone()
{
           String s=jTphonenumber.getText();
           for (int i = 0; i < s.length(); i++)
           {
               char ch = s.charAt(i);
               if (ch < '0' || ch > '9')
                   return false;
           }
           return true;
}
    class EmailException extends Exception{
                   EmailException(){
                           super("你所输入的邮件格式错误,请重新输入!");
                           JOptionPane.showMessageDialog(null,"你所输入的邮件格式错误,请重新输入!","Error",JOptionPane.WARNING_MESSAGE);
                   }
           }

 class checkEmailID{
     Boolean f;
     String strEmail;
public checkEmailID(String s)
     {
         strEmail=s;
         f=false;
         try{
         check(strEmail);
         f=true;
         }
         catch(EmailException e){
             System.out.println(e);
             }

        }
 void check(String s) throws EmailException{
     int a=strEmail.indexOf("@");
     int b=strEmail.indexOf(".");
     if(a<1||b==-1||a>b||b==(strEmail.length()-1)||strEmail.indexOf("@",a+1)!=strEmail.indexOf(".",b+1))
         throw new EmailException();
   }
    }
    private void edit_doctor()
    {
        try {
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        } catch (ClassNotFoundException ce) {
            System.out.println(ce);
        }
        try {
            String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=clinique";
            Connection con = DriverManager.getConnection(url,"sa","");
            String sqlStr;
            sqlStr="update doctor set name=\'"+jTname.getText()+"\',password=\'"+jPasswordField1.getText()+"\',profession=\'"+jComboBox1.getSelectedItem()+"\',phonenumber=\'"+jTphonenumber.getText()+"\',email=\'"+jTemail.getText()+"\' where doctor_id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"数据修改成功!");
            jTname.setText("");
            jComboBox1.setSelectedItem("");
            jPasswordField1.setText("");
            jPasswordField2.setText("");
            jTphonenumber.setText("");
            jTemail.setText("");
            s.close();
            con.close();
            queryDataSet1.refresh();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        jTname.setText("");
        jComboBox1.setSelectedItem("");
        jPasswordField1.setText("");
        jPasswordField2.setText("");
        jTphonenumber.setText("");
        jTemail.setText("");
        x=-1;
    }

    public void jch_actionPerformed(ActionEvent e) {
        if(cdoctor.getText().length()==0 && jComboBox2.getSelectedItem().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请输入你要查询的关键字！");
            cdoctor.requestFocus();
        }
        else if(!cdoctor.getText().equals("") && !jComboBox2.getSelectedItem().equals(""))
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select doctor_id,name,profession,phonenumber,email from doctor where name=\'" +
                    cdoctor.getText() + "\' and profession=\'" +
                    jComboBox2.getSelectedItem() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的医生信息不存在");
            }
        }
        else
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select doctor_id,name,profession,phonenumber,email from doctor where name=\'" +
                    cdoctor.getText() + "\' or profession=\'" +
                    jComboBox2.getSelectedItem() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的医生信息不存在");
            }
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select doctor_id,name,profession,phonenumber,email from doctor" , null, true,Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
    }

}


class edit_doctor_jButton1_actionAdapter implements ActionListener {
    private edit_doctor adaptee;
    edit_doctor_jButton1_actionAdapter(edit_doctor adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class edit_doctor_jch_actionAdapter implements ActionListener {
    private edit_doctor adaptee;
    edit_doctor_jch_actionAdapter(edit_doctor adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jch_actionPerformed(e);
    }
}


class edit_doctor_jButton2_actionAdapter implements ActionListener {
    private edit_doctor adaptee;
    edit_doctor_jButton2_actionAdapter(edit_doctor adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}


class edit_doctor_jBorder_actionAdapter implements ActionListener {
    private edit_doctor adaptee;
    edit_doctor_jBorder_actionAdapter(edit_doctor adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBorder_actionPerformed(e);
    }
}


class edit_doctor_jdbTable1_mouseAdapter extends MouseAdapter {
    private edit_doctor adaptee;
    edit_doctor_jdbTable1_mouseAdapter(edit_doctor adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jdbTable1_mouseClicked(e);
    }
}