db.properteis源文件
jdbc.url=jdbc:mysql://39.106.98.91:3306/dianxiaoer?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
jdbc.username=root
jdbc.password=123456
jdbc.initialSize=10
jdbc.maxActive=999999
jdbc.minPoolSize=10
jdbc.maxIdleTime=30000
jdbc.idleConnectionTestPeriod=100
/*****************************************************************************************************************************/
package com.dianxiaoer.properties.read;
import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import org.apache.ibatis.io.Resources;
/**
* 读取properties源文件
* @author zuiweng clq_zuiweng@163.com
* 2019年7月24日
*/
public class ReadProperties {
public ReadProperties() {
}
private static InputStream in;
private static Properties properties;
static String resource_path = "";
/**
*
* @param respurce_path 文件路径 eg:xx/xx.properties
* @param name 文件中的键 eg url=xxx,则name=url
* @return name键对应的值
*/
public static String getHttpUrl(String name, String respurce_path) {
resource_path = respurce_path;
properties = new Properties();
try {
in = Resources.getResourceAsStream(resource_path);
properties.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return properties.getProperty(name);
}
}
/*****************************************************************************************************************************/
package com.dianxiaoer.jdbc.util;
import java.sql.DriverManager;
import java.sql.ResultSet;
import com.dianxiaoer.properties.read.ReadProperties;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
public class JDBCConfig {
static Connection conn = null;
public static Connection openJDBC() throws Exception{
//Class.forName("com.mysql.jdbc.Driver");
String url = ReadProperties.getHttpUrl("jdbc.url", "db.properties");
String username = ReadProperties.getHttpUrl("jdbc.username", "db.properties");
String password = ReadProperties.getHttpUrl("jdbc.password", "db.properties");
conn = (Connection) DriverManager.getConnection(url, username, password);
return conn;
}
public static void closeJDBC(ResultSet resultSet,Connection conn,Statement stmt)throws Exception {
if(resultSet != null) {
resultSet.close();
}
if(stmt != null) {
stmt.close();
}
if(conn != null) {
conn.close();
}
}
public static void main(String[] args) {
try {
System.out.println(openJDBC());
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}