📄 chargequerycondition.java
字号:
T14.requestFocus();
return false;
}
}
if(!T15.getText().equals("")){
Matcher mdate = dates.matcher(T15.getText().trim());
if (!mdate.matches()){ //判断接种日期输入格式是否正确
JOptionPane.showMessageDialog(this,"接种日期大于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T15.requestFocus();
return false;
}
}
if (!T1.getText().equals("")){
if (!T2.getText().equals("") || !T3.getText().equals("")){
JOptionPane.showMessageDialog(this,"宠物编号等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T2.getText().equals("") || !T3.getText().equals("")){
if (!T1.getText().equals("")){
JOptionPane.showMessageDialog(this,"宠物编号等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T2.getText().equals("") && !T3.getText().equals("")){
if (Integer.parseInt(T2.getText())<Integer.parseInt(T3.getText())){
JOptionPane.showMessageDialog(this,"宠物编号等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T4.getText().equals("")){
if (!T5.getText().equals("") || !T6.getText().equals("")){
JOptionPane.showMessageDialog(this,"收费日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T5.getText().equals("") || !T6.getText().equals("")){
if (!T4.getText().equals("")){
JOptionPane.showMessageDialog(this,"收费日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T7.getText().equals("")){
if (!T8.getText().equals("") || !T9.getText().equals("")){
JOptionPane.showMessageDialog(this,"金额等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T8.getText().equals("") || !T9.getText().equals("")){
if (!T7.getText().equals("")){
JOptionPane.showMessageDialog(this,"金额等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T10.getText().equals("")){
if (!T11.getText().equals("") || !T12.getText().equals("")){
JOptionPane.showMessageDialog(this,"就诊日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T11.getText().equals("") || !T12.getText().equals("")){
if (!T10.getText().equals("")){
JOptionPane.showMessageDialog(this,"就诊日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T13.getText().equals("")){
if (!T14.getText().equals("") || !T15.getText().equals("")){
JOptionPane.showMessageDialog(this,"接种日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
if (!T14.getText().equals("") || !T15.getText().equals("")){
if (!T13.getText().equals("")){
JOptionPane.showMessageDialog(this,"接种日期等于（或大于或小于）数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
return false;
}
}
this.panduan=panduan;
return panduan;
}
public static String saveSQL() {
String sqlxianzhi1="";
String sqlxianzhi2="";
String sqlxianzhi3="";
String sqlxianzhi4="";
String sqlxianzhi5="";
if (!T1.getText().equals("")){
sqlxianzhi1=" petcode ='"+T1.getText().trim()+"'";
}
else{
if (!T2.getText().equals("") && T3.getText().equals("")){
sqlxianzhi1=" petcode <'"+T2.getText().trim()+"'";
}
if (T2.getText().equals("") && !T3.getText().equals("")){
sqlxianzhi1=" petcode >'"+T3.getText().trim()+"'";
}
if (!T2.getText().equals("") && !T3.getText().equals("")){
sqlxianzhi1=" petcode >'"+T3.getText().trim()+"' and petcode <'"+T2.getText().trim()+"'";
}
}
if (!T4.getText().equals("")){
sqlxianzhi2=" chargedate = '"+T4.getText().trim()+"'";
}
else{
if (!T5.getText().equals("") && T6.getText().equals("")){
sqlxianzhi2=" chargedate < '"+T5.getText().trim()+"'";
}
if (T5.getText().equals("") && !T6.getText().equals("")){
sqlxianzhi2=" chargedate > '"+T6.getText().trim()+"'";
}
if (!T5.getText().equals("") && !T6.getText().equals("")){
sqlxianzhi2=" chargedate > '"+T6.getText().trim()+"' and chargedate < '"+T4.getText().trim()+"'";
}
}
if (!T7.getText().equals("")){
sqlxianzhi3=" totalmoney = '"+T7.getText().trim()+"'";
}
else{
if (!T8.getText().equals("") && T9.getText().equals("")){
sqlxianzhi3=" totalmoney < '"+T8.getText().trim()+"'";
}
if (T8.getText().equals("") && !T9.getText().equals("")){
sqlxianzhi3=" totalmoney > '"+T9.getText().trim()+"'";
}
if (!T8.getText().equals("") && !T9.getText().equals("")){
sqlxianzhi3=" totalmoney > '"+T9.getText().trim()+"' and " +"totalmoney < '"+T8.getText().trim()+"'";
}
}
if (!T10.getText().equals("")){
sqlxianzhi4=" diagnosedate = '"+T10.getText().trim()+"'";
}
else{
if (!T11.getText().equals("") && T12.getText().equals("")){
sqlxianzhi4=" diagnosedate < '"+T11.getText().trim()+"'";
}
if (T11.getText().equals("") && !T12.getText().equals("")){
sqlxianzhi4=" diagnosedate > '"+T12.getText().trim()+"'";
}
if (!T11.getText().equals("") && !T12.getText().equals("")){
sqlxianzhi4=" diagnosedate > '"+T12.getText().trim()+"' and diagnosedate < '"+T11.getText().trim()+"'";
}
}
if (!T13.getText().equals("")){
sqlxianzhi5=" inoculatedate = '"+T13.getText().trim()+"'";
}
else{
if (!T14.getText().equals("") && T15.getText().equals("")){
sqlxianzhi5=" inoculatedate < '"+T14.getText().trim()+"'";
}
if (T14.getText().equals("") && !T15.getText().equals("")){
sqlxianzhi5=" inoculatedate > '"+T15.getText().trim()+"'";
}
if (!T14.getText().equals("") && !T15.getText().equals("")){
sqlxianzhi5=" inoculatedate > '"+T15.getText().trim()+"' and inoculatedate < '"+T14.getText().trim()+"'";
}
}
if(!sqlxianzhi1.equals("")){
if(!sqlxianzhi2.equals("")){
if(!sqlxianzhi3.equals("")){
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi3;
}
}
}
else{
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi2;
}
}
}
}
else{
if(!sqlxianzhi3.equals("")){
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi3+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi3+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi3+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi3;
}
}
}
else{
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi1+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi1;
}
}
}
}
}
else{
if(!sqlxianzhi2.equals("")){
if(!sqlxianzhi3.equals("")){
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi3+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi3;
}
}
}
else{
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi2+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi2;
}
}
}
}
else{
if(!sqlxianzhi3.equals("")){
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi3+" and "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi3+" and "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi3+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi3;
}
}
}
else{
if(!sqlxianzhi4.equals("")){
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi4+" and "+sqlxianzhi5;
}
else{
Conditions="where "+sqlxianzhi4;
}
}
else{
if(!sqlxianzhi5.equals("")){
Conditions="where "+sqlxianzhi5+"";
}
else{
Conditions=""; //全部为空时，没有条件限制，输出所有记录！
}
}
}
}
}
return Conditions;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -