📄 adminscore_0002ejsp_jsp.java
字号:
titlelist = new String[99999];
String strSQL = "select stuid ,stuname from student ";
ResultSet rs = subject.executeQuery(strSQL);
int length = 0;
while(rs.next())
{
String id = rs.getString("stuid");
String title = rs.getString("stuname").trim();
titlelist[length] = title;
length++;
}
// end
// HTML // begin [file="/adminscore.jsp";from=(16,2);to=(17,0)]
out.write("\r\n");
// end
// begin [file="/adminscore.jsp";from=(17,2);to=(30,0)]
String titlelist1[];
titlelist1 = new String[99999];
String strSQL1 = "select teaid ,teaname from teacher ";
ResultSet rs1 = subject.executeQuery(strSQL1);
int length1 = 0;
while(rs1.next())
{
String id1 = rs1.getString("teaid");
String title1 = rs1.getString("teaname").trim();
titlelist1[length1] = title1;
length1++;
}
// end
// HTML // begin [file="/adminscore.jsp";from=(30,2);to=(32,0)]
out.write("\r\n\r\n");
// end
// begin [file="/adminscore.jsp";from=(32,2);to=(45,0)]
String titlelist2[];
titlelist2 = new String[99999];
String strSQL2 = "select couid ,couname from course ";
ResultSet rs2 = subject.executeQuery(strSQL2);
int length2 = 0;
while(rs2.next())
{
String id2 = rs2.getString("couid");
String title2 = rs2.getString("couname").trim();
titlelist2[length2] = title2;
length2++;
}
// end
// HTML // begin [file="/adminscore.jsp";from=(45,2);to=(148,28)]
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</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>>成绩录入<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=\"adminscore2.jsp\">\r\n <table width=\"253\" border=\"0\" bordercolor=\"#006666\">\r\n <tr bordercolor=\"#006666\">\r\n <td width=\"67\" 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 <select name=\"select\" id=\"select\">\r\n <option value=\"0\" selected>请选择学生</option>\r\n ");
// end
// begin [file="/adminscore.jsp";from=(148,30);to=(150,9)]
for (int i = 0; i < length; i++)
out.print("<option>" + titlelist[i].trim() + "</option>");
// end
// HTML // begin [file="/adminscore.jsp";from=(150,11);to=(161,38)]
out.write("\r\n </select>\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 <div align=\"left\">\r\n <select name=\"select2\" id=\"select2\">\r\n <option selected>请选择教师</option>\r\n ");
// end
// begin [file="/adminscore.jsp";from=(161,40);to=(163,9)]
for (int i = 0; i < length1; i++)
out.print("<option>" + titlelist1[i].trim() + "</option>");
// end
// HTML // begin [file="/adminscore.jsp";from=(163,11);to=(173,71)]
out.write("\r\n </select> \r\n </div></td>\r\n </tr>\r\n <tr>\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 <div align=\"left\">\r\n <select name=\"select3\" id=\"select3\">\r\n <option selected>请选择课程</option>");
// end
// begin [file="/adminscore.jsp";from=(173,73);to=(175,9)]
for (int i = 0; i < length2; i++)
out.print("<option>" + titlelist2[i].trim() + "</option>");
// end
// HTML // begin [file="/adminscore.jsp";from=(175,11);to=(266,7)]
out.write("\r\n </select>\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 <table width=\"174\" height=\"28\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td width=\"69\">\r\n <div align=\"left\">\r\n <select name=\"select4\" id=\"select4\">\r\n <option value=\"1\">第一学年</option>\r\n <option value=\"2\">第二学年</option>\r\n <option value=\"3\">第三学年</option>\r\n <option value=\"4\">第四学年</option>\r\n <option selected>选择学年</option>\r\n </select>\r\n</div>\r\n <div align=\"right\"> </div></td>\r\n <td width=\"33\" class=\"bbb\"><div align=\"right\">成绩</div></td>\r\n <td width=\"72\" class=\"bbb\"><input name=\"select5\" type=\"text\" id=\"select5\" size=\"4\"></td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n <tr>\r\n <td> </td>\r\n <td width=\"65\">\r\n <div align=\"right\">\r\n <input name=\"tijiao\" type=\"submit\" id=\"tijiao\" value=\"提交\">\r\n </div></td>\r\n <td width=\"107\" bordercolor=\"#006666\"><div align=\"left\">\r\n <input name=\"chongzhi\" type=\"reset\" id=\"chongzhi\" value=\"重置\">\r\n </div></td>\r\n </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=\"adminstudent.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 + -