Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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()·½·¨¿ÉÒ


Ïà¹ØÎÊ´ð£º

jspÖÐÏÔʾ²Ëµ¥£¨µÝ¹é£©

ÎÊÌâÃèÊö£º

    ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ

Ò»¼¶Ä¿Â¼1
    Ò»¼¶Ä¿Â¼1×ÓÀà1
        ×ÓÀà1
    Ò»¼¶Ä¿Â¼1×ÓÀà2
      ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

jspÒ³ÃæÖÐ×ÖÌå±äÉ«ÎÊÌâ - Java / Web ¿ª·¢

<html><head><title>[@title]</title>
<meta http-equiv=Content-Type content="text/html; charset=gb2312">
<script language='javascript'>
function diyCheck ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

¹ØÓÚAJAXºÍJSPµÄһЩСÎÊÌâ¡« - Java / Web ¿ª·¢

ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
  %>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ