changediagnoseget.java

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

package yd.pethospital.diagnose.jdbc;

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

public class ChangeDiagnoseGet {
	
	static PreparedStatement pst;                      //声明PreparedStatement对象 
	boolean check = false;
	public JFrame frame;                               //用于错误时返回原窗体
	
	public ChangeDiagnoseGet(JFrame frame){

		this.frame=frame;
		if(setDao(check)){
			
			frame.dispose();
		}
	}
	
	public static void GetText(){                     //调用
		
		ChangeDiagnose.TNum.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 1));
		ChangeDiagnose.TDate.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 2));
		ChangeDiagnose.TProblem.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 3));
		ChangeDiagnose.TResult.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 4));
		ChangeDiagnose.TWays.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 5));
		ChangeDiagnose.TMan.setText((String)DiagnoseRegister.BTCK.getValueAt(DiagnoseRegister.BTCK.getSelectedRow(), 6));
		
	}
	
	public boolean setDao(boolean check){
		
		try {
			
			SystemShare.SQL="update DiagnoseInfo set diagnosedate=?,symptom=?,diagnoseresult=?,dealstep=?,diagnoseman=? where petcode="+ChangeDiagnose.TNum.getText();
			SystemShare.getConnection();
			ChangeDiagnoseGet.pst=SystemShare.pst; 
			
			if(ChangeDiagnose.TDate.getText().trim().equals("")){        //就诊日期为空处理
				
				JOptionPane.showMessageDialog(null,"就诊日期不允许为空！","修改诊断",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TDate.requestFocus();
				return false;
			}
			                                                             //就诊日期处理
			Pattern birth=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 mbirth=birth.matcher(ChangeDiagnose.TDate.getText()); 
			
			if (!mbirth.matches()){ 
				
				JOptionPane.showMessageDialog(null,"就诊日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TDate.setText("");
				ChangeDiagnose.TDate.requestFocus();
                return false;
			} 
			
			if(ChangeDiagnose.TProblem.getText().trim().equals("")){    //症状为空处理
				
				JOptionPane.showMessageDialog(null,"症状不允许为空！","修改诊断",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TProblem.requestFocus();
				return false;
			}
			
			if(ChangeDiagnose.TResult.getText().trim().equals("")){     //诊断结果为空处理
				
				JOptionPane.showMessageDialog(null,"诊断结果不允许为空！","修改诊断",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TResult.requestFocus();
				return false;
			}

			if(ChangeDiagnose.TWays.getText().trim().equals("")){      //处理措施为空处理
				
				JOptionPane.showMessageDialog(null,"处理措施不允许为空！","修改诊断",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TWays.requestFocus();
				return false;
			}
			
			if(ChangeDiagnose.TMan.getText().trim().equals("")){       //诊断人为空处理
				
				JOptionPane.showMessageDialog(null,"诊断人不允许为空！","修改诊断",JOptionPane.ERROR_MESSAGE);
				ChangeDiagnose.TMan.requestFocus();
				return false;
			}
			
			pst.setString(1,ChangeDiagnose.TDate.getText().trim());      //修改就诊日期
			pst.setString(2,ChangeDiagnose.TProblem.getText().trim());  //修改症状
			pst.setString(3,ChangeDiagnose.TResult.getText().trim());   //修改诊断结果
			pst.setString(4,ChangeDiagnose.TWays.getText().trim());    //修改处理措施
			pst.setString(5,ChangeDiagnose.TMan.getText().trim());     //修改诊断人
			
			pst.executeUpdate();
			                                            //修改诊断成功
			SystemShare.changesuccess();
			frame.dispose();
			new DiagnoseRegister();
			
			this.check=check;
			
		} catch (SQLException e) {                     //处理异常
			SystemShare.changefail();
		} 
		SystemShare.close();
		return false;
	}
}