请问如何在jsp直接访问oracle数据库

在这里搜索一下oracle 应该有不少
如果打开不了页面可以点击管理

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

就是直接写出连接语句，暂时不用javabean
一、jsp连接Oracle8/8i/9i数据库（用thin模式）
  testoracle.jsp如下：
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//orcl为你的数据库的SID
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
精华区
关于连接数据库
http://expert.csdn.net/Expert/topic/670/670716.xml?temp=.6459314
用BEAN的例子
package bean;
import java.sql.*;public class Jdbc195{
  //Áª½ÓÊý¾ÝÔ´rstc
  //String Dbdriver="oracle.jdbc.driver.OracleDriver";
  String constr="jdbc:oracle:thin:@10.1.3.195:1521:orcl2.ysgz.com";
  Connection cn=null;
  ResultSet rs=null;
  Statement stmt;  //·µ»Ø¼ÇÂ¼½á¹û¼¯µÄ²éÑ¯²Ù×÷
  public Jdbc195() throws Exception
  {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
cn=DriverManager.getConnection(constr,"CCTVSMS","CCTVSMS");

  }
  public ResultSet Query(String sql)throws Exception{    stmt=cn.createStatement();
    rs=stmt.executeQuery(sql);
    return rs;
  }
  //ÎÞ·µ»ØµÄ¸üÐÂ²Ù×÷
  public void Update(String sql)throws Exception{    stmt=cn.createStatement();
    stmt.executeUpdate(sql);
  }

  //¹Ø±ÕÊý¾Ý¿âÁª½Ó¶ÔÏó
  public void CloseStmt()throws Exception{
    stmt.close();
  }

  public void CloseCn()throws Exception{
    cn.close();
  }
}
testoracle.jsp 显示出错
500 Servlet Exception
java.lang.AbstractMethodError
at _jsp._jack._abc__jsp._jspService(/jack/abc.jsp:11)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:410)
at com.caucho.server.http.Invocation.service(Invocation.java:319)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:121)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:333)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:266)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)
500 Servlet Exception
java.lang.AbstractMethodError
at _jsp._jack._testoracle__jsp._jspService(/jack/testoracle.jsp:11)
at com.caucho.jsp.JavaPage.service(JavaPage.java:87)
at com.caucho.jsp.JavaPage.subservice(JavaPage.java:81)
at com.caucho.jsp.Page.service(Page.java:410)
at com.caucho.server.http.Invocation.service(Invocation.java:319)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:121)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:333)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:266)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:484)--------------------------------------------------------------------------------
Resin 1.2.8 (built Wed Jul 11 11:14:00 PDT 2001)
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.Statement"%><html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="d3ecc5">
<p> </p>
<%-- 连接数据库 --%>
<%
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@192.168.67.8:1521:orcl","username","userpass");
Statement stat1=conn.createStatement();
ResultSet rs = stat1.executeQuery("select * from usertable");
while(rs.next())
{
out.println(rs.getString(1));
}
out.println("数据库连接成功");
rs.close();
stat1.close();
conn.close();
}
catch(Exception e) {
　out.println("数据库连接失败");
  out.println(e.toString());
  }
%>

</div>
</body>
</html>
谢谢各位，
myzhouyj(myzhouyj)提供的方法ＯＫ了，
cai_yb(有来有去) 提供的方法出现了 java.lang.AbstractMethodError.