连接数据库的封装类

连接数据库的封装类

1.db.properties文件:

driver="com.mysql.jdbc.Driver"
url=jdbc:mysql://localhost:3306/mysql-me
user=root
password=123456

2.封装方法

package com.cdsxt.utils;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;

public class DBUtil {
	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	static{
		
		try {
			//读取配置文件db.properties的信息
			InputStream is=DBUtil.class.getResourceAsStream("/db.properties");
			Properties ps=new Properties();
			ps.load(is);
			driver=ps.getProperty("driver");
			url=ps.getProperty("url");
			user=ps.getProperty("user");
			password=ps.getProperty("password");
			Class.forName(driver);
		} catch (Exception e) {
			e.printStackTrace();
		}	
	}
	//获取数据库连接
	public static Connection getConn(){
		Connection conn=null;
		try{
			conn=DriverManager.getConnection(url,user,password);
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("获取数据库连接异常");
		}
		return conn;
	}
	//关闭资源
	public static void close(Object...objs){
		if(objs!=null&&objs.length>0){
			for(int i=0;i<objs.length;i++){
				try{
					if(objs[i] instanceof Connection){
						((Connection) objs[i]).close();
					}else if(objs[i] instanceof PreparedStatement){
						((PreparedStatement) objs[i]).close();
					}else if(objs[i] instanceof ResultSet){
						((ResultSet)objs[i]).close();
					}
				}catch(Exception e){
					e.printStackTrace();
					System.out.println("关闭资源异常");
				}
			}
		}
	}
}