有段代码请高手进来看看。

Question

try
   {
        stmt = conn.createStatement();

sql="SELECT id,title,author,content FROM note";
            rs=stmt.executeQuery(sql);
        
    %>
       <table border="1" width="80%">
       <tr>
       <td>id</td>
       <td>title</td>
       <td>author</td>
       <td>content</td>
       </tr>
    <%      
            while(rs.next())
           {
              //i++;
            
              int id=rs.getInt("id");
              String title=rs.getString("title");
              String author=rs.getString("author");
              String content=rs.getString("content");
    %>
              <tr>
              <td><%=id %></td>
              <td><%=title %></td>
              <td><%=author %></td>
              <td><%=content %></td>
              </tr>
      <%
           }
           //if(i==0)
           //{
      %>
           
       
           </table>
           </center>            
    <% 
    }
    catch(Exception e)
    {
    %>
       <h2>dgsdg</h2>
     <%
    }
运行时出现异常，打印出dgsdg，请高手帮忙指点一下。

Answer 1

rs在哪儿定义的?是不是rs的空指针异常呀?

Answer 2

<%   
        } 
        catch(Exception   e) 
        { 
        %> 
              <h2> <%=e.printStack()%> </h2> 
          <% 
        } 
把详细错误打出来看看吧

Answer 3

JdbcOdbc.standardError(short, long, long, long) line: 7115
这个错误什么意思啊。

Answer 4

晕 你那第一个是Short类型,为什么用getInt("id")去获得,应该用getShort("id")