Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/cb?user=root & password='refar'");
sql = con.createStatement();
rs = sql.executeQuery("select * from student where username = '"+username+"' and password ='"+password+"'");肯定就是连接有问题
结果是:
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:822)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:755)
org.apache.jsp.success_jsp._jspService(success_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:258)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:205)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(DriverManager.java:532)
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.apache.jsp.success_jsp._jspService(success_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:258)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:205)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/cb?user=root & password='refar'");
sql = con.createStatement();
rs = sql.executeQuery("select * from student where username = '"+username+"' and password ='"+password+"'");肯定就是连接有问题
结果是:
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:822)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:755)
org.apache.jsp.success_jsp._jspService(success_jsp.java:91)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:258)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:205)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(DriverManager.java:532)
java.sql.DriverManager.getConnection(DriverManager.java:193)
org.apache.jsp.success_jsp._jspService(success_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:268)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:258)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:205)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
解决方案 »
- struts1.2标签绑定Date数据类型提交给ActionForm报错
- Tomcat 虚拟路径问题 求大虾指点!
- 一个<jsp:param name="user" value="<%=name%>"/>参数传递的菜鸟问题
- 急求java 问题???
- jsp 处女作
- 关于STRUTS的初级问题
- 请问在jsp中怎么调用oracle的存储过程?
- 如何通过JSP调用JavaBean
- 请问如何在windows2000 professional 下搭建JSP环境
- (我每粉)编写JAVABEAN,在JSP中调用JAVABEAN的方法时,根据JAVABEAN的内部计算,有时要返回int,有时要返回String,如何解决
- 请教JSP如何读取和写入sqlserver2000的text类型字段!急
- help ji
当然你的问题不是这里,是驱动问题.
你把newInstance()去掉试试.
估计是这里的问题,建议用com.mysql.jdbc.Driver连接还有一个可能是你没有在lib目录下放置驱动包。
com.mysql.jdbc.Driver用于mysql5.0
以前遇到过类型的问题,还有你的驱动是否放在了lib文件夹下面