JSPÊý¾ÝÔ´Á¬½ÓOracle³ö´í
ÔËÐл·¾³£ºMyEclipse8.5+Oracle 11g
ÔÚWEB-INF/libÎļþ¼ÐϵÄJDBCÇý¶¯£º
ojdbc5.jar;
ojdbc5_g.jar;
ojdbc6.jar;
ojdbc6_g.jar;
ÔÚMETA-INFÎļþ¼ÐϵÄÊý¾ÝÔ´ÅäÖÃÎļþcontext.xml:
<Context reloadable="true">
<Resource name="jdbc/bookstore" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:orcl"
username="scott" password="tiger" maxActive="200" maxIdle="30"
maxWait="-1"/>
</Context>
JSPÎļþµÄÁ¬½ÓÓï¾ä£º
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/bookstore");
Connection conn=ds.getConnection();
ÔÚÕâÒ»¾ä±¨´í£º
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp
at Connection conn=ds.getConnection();
javax.servlet.ServletException: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
ps£ºÊ¹ÓÃClass.forName()·½·¨¿ÉÒ
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......