I am new to this field, so I have some silly questions here.
Can I call directly the method in JDBC classes in my jsp file to connect to
my database, or it is necessary to write a connection bean to connect the
DB.
My JSP source code:
<%@ page language="java" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=Big5" %>
<%Class.forName("Driver");%>
<%String url="jdbc:odbc:localhost";%>
<%Connection con=DriverManager.getConnection(url,"1234567890","1111");%>
<%Statement stmt =con.createStatement();%>
<%String test="select * from tbl_eDN";%>
<%ResultSet rs=stmt.executeQuery(test);%>
But the error message on the web page is:
Error: 500
Location: /examples/jsp/jean/DBtest.jsp
Internal Servlet Error:
javax.servlet.ServletException: Unable to load class Driver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:386)
at
jsp.jean._0002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0._jspService(_0
002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0.java:111)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.ja
va:174)
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:156)
at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
)
at java.lang.Thread.run(Thread.java:484)
Root cause:
java.lang.ClassNotFoundException: Unable to load class Driver
at org.apache.jasper.runtime.JspLoader.findClass(JspLoader.java:184)
at org.apache.jasper.runtime.JspLoader.loadClass(JspLoader.java:136)
at java.lang.ClassLoader.loadClass(ClassLoader.java:253)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at
jsp.jean._0002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0._jspService(_0
002fjsp_0002fjean_0002fDBtest_0002ejspDBtest_jsp_0.java:72)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.ja
va:174)
at
org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:156)
at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338
)
at java.lang.Thread.run(Thread.java:484)
Thanks
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets