main_jsp.java

sql+struts+jsp 提供考试的一般需求

      out.write("                                      <tr>\r\n");
      out.write("                                        <td height=\"25\" class=\"lh120 STYLE12\"><span class=\"STYLE25\">【考生信息】</span><span class=\"STYLE21\"><a href=\"#\">考试成绩查询</a> <a href=\"#\">考生资料查询</a></span></td>\r\n");
      out.write("                                      </tr>\r\n");
      out.write("                                      <tr>\r\n");
      out.write("                                        <td height=\"25\" class=\"lh120 STYLE24\"><span class=\"STYLE21\">【考试流程】<a href=\"#\">在线报考</a> <a href=\"#\">考试时间</a></span></td>\r\n");
      out.write("                                      </tr>\r\n");
      out.write("                                  </table></td>\r\n");
      out.write("                                </tr>\r\n");
      out.write("                              </table></td>\r\n");
      out.write("                          </tr>\r\n");
      out.write("                          <tr>\r\n");
      out.write("                            <td height=\"18\" colspan=\"2\">&nbsp;</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></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td><img src=\"images/m_line2.gif\" width=\"570\" height=\"8\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("            </table></td>\r\n");
      out.write("          <td width=\"5\"><img src=\"images/blank.gif\" width=\"5\" height=\"1\"></td>\r\n");
      out.write("          <td width=\"200\" valign=\"top\">\r\n");
      out.write("\r\n");
      out.write("            <table width=\"100%\" height=\"225\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"32\"><img src=\"images/right_tit.gif\" width=\"200\" height=\"32\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td background=\"images/right_bg.gif\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"45\"><div align=\"right\"><img src=\"images/bullet03.gif\" width=\"40\" height=\"45\"></div></td>\r\n");
      out.write("                      <td><font color=\"2671BC\">比赛获奖名单</font></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                  </table></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td bgcolor=\"FFC600\"><img src=\"images/blank.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td valign=\"top\" background=\"images/right_bg.gif\"><table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td colspan=\"2\"><img src=\"images/blank.gif\" width=\"1\" height=\"10\"></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td width=\"11\">&nbsp;</td>\r\n");
      out.write("\t\t\t\t\t  ");
ResultSet rstt=stmt.executeQuery("select top 6 * from bisai");
      out.write("\r\n");
      out.write("\r\n");
      out.write("                      <td width=\"189\"><table width=\"100%\" border=\"0\" cellspacing=\"0\">\r\n");
      out.write("\r\n");
      out.write("                            <th height=\"170\" align=\"left\" scope=\"row\">\r\n");
      out.write("\t\t\t\t\t\t\t");
while(rstt.next()){
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t<img src=\"images/point2.gif\" width=\"4\" height=\"6\"> <font color=\"979797\"><a harf=\"\">");
      out.print(rstt.getString(7));
      out.write("</a></font><br>\r\n");
      out.write("\t\t\t\t\t\t\t");
}
      out.write("</th>\r\n");
      out.write("                        </table></td>\r\n");
      out.write("\r\n");
      out.write("                    </tr>\r\n");
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td height=\"10\" colspan=\"2\"><hr width=\"100%\" color=\"#FFCC00\"></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                </table></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"10\">&nbsp;</td>\r\n");
      out.write("              </tr>\r\n");
      out.write("            </table>\r\n");
      out.write("\r\n");
      out.write("            <table width=\"100%\" height=\"272\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"8\"><img src=\"images/m_line1.gif\" width=\"200\" height=\"8\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"64\" valign=\"top\" background=\"images/right_bg2.gif\">\r\n");
      out.write("\r\n");
      out.write("                  <table width=\"95%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td><img src=\"images/right_tit2.gif\" width=\"168\" height=\"28\"><img src=\"images/blank.gif\" width=\"1\" height=\"8\"></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td><img src=\"images/blank.gif\" width=\"1\" height=\"10\">\r\n");
      out.write("                        <table width=\"95%\" height=\"144\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("                          <tr>\r\n");
      out.write("                            <td height=\"144\">\r\n");
      out.write("                                <p>\r\n");
      out.write("                                ");

    ResultSet rst=stmt.executeQuery("select top 10 * from news order by n_time ");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("             <marquee onMouseOver=\"this.stop()\" onMouseOut=\"this.start()\" behavior=\"scroll\" direction=\"up\" bgcolor=\"#FFFFFF\" height=\"150\" width=\"180\" hspace=\"0\" vspace=\"0\" loop=\"INFINITE\" scrollamount=\"30\" scrolldelay=\"800\">\r\n");
      out.write("             ");
while(rst.next()){
      out.write("\r\n");
      out.write("                   <img src=\"images/dot2.jpg\" width=\"7\" height=\"7\"><a href=\"newsAction.do?method=nsearch&nid=");
      out.print(rst.getString(1));
      out.write('"');
      out.write('>');
      out.print(rst.getString(2));
      out.write("</a><br>\r\n");
      out.write("             ");
}
      out.write("\r\n");
      out.write("             </marquee>\r\n");
stmt.close();
//conn.close();
}
catch(Exception e)
{
out.println(e.toString());
}

      out.write("\r\n");
      out.write("                            </td>\r\n");
      out.write("                          </tr>\r\n");
      out.write("                        </table></td>\r\n");
      out.write("                    </tr>\r\n");
      out.write("                    <tr>\r\n");
      out.write("                      <td></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("              <tr>\r\n");
      out.write("                <td height=\"4\" valign=\"top\" background=\"images/right_bg2.gif\"><img src=\"images/m_line2.gif\" width=\"200\" height=\"8\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"4\" valign=\"top\" background=\"images/right_bg2.gif\">&nbsp;</td>\r\n");
      out.write("              </tr>\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td height=\"8\" align=\"center\"><img src=\"images/left_bnr.jpg\" width=\"170\" height=\"220\" border=\"0\" usemap=\"#Map\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("            </table>\r\n");
      out.write("\r\n");
      out.write("          </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("\r\n");
      out.write("<table width=\"950\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("  <tr>\r\n");
      out.write("    <td width=\"25\"><img src=\"images/btm_1.gif\" width=\"25\" height=\"149\"></td>\r\n");
      out.write("    <td width=\"900\" valign=\"top\"><table width=\"900\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"900\" bgcolor=\"E9E9E9\"><table width=\"601\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td width=\"57\"><img src=\"images/btm_mn1.gif\" width=\"57\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"77\"><img src=\"images/btm_mn2.gif\" width=\"77\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"35\"><img src=\"images/btm_mn3.gif\" width=\"35\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"53\"><img src=\"images/btm_mn4.gif\" width=\"53\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"51\"><img src=\"images/btm_mn5.gif\" width=\"51\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"69\"><img src=\"images/btm_mn6.gif\" width=\"69\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"87\"><img src=\"images/btm_mn7.gif\" width=\"87\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"95\"><img src=\"images/btm_mn8.gif\" width=\"95\" height=\"31\"></td>\r\n");
      out.write("                <td width=\"77\"><img src=\"images/btm_mn9.gif\" width=\"77\" height=\"31\"></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("            </table></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td><table width=\"100%\" height=\"101\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("              <tr>\r\n");
      out.write("                <td width=\"210\"><img src=\"images/btm_logo.gif\" width=\"190\" height=\"100\"></td>\r\n");
      out.write("                <td align=\"center\"><p class=\"STYLE13\"><font color=\"ADADAD\">广东科学技术职业学院 计算机工程技术学院专业资格考试网</font> </p>\r\n");
      out.write("                  <p class=\"STYLE13\"><font color=\"ADADAD\">06级网络编程2班 513开发团队 技术支持<br>\r\n");
      out.write("                    意见反馈邮箱地址\r\n");
      out.write("                  :</font><span class=\"STYLE2\">[e-mail]</span></p></td>\r\n");
      out.write("              </tr>\r\n");
      out.write("            </table></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td bgcolor=\"E9E9E9\"><div align=\"center\"><img src=\"images/copyright.gif\" width=\"355\" height=\"17\"></div></td>\r\n");