JDBC读取Properties配置文件的Utils工具类

• 通过工具类去读取配置文件，然后避免反复调用数据库连接对象，所以用static关键字，然后通过Properties集合的getProperty方法通过key获得value，最后返回数据库连接对象，获得连接。

• package cn.itcast.jabcutil;
  
  import java.io.IOException;
  import java.io.InputStream;
  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.util.Properties;
  
  public class JDBCUtilsConfig {
  	private static Connection con;
  	private static String driverClass;
  	private static String url;
  	private static String username;
  	private static String password;
  
  	static {
  		try {
  			readConfig();
  			Class.forName(driverClass);
  			con = DriverManager.getConnection(url, username, password);
  		} catch (Exception e) {
  			throw new RuntimeException("数据库连接失败!");
  		}
  
  	}
  
  	private static void readConfig() throws Exception {
  		InputStream in = JDBCUtilsConfig.class.getClassLoader().getResourceAsStream("database.properties");
  		Properties pro = new Properties();
  		pro.load(in);
  		driverClass = pro.getProperty("driverClass");
  		url = pro.getProperty("url");
  		username = pro.getProperty("username");
  		password = pro.getProperty("password");
  	}
  
  	public static Connection getConnection() {
  		return con;
  	}
  
  }