studentdelete_jsp.java

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

      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=\"TeacherUpdate.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=\"TeacherDelete.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("      \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("         \r\n");
      out.write("          \r\n");
      out.write("<!---- -- -- -- -- -- -- -- -- -- -- -- -- --  删除方法一 -- -- -- -- -- -- -- -- -- -- --  -->   \t\r\n");
      out.write("    \t\r\n");
      out.write("    \t<table border=\"0\" width=\"98%\" cellspacing=\"1\" cellpadding=\"0\" >\r\n");
      out.write("        \r\n");
      out.write("         \t<tr>\r\n");
      out.write("         \t\t<td align=\"left\" colspan=\"3\">\r\n");
      out.write("         \t\t\t选择要删除的成果名称:\r\n");
      out.write("         \t\t</td>\r\n");
      out.write("         \t</tr>\r\n");
      out.write("         \t\t\r\n");
      out.write("         \t<form method=\"POST\" action=\"~StudentDelete.jsp\">\r\n");
      out.write("         \t<tr>\r\n");
      out.write("         \t\t<td align=\"center\" valign=\"middle\" width=\"100\" bgcolor=\"#304D7C\">\r\n");
      out.write("\t\t\t\t<font color=\"ffffff\">&nbsp;学生姓名： </font>\r\n");
      out.write("\t\t\t\t</td>\t\r\n");
      out.write("\t\t\t \t<td  align=\"left\" bgcolor=\"#8DB6CD\" width=\"420\" height=\"30\">&nbsp;\r\n");
      out.write("\t\t\t\t<input type=\"text\" name=\"sname\" size=\"32\"> *\r\n");
      out.write("\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t<td  align=\"center\"  valign=\"middle\" bgcolor=\"#8DB6CD\" width=\"80\" height=\"30\">&nbsp;\r\n");
      out.write("\t\t\t\t<input type=\"submit\" name=\"delete\" value=\"删除\">\r\n");
      out.write("\t\t\t\t</td>\r\n");
      out.write("         \t</tr>\r\n");
      out.write("         \t</form>\r\n");
      out.write("         \t\r\n");
      out.write("         \t<tr>\r\n");
      out.write("         \t\t&nbsp;\r\n");
      out.write("         \t</tr>\r\n");
      out.write(" \t\t  </table>\r\n");
      out.write(" \t\t  \r\n");
      out.write("<!---- -- -- -- -- -- -- -- -- -- -- -- -- --  删除方法二 -- -- -- -- -- -- -- -- -- -- --  -->   \t\r\n");
      out.write("\t\t\r\n");
      out.write("\t\t<table>\r\n");
      out.write("\t\t<tr>\r\n");
      out.write("\t\t<td width=\"1%\"> &nbsp;</td>\r\n");
      out.write("\t\t<td>\r\n");
      out.write("     \t<table border=\"0\" cellspacing=\"1\"  bordercolor=\"#000000\" cellpadding=\"0\" bgcolor=\"#ffffff\">\r\n");
      out.write("\r\n");
      out.write("        \t\r\n");
      out.write("         \t\t\r\n");
      out.write("            <tr>&nbsp;</tr>   \r\n");
      out.write("               \t\r\n");
      out.write("            <tr>\r\n");
      out.write("         \t\t<td align=\"left\" colspan=\"4\" >\r\n");
      out.write("         \t\t\t在下面挑选要删除的学生：\r\n");
      out.write("         \t\t</td>\r\n");
      out.write("         \t</tr>   \r\n");
      out.write("            <tr bgcolor=\"#304D7C\"> \r\n");
      out.write("   \t\t\t\t\t<td width=\"100\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">学生姓名 </font></td>\r\n");
      out.write("\t\t\t\t\t<td width=\"50\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">性别</font></td> \r\n");
      out.write("                    <td width=\"80\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">学位 </font></td>\r\n");
      out.write("                    <td width=\"100\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">导师姓名 </font></td>\r\n");
      out.write("                     <td width=\"300\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">毕业论文 </font></td>\r\n");
      out.write("                    <td width=\"50\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#FFFFFF\">操作 </font></td>\r\n");
      out.write("             </tr>\r\n");
      out.write("       \r\n");
      out.write("          \t ");
 	//输出学生列表
          	 ResultSet rs;
          	 int sid=0;
          	 String sname = new String();
          	 String lvl = new String();
          	 String sex = new String();
          	 String tname = new String();
          	 String paper = new String();
          	 
          	 //rs = myPM.getAllStudent();
          	 rs = myDM.execQuery("select * FROM StudentInfo ORDER BY Name,EduLevel");	
          	 
          	 while(rs!=null && rs.next())
         	 {
         		sid =rs.getInt("Sid");
         	 	sname = myPM.getSName(sid);
         	 	lvl = myPM.getSLevel(sid);
         	 	sex = myPM.getSSex(sid);
         	 	tname = myPM.getSTName(sid);
         	 	paper = myPM.getSPaper(sid);
         	 
         	 
      out.write("\r\n");
      out.write("          \t \t<tr bgcolor=\"8DB6CD\" border=\"1\" >\t\t\r\n");
      out.write("   \t\t\t\t\t<td width=\"100\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#000000\"> ");
out.print(sname);
      out.write("</font></td>\r\n");
      out.write("\t\t\t\t\t<td width=\"50\" align=\"center\" valign=\"middle\"> \r\n");
      out.write("                    <font  color=\"#000000\"> ");
out.print(sex);
      out.write(" </font></td>\r\n");
      out.write("                    <td width=\"80\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font color=\"#000000\"> ");
out.print(lvl);
      out.write(" </font></td> \r\n");
      out.write("                    <td width=\"100\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font color=\"#000000\"> ");
out.print(tname);
      out.write(" </font></td> \r\n");
      out.write("                    <td width=\"300\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font color=\"#000000\"> ");
out.print(paper);
      out.write(" </font></td> \r\n");
      out.write("                    <td width=\"50\" align=\"center\" valign=\"middle\">\r\n");
      out.write("                    <font  color=\"#000000\"> \r\n");
      out.write("                    <a href=\"~StudentDelete.jsp?sid=");
out.print(sid);
      out.write("\"> 删除 </font>\r\n");
      out.write("\t\t\t\t\t</td>\r\n");
      out.write("          \t \t</tr>\r\n");
      out.write("          \t \t");

         		}
          	 
      out.write("     \t\r\n");
      out.write("          \t\t<tr><td>&nbsp;</td></tr>\r\n");
      out.write("         \t\t</table> \r\n");
      out.write("\t\t\t</td>\r\n");
      out.write("\t\t\t</tr>\r\n");
      out.write("\t\t\t</table>\r\n");
      out.write("         \r\n");
      out.write("         \r\n");
      out.write("        </td>\r\n");
      out.write("      </tr>\r\n");
      out.write("    </table>\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);
    }
  }
}