Jsp/eclipse 链接oracle数据库
1,在安装oracle的目录下找到ojdbc。目录一般是product/11.20/dbhome_1/jdbc.复制到工程下webContent/WEB-INF/lib。
2，编写java类：
View Code
package test;
import java.sql.*;
public class Dbconn {
String user = "user";
String password = "123456";
String url ="jdbc:oracle:thin:@localhost:1521:orcl";//orcl表示你的SID
// String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
public Dbconn(){
try {
//注册驱动程序
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//获得数据库连接
conn = DriverManager.getConnection(url,user,password);
//设置为自动提交
conn.setAutoCommit(true);
// 建立Statement对象
stmt =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// System.out.println("hello");
}
//查询语句方法
public ResultSet executeQuery(String sql){
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return rs;
}
//下面测试
public static void main(String[] args){
String sql = "select * from userinfo";
ResultSet rs = new Dbconn().executeQuery(sql);
try {
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("henolks");
}
}
下面随便用一个jsp页面来测试一下：
View Code
<%@page import="test.Dbconn"%>
<%@ page import="java.sql.*,java.util.*" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
Dbconn db = new Dbconn();
String sql = "select * from userinfo";
ResultSet rs = db.executeQuery(sql);
while(rs.next()){
out.println(rs.getString(1));
out.println(rs.getString(2));
}
%>
</body>
</html>
