📄 studentcjcx3_0002ejsp_jsp.java
字号:
out.write("\r\n");
// end
// HTML // begin [file="/studentcjcx3.jsp";from=(30,2);to=(126,49)]
out.write("\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\tfont-size: 12px;\r\n\tcolor: #FFFFFF;\r\n\tfont-weight: bold;\r\n}\r\na {\r\n\tfont-size: 12px;\r\n\tcolor: #FFFFFF;\r\n}\r\na:visited {\r\n\tcolor: #FFFFFF;\r\n}\r\n.style1 {font-size: 14px}\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\">\r\n <div align=\"center\">\r\n <p> </p>\r\n <p> </p>\r\n <p> 总选课单 <br>\r\n <br>\r\n <br>\r\n <font color=\"#2DFFFF\" size=\"5\"><strong> </strong></font></p>\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"studentwsxk.jsp\">【网上选课】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\"><a href=\"studentcjcx.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 <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\">\r\n <div align=\"left\"></div> <table width=\"91%\" height=\"66\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td height=\"2\" colspan=\"7\">\r\n <p> <a href=\"index1.htm\">首页</a>><a href=\"index1.jsp\">学生</a>><a href=\"studentcjcx.jsp\">成绩查询</a><br>\r\n <br>\r\n</p>\r\n <div align=\"center\"></div></td>\r\n </tr>\r\n <tr>\r\n <td height=\"3\" colspan=\"7\">");
// end
// begin [file="/studentcjcx3.jsp";from=(126,51);to=(134,0)]
String sql = "select stuname from student where stuid = '"+session.getValue("wnum")+"'";
ResultSet rs=subject.executeQuery(sql);
while (rs.next())
{
out.print(rs.getString("stuname"));
teaname = rs.getString("stuname");
}
// end
// HTML // begin [file="/studentcjcx3.jsp";from=(134,2);to=(153,26)]
out.write("\r\n同学 ：</td>\r\n </tr>\r\n <tr>\r\n <td height=\"5\" colspan=\"7\"><div align=\"center\">您所查询的学期所有课程成绩如下<br>\r\n <br>\r\n </div></td>\r\n </tr>\r\n <tr>\r\n <td width=\"10%\" height=\"11\"><div align=\"center\"></div></td>\r\n <td width=\"12%\"> </td>\r\n <td width=\"19%\"><div align=\"center\">课程名称</div></td>\r\n <td width=\"23%\"><div align=\"center\"></div></td>\r\n <td width=\"13%\"><div align=\"center\">成绩</div></td>\r\n <td width=\"12%\"><div align=\"center\"></div></td>\r\n <td width=\"11%\"><div align=\"center\"></div></td>\r\n </tr>\r\n <tr>\r\n <td height=\"22\" colspan=\"7\"><div align=\"left\"><br>\r\n ");
// end
// begin [file="/studentcjcx3.jsp";from=(153,28);to=(196,0)]
String temterm = new String (request.getParameter("select2"));
temterm=temterm.trim();
temterm=trans(temterm);
System.out.println (temterm);
String temcouid = new String();
String temcouname = new String();
String result = new String();
String term = new String();
int temno=0;
/*String sql1 = "select couid,term from course where couname = '"+couname+"'";
ResultSet rs1 = subject.executeQuery(sql1);
while(rs1.next())
{
temcouid = rs1.getString("couid");
}
rs1.close();*/
String sql2 = "select result,couid from score where term = '"+temterm+"'and stuid = '"+session.getValue("wnum")+"'";
ResultSet rs2 = subject.executeQuery(sql2);
while(rs2.next())
{temno=1;
result = rs2.getString("result");
temcouid = rs2.getString("couid");
String sql1 = "select couname from course where couid = '"+temcouid+"'";
ResultSet rs1 = subject.executeQuery(sql1);
while(rs1.next())
{
temcouname = rs1.getString("couname");
out.print(" ");
out.print(" ");
out.print(temcouname);
out.print(" ");
out.print(" ");
out.print(" ");
out.print(result);
out.print("<br><br>");
}
rs1.close();
}
rs2.close();
if (temno==0)
response.sendRedirect("studentcjcxerr2.htm");
// end
// HTML // begin [file="/studentcjcx3.jsp";from=(196,2);to=(198,0)]
out.write("\r\n\r\n");
// end
// begin [file="/studentcjcx3.jsp";from=(198,2);to=(228,6)]
/*//String sql2 = "select couid,couname,coumark,couback from course where couid in (select couid from tc where teaid = '"+session.getValue("wnum")+"')";
String sql2 = "select scid,teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
ResultSet rs2=subject.executeQuery(sql2);
while (rs2.next())
{ temscid = rs2.getInt("scid");
out.print (" ");
out.print ("<a href='studentxkd2.jsp?tuixuan=" +temscid + "'>退选</a>");
teaid1 = rs2.getString("teaid");
String sql4 = "select teaname from teacher where teaid = '"+teaid1+"'";
ResultSet rs4 = subject.executeQuery(sql4);
while (rs4.next())
{
out.print (" ");
out.print (rs4.getString("teaname"));
}
couid1 = rs2.getString("couid");
//out.print("tttt");
String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
ResultSet rs3=subject.executeQuery(sql3);
while (rs3.next())
{out.print(" ");
out.print(rs3.getString("couback"));
out.print(" ");
out.print(rs3.getString("couname"));
out.print(" ");
out.print(rs3.getString("coumark"));
//out.print(rs3.getString("couback"));
} */
// end
// HTML // begin [file="/studentcjcx3.jsp";from=(228,8);to=(231,31)]
out.write("\r\n <br>\r\n <br>\r\n (以上为第");
// end
// begin [file="/studentcjcx3.jsp";from=(231,33);to=(231,52)]
out.print(temterm);
// end
// HTML // begin [file="/studentcjcx3.jsp";from=(231,54);to=(275,7)]
out.write("\r\n 学年成绩)<br>\r\n </div></td></tr>\r\n <tr>\r\n <td colspan=\"7\"> </td>\r\n </tr>\r\n </table></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\">\r\n <div align=\"center\">\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"lyb.jsp\">【留言板】</a></div></td>\r\n </tr>\r\n </table>\r\n <p> <font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n <p> </p>\r\n <p> <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n <p class=\"aaa\"><a href=\"index1.htm\" class=\"style1\">[退出系统]</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 + -