Question

jsp连接Oracle数据库错误，急！

代码如下：
<%@ page contentType="text/htm;charset=gb2312"%>

<%@ page import="java.sql.*"%>

<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:bbs";
String user="scott";
String password="tiger";
Connection conn= DriverManager.getConnection(url,user,password);
Statement
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>

报错：
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /conn.jsp at line 5

2:
3: <%@ page import="java.sql.*"%>
4:
5: <%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
6: String url="jdbc:oracle:thin:@localhost:1521:bbs";
7: String user="scott";
8: String password="tiger";

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
一楼不对
oot cause

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
这是怎么回事啊
三楼localhost就是本地ip

Answer 1

缺少Oracle数据库连接jar包,把Oracle中的class12.jar拷贝到项目的lib目录下

Answer 2

<%@page import="java.util.*,java.sql.*,"%>

String url="jdbc:oracle:thin:@127.0.0.1:1521:bbs";

Answer 3

String url="jdbc:oracle:thin:@你的IP:oracle实际端口:bbs";

Answer 4

使用ORM框架连接！