changepetget.java

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

package yd.pethospital.petregister.jdbc;

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

public class ChangePetGet {

	public PreparedStatement pst;
	public static String sex;                         //获得宠物性别
	boolean check = false;
	public JFrame frame;                               //用于错误时返回原窗体
	
	public ChangePetGet(JFrame frame){
		
		this.frame=frame;
		if(setDao(check)){
			
			frame.dispose();
		}
	}
	
	public static void GetText(){
		
		ChangePet.TNum.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 0));     //获得所选中的表格的内容 编号
		ChangePet.TName.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 1));    //名称
		ChangePet.CType.select((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 2));     //类型
		
		sex=(String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 3);        
			
			if(sex.trim().equals("雄性")){                      //对性别的处理
				ChangePet.male.setSelected(true);	
			}	
			else{
				ChangePet.female.setSelected(true);
			}
			
		ChangePet.TBirth.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 4));   //出生日期
		ChangePet.TFace.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 5));    //外貌
		ChangePet.THost.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 6));    //主人
		ChangePet.TDate.setText((String)PetRegister.BTCK.getValueAt(PetRegister.BTCK.getSelectedRow(), 7));    //收录日期
		
	}
	
	public boolean setDao(boolean check){
		
		try {
			
			SystemShare.SQL="update  PetInfo set petname=?,petcategory=?,petsex=?,petbirthday=?,petface=?,petowener=?,logindate=? where petcode="+ChangePet.TNum.getText();
			SystemShare.getConnection();			
			this.pst=SystemShare.pst;
			
			if(ChangePet.TName.getText().trim().equals("")){               //宠物名称为空的判断与处理
				
				JOptionPane.showMessageDialog(null,"宠物姓名不允许为空！","修改宠物",JOptionPane.ERROR_MESSAGE);
				ChangePet.TName.requestFocus();
				return false;
			}
			
			if (ChangePet.male.isSelected()){
				pst.setString(3,"雄性");
			}
			if(ChangePet.female.isSelected()){
				pst.setString(3,"雌性");
			}
			
			if(ChangePet.TBirth.getText().trim().equals("")){               //宠物出生日期为空的判断与处理
				
				JOptionPane.showMessageDialog(null,"出生日期不允许为空！","修改宠物",JOptionPane.ERROR_MESSAGE);
				ChangePet.TBirth.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(ChangePet.TBirth.getText()); 
			
			if (!mbirth.matches()){ 
				
				JOptionPane.showMessageDialog(null,"出生日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangePet.TBirth.setText("");
				ChangePet.TBirth.requestFocus();
                return false;
			}
			
			
			if(ChangePet.THost.getText().trim().equals("")){                //宠物主人为空的判断与处理
				
				JOptionPane.showMessageDialog(null,"宠物主人不允许为空！","修改宠物",JOptionPane.ERROR_MESSAGE);
				ChangePet.THost.requestFocus();
				return false;
			}
			
			if(ChangePet.TDate.getText().trim().equals("")){                 //更新日期为空的判断与处理
				
				JOptionPane.showMessageDialog(null,"登记日期不允许为空！","修改宠物",JOptionPane.ERROR_MESSAGE);
				ChangePet.TDate.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) "); 
			Matcher mdate=dates.matcher(ChangePet.TDate.getText()); 
			
			if (!mdate.matches()){ 
				
				JOptionPane.showMessageDialog(null,"登记日期格式不符,重新输入!", "错误对话框",JOptionPane.ERROR_MESSAGE);
				ChangePet.TDate.setText("");
				ChangePet.TDate.requestFocus();
				return false;
			}
			
			pst.setString(1,ChangePet.TName.getText().trim());              //更新宠物名称
			pst.setString(2,(String)ChangePet.CType.getSelectedItem());     //更新宠物类型
			pst.setString(4,ChangePet.TBirth.getText().trim());             //更新宠物出生日期
			pst.setString(5,ChangePet.TFace.getText().trim());              //更新宠物外观
			pst.setString(6,ChangePet.THost.getText().trim());              //更新宠物主人                   
			pst.setString(7,ChangePet.TDate.getText().trim());               //更新登记日期
			
			pst.executeUpdate();                                              //刷新数据库
			
			SystemShare.changesuccess();
			frame.dispose();
			new PetRegister();
			
			this.check=check;
			
		} catch (SQLException e) {//处理异常
			SystemShare.changefail();
		}
		SystemShare.close();
		return false;
		
	}
}