denglu_jsp.java

用JSP制作的个人网站

      out.write("                      <td>");
      out.print(s_fshiyongnianxian);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_fshengchanriqi);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_fgoumaichishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_ftuijianzhishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_fyoudian);
      out.write("</td>\r\n");
      out.write("                    </tr> ");
  }
      out.write("\r\n");
      out.write("\r\n");
      out.write("                  </table>\r\n");
      out.write("                  <table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"1\" bordercolor=\"#cccccc\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td height=\"35\" colspan=\"9\" background=\"images/zuihou.png\">　　　饰品</td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"10%\" height=\"25\"><div align=\"center\">物品名</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">颜色</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">厂家</div></td>\r\n");
      out.write("                      <td width=\"11%\"><div align=\"center\">材料</div></td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">使用年限</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">生产日期</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">购买次数</div></td>\r\n");
      out.write("                      <td width=\"11%\"><div align=\"center\">推荐指数</div></td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">优点</div></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                       ");

                  while (rs_shipin.next()) {
                    s_shipinid=rs_shipin.getInt(1);
                    s_swupinming = rs_shipin.getString(2);
                      s_syanse = rs_shipin.getString(3);
                       s_schangjia = rs_shipin.getString(4);
                        s_scailiao = rs_shipin.getString(5);
                         s_sshiyongnianxian = rs_shipin.getString(6);
                          s_sshengchanriqi = rs_shipin.getString(7);
                          s_sgoumaichishu= rs_shipin.getString(8);
                           s_stuijianzhishu= rs_shipin.getString(9);
                            s_syoudian= rs_shipin.getString(10);
                  
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td height=\"31\">");
      out.print(s_swupinming);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_syanse);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_schangjia );
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_scailiao);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_sshiyongnianxian);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_sshengchanriqi);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_sgoumaichishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_stuijianzhishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_syoudian);
      out.write("</td>\r\n");
      out.write("                    </tr>");
} 
      out.write("\r\n");
      out.write("                  </table>\r\n");
      out.write("                  <table width=\"100%\" height=\"105\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\" bordercolor=\"#cccccc\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td colspan=\"9\" background=\"images/zuihou.png\">　　　 生活用品</td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"10%\"><div align=\"center\">物品名</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">颜色</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">厂家</div></td>\r\n");
      out.write("                      <td width=\"11%\"><div align=\"center\">材料</div></td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">使用年限</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">生产日期</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">购买次数</div></td>\r\n");
      out.write("                      <td width=\"11%\"><div align=\"center\">推荐指数</div></td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">优点</div></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                       ");

                  while (rs_shenghuoyongpin.next()) {
                    s_shenghuoyongpinid=rs_shenghuoyongpin.getInt(1);
                    s_hwupinming = rs_shenghuoyongpin.getString(2);
                      s_hyanse = rs_shenghuoyongpin.getString(3);
                       s_hchangjia = rs_shenghuoyongpin.getString(4);
                        s_hcailiao = rs_shenghuoyongpin.getString(5);
                         s_hshiyongnianxian = rs_shenghuoyongpin.getString(6);
                          s_hshengchanriqi = rs_shenghuoyongpin.getString(7);
                          s_hgoumaichishu= rs_shenghuoyongpin.getString(8);
                           s_htuijianzhishu= rs_shenghuoyongpin.getString(9);
                            s_htuijianzhishu= rs_shenghuoyongpin.getString(10);
                  
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td>");
      out.print(s_hwupinming);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hyanse );
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hchangjia);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hcailiao);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hshiyongnianxian);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hshengchanriqi);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_hgoumaichishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_htuijianzhishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_htuijianzhishu);
      out.write("</td>\r\n");
      out.write("                    </tr>");
}
      out.write("\r\n");
      out.write("                  </table>\r\n");
      out.write("                  <table width=\"100%\" height=\"110\" cellpadding=\"0\" cellspacing=\"0\" border=\"1\" bordercolor=\"#cccccc\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td colspan=\"9\" background=\"images/zuihou.png\">　　　其他</td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"10%\"><div align=\"center\">物品名</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">颜色</div></td>\r\n");
      out.write("                      <td width=\"9%\"><div align=\"center\">厂家</div></td>\r\n");
      out.write("                      <td width=\"11%\"><div align=\"center\">材料</div></td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">使用年限</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">生产日期</div></td>\r\n");
      out.write("                      <td width=\"13%\"><div align=\"center\">购买次数</div></td>\r\n");
      out.write("                      <td width=\"11%\">推荐指数</td>\r\n");
      out.write("                      <td width=\"12%\"><div align=\"center\">优点</div></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                 ");

                  while (rs_qita.next()) {
                    s_qitaid=rs_qita.getInt(1);
                    s_qwupinming = rs_qita.getString(2);
                      s_qyanse = rs_qita.getString(3);
                       s_qchangjia = rs_qita.getString(4);
                        s_qcailiao = rs_qita.getString(5);
                         s_qshiyongnianxian = rs_qita.getString(6);
                          s_qshengchanriqi = rs_qita.getString(7);
                          s_qgoumaichishu= rs_qita.getString(8);
                           s_qtuijianzhishu= rs_qita.getString(9);
                            s_qyoudian= rs_qita.getString(10);
                  
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td>");
      out.print(s_qwupinming);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qyanse);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qchangjia);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qcailiao);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qshiyongnianxian);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qshengchanriqi);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qgoumaichishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qtuijianzhishu);
      out.write("</td>\r\n");
      out.write("                      <td>");
      out.print(s_qyoudian);
      out.write("</td>\r\n");
      out.write("                    </tr>");
}
      out.write("\r\n");
      out.write("                  </table>\r\n");
      out.write("                  <table width=\"100%\" height=\"40\" >\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td>　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　更多 </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("          </td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table>\r\n");
      out.write("    <img src=\"file:///C|/Documents%20and%20Settings/liang/My%20Documents/liangjuyan/yan.png\" width=\"719\" height=\"45\"/>    </td>\r\n");
      out.write("  </tr>\r\n");
      out.write("</table>\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\n");
conn.close();
      out.write('\r');
      out.write('\n');
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}