连接Oracle数据库有关问题
日期：2014-05-17 浏览次数：20752 次
连接Oracle数据库问题
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
<html>
<title>数据库连接</title>
<body>
<center>
<%
Connection con=null;
Statement Stmt=null;
System.out.println("cdgf");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@19.133.100.3:1521:ccjsj";
String user="ces#jsj";
String password="ces#jsj";
con=DriverManager.getConnection(url,user,password);
con.setAutoCommit(false);
Stmt = con.createStatement(); /*创建JDBC声明*/
//ResultSet rst=Stmt.executeQuery("select * from users t");
// rst.close();
Stmt.close();
con.close();
%>
</center>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``
报了javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.for_.list_jsp._jspService(list_jsp.java:82)
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(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
错误1 请问是哪里错了
------解决方案--------------------
oracle的jdbc包class12.jar有没有放入应用啊
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"%>
<html>
<title>数据库连接</title>
<body>
<center>
<%
Connection con=null;
Statement Stmt=null;
System.out.println("cdgf");
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@19.133.100.3:1521:ccjsj";
String user="ces#jsj";
String password="ces#jsj";
con=DriverManager.getConnection(url,user,password);
con.setAutoCommit(false);
Stmt = con.createStatement(); /*创建JDBC声明*/
//ResultSet rst=Stmt.executeQuery("select * from users t");
// rst.close();
Stmt.close();
con.close();
%>
</center>
</body>
</html>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``
报了javax.servlet.ServletException: oracle.jdbc.driver.OracleDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.for_.list_jsp._jspService(list_jsp.java:82)
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(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
错误1 请问是哪里错了
------解决方案--------------------
oracle的jdbc包class12.jar有没有放入应用啊
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
