dbconnection.java

好的超市源码供大家下载

package common.jdbc;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

/**
 * 连接数据库
 * @author linfeng
 *
 */
public class DbConnection {
    
  /**
   * con 连接
   */
  private static Connection con;
  public static void main(String[] args) {
    DbConnection db = new DbConnection();
    if(getConnection()==null){
      System.out.println("数据库连接失败");
    }else{
      System.out.println("数据库连接成功");
    }

  }

  /**
   * 获得数据库连接
   * @return con 连接
   */
  public static Connection getConnection() {
    con = null;
    
    try {
      Properties pro = getProperties();
      String driver = pro.getProperty("oracle.driver");
      String url = pro.getProperty("oracle.url");
      String user = pro.getProperty("oracle.user");
      String pwd = pro.getProperty("oracle.password");      
      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;
  }

  /**
   * 读取文件属性
   * @return pro 文件属性
   */
  public static Properties getProperties() {
    Properties pro = new Properties();
    try {
      pro.load(new FileInputStream(new File("file\\db.properties")));
    } catch (Exception e) {
      System.out.println("db.properties:=" + e.getMessage());
    }
    return pro;
  }
  
  /**
   * 关闭数据库连接
   */
  public void closeDbConnection(){
    try{
      con.close();
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
  }
}