changechargeget.java

宠物医院管理系统 包含宠物的注册 管理 收费 诊断等一系列过程控制 还包含配应的数据库 Jar包

package yd.pethospital.chargecommon;

import java.sql.*;
import java.util.regex.*;
import javax.swing.*;
import yd.pethospital.chargeregister.view.*;
import yd.pethospital.share.SystemShare;

public class ChangeChargeGet {
	
	static PreparedStatement pst;                      //声明PreparedStatement对象 
	public static String sex;                         //获得宠物性别
	boolean check = false;
	public JFrame frame;                               //用于错误时返回原窗体
	
	ChargeRegister ChargeR=new ChargeRegister();
	
	public ChangeChargeGet(JFrame frame){
		
		this.frame=frame;
		if(setDao(check)){
			
			frame.dispose();
		}
	}
	
	public static void GetText(){
		
		ChangeCharge.TNum.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 0));    //获得所选表格内容 编号
		ChangeCharge.TDate.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 1));   //收费日期
		ChangeCharge.TMoney.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 2));  //金额
		ChangeCharge.TGo.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 3));     //就诊日期
		ChangeCharge.TReceive.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 4));//接种日期
		ChangeCharge.TMan.setText((String)ChargeRegister.BTCK.getValueAt(ChargeRegister.BTCK.getSelectedRow(), 5));    //诊断人
		
	}
	
	public boolean setDao(boolean check){
		
		try {
			
			SystemShare.SQL="update  ChargeInfo set chargedate=?,totalmoney=?,diagnosedate=?,inoculatedate=?,chargeman=? where petcode="+ChangeCharge.TNum.getText();
			SystemShare.getConnection();
			ChangeChargeGet.pst=SystemShare.pst;
			
			if(ChangeCharge.TDate.getText().trim().equals("")){             //收费日期为空处理
				
				JOptionPane.showMessageDialog(null,"收费日期不允许为空！","修改收费",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TDate.requestFocus();
				return false;
			}
			                                                                 //收费日期格式
			Pattern date=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) "); 
			Matcher mdate=date.matcher(ChangeCharge.TDate.getText()); 
			
			if (!mdate.matches()){ 
				
				JOptionPane.showMessageDialog(null,"收费日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TDate.setText("");
				ChangeCharge.TDate.requestFocus();
                return false;
			} 
			
			if(ChangeCharge.TMoney.getText().trim().equals("")){            //收费为空处理
				
				JOptionPane.showMessageDialog(null,"金额不允许为空！","修改收费",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TMoney.requestFocus();
				return false;
			}
			   
			if(ChangeCharge.TGo.getText().trim().equals("")){
				
				JOptionPane.showMessageDialog(null,"就诊日期不允许为空！","修改收费",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TGo.requestFocus();
				return false;
			}
			                                                                //就诊日期格式
			Pattern go=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) "); 
			Matcher mgo=go.matcher(ChangeCharge.TGo.getText()); 
			
			if (!mgo.matches()){ 
				
				JOptionPane.showMessageDialog(null,"就诊日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TGo.setText("");
				ChangeCharge.TGo.requestFocus();
                return false;
			} 
			
			if(ChangeCharge.TReceive.getText().trim().equals("")){
				
				JOptionPane.showMessageDialog(null,"接种日期不允许为空！","修改收费",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TReceive.requestFocus();
				return false;
			}
			                                                                    //接种日期为空处理
			Pattern receive=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) "); 
			Matcher mreceive=receive.matcher(ChangeCharge.TReceive.getText()); 
			
			if (!mreceive.matches()){ 
				
				JOptionPane.showMessageDialog(null,"接种日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TReceive.setText("");
				ChangeCharge.TReceive.requestFocus();
                return false;
			} 
			
			if(ChangeCharge.TMan.getText().trim().equals("")){                  //收费人为空处理           
				
				JOptionPane.showMessageDialog(null,"收费人不允许为空！","修改收费",JOptionPane.ERROR_MESSAGE);
				ChangeCharge.TMan.requestFocus();
				return false;
			}
			
			pst.setString(1,ChangeCharge.TDate.getText().trim());           //修改收费日期
			pst.setString(2,ChangeCharge.TMoney.getText().trim());          //修改费用
			pst.setString(3,ChangeCharge.TGo.getText().trim());             //修改就诊日期       
			pst.setString(4,ChangeCharge.TReceive.getText().trim());            //修改接种日期
			pst.setString(5,ChangeCharge.TMan.getText().trim());                //修改收费人
			
			pst.executeUpdate();                                                //更新数据库
			
			SystemShare.changesuccess();
			frame.dispose();
			new ChargeRegister();
			
			this.check=check;
			
		} catch (SQLException e) {                                              //处理异常
			e.printStackTrace();
			SystemShare.changefail();
		}
		SystemShare.close();
		return false;
	}
	
}