求JSP连接oracle7。3例子急用！！！！！！！！！在线等~~~~~~~~~！

Question

求JSP连接oracle7。3例子急用！！！！！！！！！在线等~~~~~~~~~！

Answer 1

public static Connection getConn()
{
          if (logger.isDebugEnabled()) {
logger.debug("getConnection() - start");
}
Connection conn=null;
try{                      Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
                      conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.1:1521:temp","user","password"); if (logger.isDebugEnabled()) {
logger.debug("getConnection() - end");
}
} catch (Exception e)
{
logger.error("getConnection()", e); e.printStackTrace();
System.out.println("Exception ***************"); if (logger.isDebugEnabled()) {
logger.debug("getConnection() - end");
}
return null;
}
return conn;
}

Answer 2

楼上的例子是连接ORACLE9I的例子，可是在ORACLE7。3中没有JDBC这个文件夹？？

Answer 3

你是建的什么工程? 如果是lomboz工程直接把oracle的驱动引入进去就行了

Answer 4

在ORACLE7。3里我没有找到CLASSES12。JAR文件，我建的是WEB工程，服务器用的是TOMCAT5。0

Answer 5

连接oracle7.3报这个错
javax.servlet.ServletException: no ocijdbc9 in java.library.path
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.ta_jsp._jspService(ta_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682)
java.lang.Runtime.loadLibrary0(Runtime.java:822)
java.lang.System.loadLibrary(System.java:992)
oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:262)
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
com.yourcompany.struts.Comjdcb.getcon(Comjdcb.java:16)
com.yourcompany.struts.Text.outExcel(Text.java:89)
org.apache.jsp.ta_jsp._jspService(ta_jsp.java:60)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.

Answer 6

晕死,把这个JAR放到LIB下这是啦.

Answer 7

说的明白一点,oracle7.3下没有CLASSES12.JAR,更没有,JDBC的这个文件夹

Answer 8

要是oracle9就好连了,我现在要连的是oracle7.3和oracle9完全不一
样