用配置文件连接数据库

 

1.定义一个配置文件：

conn_url=jdbc:mysql://localhost:3306/buy?useUnicode=true&characterEncoding=UTF-8
conn_user=root
conn_pwd=root
conn_driver=com.mysql.jdbc.Driver

2.取出配置文件里面的值：

  

	private static Properties prop = new Properties();
	static {
		try {
			prop.load(Config.class
					.getResourceAsStream("config.properties"));
			
		} catch (IOException e) {
			System.out.println("File:config.properties no find,PLS check out!");
			e.printStackTrace();
		}
	}	
	public static String CONNECTION_TYPE = prop.getProperty("conn_type");
	public static String CONNECTION_URL = prop.getProperty("conn_url");
	public static String CONNECTION_USER = prop.getProperty("conn_user");
	public static String CONNECTION_PWD = prop.getProperty("conn_pwd");
	public static String CONNECTION_DRIVER = prop.getProperty("conn_driver");
		
}

3.链接数据库：

 

	public static Connection getConnection() {
		Connection conn = null;
			try {
				
				Class.forName(Config.CONNECTION_DRIVER).newInstance();
				
				conn = DriverManager.getConnection(Config.CONNECTION_URL,
						Config.CONNECTION_USER, Config.CONNECTION_PWD);
			} catch (Exception e) {
				e.printStackTrace();
			}
		if (conn == null) {
			System.out.println("no get connection!throws Exception");
		}
		return conn;
	}
}