edit_patient.java

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

    JPanel jPanel2 = new JPanel();
    JTextField mname = new JTextField();
    JTextField mnumber = new JTextField();
    JTextField pdoctor = new JTextField();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JPanel jPanel3 = new JPanel();
    JTextField lookname = new JTextField();
    JLabel jLabel12 = new JLabel();
    JButton jButton3 = new JButton();
    Column column8 = new Column();
    Column column11 = new Column();
    Column column9 = new Column();
    Column column10 = new Column();
    JTextField birthday = new JTextField();
    JTextField price = new JTextField();
    Column column12 = new Column();
    JButton show = new JButton();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    public void jdbTable1_mouseClicked(MouseEvent e) {
        x=1;
        n=jdbTable1.getSelectedRow();
        id=""+jdbTable1.getValueAt(n,0);
        name.setText((String)jdbTable1.getValueAt(n,1));
        sex.setSelectedItem((String)jdbTable1.getValueAt(n,2));
        birthday.setText(""+jdbTable1.getValueAt(n,3));
        bloodtype.setSelectedItem((String)jdbTable1.getValueAt(n,4));
        shengao.setText(""+jdbTable1.getValueAt(n,5));
        tizhong.setText(""+jdbTable1.getValueAt(n,6));
        mname.setText((String)jdbTable1.getValueAt(n,8));
        mnumber.setText(""+jdbTable1.getValueAt(n,9));
        pdoctor.setText((String)jdbTable1.getValueAt(n,7));
        price.setText(""+jdbTable1.getValueAt(n,10));
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        if(x==-1)
        {
            JOptionPane.showMessageDialog(null,"请选择你要修改的一条数据！");
        }
        else if(name.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的姓名！");
            name.requestFocus();
        }
        else if(sex.getSelectedItem().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的性别！");
            sex.requestFocus();
        }
        else if(birthday.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的性别！");
            birthday.requestFocus();
        }
        else if(bloodtype.getSelectedItem().equals(""))
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的血型！");
            bloodtype.requestFocus();
        }
        else if(shengao.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的身高！");
            shengao.requestFocus();
        }
        else if(number(shengao.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你修改的病人身高数据无效，请重新输入！");
            shengao.setText("");
            shengao.requestFocus();
        }
        else if(tizhong.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人的体重！");
            tizhong.requestFocus();
        }
        else if(number(tizhong.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你修改的病人体重数据无效，请重新输入！");
            tizhong.setText("");
            tizhong.requestFocus();
        }
        else if(mname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改的药品名称！");
            mname.requestFocus();
        }
        else if(mnumber.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改的药品数量！");
            mnumber.requestFocus();
        }
        else if(number(mnumber.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你修改的药品数量无效，请重新输入！");
            mnumber.setText("");
            mnumber.requestFocus();
        }
        else if(price.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改的药品价格！");
            price.requestFocus();
        }
        else if(pdoctor.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改的医生姓名！");
            pdoctor.requestFocus();
        }
        else
        {
            edit_patient();
        }


    }

    private boolean number(String s)
            {
                    String Phostr=s;
                    for(int i=0;i<Phostr.length();i++)
                    {
                            char ch=Phostr.charAt(i);
                            if(ch<'0'||ch>'9')
                            return false;
                    }
                    return true;
	}

    private void edit_patient()
    {
        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 patient set name=\'"+ name.getText()+"\',sex=\'"+ sex.getSelectedItem()+"\',birthday=\'"+birthday.getText()+"\',bloodtype=\'"+
                     bloodtype.getSelectedItem()+"\',stature=\'"+
                     shengao.getText()+"\',avoirdupois=\'"+ tizhong.getText()+"\',doctor=\'"+pdoctor.getText()+"\',medname=\'"+mname.getText()+"\',nenumber=\'"+mnumber.getText()+"\',price=\'"+ price.getText()+"\' where patient_id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"病人信息数据修改成功!");

            name.setText("");
            birthday.setText("");
            sex.setSelectedItem("");
            bloodtype.setSelectedItem("");
            shengao.setText("");
            tizhong.setText("");
            queryDataSet1.refresh();
            mname.setText("");
            mnumber.setText("");
            price.setText("");
            pdoctor.setText("");
            s.close();
            con.close();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        name.setText("");
        birthday.setText("");
        sex.setSelectedItem("");
        bloodtype.setSelectedItem("");
        shengao.setText("");
        tizhong.setText("");
        queryDataSet1.refresh();
        mname.setText("");
        mnumber.setText("");
        price.setText("");
        pdoctor.setText("");
        x=-1;
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        if(lookname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请输入你要查询的关键字！");
            lookname.requestFocus();
        }
        else if(!lookname.getText().equals(""))
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select * from patient where name=\'" +
                    lookname.getText() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的病人信息不存在");
            }
        }

    }

    public void show_actionPerformed(ActionEvent e) {
        queryDataSet1.close();
        queryDataSet1.setQuery(new QueryDescriptor(database1,
                "select * from patient" , null, true,Load.ALL));
        jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
    }

}


class edit_patient_show_actionAdapter implements ActionListener {
    private edit_patient adaptee;
    edit_patient_show_actionAdapter(edit_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_patient_jButton3_actionAdapter implements ActionListener {
    private edit_patient adaptee;
    edit_patient_jButton3_actionAdapter(edit_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_patient_jButton2_actionAdapter implements ActionListener {
    private edit_patient adaptee;
    edit_patient_jButton2_actionAdapter(edit_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_patient_jdbTable1_mouseAdapter extends MouseAdapter {
    private edit_patient adaptee;
    edit_patient_jdbTable1_mouseAdapter(edit_patient adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_patient_jButton1_actionAdapter implements ActionListener {
    private edit_patient adaptee;
    edit_patient_jButton1_actionAdapter(edit_patient adaptee) {
        this.adaptee = adaptee;
    }

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