jsp页面不能显示我要查询的结果

update2.jsp
<%@page contentType="text/html" pageEncoding="gb2312"%>
<%@ page import="java.sql.*,java.util.*;" errorPage=""%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
 <jsp:useBean id="modify" scope="session" class="com.testbean"/>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
        <title>修改记录</title>
   </head>
   <body background="./image/68c899d43003bc0307088b8a.jpg">
       <div align="center"><font color="#000000" size="5">修改记录</font> </div>
       <%! String id,url,sql; %>
       <%
         id=request.getParameter("id").trim();
         //调用getConn()方法与数据库建立连接
         modify.getConn("system","123");
         sql="select * from restoreinformation where ID='"+id+"'";
         ResultSet  rs=modify.executeQuery1(sql);
          while(rs.next())
         {
         %>
               <form name="form1" method="post" action="change_query.jsp?id=<%=rs.getString(1)%>">
                    <table width="35%" border="1" cellspacing="1" cellpadding="1" align="center">
                        <tr>
                            <td width="46%" align="center">身份证号码 </td>
                            <td width="54%"> &nbsp;&nbsp;&nbsp;<input type="text" name="id" size="20" value=<%=rs.getString(1)%>></td>
                         </tr>
                         <tr>
                             <td width="46%" align="center">主治医生 </td>
                             <td width="54%"> &nbsp;&nbsp;&nbsp;
                                <input type="text" name="doctorName" size="10" value=<%=rs.getString(2)%>></td>
                          </tr>                         <tr>
                             <td width="46%" align="center">恢复情况</td>
                             <td width="54%"> &nbsp;&nbsp;&nbsp;
                                <input type="text" name="restoreInformation" size="10" value=<%=rs.getString(3)%>></td>
                         </tr>
                         <tr>
                             <td width="46%" align="center">日期</td>
                             <td width="54%">&nbsp;&nbsp;&nbsp;
                                <input type="text" name="date" size="10" value=<%=rs.getString(4)%>></td>
                         </tr>                         <tr align="center">
                             <td colspan="2" align="center">
                                 <input type="submit" name="Submit" value="提交">&nbsp;&nbsp;&nbsp;
                                 <input type="reset" name="reset" value="清空">
                             </td>
                        </tr>
                </table>
           </form>
           <%
             }
             rs.close();
            modify.closeStmt();
            modify.closeConn();
         %>
       </body>
</html>testbean.java
package com;
import java.sql.*;
public class testbean
{
    private Statement stmt = null;
    ResultSet rs = null;
    private Connection conn = null;
    private String dsn;
    public void getConn(String uid, String pwd) throws Exception
    {
        try
        {
            dsn ="jdbc:oracle:thin:@WIN-CESJ6MERFNH:1521:orcl";
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
            conn = DriverManager.getConnection(dsn, uid, pwd);
        }
        catch (Exception ex)
        {
            System.err.println("aq.executeQuery: " + ex.getMessage());
        }
    }
    public void executeUpdate2(String sql)
    {
        stmt = null;
        rs=null;
        try
        {
       stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            stmt.executeQuery(sql);
            stmt.close();
            conn.close();
        }
        catch(SQLException ex)
        {
            System.err.println("aq.executeQuery: " + ex.getMessage());
        }
    }    public ResultSet executeQuery1(String sql)
    {
        rs = null;
        try
        {
       stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
        }
        catch(SQLException ex)
        {
            System.err.println("aq.executeQuery:"+ex.getMessage());
        }
        return rs;
    }
   public void closeStmt()
    {
        try{   stmt.close();   }
        catch(SQLException ex)
        {
            System.err.println("aq.executeQuery: " + ex.getMessage());
        }
    }
    public void closeConn()
    {
        try{   conn.close();  }
        catch(SQLException ex)
        {
            System.err.println("aq.executeQuery: " + ex.getMessage());
        }
    }}
 出现的问题是:jsp页面的rs.()=false,明明我数据库中不为false 但是就是不显示我查询的数据记录，请各位帮帮忙，帮我分析下 谢谢

解决方案 »

  1.   

    首先LZ 你DeBug测试了res没？可能你的res为空...
    action="change_query.jsp?id=<%=rs.getString(1)%>" 中<%=rs.getString(1)%>代表什么意思？
      

  2.   

    我修改数据库中的某一条记录，是先将该条记录从数据库中读出来，<%=rs.getString(1)%>是读出该条记录的第一个字段 
      

  3.   

    form name="form1" method="post" action="change_query.jsp?id=<%=rs.getString(1)%>">生成N个表单？然后 rs.getString(1) 这里取出的是你表结构里面的第二个字段的值？？？id应该是int类型的？？？ id=<%Intger.parseInt(rs.getString("字段值"))%>这样试试看。如果不行 先在控制台输出调试一下。
      

  4.   

    String  为了方便 我将所有字段设置为String类型
      

  5.   

    我修改数据库中的某一条记录，是先将该条记录从数据库中读出来，<%=rs.getString(1)%>是读出该条记录的第一个字段