java读取properties文件,连接数据库
//配置文件:config.properties放在classpath下jdbc_driver=com.mysql.jdbc.Driverjdbc_username=rootjdbc_password=jdbc_url=jdbc\:mysql\://localhost\:3306/student?useUnicode\=true&characterEncoding\=utf-8//读取properties文件的工具类package com.util;import java.io.IOException;import java.util.Properties;public class ProMgr {private static Properties props = new Properties();static {try {props.load(ProMgr.class.getClassLoader().getResourceAsStream("config.properties"));} catch (IOException e) {e.printStackTrace();}}private ProMgr() {}public static String getProperty(String key) {return props.getProperty(key);}}//数据库连接类:package com.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import com.util.ProMgr;public class DBC {// private static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";// private static final String USERNAME="scott";// private static final String PASSWORD ="tiger";// private static final String// URL="jdbc:oracle:thin@localhost:1521:student";// private static final String DBDRIVER = "com.mysql.jdbc.Driver";// private static final String USERNAME = "root";// private static final String PASSWORD = "";// private static final String URL =// "jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf-8";private static final String DBDRIVER = ProMgr.getProperty("jdbc_driver");private static final String USERNAME = ProMgr.getProperty("jdbc_username");private static final String PASSWORD = ProMgr.getProperty("jdbc_password");private static final String URL = ProMgr.getProperty("jdbc_url");private Connection conn;public DBC() {try {Class.forName(DBDRIVER);} catch (ClassNotFoundException e) {e.printStackTrace();}}public Connection conn() {try {conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);} catch (SQLException e) {e.printStackTrace();}return conn;}public void close() {if (conn != null) {try {conn.close();conn = null;} catch (SQLException e) {e.printStackTrace();}}}}//测试类:package com.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import com.util.ProMgr;public class DBC {// private static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";// private static final String USERNAME="scott";// private static final String PASSWORD ="tiger";// private static final String// URL="jdbc:oracle:thin@localhost:1521:student";// private static final String DBDRIVER = "com.mysql.jdbc.Driver";// private static final String USERNAME = "root";// private static final String PASSWORD = "";// private static final String URL =// "jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf-8";private static final String DBDRIVER = ProMgr.getProperty("jdbc_driver");private static final String USERNAME = ProMgr.getProperty("jdbc_username");private static final String PASSWORD = ProMgr.getProperty("jdbc_password");private static final String URL = ProMgr.getProperty("jdbc_url");private Connection conn;public DBC() {try {Class.forName(DBDRIVER);} catch (ClassNotFoundException e) {e.printStackTrace();}}public Connection conn() {try {conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);} catch (SQLException e) {e.printStackTrace();}return conn;}public void close() {if (conn != null) {try {conn.close();conn = null;} catch (SQLException e) {e.printStackTrace();}}}}?