edit_reckoning.java

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

    JLabel jLabel9 = new JLabel();
    JButton show = new JButton();
    public void look_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 reckoning where patientname=\'" +
                    lookname.getText() + "\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的病人信息不存在");
            }
        }
    }

    public void jdbTable1_mouseClicked(MouseEvent e) {

        int n;
        n=jdbTable1.getSelectedRow();
        id=""+jdbTable1.getValueAt(n,0);
        pname.setText((String)jdbTable1.getValueAt(n,1));
        pmedicine.setText((String)jdbTable1.getValueAt(n,2));
        pprice.setText(""+jdbTable1.getValueAt(n,3));
        pnumber.setText(""+jdbTable1.getValueAt(n,4));
        doctor.setText((String)jdbTable1.getValueAt(n,5));
        day.setText(""+jdbTable1.getValueAt(n,6));
        x=1;
    }

    public void edit_r_actionPerformed(ActionEvent e) {

        if(x==-1)
        {
            JOptionPane.showMessageDialog(null,"请选择你要修改的一条数据！");
        }
        else if(pname.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的姓名！");
            pname.requestFocus();
        }
        else if(pmedicine.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的用药名称！");
            pmedicine.requestFocus();
        }
        else if(pprice.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的用药单价！");
            pprice.requestFocus();
        }
        else if(pnumber.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的用药数量！");
            pnumber.requestFocus();
        }
        else if(number(pnumber.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你修改的病人帐单用药数量无效，请重新输入！");
            pnumber.setText("");
            pnumber.requestFocus();
        }
        else if(doctor.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的主治医生的姓名！");
            doctor.requestFocus();
        }
        else if(day.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请填写你要修改病人帐单的时间！");
            day.requestFocus();
        }
        else
        {
            edit_reckoning();
        }



    }
void edit_reckoning()
    {
        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 reckoning set patientname=\'"+ pname.getText()+"\',medicine=\'"+ pmedicine.getText()+"\',price=\'"+pprice.getText()+"\',number=\'"+
                     pnumber.getText()+"\',doctor=\'"+
                     doctor.getText()+"\',date=\'"+ day.getText()+"\' where id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"病人帐单信息数据修改成功!");

            pname.setText("");
            pmedicine.setText("");


            pprice.setText("");
            pnumber.setText("");
            queryDataSet1.refresh();
            doctor.setText("");
            day.setText("");

            s.close();
            con.close();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }
    }
    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;
	}

    public void exit_actionPerformed(ActionEvent e) {
        pname.setText("");
        pmedicine.setText("");


        pprice.setText("");
        pnumber.setText("");
        queryDataSet1.refresh();
        doctor.setText("");
        day.setText("");
        x=-1;
    }

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


class edit_reckoning_show_actionAdapter implements ActionListener {
    private edit_reckoning adaptee;
    edit_reckoning_show_actionAdapter(edit_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_reckoning_exit_actionAdapter implements ActionListener {
    private edit_reckoning adaptee;
    edit_reckoning_exit_actionAdapter(edit_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_reckoning_edit_r_actionAdapter implements ActionListener {
    private edit_reckoning adaptee;
    edit_reckoning_edit_r_actionAdapter(edit_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_reckoning_jdbTable1_mouseAdapter extends MouseAdapter {
    private edit_reckoning adaptee;
    edit_reckoning_jdbTable1_mouseAdapter(edit_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class edit_reckoning_look_actionAdapter implements ActionListener {
    private edit_reckoning adaptee;
    edit_reckoning_look_actionAdapter(edit_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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