honoraudit_jsp.java

jsp制作的一个信息管理系统源码,完整实用版

      out.write("                    <td bgcolor=\"#8DB6CD\"><div align=\"center\"> \r\n");
      out.write("                        <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("                          <tr> \r\n");
      out.write("                            <td><div align=\"center\"><a href=\"HonorInfoUpdate.jsp\"><font color=\"#ffffff\">修改基本信息 </font></a></div></td>\r\n");
      out.write("                          </tr>\r\n");
      out.write("                        </table>\r\n");
      out.write("                        <strong></strong></div></td>\r\n");
      out.write("                  </tr>\r\n");
      out.write("\t\t\t\t  <tr bgcolor=\"#000000\"> \r\n");
      out.write("        \t\t\t<td colspan=\"2\" height=\"1\"><img src=\"../images/dot.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("      \t\t\t  </tr>\r\n");
      out.write("      \t\t\t  \r\n");
      out.write("      \t\t\t  \r\n");
      out.write("      \t\t\t  \r\n");
      out.write("                  <tr> \r\n");
      out.write("                    <td bgcolor=\"#8DB6CD\"><div align=\"center\"> \r\n");
      out.write("                        <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("                          <tr>  \r\n");
      out.write("                            <td><div align=\"center\"><a href=\"HonorPersonAdd.jsp\"><font color=\"#FFFFFF\">增加人员信息 </font></a></div></td>\r\n");
      out.write("                          </tr>\r\n");
      out.write("                        </table>\r\n");
      out.write("                        <strong></strong></div></td>\r\n");
      out.write("                  </tr>\r\n");
      out.write("\t\t\t\t  <tr bgcolor=\"#000000\"> \r\n");
      out.write("        \t\t\t<td colspan=\"2\" height=\"1\"><img src=\"../images/dot.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("      \t\t\t  </tr>\r\n");
      out.write("      \t\t\t  \r\n");
      out.write("      \t\t\t   <tr> \r\n");
      out.write("                    <td bgcolor=\"#8DB6CD\"><div align=\"center\"> \r\n");
      out.write("                        <table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n");
      out.write("                          <tr> \r\n");
      out.write("                            <td><div align=\"center\"><a href=\"HonorPersonDelete.jsp\"><font color=\"#FFFFFF\">删除人员信息 </font></a></div></td>\r\n");
      out.write("                          </tr>\r\n");
      out.write("                        </table>\r\n");
      out.write("                        <strong></strong></div></td>\r\n");
      out.write("                  </tr>\r\n");
      out.write("\t\t\t\t  <tr bgcolor=\"#000000\"> \r\n");
      out.write("        \t\t\t<td colspan=\"2\" height=\"1\"><img src=\"../images/dot.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("      \t\t\t  </tr>\r\n");
      out.write("      \t\t\t  \r\n");
      out.write("\r\n");
      out.write("      \t\t\t  \r\n");
      out.write("\r\n");
      out.write("      \t\t\t  \r\n");
      out.write("\r\n");
      out.write("      \t\t\t \r\n");
      out.write("      \t\t\t  \r\n");
      out.write("      \t\t\t  \r\n");
      out.write("<!-- 菜单完成 -->\r\n");
      out.write("\t\t\t\t  <tr bgcolor=\"#000000\"> \r\n");
      out.write("        \t\t\t<td colspan=\"2\" height=\"1\"><img src=\"../images/dot.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("      \t\t\t  </tr>\r\n");
      out.write("                  <tr> \r\n");
      out.write("                    <td>&nbsp;</td>\r\n");
      out.write("                  </tr>\r\n");
      out.write("                </table></td>\r\n");
      out.write("              <td width=\"15%\">&nbsp;</td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table> </td>\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("\r\n");
      out.write("<!-- 右页面 -->\r\n");
      out.write("        <td bgcolor=\"#C4C4C4\" width=\"3\" height=\"143\"><img src=\"../images/dot1.gif\" width=\"1\" height=\"1\"></td>\r\n");
      out.write("        <td colspan=\"2\" height=\"143\" valign=\"top\" align=\"right\">\r\n");
      out.write("    \t\t\r\n");
      out.write("    \t<table>\r\n");
      out.write("    \t<tr>\r\n");
      out.write("    \t<td width=\"1%\"></td>\r\n");
      out.write("    \t<td>\r\n");
      out.write("\t\t\t\r\n");
      out.write("   \t\t  \t<table  border=\"0\" cellspacing=\"1\" width=\"100%\" bordercolor=\"#000000\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n");
      out.write("\t\t\r\n");
      out.write("        \t    <tr>&nbsp;</tr>   \r\n");
      out.write("               \t\r\n");
      out.write("            \t<tr>\r\n");
      out.write("         \t\t\t<td align=\"left\" colspan=\"4\" >\r\n");
      out.write("         \t\t\t以下是待审计的成果：\r\n");
      out.write("         \t\t\t</td>\r\n");
      out.write("         \t\t</tr> \r\n");
      out.write("         \t  \r\n");
      out.write("            \t<tr bgcolor=\"#304D7C\"> \r\n");
      out.write("   \t\t\t\t\t<td width=\"300\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">成果名称</font></td>\r\n");
      out.write("\t\t\t\t\t<td width=\"200\" align=\"center\">\r\n");
      out.write("                    <font   color=\"#FFFFFF\">人员名称</font></td>\r\n");
      out.write("                    <td width=\"180\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">职位</font></td> \r\n");
      out.write("                    <td width=\"80\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">操作</font></td>\r\n");
      out.write("             \t</tr>\r\n");
      out.write("       \r\n");
      out.write("      \t    \t");
 	//输出未审计列表
        	    ResultSet rs;
          		int hid,tid;
          		String hname=null,tname=null,location=null;
          	 	rs = myHM.getAllUnflag();
          		//rs = myDM.execQuery("select * FROM TeacherHonor where Flag=0 ORDER BY Hid");
          		
          	 	while(rs!=null && rs.next())
         	 	{
         			hid =rs.getInt("Hid");
         	 		hname =myHM.getHName(hid);
         	 		tid =rs.getInt("Tid");
         	 		tname =myHM.getTName(tid);
         	 		location =rs.getString("Location");	
        			if(hname==null)
        				hname="Wrong Data";
        			else if(hname.length()==0)
        				hname="Wrong Data";
        			else
        				;
        			if(tname==null)
        				tname="Wrong Data";
        			else if(tname.length()==0)
        				tname="Wrong Data";
        			else
        				;
       
   	    	 	
      out.write("\r\n");
      out.write("    \t      \t \t<tr bgcolor=\"8DB6CD\" border=\"0\" >\t\r\n");
      out.write("    \t      \t \t\t\r\n");
      out.write("   \t\t\t\t\t<td width=\"300\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#000000\"> ");
out.print(hname);
      out.write(" </font></td>\r\n");
      out.write("\t\t\t\t\t<td width=\"200\" align=\"center\"> \r\n");
      out.write("                    <font  color=\"#000000\"> ");
out.print(tname);
      out.write(" </font></td>\r\n");
      out.write("                    <td width=\"180\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#000000\"> ");
out.print(location);
      out.write(" </font></td> \r\n");
      out.write("                    <td width=\"80\" align=\"center\">\r\n");
      out.write("                    <font  color=\"#000000\"> \r\n");
      out.write("                    <a href=\"~HonorAudit.jsp?hid=");
out.print(hid);
      out.write("&tid=");
out.print(tid);
      out.write("\">审核\r\n");
      out.write("                    \r\n");
      out.write("                    </a>\r\n");
      out.write("                    </font></td>\r\n");
      out.write("          \t \t\t\r\n");
      out.write("          \t \t\t</tr>\r\n");
      out.write("          \t \t");

         		}
          	 	
      out.write("     \t\r\n");
      out.write("          \t\r\n");
      out.write("         \t\t</table> \r\n");
      out.write("         \t\r\n");
      out.write("\t\t</td>\r\n");
      out.write("\t\t</tr>\r\n");
      out.write("\t\t</table>\r\n");
      out.write(" \t\t  \r\n");
      out.write(" \r\n");
      out.write("        </td>\r\n");
      out.write("      </tr>\r\n");
      out.write("    </table>\r\n");
      out.write("    \r\n");
      out.write("\t<!-- include  common bottom.htm -->\r\n");
      out.write("    ");
      org.apache.jasper.runtime.JspRuntimeLibrary.include(request, response, "bottom.htm", out, false);
      out.write("\r\n");
      out.write("  </center></div>\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\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);
    }
  }
}