manage_reckoning.java

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

        secondday=syear.getText()+"-"+smonth.getText()+"-"+sday.getText();

        if(fyear.getText().length()==0 || fmonth.getText().length()==0 || fday.getText().length()==0 || syear.getText().length()==0 || smonth.getText().length()==0 || sday.getText().length()==0)
        {
            JOptionPane.showMessageDialog(null,"请完整的输入你要查询的关键字！");
        }
        else if(number(fyear.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询年不是有效数字!");
            fyear.setText("");
            fyear.requestFocus();
        }
        else if(Integer.parseInt(fyear.getText())<1900 || Integer.parseInt(fyear.getText())>2200)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询年份有误，请重新输入!");
            fyear.setText("");
            fyear.requestFocus();
        }
        else if(number(fmonth.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询月不是有效数字!");
            fmonth.setText("");
            fmonth.requestFocus();
        }
        else if(Integer.parseInt(fmonth.getText())<1 || Integer.parseInt(fmonth.getText())>12)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询月份有误，请重新输入!");
            fmonth.setText("");
            fmonth.requestFocus();
        }
        else if(number(fday.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询日不是有效数字!");
            fday.setText("");
            fday.requestFocus();
        }
        else if(Integer.parseInt(fday.getText())<1 || Integer.parseInt(fday.getText())>31)
        {
            JOptionPane.showMessageDialog(null,"你输入的起始查询日有误，请重新输入!");
            fday.setText("");
            fday.requestFocus();
        }
        else if(number(syear.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间年不是有效数字!");
            syear.setText("");
            syear.requestFocus();
        }
        else if(Integer.parseInt(syear.getText())<1900 || Integer.parseInt(syear.getText())>2200)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间年份有误，请重新输入!");
            syear.setText("");
            syear.requestFocus();
        }
        else if(number(smonth.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间月不是有效数字!");
            smonth.setText("");
            smonth.requestFocus();
        }
        else if(Integer.parseInt(smonth.getText())<1 || Integer.parseInt(smonth.getText())>12)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间月份有误，请重新输入!");
            smonth.setText("");
            smonth.requestFocus();
        }
        else if(number(sday.getText())==false)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间日不是有效数字!");
            sday.setText("");
            sday.requestFocus();
        }
        else if(Integer.parseInt(sday.getText())<1 || Integer.parseInt(sday.getText())>31)
        {
            JOptionPane.showMessageDialog(null,"你输入的截止时间日有误，请重新输入!");
            sday.setText("");
            sday.requestFocus();
        }
        else if(Integer.parseInt(fyear.getText())>Integer.parseInt(syear.getText()))
        {
            JOptionPane.showMessageDialog(null,"你输入的起始时间年大于截止时间年，请重新输入!");
        }
        else if(Integer.parseInt(fmonth.getText())>Integer.parseInt(smonth.getText()))
        {
            JOptionPane.showMessageDialog(null,"你输入的起始时间月份大于截止时间月份，请重新输入!");
        }
        else if(Integer.parseInt(fday.getText())>Integer.parseInt(sday.getText()))
        {
            JOptionPane.showMessageDialog(null,"你输入的起始时间日大于截止时间日，请重新输入!");
        }
        else
        {
            queryDataSet1.close();
            queryDataSet1.setQuery(new QueryDescriptor(database1,
                    "select * from reckoning where date between\'"+firstday + "\' and \'"+secondday+"\'", null, true,
                    Load.ALL));
            jdbTable1.setDataSet(queryDataSet1);
            queryDataSet1.refresh();//
            if(queryDataSet1.getRowCount()==0)
            {
                JOptionPane.showMessageDialog(null,"你要查询的帐单信息不存在");
            }
        }



    }

    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 delete_actionPerformed(ActionEvent e) {
        if(x==-1)
        {
            JOptionPane.showMessageDialog(null,"请选择你要删除的一条数据！");
        }
        else
        {
            int i=JOptionPane.showConfirmDialog(null,"确定真的要删除这条数据么？","信息提示",JOptionPane.YES_NO_OPTION);
            if(i==JOptionPane.YES_OPTION)
            {
                delete_reck();
            }
            else
            {
                JOptionPane.showMessageDialog(null,"你所选的数据没用删除！");
                x=-1;
            }

        }
    }
    void delete_reck()
    {
        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="delete from reckoning where id=\'"+id+"\'";
            Statement s = con.createStatement();
            s.executeUpdate(sqlStr);
            JOptionPane.showMessageDialog(null,"删除数据成功!");
            queryDataSet1.refresh();

            s.close();
            con.close();
            x=-1;
        } catch (SQLException ce) {
            System.out.println(ce);
        }
    }

    public void quxiao2_actionPerformed(ActionEvent e) {

        fyear.setText("");
        fmonth.setText("");
        fday.setText("");
        syear.setText("");
        smonth.setText("");
        sday.setText("");


    }

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

            fyear.setText("");
            fmonth.setText("");
            fday.setText("");
            syear.setText("");
            smonth.setText("");
            sday.setText("");
    }

    public void sum_actionPerformed(ActionEvent e) {

        float sum=0;
        float a=0;
        String pri;
        String number;
        int i;
        int z;
        int j;
        z=jdbTable1.getSelectedRow();
        j=jdbTable1.getRowCount();
        for(i=0;i<j;i++)
        {
            int n;
            //n = jdbTable1.getSelectedRow();
            pri = String.valueOf(jdbTable1.getValueAt(i, 3));
            number = String.valueOf(jdbTable1.getValueAt(i, 4));
            a = Float.parseFloat(pri) * Float.parseFloat(number);
            sum=sum+a;

        }
        if(fyear.getText().length()==0 || syear.getText().length()==0)
            huizong.setText("\n"+"上面所示帐单汇总结果如下："+"\n\n"+"             上面所有帐单收入是："+"\n\n"+""+"\t\t"+sum+" 元");
        else
            huizong.setText("\n"+"上面所示帐单汇总结果如下："+"\n\n"+"             从"+firstday+"到"+secondday+"的所有帐单收入是："+"\n\n"+""+"\t\t"+sum+" 元");
    }
}


class manage_reckoning_sum_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_sum_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_jButton6_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_jButton6_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_quxiao2_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_quxiao2_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_delete_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_delete_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_looktime_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_looktime_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_jdbTable1_mouseAdapter extends MouseAdapter {
    private manage_reckoning adaptee;
    manage_reckoning_jdbTable1_mouseAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_quxiao1_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_quxiao1_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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


class manage_reckoning_lookname_actionAdapter implements ActionListener {
    private manage_reckoning adaptee;
    manage_reckoning_lookname_actionAdapter(manage_reckoning adaptee) {
        this.adaptee = adaptee;
    }

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