1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
package properties;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;
/**
* @version 2015年4月26日 下午1:18:34
* @author sky 读取配置文件 方式二:(推荐)
*/
public class UnDb {
public static Properties prop =
new
Properties();
static {
try
{
prop.load(Thread.currentThread().getContextClassLoader().getResourceAsStream(
"db.properties"
));
//db.properties 文件在 该工程的 bin 目录下
}
catch
(IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConn() throws ClassNotFoundException,
SQLException {
String driverStr = prop.getProperty(
"driver"
);
String urlStr = prop.getProperty(
"url"
);
String userStr = prop.getProperty(
"user"
);
String pwdStr = prop.getProperty(
"pwd"
);
// 加载驱动
Class.forName(driverStr);
return
DriverManager.getConnection(urlStr, userStr, pwdStr);
}
public static void main(String[] args) throws ClassNotFoundException,
SQLException {
Connection con = getConn();
System.out.println(con);
}
}
|
#oracle dbinfo \u7532\u9AA8\u6587\u914D\u7F6E\u6587\u4EF6
#Sun Apr 26 16:22:20 CST 2015
user=scott
url=jdbc\:oracle\:thin\:@localhost\:1521\:LYS
driver=oracle.jdbc.driver.OracleDriver
pwd=m123
|