web项目连接oracle数据库配置,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的对应方式进行配置