读取配置文件的封装Dao

1.配置文件

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

2.DBUtil

package com.cdsxt.utils;

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 mysql;
	private static String url;
	private static String username;
	private static String password;
	static{
		try{
			InputStream is=DBUtil.class.getResourceAsStream("/db.properties");
			Properties ps=new Properties();
			ps.load(is);
			mysql=ps.getProperty("mysql");
			url=ps.getProperty("url");
			username=ps.getProperty("username");
			password=ps.getProperty("password");
			//加载驱动
			Class.forName(mysql);
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	//获取数据库连接
	public static Connection getConn(){
		Connection conn=null;
		try{
			conn=DriverManager.getConnection(url,username,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("关闭资源异常");
				}
			}
		}
	}
}