dbconnection.java

掌握 JDBC 驱动程序的加载方法和JDBC-ODBC桥URL的形式； 掌握使用JDBC连接数据库的步骤； 掌握使用JDBC发送SQL语句的基本步骤； 掌握使用JDBC处理SQL查询结果集

package cn.edu.csu.oo.gui.project.dao.common;

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


public class DbConnection {
  public static void main(String[] args) {
    Connection con = getConnection();
    if(con != null){
      System.out.println("数据库连接成功");
    }else{
      System.out.println("数据库连接失败");
    }
  }
  public static Connection getConnection(){
    Connection con = null;
    Properties pro = getProperties();
    try {
      // 定义数据库驱动程序主入口程序名
      String driver = pro.getProperty("oracle.driver");
      //加载驱动程序
      Class.forName(driver);
      //定义数据库URL
      String url = pro.getProperty("oracle.url");
      String user = pro.getProperty("oracle.user");
      String password = pro.getProperty("oracle.password");
      con = DriverManager.getConnection(url,user,password);

    } catch (Exception e) {
      System.out.println(e.getMessage());
    }   
    return con;
  }
  public static Properties getProperties(){
    Properties pro = new Properties();
    try{
      pro.load(new FileInputStream(new File("db.properties")));
    }catch(Exception e){
      System.out.println(e.getMessage());
    }
    return pro;
  }
}