web项目中连接oracle数据库的步骤

web项目中连接oracle数据库的步骤

首先将oracle安装包（F:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib）下的ojdbc6.jar（版本不同，名称亦不同）文件拷贝到当前web项目中。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;

public class NewsDao {

 /**
  * 连接数据库，查看新闻信息
  * @param args
  */
 public void getNews(){
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  try {
   //(1)Class.forName()加载驱动
   Class.forName("oracle.jdbc.driver.OracleDriver");
   //(2)DriverManager.getConnection(URL,user,password)获得数据库连接(Connection)
   conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","scott");//orcl数据库名
   //(3)获得Statement对象，执行SQL语句
   String sql = "select * from news";
   stmt = conn.createStatement();
   rs = stmt.executeQuery(sql);
   //(4)处理执行结果(ResultSet)
   while(rs.next()){
    int id = rs.getInt("news_id");//news_id为数据库中的字段名
    String title = rs.getString("news_title");
    String content = rs.getString("news_content");
    Timestamp date = rs.getTimestamp("news_date");
    System.out.println(id+"\t"+title+"\t\t"+content+"\t"+date);
   } 
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }finally{
   //(5)释放资源
    try {
     rs.close();//倒序释放
     stmt.close();
     conn.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
  }
 }

 
 public static void main(String[] args) {//测试
  NewsDao news = new NewsDao();
  news.getNews();
 } 
}
以上（1）（2）步骤中Class.forName()、DriverManage.getConnection()中的参数最好在配置文件*.properties中配置，采用key-value的对应方式进行配置