properties

 

区别：一般来说，ResourceBundle类通常是用于针对不同的语言来使用的属性文件。而如果你的应用程序中的属性文件只是一些配置，并不是针对多国语言的目的。那么使用Properties类就可以了。

1.    连接数据库所需参数(config.properties)

conn_type=
conn_url=jdbc:oracle:thin:@192.168.1.62:1521:ora9
conn_driver=oracle.jdbc.driver.OracleDriver
conn_user=test
conn_pwd=test

2.    用Properties的load()方法装载这些参数(Config.java)

package com.buy.bean.comm.database;
import java.util.Properties;

public class Config {
private static Properties prop=new Properties();
static{
    try{
   prop.load(Config.class.getResourceAsStream("config.properties"));
    }
    catch(Exception e){
     System.out.println("文件config.properties没有找到!");
     System.out.println(e.toString());
    }
  
}
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.    用这个类测试一下！！(DBConnection.java)

package com.buy.bean.comm.database;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {

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("没有连接上数据库");
    }else{
     System.out.println("连上数据库啦");
    }
    return conn;
}

public static void main(String []args){
    Connection conn=getConnection();
  
    System.out.println("数据库连接测试");
}
}

=========================下面是ResourceBundle用法：

public class DBUtils {
private static final String OPTION_FILE_NAME = "ajax_db";   //classpath下的ajax_db.properties配制文件

private static String drivers;

private static String url;

private static String user;

private static String password;
static {   //用static块初始化数据库连接
   ResourceBundle res = ResourceBundle.getBundle(OPTION_FILE_NAME);
   drivers = res.getString("DRIVERS").trim();
   url = res.getString("URL").trim();
   user = res.getString("USER").trim();
   password = res.getString("PASSWORD").trim();
}

public static Connection getConnection() throws SQLException {
   Connection conn = null;
   try {
    Class.forName(drivers).newInstance();
    conn = DriverManager.getConnection(url, user, password);
   } catch (Exception e) {
    e.printStackTrace();
   }
   if (conn == null) {
    throw new SQLException("ajax.DBUtils: Cannot get connection.");
   }
   return conn;
}

}