dbconnection.java

一个优秀的干洗店管理系统

package dao.common;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DbConnection {

  /**
   * @param args
   */
  public static void main(String[] args) {
	  DBConnectionManager manager = DBConnectionManager.getInstance();
    if (/*getConnection() */manager.getConnection("oracle")!= null) {
      System.out.println("db connect success");
    } else {
      System.out.println("连接失败");
    }
  }

  /*public static Connection getConnection() {
    Connection con = null;
    // 定义jdbc驱动程序主入口程序名;
    String driver = "oracle.jdbc.driver.OracleDriver";
    // 定义jdbc url
    String url = "jdbc:oracle:thin:@192.168.1.161:1521:oracle";
    String user = "system";
    String pwd = "system";
    try {
      // 加载jdbc驱动程序
      Class.forName(driver);
      // 建立连接
      con = DriverManager.getConnection(url, user, pwd);
    } catch (SQLException e) {
      e.printStackTrace();
    } catch (ClassNotFoundException e) {
      e.printStackTrace();
    }

    return con;
  }*/
  
  public static Connection getConnection(){
    Connection con = null;
    try{
      Properties pro = getProperties();
      String driver = pro.getProperty("driver");
      String url = pro.getProperty("url");
      String user = pro.getProperty("user");
      String pwd = pro.getProperty("pwd");
      Class.forName(driver);
      con = DriverManager.getConnection(url,user,pwd);
    }catch(SQLException e){
      System.out.println("数据库连接异常:= " + e.getMessage());
    }catch(ClassNotFoundException e){
      System.out.println("数据库驱动程序加载异常:= " + e.getMessage());
    }
    return con;
  }
  
  public static Properties getProperties(){
    Properties pro = null;
    try{
      pro = new Properties();
      pro.load(new FileInputStream(new File("db.properties")));
    }catch(IOException e){
      
    }
    return pro;
  }

}