📄 chargequerycondition.java
字号:
package yd.pethospital.chargequery.view;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.regex.*;
public class ChargeQueryCondition extends JFrame {
JLabel LTitle,LNum,LDate,LMoney,LGo,LCure,LShuo;
JLabel LE1,LE2,LE3,LE4,LE5,LE6,LE7,LE8,LE9,LE10,LE11,LE12,L13LE14,LE15;
JLabel LS1,LS2,LS3,LS4,LS5,LS6,LS7,LS8,LS9,LS10,LS11,LS12,LS13,LS14,LS15;
JLabel LB1,LB2,LB3,LB4,LB5,LB6,LB7,LB8,LB9,LB10,LB11,LB12,LB13,LB14,LB15;
JButton BSure,BCancel;
public static JTextField T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15;
JPanel panel;
public JFrame frame;
boolean panduan=false; //判断输入是否符合要求
public static String Conditions=""; //保存sql的限制语句
public ChargeQueryCondition(){
this.setTitle("查询条件");
this.setBounds(230, 100, 630, 450);
this.setResizable(false);
this.validate();
LTitle=new JLabel("请输入查询条件");
LTitle.setFont(new Font(null,Font.BOLD,25));
LTitle.setBounds(220, 20, 200, 40);
this.add(LTitle);
LNum=new JLabel("宠物编号");
LNum.setFont(new Font(null,Font.BOLD,16));
LNum.setBounds(30, 70, 80, 30);
this.add(LNum);
LDate=new JLabel("收费日期");
LDate.setFont(new Font(null,Font.BOLD,16));
LDate.setBounds(30, 120, 80, 30);
this.add(LDate);
LMoney=new JLabel("金 额");
LMoney.setFont(new Font(null,Font.BOLD,16));
LMoney.setBounds(30, 170, 80, 30);
this.add(LMoney);
LGo=new JLabel("就诊日期");
LGo.setFont(new Font(null,Font.BOLD,16));
LGo.setBounds(30, 220, 80, 30);
this.add(LGo);
LCure=new JLabel("接种日期");
LCure.setFont(new Font(null,Font.BOLD,16));
LCure.setBounds(30, 270, 80, 30);
this.add(LCure);
LShuo=new JLabel("说明：以上条件若不为空则同时满足");
LShuo.setFont(new Font(null,Font.BOLD,16));
LShuo.setBounds(30, 320, 280, 30);
this.add(LShuo);
LE1=new JLabel("等于");
LE1.setFont(new Font(null,Font.BOLD,16));
LE1.setBounds(130, 75, 50, 20) ;
this.add(LE1);
T1=new JTextField(20); //编号 等于
T1.setBounds(170, 75, 100, 25);
this.add(T1);
LS1=new JLabel("小于");
LS1.setFont(new Font(null,Font.BOLD,16));
LS1.setBounds(290, 75, 50, 20) ;
this.add(LS1);
T2=new JTextField(20); //编号 小于
T2.setBounds(330, 75, 100, 25);
this.add(T2);
LB1=new JLabel("大于");
LB1.setFont(new Font(null,Font.BOLD,16));
LB1.setBounds(450, 75, 50, 20) ;
this.add(LB1);
T3=new JTextField(20); //编号 大于
T3.setBounds(490, 75, 100, 25);
this.add(T3);
LE2=new JLabel("等于");
LE2.setFont(new Font(null,Font.BOLD,16));
LE2.setBounds(130, 125, 50, 20) ;
this.add(LE2);
T4=new JTextField(20);
T4.setBounds(170, 125, 100, 25);
this.add(T4);
LS2=new JLabel("小于");
LS2.setFont(new Font(null,Font.BOLD,16));
LS2.setBounds(290, 125, 50, 20) ;
this.add(LS2);
T5=new JTextField(20);
T5.setBounds(330, 125, 100, 25);
this.add(T5);
LB2=new JLabel("大于");
LB2.setFont(new Font(null,Font.BOLD,16));
LB2.setBounds(450, 125, 50, 20) ;
this.add(LB2);
T6=new JTextField(20);
T6.setBounds(490, 125, 100, 25);
this.add(T6);
LE3=new JLabel("等于");
LE3.setFont(new Font(null,Font.BOLD,16));
LE3.setBounds(130, 175, 50, 20) ;
this.add(LE3);
T7=new JTextField(20);
T7.setBounds(170, 175, 100, 25);
this.add(T7);
LS3=new JLabel("小于");
LS3.setFont(new Font(null,Font.BOLD,16));
LS3.setBounds(290, 175, 50, 20) ;
this.add(LS3);
T8=new JTextField(20);
T8.setBounds(330, 175, 100, 25);
this.add(T8);
LB3=new JLabel("大于");
LB3.setFont(new Font(null,Font.BOLD,16));
LB3.setBounds(450, 175, 50, 20) ;
this.add(LB3);
T9=new JTextField(20);
T9.setBounds(490, 175, 100, 25);
this.add(T9);
LE4=new JLabel("等于");
LE4.setFont(new Font(null,Font.BOLD,16));
LE4.setBounds(130, 225, 50, 20) ;
this.add(LE4);
T10=new JTextField(20);
T10.setBounds(170, 225, 100, 25);
this.add(T10);
LS4=new JLabel("小于");
LS4.setFont(new Font(null,Font.BOLD,16));
LS4.setBounds(290, 225, 50, 20) ;
this.add(LS4);
T11=new JTextField(20);
T11.setBounds(330, 225, 100, 25);
this.add(T11);
LB4=new JLabel("大于");
LB4.setFont(new Font(null,Font.BOLD,16));
LB4.setBounds(450, 225, 50, 20) ;
this.add(LB4);
T12=new JTextField(20);
T12.setBounds(490, 225, 100, 25);
this.add(T12);
LE5=new JLabel("等于");
LE5.setFont(new Font(null,Font.BOLD,16));
LE5.setBounds(130, 275, 50, 20) ;
this.add(LE5);
T13=new JTextField(20);
T13.setBounds(170, 275, 100, 25);
this.add(T13);
LS5=new JLabel("小于");
LS5.setFont(new Font(null,Font.BOLD,16));
LS5.setBounds(290, 275, 50, 20) ;
this.add(LS5);
T14=new JTextField(20);
T14.setBounds(330, 275, 100, 25);
this.add(T14);
LB5=new JLabel("大于");
LB5.setFont(new Font(null,Font.BOLD,16));
LB5.setBounds(450, 275, 50, 20) ;
this.add(LB5);
T15=new JTextField(20);
T15.setBounds(490, 275, 100, 25);
this.add(T15);
BSure=new JButton("确定");
BSure.setBounds(200,360,70,30);
this.add(BSure);
BSure.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0) {
check(panduan);
new ChargeQuery();
ChargeQueryCondition.this.dispose();
}
});
BCancel=new JButton("取消");
BCancel.setBounds(380,360,70,30);
this.add(BCancel);
BCancel.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent arg0) {
ChargeQueryCondition.this.dispose();
}
});
panel=new JPanel();
this.add(panel);
this.setVisible(true);
}
public boolean check(boolean panduan){
Pattern codes=Pattern.compile("[0-9]{8}");
if(!T1.getText().equals("")){
Matcher mcode=codes.matcher(T1.getText().trim());
if (!mcode.matches()){ //判断宠物编号输入格式是否正确
JOptionPane.showMessageDialog(this,"宠物编号等于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T1.requestFocus();
return false;
}
}
if(!T2.getText().equals("")){
Matcher mname = codes.matcher(T2.getText().trim());
if (!mname.matches()){ //判断宠物编号输入格式是否正确
JOptionPane.showMessageDialog(this,"宠物编号小于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T2.requestFocus();
return false;
}
}
if(!T3.getText().equals("")){
Matcher mname = codes.matcher(T3.getText().trim());
if (!mname.matches()){ //判断宠物编号输入格式是否正确
JOptionPane.showMessageDialog(this,"宠物编号大于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T3.requestFocus();
return false;
}
}
Pattern moneys=Pattern.compile("[0-9]");
if(!T7.getText().equals("")){
Matcher mmoney=moneys.matcher(T7.getText().trim());
if (!mmoney.matches()){ //判断金额输入格式是否正确
JOptionPane.showMessageDialog(this,"金额等于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T7.requestFocus();
return false;
}
}
if(!T8.getText().equals("")){
Matcher mmoney = moneys.matcher(T8.getText().trim());
if (!mmoney.matches()){ //判断金额输入格式是否正确
JOptionPane.showMessageDialog(this,"金额小于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T8.requestFocus();
return false;
}
}
if(!T9.getText().equals("")){
Matcher mmoney = moneys.matcher(T9.getText().trim());
if (!mmoney.matches()){ //判断金额输入格式是否正确
JOptionPane.showMessageDialog(this,"金额大于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T9.requestFocus();
return false;
}
}
Pattern dates=Pattern.compile("(([0-9]{3}[1-9]|[0-9]{2}[1-9][0-9]{1}|[0-9]{1}[1-9][0-9]{2}|[1-9][0-9]{3})-(((0[13578]|1[02])-(0[1-9]|[12][0-9]|3[01]))|((0[469]|11)-(0[1-9]|[12][0-9]|30))|(02-(0[1-9]|[1][0-9]|2[0-8]))))|((([0-9]{2})(0[48]|[2468][048]|[13579][26])|((0[48]|[2468][048]|[3579][26])00))-02-29) ");
if(!T4.getText().equals("")){
Matcher mdate = dates.matcher(T4.getText().trim());
if (!mdate.matches()){ //判断收费日期输入格式是否正确
JOptionPane.showMessageDialog(this,"收费日期等于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T4.requestFocus();
return false;
}
}
if(!T5.getText().equals("")){
Matcher mdate = dates.matcher(T5.getText().trim());
if (!mdate.matches()){ //判断收费日期输入格式是否正确
JOptionPane.showMessageDialog(this,"收费日期小于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T5.requestFocus();
return false;
}
}
if(!T6.getText().equals("")){
Matcher mdate = dates.matcher(T6.getText().trim());
if (!mdate.matches()){ //判断收费日期输入格式是否正确
JOptionPane.showMessageDialog(this,"收费日期大于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T6.requestFocus();
return false;
}
}
if(!T10.getText().equals("")){
Matcher mdate = dates.matcher(T10.getText().trim());
if (!mdate.matches()){ //判断就诊日期输入格式是否正确
JOptionPane.showMessageDialog(this,"就诊日期等于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T10.requestFocus();
return false;
}
}
if(!T11.getText().equals("")){
Matcher mdate = dates.matcher(T1.getText().trim());
if (!mdate.matches()){ //判断就诊日期输入格式是否正确
JOptionPane.showMessageDialog(this,"就诊日期小于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T11.requestFocus();
return false;
}
}
if(!T12.getText().equals("")){
Matcher mdate = dates.matcher(T12.getText().trim());
if (!mdate.matches()){ //判断就诊日期输入格式是否正确
JOptionPane.showMessageDialog(this,"就诊日期大于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T12.requestFocus();
return false;
}
}
if(!T13.getText().equals("")){
Matcher mdate = dates.matcher(T13.getText().trim());
if (!mdate.matches()){ //判断接种日期输入格式是否正确
JOptionPane.showMessageDialog(this,"接种日期等于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
T13.requestFocus();
return false;
}
}
if(!T14.getText().equals("")){
Matcher mdate = dates.matcher(T14.getText().trim());
if (!mdate.matches()){ //判断接种日期输入格式是否正确
JOptionPane.showMessageDialog(this,"接种日期小于数据不合法！","收费查询",JOptionPane.ERROR_MESSAGE);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -