jdbc连接mysql数据库之1.1--properties配置文件连接

package caozuo;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class conn02 {
	static Properties prop=null;
	static FileReader fr;
	public static void main(String[] args) throws Exception {
		System.out.println(getConn());
		getConn();
	}
//	static String driverClassName=null;
	static {
		try {
			fr = new FileReader("dbconfig.properties"); //在项目下创建dbconfig.properties文件存储四大参数信息
		} catch (FileNotFoundException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		} 
		prop=new Properties();
		try {
			prop.load(fr);
		} catch (IOException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		try {
			Class.forName(prop.getProperty("driverClassName"));
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("注册驱动成功");
	}
	public static Connection getConn() throws Exception{
		Connection conn=DriverManager.getConnection(prop.getProperty("url"),prop.getProperty("username"),prop.getProperty("password"));
		System.out.println("获取连接成功");
		return conn;
	}
	public static void setColse(Connection conn,Statement stat,ResultSet rs){ //关闭连接方法
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(stat!=null){
			try {
				stat.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(rs!=null){
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}