📄 adminstudent3_0002ejsp_jsp.java
字号:
// begin [file="/adminstudent3.jsp";from=(21,2);to=(51,0)]
//String strSQL = "select id ,title from news order by id desc";
//ResultSet rs = sts.executeQuery(strSQL);
String temstuname = new String();
temstuname = request.getParameter("select");
temstuname = temstuname.trim();
temstuname = trans(temstuname);
String temstuid = new String();
String temstuno = new String();
String temstupsw = new String();
String temstugrade = new String();
String strSQL = "select stuid ,stuno,stupsw,stugrade from student where stuname = '"+temstuname+"'";
ResultSet rs = subject.executeQuery(strSQL);
while(rs.next())
{
temstuid = rs.getString("stuid");
temstuno = rs.getString("stuno");
temstupsw= rs.getString("stupsw");
temstugrade = rs.getString("stugrade");
}
rs.close();
//String strSQL2 = "delete from news where id =" + k;
//sts.executeUpdate(strSQL2);
// end
// HTML // begin [file="/adminstudent3.jsp";from=(51,2);to=(153,34)]
out.write("\r\n\r\n<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link href=\"_notes/aaa.css\" rel=\"stylesheet\" type=\"text/css\">\r\n<style type=\"text/css\">\r\n<!--\r\n@import url(\"_notes/ccc\");\r\nbody,td,th {\r\n\tcolor: #FFFFFF;\r\n\tfont-weight: bold;\r\n\tfont-size: 12px;\r\n}\r\na:link {\r\n\tcolor: #FFFFFF;\r\n}\r\na:visited {\r\n\tcolor: #FFFFFF;\r\n}\r\n-->\r\n</style>\r\n\r\n</HEAD>\r\n<BODY BGCOLOR=#0D85A6 BACKGROUND=\"images/bg.gif\" >\r\n\r\n<br>\r\n<br>\r\n<TABLE WIDTH=750 height=\"494\" BORDER=0 align=\"center\" CELLPADDING=0 CELLSPACING=0>\r\n <TR>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=231 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=4 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=75 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=105 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=5 HEIGHT=1></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=4> <IMG SRC=\"images/temp_01.jpg\" WIDTH=420 HEIGHT=15></TD>\r\n <TD COLSPAN=4> <IMG SRC=\"images/temp_02.jpg\" WIDTH=330 HEIGHT=15></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <IMG SRC=\"images/temp_03.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n </TR>\r\n <TR>\r\n <TD>\r\n <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"226\" background=\"images/left_top.jpg\">\r\n <tr>\r\n <td width=\"231\" valign=\"bottom\">\r\n <div align=\"center\">\r\n <p><br>\r\n </p>\r\n <p>【学生管理】</p>\r\n <p align=\"center\"> 再这里您可以注册<br>\r\n 或删除学生的信息 <br>\r\n <br>\r\n <br>\r\n </p>\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"adminteacher.jsp\">【教师<strong>管理</strong>】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\"><a href=\"admincourse.jsp\">【课程<strong>管理</strong>】</a></div></td>\r\n </tr>\r\n </table>\r\n <p> <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n </div> </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n <TD ROWSPAN=2> <IMG SRC=\"images/temp_05.jpg\" WIDTH=4 HEIGHT=455></TD>\r\n <TD COLSPAN=5 ROWSPAN=2>\r\n <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\" background=\"images/main_bg.jpg\">\r\n <tr>\r\n <td width=\"510\">\r\n <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\">\r\n <tr>\r\n <td width=\"510\" height=\"78\">\r\n <div align=\"center\"><img src=\"images/blank_banner.gif\" width=\"468\" height=\"60\"></div>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td valign=\"top\"> <div align=\"left\"><a href=\"index1.htm\">首页</a>><a href=\"index3.jsp\">后台管理</a>><a href=\"adminstudent.jsp\">学生管理</a>>删改学生信息<br>\r\n <br>\r\n <br>\r\n <br>\r\n <table width=\"500\" border=\"1\" bordercolor=\"#006666\">\r\n <tr>\r\n <td><div align=\"center\">修改学生信息</div> <div align=\"center\"></div></td>\r\n </tr>\r\n <tr>\r\n <td height=\"248\"><div align=\"center\">\r\n <form name=\"form1\" method=\"post\" action=\"adminstudent4.jsp\">\r\n <table width=\"274\" border=\"0\" bordercolor=\"#006666\">\r\n <tr bordercolor=\"#006666\">\r\n <td width=\"65\" height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n <div align=\"right\">学生编号</div></td>\r\n <td colspan=\"2\" background=\"images/bg.gif\">\r\n <div align=\"left\">\r\n ");
// end
// begin [file="/adminstudent3.jsp";from=(153,36);to=(153,129)]
out.print("<input name=\"stuid\" type=\"hidden\" id=\"stuid\" value = \""+temstuid+"\">" );
// end
// HTML // begin [file="/adminstudent3.jsp";from=(153,131);to=(154,11)]
out.write("\r\n\t\t\t\t\t\t\t\t ");
// end
// begin [file="/adminstudent3.jsp";from=(154,13);to=(154,34)]
out.print(temstuid);
// end
// HTML // begin [file="/adminstudent3.jsp";from=(154,36);to=(162,8)]
out.write("\r\n </div></td>\r\n </tr>\r\n <tr bordercolor=\"#006666\">\r\n <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n <div align=\"right\">学生姓名</div></td>\r\n <td colspan=\"2\" background=\"images/bg.gif\">\r\n <!--<input name=\"stuname\" type=\"text\" id=\"stuname2\">-->\r\n\t\t\t\t\t\t\t\t");
// end
// begin [file="/adminstudent3.jsp";from=(162,10);to=(162,108)]
out.print("<input name=\"stuname\" type=\"text\" id=\"stuname2\" value = \""+temstuname+"\">" );
// end
// HTML // begin [file="/adminstudent3.jsp";from=(162,110);to=(174,10)]
out.write("\r\n </td>\r\n </tr>\r\n <tr bordercolor=\"#006666\">\r\n <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n <div align=\"right\">学号</div></td>\r\n <td colspan=\"2\" background=\"images/bg.gif\">\r\n <table width=\"195\" height=\"28\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td width=\"69\">\r\n <div align=\"left\">\r\n <!-- <input name=\"stuno\" type=\"text\" id=\"stuno\" size=\"8\">-->\r\n\t\t\t\t\t\t\t\t\t\t");
// end
// begin [file="/adminstudent3.jsp";from=(174,12);to=(174,114)]
out.print("<input name=\"stuno\" type=\"text\" size=\"8\" id=\"stuno\" value = \""+temstuno+"\">" );
// end
// HTML // begin [file="/adminstudent3.jsp";from=(174,116);to=(180,40)]
out.write("\r\n\r\n </div>\r\n <div align=\"right\"> </div></td>\r\n <td width=\"30\" class=\"bbb\"><div align=\"right\">年级</div></td>\r\n <td width=\"96\" class=\"bbb\"><select name=\"stugrade\" id=\"stugrade\">\r\n ");
// end
// begin [file="/adminstudent3.jsp";from=(180,42);to=(193,40)]
String tem[] = new String[4];
tem[0]= new String("大一");
tem[1]= new String("大二");
tem[2]= new String("大三");
tem[3]= new String("大四");
for (int i = 0; i < 4; i++){
if(i== Integer.parseInt(temstugrade)-1)
{out.print("<option selected>" + tem[i].trim() + "</option>");
System.out.println("qqqqqqqqqqqqqqqq");}
else
out.print("<option>" + tem[i].trim() + "</option>");
}
// end
// HTML // begin [file="/adminstudent3.jsp";from=(193,42);to=(205,8)]
out.write("\r\n\r\n\r\n </select></td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n <tr bordercolor=\"#006666\">\r\n <td height=\"28\" background=\"images/bg.gif\" class=\"bbb\">\r\n <div align=\"right\">初始密码</div></td>\r\n <td colspan=\"2\" bordercolor=\"#006666\" background=\"images/bg.gif\">\r\n <!-- <input name=\"stupsw\" type=\"text\" id=\"stupsw\" value=\"123\">-->\r\n\t\t\t\t\t\t\t\t");
// end
// begin [file="/adminstudent3.jsp";from=(205,10);to=(205,104)]
out.print("<input name=\"stupsw\" type=\"text\" id=\"stupsw\" value = \""+temstupsw+"\">" );
// end
// HTML // begin [file="/adminstudent3.jsp";from=(205,106);to=(214,134)]
out.write("\r\n </td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td width=\"83\">\r\n <div align=\"center\">\r\n <input name=\"tijiao\" type=\"submit\" id=\"tijiao\" value=\"修改\">\r\n</div></td>\r\n <td width=\"112\" valign=\"baseline\" bordercolor=\"#006666\"> <div align=\"left\">");
// end
// begin [file="/adminstudent3.jsp";from=(214,136);to=(214,210)]
out.print("<a href='adminstudent5.jsp?delpage=" +temstuid + "'>删除信息</a>");
// end
// HTML // begin [file="/adminstudent3.jsp";from=(214,212);to=(272,7)]
out.write("</div></td>\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t</tr>\r\n </table>\r\n </form>\r\n </div></td>\r\n </tr>\r\n </table>\r\n <br>\r\n </div></td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n <TD ROWSPAN=2> <IMG SRC=\"images/temp_07.jpg\" WIDTH=5 HEIGHT=455></TD>\r\n </TR>\r\n <TR>\r\n <TD>\r\n <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"229\" background=\"images/left_bottom.jpg\">\r\n <tr>\r\n <td width=\"231\" height=\"222\" valign=\"top\"><div align=\"center\">\r\n <p><font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"admincourse.jsp\">【课程分配】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\"><a href=\"adminscore.jsp\">【成绩录入】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\">【购书管理】</div></td>\r\n </tr>\r\n </table>\r\n <br>\r\n <br>\r\n <table width=\"200\" border=\"0\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"adminlyb.jsp\">查看留言</a></div></td>\r\n </tr>\r\n </table>\r\n <p align=\"center\"><br>\r\n <a href=\"index1.htm\" class=\"ccc\">[退出系统]</a></p>\r\n </div>\r\n </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <IMG SRC=\"images/temp_09.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <img src=\"images/temp_10.jpg\" width=752 height=20></TD>\r\n </TR>\r\n</TABLE>\r\n</BODY>\r\n</HTML>");
// end
} catch (Throwable t) {
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -