1. 爱易网页
  2. Java教程
  3. sql+tomcat的有关问题，十多天解决不了

sql+tomcat的有关问题，十多天解决不了

日期：2014-05-18　 浏览次数：20712 次

sql+tomcat的问题，十多天解决不了，救命啊
源程序
<%@   page   contentType= "text/html;charset=GB2312 "   %>
<%@   page   import= "java.sql.* "   %>
<html>
<body>
<%
  Connection   con;
  Statement   sql;
  ResultSet   rs;
        out.print( "a ");
        con=DriverManager.getConnection( "jdbc:odbc:yuan ", "sa ", " ");
            out.print( "b ");
        sql=con.createStatement();
        rs=sql.executeQuery( "SELECT   *   FROM   login ");
        while(rs.next())
{
        out.print(rs.getString( "name "));
        out.print(rs.getString( "password "));
}
con.close();
%>    
</body>
</html>    
错误
exception  

org.apache.jasper.JasperException:   An   exception   occurred   processing   JSP   page   /tt.jsp   at   line   10

7:     Statement   sql;
8:     ResultSet   rs;
9:           out.print( "a ");
10:           con=DriverManager.getConnection( "jdbc:odbc:yuan ", "sa ", " ");
11:               out.print( "b ");
12:           sql=con.createStatement();
13:           rs=sql.executeQuery( "SELECT   *   FROM   login ");


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:515)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root   cause  

javax.servlet.ServletException:   java.sql.SQLException:   No   suitable   driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.tt_jsp._jspService(tt_jsp.java:82)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root   cause  

java.sql.SQLException:   No   suitable   driver
java.sql.DriverManager.getConnection(Driv

相关资料更多>

  1. 请问一个sql有关问题
  2. 一台电脑上有多个版本的JDK和JRE，怎么让电脑识别使用哪个版本
  3. 关于多对多的关联有关问题，求大神进来看下
  4. TextFiled能不限定输入的字符个数吗？解决方案
  5. 求孙卫琴的<tomcat与java web开发技术详解> 源码解决思路
  6. was服务器获取文件流的有关问题
  7. 关于jsp/servlet连接数据库的有关问题，进来吧，绝对结贴给高分！
  8. native润色的方法在哪
  9. 处理request数组有关问题