📄 studentqbkb_0002ejsp_jsp.java
字号:
out.print("<a href='studentqbkb.jsp?page=" + (intPage+1) +"'>[后页] </a>");
out.print("<a href='studentqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
}
// end
// HTML // begin [file="/studentqbkb.jsp";from=(135,2);to=(138,29)]
out.write("\r\n\r\n\r\n 页次：");
// end
// begin [file="/studentqbkb.jsp";from=(138,32);to=(138,43)]
out.print(currentPage);
// end
// HTML // begin [file="/studentqbkb.jsp";from=(138,45);to=(138,46)]
out.write("/");
// end
// begin [file="/studentqbkb.jsp";from=(138,49);to=(138,86)]
out.print((totalRecord+PageNumbers)/PageNumbers);
// end
// HTML // begin [file="/studentqbkb.jsp";from=(138,88);to=(138,89)]
out.write(" ");
// end
// begin [file="/studentqbkb.jsp";from=(138,92);to=(138,103)]
out.print(PageNumbers);
// end
// HTML // begin [file="/studentqbkb.jsp";from=(138,105);to=(155,3)]
out.write("篇/页</span></td>\r\n </tr>\r\n\r\n <tr>\r\n <td colspan=\"5\"></td>\r\n </tr>\r\n <tr valign=\"bottom\">\r\n <td width=\"103\" height=\"26\"><div align=\"right\">授课学年</div></td>\r\n <td width=\"107\"><div align=\"center\">课程名</div></td>\r\n <td width=\"58\"><div align=\"center\">成绩</div></td>\r\n <td width=\"71\"><div align=\"right\"></div></td>\r\n <td width=\"122\"> </td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"5\">\r\n\t<br>\r\n\t<form name=\"form1\" method=\"post\" action=\"\">\r\n\t ");
// end
// begin [file="/studentqbkb.jsp";from=(155,5);to=(178,63)]
String sql2 = "select couid,term,result from score where stuid = '"+session.getValue("wnum")+"' order by term asc";
ResultSet rs2=sts.executeQuery(sql2);
int i=0;
int tmpid;
while (rs2.next())
{
if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
{
//tmpid =rs2.getInt("tcid");
temcouid = rs2.getString("couid");
temterm = rs2.getString("term");
temresult = rs2.getString("result");
//out.print("tttt");
String sql4 = "select couname from course where couid = '"+temcouid+"'";
ResultSet rs4=sts.executeQuery(sql4);
while (rs4.next())
{
temcouname =rs4.getString("couname");
//tmpteaid = rs4.getString("teaid");
}
out.print(" ");
// end
// HTML // begin [file="/studentqbkb.jsp";from=(178,65);to=(178,66)]
out.write("第");
// end
// begin [file="/studentqbkb.jsp";from=(178,68);to=(178,87)]
out.print(temterm);
// end
// HTML // begin [file="/studentqbkb.jsp";from=(178,89);to=(178,91)]
out.write("学年");
// end
// begin [file="/studentqbkb.jsp";from=(178,93);to=(203,1)]
out.print(" ");out.print(temcouname);
out.print(" ");out.print(temresult);
out.print("<br>");out.print("<br>");out.print("<br>");
/*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
ResultSet rs3=sts.executeQuery(sql3);
while (rs3.next())
{
tmpcouid = rs3.getString("couid");
out.print(rs3.getString("couback"));
out.print(" ");
out.print(rs3.getString("couname"));
out.print(" ");
out.print(rs3.getString("coumark"));
String sql5 = "select teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
ResultSet rs5 = sts.executeQuery(sql5);
while (rs5.next())
{
if (tmpteaid.trim().equals(rs5.getString("teaid"))&&tmpcouid.trim().equals(rs5.getString("couid")))
{
signing = 1;
}
}//out.print(" <input name="1" type="checkbox" id="1" value="1">");
// end
// HTML // begin [file="/studentqbkb.jsp";from=(203,3);to=(205,6)]
out.write("\r\n\t <br>\r\n ");
// end
// begin [file="/studentqbkb.jsp";from=(205,8);to=(207,3)]
//if (signing==0){out.print(" <a href='studentwsxk2.jsp?xuan=" +tmpid + "'>选课</a>");}
//else {out.print(" 已选择");}
// end
// HTML // begin [file="/studentqbkb.jsp";from=(207,5);to=(211,3)]
out.write("\r\n\r\n\t <br>\r\n\t <br>\r\n\t ");
// end
// begin [file="/studentqbkb.jsp";from=(211,5);to=(219,1)]
}*/
}//signing = 0;
i++;
}
//out.print(rs3.getString("couback"));
// end
// HTML // begin [file="/studentqbkb.jsp";from=(219,3);to=(261,7)]
out.write("\r\n <br>\r\n\t </form>\r\n\t<br>\r\n\t\t\t<br></td>\r\n </tr>\r\n </table>\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><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> </p>\r\n <p> <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n <p class=\"aaa\"><a href=\"index1.htm\" class=\"style3\">[退出系统]</a></p>\r\n </div></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 + -