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的对应方式进行配置