方式1:通过输入流的方式获取jdbc.properties文件中的内容
try {
Properties pro = new Properties ( ) ;
InputStream stream = new FileInputStream ( new File ( "src/jdbc.properties" ) ) ;
pro. load ( stream) ;
driver = pro. getProperty ( "driver" ) ;
url = pro. getProperty ( "url" ) ;
user = pro. getProperty ( "user" ) ;
pwd = pro. getProperty ( "pwd" ) ;
} catch ( FileNotFoundException e) {
e. printStackTrace ( ) ;
} catch ( IOException e) {
e. printStackTrace ( ) ;
}
方式2:通过类加载器读取jdbc.properties文件中的数据
try {
Properties pro = new Properties ( ) ;
InputStream stream = JDBCUtils. class . getClassLoader ( ) . getResourceAsStream ( "jdbc.properties" ) ;
pro. load ( stream) ;
driver = pro. getProperty ( "driver" ) ;
url = pro. getProperty ( "url" ) ;
user = pro. getProperty ( "user" ) ;
pwd = pro. getProperty ( "pwd" ) ;
} catch ( Exception ex) {
ex. printStackTrace ( ) ;
}
方式3:通过ResourceBundle.getBundle("")静态方法获取
try {
ResourceBundle rb = ResourceBundle. getBundle ( "jdbc" ) ;
driver = rb. getString ( "driver" ) ;
url = rb. getString ( "url" ) ;
user = rb. getString ( "user" ) ;
pwd = rb. getString ( "pwd" ) ;
} catch ( Exception ex) {
ex. printStackTrace ( ) ;
}
几种xxx.properties文件的配置方法
1.MySQL数据源文件配置
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/数据库名?characterEncoding=utf-8
user=用户名
pwd=密码
2.Oracle数据源文件配置
driver = oracle.jdbc.driver.OracleDriver
url = jdbc\:oracle\:thin\:@localhost\:1521\:数据库名
user= 用户名
pwd = 密码
3.SQL Server数据源文件配置
SqlServer_Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
SqlServer_Url=jdbc:sqlserver://localhost:1433;databaseName=数据库名称
SqlServer_User=用户名
SqlServer_Pwd=密码