jdbc中oracle和mysql的应用案例

config.properties:

database.file =db_oracle.properties

 

db_mysql.properties:

driver = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/test
dbUser = root
dbPassword =1234

 

db_oracle.properties:

driver = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@192.168.0.26:1521:tarena
#192.168.0.23, tarena10g
dbUser = openlab
dbPassword =open123

 

java代码：

package day1;

import java.io.File;
import java.io.FileInputStream;
import java.sql.*;
import java.util.Properties;

public class ConnectionUtils {
 
  private static String driver = null;
  private static String url = null;
  private static String dbUser = null;
  private static String dbPassword = null;
 
  public static void getParam(){
    String filename = "src/db_oracle.properties";
    File file = new File(filename);
    try {
      FileInputStream fis = new FileInputStream(file);

      // Map接口的子类Properties,键值对对象
      Properties props = new Properties();
      // fis中的键值对信息装载到props对象中
      props.load(fis);

      // 从键值对对象props中通过key找到value
      driver = props.getProperty("driver");
      url = props.getProperty("url");
      dbUser = props.getProperty("dbUser");
      dbPassword = props.getProperty("dbPassword");

    } catch (Exception e) {
      e.printStackTrace();
    }
  }
 
  public static Connection getConnection(){
    Connection conn = null;
    getParam();
    try{
      Class.forName(driver);
      conn = DriverManager.getConnection(
          url,dbUser,dbPassword);
    }catch(Exception e){
      e.printStackTrace();
    }
   
    return conn;
  }
  public static void close(Connection conn){
    try{
      if (conn != null)
        conn.close();
    }catch(Exception e){
      e.printStackTrace();
    }
  }
  public static void close(Statement stmt){
    try{
      if (stmt != null)
        stmt.close();
    }catch(Exception e){
      e.printStackTrace();
    }
  }
  public static void close(ResultSet rs){ 
    try{
      if (rs != null){
        rs.close();
      }
    }catch(Exception e){
      e.printStackTrace();
    }
  }
}