📄 teacherqbkb.jsp
字号:
<%@ page language = "java" contentType = "text/html;charset=gb2312"%>
<%@ page import = "java.sql.*" %>
<jsp:useBean id = "sts" scope = "page" class = "wsxk.ConDB" />
<% int signing =0;
int intPage;
int currentPage = 1;
int PageNumbers = 5;
if(request.getParameter("page")!= null && request.getParameter("page")!="")
{intPage = Integer.parseInt(request.getParameter("page"));
currentPage=intPage;}
else
intPage = 1;
int totalRecord = 0;
ResultSet counters = sts.executeQuery("select count(*) as tcid from tc");
if(counters.next())
{
totalRecord = Integer.parseInt(counters.getString("tcid"));
}
String couid1 = new String();
String teaid1 = new String();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="_notes/aaa.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
@import url("_notes/ccc");
.style1 {color: #FFFFFF}
body,td,th {
color: #FFFFFF;
font-weight: bold;
font-size: 12px;
}
a:link {
color: #FFFFFF;
}
a:visited {
color: #FFFFFF;
}
.style2 {
font-size: 12px;
color: #FFFFFF;
}
.style3 {font-size: 14px}
-->
</style>
</HEAD>
<BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
<br>
<br>
<TABLE WIDTH=750 height="500" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
<TR>
<TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
<TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
</TR>
<TR>
<TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
<TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
</TR>
<TR>
<TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
</TR>
<TR>
<TD height="225">
<table width="231" border="0" cellspacing="0" cellpadding="0" height="225" background="images/left_top.jpg">
<tr>
<td width="231" height="225" valign="bottom"><div align="center">
<p><br>
<font color="#2DFFFF" size="5"><strong><br>
</strong></font><strong>全部课表</strong><font color="#2DFFFF" size="5"><strong><br>
</strong></font><strong><span class="style2"><br>
<br>
<br>
</span></strong>
</p>
<table width="200" border="1">
<tr>
<td><div align="center"><a href="teacherkccx.jsp">【课程查询】</a></div></td>
</tr>
<tr>
<td><div align="center"><a href="teacherqbkb.jsp">【全部课表】</a></div></td>
</tr>
</table>
<p></p>
<p> <strong><font color="#2DFFFF" size="5"> </font></strong></p>
</div> </td>
</tr>
</table>
</TD>
<TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
<TD COLSPAN=5 ROWSPAN=2>
<table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
<tr>
<td width="510">
<table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
<tr>
<td width="510" height="78">
<div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
</td>
</tr>
<tr>
<td valign="top"> <div align="left">
<table width="483" height="204" border="0">
<tr>
<td height="14" colspan="5"><a href="index1.htm">首页</a>><a href="index2.jsp">教师</a>>全部课表</td>
</tr>
<tr>
<td height="16" colspan="5"><span class="style1">分页： 课程总数：<%=totalRecord%> <a href="teacherqbkb.jsp?page=1">[首页]</a>
<%
if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
{
out.print("<a href='teacherqbkb.jsp?page=" + (intPage-1) + "'>[前页] </a>");
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>");
}
%>
页次：<%=currentPage%>/<%=(totalRecord+PageNumbers)/PageNumbers%> <%=PageNumbers%>篇/页</span></td>
</tr>
<tr>
<td colspan="5"></td>
</tr>
<tr valign="bottom">
<td width="103" height="26"><br>
授课教师</td>
<td width="107">课程说明</td>
<td width="58">课程名</td>
<td width="71"><div align="right">学分</div></td>
<td width="122"> </td>
</tr>
<tr>
<td colspan="5">
<br>
<form name="form1" method="post" action="">
<%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">");
%>
<br>
<%//if (signing==0){out.print(" <a href='studentwsxk2.jsp?xuan=" +tmpid + "'>选课</a>");}
//else {out.print(" 已选择");}
%>
<br>
<br>
<%
}
}signing = 0;
i++;
}
//out.print(rs3.getString("couback"));
%>
<br>
</form>
<br>
<br></td>
</tr>
</table>
</div></td>
</tr>
</table>
</td>
</tr>
</table>
</TD>
<TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
</TR>
<TR>
<TD>
<table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
<tr>
<td width="231" height="222" valign="top"><div align="center">
<p> </p>
<p><br>
<font color="#2DFFFF" size="5"> </font></p>
<br>
<p align="center"><br>
<a href="index1.htm" class="style3">[退出系统]</a></p>
</div>
</td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
</TR>
<TR>
<TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
</TR>
</TABLE>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -