恳求 ！！！jsp 连接数据库的问题

我的jsp连不到数据库，我不知道怎么配置JDBC 我用ODBC 可以连接到数据库，但是直接不用ODBC就连不上，怎么办啊！<%@ page contentType="text/html;charset=gb2312"%>   
<%@ page import="java.sql.*"%> 
<html>   
<body>   
<%Class.forName("oracle.jdbc.driver.OracleDriver".newInstance();   
String url="jdbcracle:thinerp03:1522:NTP"; 
String user="NTP"; 
String password="passwd"; 
Connection conn= DriverManager.getConnection(url,user,password);   
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);   
String sql="select * from main2";   
ResultSet rs=stmt.executeQuery(sql);   
while(rs.next()) {%>   
您的第一个字段内容为：<%=rs.getString(1)%>   
您的第二个字段内容为：<%=rs.getString(2)%>   
<%}%>   
<%out.print("数据库操作成功，恭喜你";%>   
<%rs.close();   
stmt.close();   
conn.close();   
%>   
</body>   
</html
恳求大家帮忙

解决方案 »

  1.   

    jdbcracle:thinerp03:1522:NTP";
    ------------------------------
    jdbc:oracle:thin@erp03:1522:NTP
      

  2.   

    我改过了还是不可以啊
    Class.forName("oracle.jdbc.driver.OracleDriver"）.newInstance();   
    不知道那里错误
      

  3.   

    Class.forName("oracle.jdbc.driver.OracleDriver")就可以了
      

  4.   

    我的AP 是SUN APPLICATION SERVER ，我在本机安装了oracle client ，我在没有安装其他的软件，用odbc可以通过，就是用jdbc 就不能了  Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:830)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:763)
    org.apache.jsp.test1_jsp._jspService(test1_jsp.java:81)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:105)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:336)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:251)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
    java.security.AccessController.doPrivileged(Native Method)
    javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
    org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
    root cause java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1447)
    org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1228)
    org.apache.jasper.servlet.JasperLoader$1.run(JasperLoader.java:151)
    java.security.AccessController.doPrivileged(Native Method)
    org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:149)
    org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:85)
    java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
    java.lang.Class.forName0(Native Method)
    java.lang.Class.forName(Class.java:164)
    org.apache.jsp.test1_jsp._jspService(test1_jsp.java:48)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:105)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:336)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:251)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:860)
    sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    java.lang.reflect.Method.invoke(Method.java:585)
    org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:249)
    java.security.AccessController.doPrivileged(Native Method)
    javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
    org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:282)
    org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.java:165)
    note The full stack trace of the root cause is available in the Sun-Java-System/Application-Server logs.
    --------------------------------------------------------------------------------
    CLASSPATH=.;C:\Sun\Shared\lib\saaj-impl.jar;C:\Sun\Shared\lib\saaj-api.jar;C:\Su
    n\Shared\lib\jhall.jar;C:\Sun\Shared\lib\activation.jar;C:\Sun\Shared\lib\ldapjd
    k.jar;C:\OraHome1\jdbc\lib\classes12.jar;C:\Sun\Shared\lib\mail.jar
      

  5.   

    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    很明显是没找到驱动
    把classes12.jar拿到工程下看看