tomcat连接oracle9有关问题
日期：2014-05-18 浏览次数：20708 次
tomcat连接oracle9问题
代码
<%@page contentType= "text/html;charset=gb2312 " language= "java " import= "java.sql.* "%>
<%@page import= "java.io.* "%>
<%@page import= "java.lang.* "%>
<html>
<body>
以下是从Oracle数据库读取的数据： <hr>
<table border=1>
<tr> <td> id </td> <td> 书名 </td> <td> 出版社 </td> <td> 价格 </td> </tr>
<%
Class.forName( "oracle.jdbc.driver.OracleDriver ").newInstance();
String url= "jdbc.oracle:thin:@localhost:1521:oracle ";
String uid= "system ";
String pwd= "system ";
Connection con=DriverManager.getConnection(url,uid,pwd);
out.println(DriverManager.getConnection(url,uid,pwd));
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery( "select * from system.book ");
while(rst.next()){
out.println( " <tr> ");
out.println( " <td> "+rst.getString( "BOOKID ")+ " </td> ");
}
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>
错误：
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.Oracle_jsp._jspService(Oracle_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServl
代码
<%@page contentType= "text/html;charset=gb2312 " language= "java " import= "java.sql.* "%>
<%@page import= "java.io.* "%>
<%@page import= "java.lang.* "%>
<html>
<body>
以下是从Oracle数据库读取的数据： <hr>
<table border=1>
<tr> <td> id </td> <td> 书名 </td> <td> 出版社 </td> <td> 价格 </td> </tr>
<%
Class.forName( "oracle.jdbc.driver.OracleDriver ").newInstance();
String url= "jdbc.oracle:thin:@localhost:1521:oracle ";
String uid= "system ";
String pwd= "system ";
Connection con=DriverManager.getConnection(url,uid,pwd);
out.println(DriverManager.getConnection(url,uid,pwd));
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery( "select * from system.book ");
while(rst.next()){
out.println( " <tr> ");
out.println( " <td> "+rst.getString( "BOOKID ")+ " </td> ");
}
rst.close();
stmt.close();
con.close();
%>
</table>
</body>
</html>
错误：
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.Oracle_jsp._jspService(Oracle_jsp.java:93)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServl
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
