changebacteriaget.java

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

package yd.pethospital.bacteriaregister.jdbc;

import java.sql.*;
import javax.swing.*;
import yd.pethospital.share.SystemShare;
import yd.pethospital.bacteriaregister.view.*;

public class ChangeBacteriaGet {
	
	static PreparedStatement pst;                       //声明PreparedStatement对象 
	boolean check = false;
	public JFrame frame;                               //用于错误时返回原窗体
	public static String type;
	
	public ChangeBacteriaGet(JFrame frame){
		
		this.frame=frame;
		if(setDao(check)){
			
			frame.dispose();
		}
	}
	
	public static void GetText(){
		
		ChangeBacteria.TNum.setText((String)BacteriaRegister.BTCK.getValueAt(BacteriaRegister.BTCK.getSelectedRow(), 0));         //获得所选表格内容 疫苗编号
		ChangeBacteria.TName.setText((String)BacteriaRegister.BTCK.getValueAt(BacteriaRegister.BTCK.getSelectedRow(), 1));        //疫苗姓名
		ChangeBacteria.CType.select((String)BacteriaRegister.BTCK.getValueAt(BacteriaRegister.BTCK.getSelectedRow(), 2));         //疫苗类型
		ChangeBacteria.TAttention.setText((String)BacteriaRegister.BTCK.getValueAt(BacteriaRegister.BTCK.getSelectedRow(), 3));   //注意事项
	}
	
	public boolean setDao(boolean check){
		
		try {
			SystemShare.SQL="update  BacterinInfo set bacterinname=?,bacterintype=?,bewarethings=? where bacterincode="+ChangeBacteria.TNum.getText();
			SystemShare.getConnection();
			ChangeBacteriaGet.pst=SystemShare.pst;
			
			if(ChangeBacteria.TName.getText().trim().equals("")){                                  //疫苗名称为空判断
				
				JOptionPane.showMessageDialog(null,"疫苗姓名不允许为空！","修改疫苗",JOptionPane.ERROR_MESSAGE);
				ChangeBacteria.TName.requestFocus();
				return false;
			}
			
			if(ChangeBacteria.CType.getSelectedItem().equals("多种动物用灭活疫苗")){                //类型选择：多种动物用灭活疫苗
				type="11";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("马牛羊用灭活疫苗")){            //类型选择：马牛羊用灭活疫苗
				type="12";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("猪用活疫苗")){                  //类型选择：猪用活疫苗
				type="13";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("禽用活疫苗")){                  //类型选择：禽用活疫苗
				type="14";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("其他用活疫苗")){                  //类型选择：其他用活疫苗
				type="15";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("治疗用抗血清")){               //类型选择：治疗用抗血清
				type="31";	
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("诊断制剂")){                  //类型选择：诊断制剂
				type="41";
			}
			else if(ChangeBacteria.CType.getSelectedItem().equals("微生态制剂")){                //类型选择：微生态制剂
				type="51";
			}
			
			pst.setString(1,ChangeBacteria.TName.getText().trim());                                //修改疫苗名称
			pst.setString(2, type);                                                                //修改类型
			pst.setString(3,ChangeBacteria.TAttention.getText().trim());                            //修改注意事项
			
			pst.executeUpdate();                          //更新数据库
			
			SystemShare.changesuccess();
			frame.dispose();
			new BacteriaRegister();
			
			this.check=check;
			
		} catch (SQLException e) {                         //处理异常
			SystemShare.changefail();
		}
		SystemShare.close();
		return false;
		
	}
}