Expand|Select|Wrap|Line Numbers
- <%@page import="java.sql.*"%>
- <form action="index.jsp?pg=13" method="post">
- <table>
- <tr><td>class:</td><td><select name="cl">
- <option value="">class</option>
- <%
- String connectionURL="jdbc:mysql://localhost:3306/intranet?";
- Connection cn=null;
- Statement st=null;
- ResultSet rs=null;
- cn = DriverManager.getConnection(connectionURL, "root","");
- st = cn.createStatement();
- rs = st.executeQuery("SELECT * FROM class");
- while(rs.next())
- {
- out.print("<option value='"+rs.getString("class")+"'>"+rs.getString("class")+"</option>");
- }
- %>
- </select></td></tr>
- <tr><td>sub1:</td><td><input type="text" name ="sub1"></td></tr>
- <tr><td>sub2:</td><td><input type="text" name ="sub2"></td></tr>
- <tr><td>sub3:</td><td><input type="text" name ="sub3"></td></tr>
- <tr><td>sub4:</td><td><input type="text" name ="sub4"></td></tr>
- <tr><td>sub5:</td><td><input type="text" name ="sub5"></td></tr>
- <tr><td>sub6:</td><td><input type="text" name ="sub6"></td></tr>
- <tr><td><input type="submit" value="save"/></td></tr></table>
- </form>
when running this i got an error message
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: /subjent.jsp:11
8: Connection cn=null;
9: Statement st=null;
10: ResultSet rs=null;
11: cn = DriverManager.getConnection(connectionURL, "root","");
12: st = cn.createStatement();
13: rs = st.executeQuery("SELECT * FROM class");
14: while(rs.next())
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
root cause
javax.servlet.ServletException: No suitable driver found for jdbc:mysql://localhost:3306/intranet?
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:774)
org.apache.jsp.subjent_jsp._jspService(subjent_jsp .java:77)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
root cause
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/intranet?
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.subjent_jsp._jspService(subjent_jsp .java:53)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet .java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.27