systemshare.java

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

package yd.pethospital.share;

import java.sql.*;                                   //导入包
import javax.swing.*;

public class SystemShare {

	public static Connection con;                   //静态方法声明一个Connection对象
	public static ResultSet rs;                     //静态方法声明一个结果集对象
	public static PreparedStatement pst;            //静态方法PreparedStatement对象
	public static int Mess;
	public static String SQL;                       //声明SQL用于存储数据库语句  
	
	public static Statement getConnection(){
		
		try {
			
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");               //加载驱动 建立JDBC-ODBC桥接器
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=petmanager", "sa", "");  //使用DriverManager的静态方法创建连接对象
		
			pst=con.prepareStatement(SQL,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);            //通过连接数据库的对象con调用prepareStatement方法
			
		} catch (ClassNotFoundException e) {         //处理异常
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return pst;                                   //返回Statement类型的对象
	}
	
	public static void delsuccess(){
		
		JOptionPane.showMessageDialog(null,"删除记录成功！","删除记录",JOptionPane.INFORMATION_MESSAGE);    //成功
	}
	
	public static void delfail(){
		
		JOptionPane.showMessageDialog(null,"删除记录失败！","删除记录",JOptionPane.ERROR_MESSAGE);
	}
	
	public static void newsuccess(){
		
		JOptionPane.showMessageDialog(null,"新增记录成功！","新增记录",JOptionPane.INFORMATION_MESSAGE);    //成功
	}
	
	public static void newfail(){
		
		JOptionPane.showMessageDialog(null,"新增记录失败！","新增记录",JOptionPane.ERROR_MESSAGE);
	}
	
	public static void changesuccess(){
		
		JOptionPane.showMessageDialog(null,"修改记录成功！","修改记录",JOptionPane.INFORMATION_MESSAGE);    //成功
	}
	
	public static void changefail(){
		
		JOptionPane.showMessageDialog(null,"修改记录失败！","修改记录",JOptionPane.ERROR_MESSAGE);
	}
	
	public static void close(){
		                                                                         //关闭连接
		try {
			if(con!=null)
				con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
	
}