有一页面里查询两次，但显示有问题，帮助

不知是否可以给出源代码 ？？

解决方案 »

  1.   

    <% 
    //声名 
    java.sql.Connection sqlConn; 
    java.sql.Statement sqlStmt; 
    java.sql.ResultSet sqlRst; 
    //regiester jdbc driver 
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
    //connect to the database 
    sqlConn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=biyesheji;SelectMethod=direct","sa","sa");
    //create the driver handle 
    sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
    sqlRst=sqlStmt.executeQuery("select member.id,member.realname,member.gender,member.nationality,year(getdate())-year(birthday) as age,member.sensusregister,member.political,member.height,member.weight,member.bloodtype,member.hobby,member.specialty,degree.name as degree1,major.name as major1,member.school1,member.graduatetime1,member.englishrank,member.otherlanguage,member.computerrank,member.drivecard,member.professionalrank,qulifypos.posname,qualifiedposition,member.studyexperience,member.jobexperience,member.address,member.postnumber,member.mobile,member.phone,member.email,member.selfinfor,member.hitnum from degree,member,major,qulifypos where degree.id=member.degree1 and major.id=member.major1 and member.qualifiedposition=qulifypos.id and member.id='"+id+"'"); 
    //out.print(sql);
    sqlRst.next();
    %>
    <%
    java.sql.Statement sqlStmt1; 
    java.sql.ResultSet sqlRst1; 
    //regiester jdbc driver 
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
    sqlStmt1=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
    //out.print(sql);
    sqlRst1=sqlStmt1.executeQuery("select member.id,degree.name as degree2,major.name as major2,member.school2,member.graduatetime2 from degree,member,major where degree.id=member.degree2 and major.id=member.major2 and member.id='"+id+"'");%> <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>无标题文档</title>
    </head><body>
    <table width="600" border="1" cellspacing="0" cellpadding="0">
      <tr> 
        <td colspan="2"><font color="#99330"><strong>基本信息：</strong></font></td>
      </tr>
      <tr> 
        <td width="255">姓名：<%=sqlRst.getString(2)%></td>
        <td width="252">性别：<%=sqlRst.getString(3)%></td>
      </tr>
    *********************省略
    <tr> 
        <td>毕业院校：<%=sqlRst.getString(15)%></td>
        <td>毕业时间：<%=sqlRst.getString(16)%></td>
      </tr>
     <%while(sqlRst1.next())
      {%> 
      <tr> 
        <td>第二学历：<%t=sqlRst1.getString(2);if(t==null){t="未填写";} out.print(t);%></td>
        <td>第二专业：<%t=sqlRst1.getString(3);if(t==null){t="未填写";} out.print(t);%></td>
      </tr>
      <tr> 
        <td>毕业院校：<%t=sqlRst1.getString(4);if(t==null){t="未填写";} out.print(t);%></td>
        <td>毕业时间：<%t=sqlRst1.getString(5);if(t==null){t="未填写";} out.print(t);%></td>
     </tr> <%}%>
      <tr> 
        <td>英语水平：<%=sqlRst.getString(17)%></td>
        <td>其他语言：<%=sqlRst.getString(18)%></td>
      </tr>
    *******************************省略
      </table>
    <p>&nbsp;</p>
    </body>
    </html>
    <% 
    sqlRst.close(); 
    sqlRst1.close(); 
    sqlStmt.close(); 
    sqlStmt1.close(); 
    sqlConn.close(); 
    %>