📄 teacherqbkb_0002ejsp_jsp.java
字号:
out.print("<a href='teacherqbkb.jsp?page=" + (intPage+1) +"'>[后页] </a>");
out.print("<a href='teacherqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
}
if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
out.print("<a href='teacherqbkb.jsp?page=" + (intPage-1) + "'>[前页] </a>");
if(intPage == 1)
{
out.print("<a href='teacherqbkb.jsp?page=" + (intPage+1) +"'>[后页] </a>");
out.print("<a href='teacherqbkb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
}
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(133,2);to=(136,29)]
out.write("\r\n\r\n\r\n 页次：");
// end
// begin [file="/teacherqbkb.jsp";from=(136,32);to=(136,43)]
out.print(currentPage);
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(136,45);to=(136,46)]
out.write("/");
// end
// begin [file="/teacherqbkb.jsp";from=(136,49);to=(136,86)]
out.print((totalRecord+PageNumbers)/PageNumbers);
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(136,88);to=(136,89)]
out.write(" ");
// end
// begin [file="/teacherqbkb.jsp";from=(136,92);to=(136,103)]
out.print(PageNumbers);
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(136,105);to=(154,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\"><br>\r\n 授课教师</td>\r\n <td width=\"107\">课程说明</td>\r\n <td width=\"58\">课程名</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="/teacherqbkb.jsp";from=(154,5);to=(198,1)]
String sql2 = "select tcid,teaid,couid from tc order by tcid desc";
ResultSet rs2=sts.executeQuery(sql2);
String tmpteaid = new String();
String tmpcouid = new String();
int i=0;
int tmpid;
while (rs2.next())
{
if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
{
tmpid =rs2.getInt("tcid");
couid1 = rs2.getString("couid");
teaid1 = rs2.getString("teaid");
//out.print("tttt");
String sql4 = "select teaid,teaname from teacher where teaid = '"+teaid1+"'";
ResultSet rs4=sts.executeQuery(sql4);
while (rs4.next())
{
out.print(rs4.getString("teaname"));
tmpteaid = rs4.getString("teaid");
}
out.print(" ");
String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
ResultSet rs3=sts.executeQuery(sql3);
while (rs3.next())
{//out.print(" ");
//out.print(rs3.getString("couid"));
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="/teacherqbkb.jsp";from=(198,3);to=(200,6)]
out.write("\r\n\t <br>\r\n ");
// end
// begin [file="/teacherqbkb.jsp";from=(200,8);to=(202,3)]
//if (signing==0){out.print(" <a href='studentwsxk2.jsp?xuan=" +tmpid + "'>选课</a>");}
//else {out.print(" 已选择");}
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(202,5);to=(206,3)]
out.write("\r\n\r\n\t <br>\r\n\t <br>\r\n\t ");
// end
// begin [file="/teacherqbkb.jsp";from=(206,5);to=(214,1)]
}
}signing = 0;
i++;
}
//out.print(rs3.getString("couback"));
// end
// HTML // begin [file="/teacherqbkb.jsp";from=(214,3);to=(255,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>\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> </p>\r\n <p><br>\r\n <font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n <br>\r\n <p align=\"center\"><br>\r\n <a href=\"index1.htm\" class=\"style3\">[退出系统]</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 + -