1. 爱易网页
  2. Java教程
  3. 关于数据库的简单有关问题，帮小弟我啊

关于数据库的简单有关问题，帮小弟我啊

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

关于数据库的简单问题，大虾帮我啊！
程序：
<html>
<body>
<%@   page   contentType= "test/html;charset=GB2312 "   %>
<%@   page   import= "java.sql.* "%>

<%
  Connection   con;
      Statement   sql;
      ResultSet   rs;
      Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
      con=DriverManager.getConnection( "jdbc:odbc:sun ", "sa ", " ");
      sql=con.createStatement();
      rs=sql.executeQuery( "SELECT   *   FROM   Students ");
      while(rs.next()){
        out.print(rs.getString(1));
        out.print(rs.getString(2));
       
        }
       
        con.close();
       
        %>
        </body>
        </html>

报错：
type   Exception   report

message  

description   The   server   encountered   an   internal   error   ()   that   prevented   it   from   fulfilling   this   request.

exception  

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

13:  
14:         con=DriverManager.getConnection( "jdbc:odbc:sun ", "sa ", " ");
15:         sql=con.createStatement();
16:         rs=sql.executeQuery( "SELECT   *   FROM   Students ");
17:         while(rs.next()){
18:           out.print(rs.getString(1));
19:           out.print(rs.getString(2));


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:   [Microsoft][ODBC   SQL   Server   Driver][SQL   Server]对象名   'Students '   无效。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:855)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:784)
org.apache.jsp.hh_jsp._jspService(hh_jsp.java:88)
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)

相关资料更多>

  1. 新人关于线程同步有关问题
  2. 学习SSH的顺序解决办法
  3. 竞赛题目、求牛人解答、JAVA算法题、有时间限制,该怎么处理
  4. 请帮小弟我解释下关于gc的程序,多谢
  5. JAVA中关于返回值的有关问题，大神们帮助
  6. 求解算法,该怎么处理
  7. org.springframework.beans.factory.BeanCreationNotAllowedException
  8. easyui jsp登录页面ajax请求失败,该怎么处理
  9. 请大家评评小弟我的面试自小弟我介绍啊