index_jsp.java

vb+java实现的图书管理系统

if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
rs.absolute((intPage-1) * intPageSize+1); 
i = 0; 
while(i< intPageSize && !rs.isAfterLast())
{
String content=rs.getString("content");
String name=rs.getString("name");
String qq=rs.getString("qq");
String email=rs.getString("email");
String http=rs.getString("http");
String sex=rs.getString("sex");
String time=rs.getString("ltime");
String ip=rs.getString("ip");
String recontent=rs.getString("recontent");
String userid=rs.getString("userid");
if (null != userid && userid.length()>0){
java.sql.Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
java.sql.ResultSet rs2=stmt2.executeQuery("select * from guestbook_user where id="+userid);
if(rs2.next()){
	name=rs2.getString("name");
	qq=rs2.getString("qq");
	email=rs2.getString("email");
	http=rs2.getString("http");
	sex=rs2.getString("sex");
}
rs2.close();
stmt2.close();
}

      out.write("\r\n");
      out.write("<table width=\"650\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" style=\"word-break:break-all\">\r\n");
      out.write("  <tr> \r\n");
      out.write("    <td width=\"81\" height=\"10\"><img src=\"img/top1.gif\" width=\"81\" height=\"22\"></td>\r\n");
      out.write("    <td width=\"575\" background=\"img/top2.gif\" height=\"22\"></td>\r\n");
      out.write("    <td width=\"1\"><img src=\"img/top3.gif\" width=\"47\" height=\"22\"></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("  <tr> \r\n");
      out.write("    <td colspan=\"3\" align=\"center\" bgcolor=\"#FFFFFF\" class=\"tittle2\"><table width=\"100%\" height=\"28\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" background=\"img/bg.gif\" class=\"tittle3\">\r\n");
      out.write("        <tr> \r\n");
      out.write("          <td width=\"4%\" align=\"center\"><img src=\"img/topicnew.gif\" width=\"16\" height=\"18\"></td>\r\n");
      out.write("          <td width=\"39%\"><span class=\"style2\"><span class=\"style4\"><span class=\"style7\">");
      out.print(name);
      out.write("<span style=\"font-family: &quot;??&quot;;\" #invalid_attr_id=\"none\"></span></span><span class=\"style3\">留言于</span><font color=\"#000099\"><font color=\"#FF0000\">");
      out.print(time);
      out.write("&nbsp;&nbsp;</font></font></span></span></td>\r\n");
      out.write("          <td width=\"39%\"><span class=\"style4\"><font color=\"#000099\">IP:</font><font color=\"#FF0000\">");
      out.print(rs.getString("ip"));
      out.write("</font></span></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"");
      out.print(http);
      out.write("\" target=\"_blank\"><img src=\"img/icon_homepage.gif\" alt=\"");
      out.print(name);
      out.write("的主页\" width=\"16\" height=\"16\" border=\"0\"></a></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"http://search.tencent.com/cgi-bin/friend/user_show_info?ln=");
      out.print(qq);
      out.write("\" target=\"_blank\"><img src=\"img/icon_editor_oicq.gif\" alt=\"");
      out.print(name);
      out.write("的QQ是：");
      out.print(qq);
      out.write("\" width=\"16\" height=\"16\" border=\"0\"></a></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"mailto:");
      out.print(email);
      out.write("\"><img src=\"img/icon_email.gif\" alt=\"");
      out.print(name);
      out.write("的Email是：");
      out.print(email);
      out.write("\" width=\"16\" height=\"16\" border=\"0\"></a></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"re.jsp?id=");
      out.print(rs.getInt("id"));
      out.write("\"><img src=\"img/icon_reply_topic.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"回复该留言[只有版主才有的权利]\"></a></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"edit.jsp?id=");
      out.print(rs.getInt("id"));
      out.write("\"><img src=\"img/icon_edit_topic.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"编辑该留言[只有版主才有的权利]\"></a></td>\r\n");
      out.write("          <td width=\"3%\"><a href=\"del.jsp?id=");
      out.print(rs.getInt("id"));
      out.write("\"><img src=\"img/icon_delete_reply.gif\" alt=\"删除该留言[只有版主才有的权利]\" width=\"16\" height=\"16\" border=\"0\"></a></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr></tr>\r\n");
      out.write("      </table>\r\n");
      out.write("      <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("        <tr> \r\n");
      out.write("          <td width=\"100\" height=\"92\" align=\"center\" valign=\"top\"> <table width=\"100%\" border=\"0\" cellspacing=\"3\" cellpadding=\"0\">\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td align=\"center\"><img src=\"img/");
      out.print(sex);
      out.write(".gif\"></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td align=\"center\"><span class=\"style4\">");
      out.print(name);
      out.write("</span></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("          <td width=\"423\"><span class=\"style4\">");
      out.print(content );
      out.write("</span></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr align=\"center\"> \r\n");
      out.write("          <td colspan=\"2\" valign=\"top\"><img src=\"images/bg_4.gif\" width=\"100%\" height=\"1\"></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr> \r\n");
      out.write("          <td colspan=\"2\" height=\"20\"><font color=\"#006699\"> 　<img src=\"img/locktop.gif\" width=\"15\" height=\"15\" align=\"absmiddle\"></font><span class=\"font0\"><span class=\"style1\">版主回复：</span><span class=\"style7\">");
      out.print(recontent);
      out.write("</span></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table></td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("<table border=\"0\" width=\"650\" cellspacing=\"0\" cellpadding=\"0\" height=\"7\" align=\"center\">\r\n");
      out.write("  <tr> \r\n");
      out.write("    <td width=\"2%\" align=\"center\"><img src=\"img/end1.gif\" width=\"12\" height=\"14\"></td>\r\n");
      out.write("    <td width=\"89%\" align=\"center\" background=\"img/end2.gif\"></td>\r\n");
      out.write("    <td width=\"9%\" align=\"center\"><img src=\"img/end3.gif\" width=\"65\" height=\"14\"></td>\r\n");
      out.write("  </tr> \r\n");
      out.write("</table>\r\n");
rs.next(); 
   i++; 
  } 
}
rs.close();
stmt.close(); 
conn.close();

      out.write("\r\n");
      out.write("<table width=\"650\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"1\" class=\"tittle0\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td height=\"28\" align=\"center\" background=\"img/bg.gif\" class=\"font0 style1\">当前显示第<span class=\"style7\"> ");
      out.print(intPage);
      out.write("</span> 页&nbsp;&nbsp; 共 ");
      out.print(intPageCount);
      out.write(" 页 &nbsp;&nbsp;&nbsp;&nbsp;导航：<a href=\"index.jsp?key=");
      out.print(key);
      out.write("&page=1\" class=\"font0\">首页</a>\r\n");
      out.write("      ");
if(intPage>1){
      out.write("\r\n");
      out.write("      <a href=\"index.jsp?key=");
      out.print(key);
      out.write("&page=");
      out.print(intPage-1);
      out.write("\" class=\"font0\">上一页</a>\r\n");
      out.write("      ");
}else{
      out.write("\r\n");
      out.write("上一页\r\n");
}
      out.write(' ');
      out.write('\r');
      out.write('\n');
if(intPage<intPageCount){
      out.write("\r\n");
      out.write("<a href=\"index.jsp?key=");
      out.print(key);
      out.write("&page=");
      out.print(intPage+1);
      out.write("\" class=\"font0\">下一页</a>\r\n");
}else{
      out.write("\r\n");
      out.write("下一页\r\n");
}
      out.write("\r\n");
      out.write("<a href=\"index.jsp?key=");
      out.print(key);
      out.write("&page=");
      out.print(intPageCount);
      out.write("\" class=\"font0\">尾页</a> </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("</body>\r\n");
      out.write("</html>");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          try { out.clearBuffer(); } catch (java.io.IOException e) {}
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}