?? teachlessionman.jsp
字號(hào):
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.ResultSet,util.commonTag"%>
<html>
<!--------接收輸入?yún)?shù)---------->
<%//-------接收l(shuí)ession_id和teacher_id參數(shù)------------
int lession_id=0;
int teacher_id=0;
try{
lession_id=Integer.parseInt(request.getParameter("lession_id"));
teacher_id=Integer.parseInt(request.getParameter("teacher_id"));
}catch(Exception e)
{}
%>
<body bgcolor="#DCDADA">
<!---------導(dǎo)航菜單------------->
<table border="0" width="100%">
<tr>
<td width="100%">
<p align="left">您當(dāng)前所在位置：教師授課信息管理-->查詢和維護(hù)教師授課信息</p>
</td>
</tr>
<jsp:include page="navigator.txt"/>
</table>
<!---------數(shù)據(jù)輸入------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<tr>
<td width="100%">
<table border="0" width="100%">
<tr>
<td width="100%" colspan="5">輸入查詢條件：<br><hr></td>
</tr>
<form name="add_teachlession_form" action="teachlessionman.jsp" method="post">
<tr>
<td width="33%" align="right">授課教師：</td>
<td width="13%">
<%//-----生成教師下拉框------
commonTag classtag=new commonTag();
out.println(classtag.getTeacherTag(teacher_id));
%>
</td>
<td width="7%" align="right">課程：</td>
<td width="17%">
<%//-----生成課程下拉框------
out.println(classtag.getLessionTag(lession_id));
%>
</td>
<td width="30%"><input type="submit" value="提交"></td>
</tr>
</form>
</table>
</td>
</tr>
</table><br>
<!---------數(shù)據(jù)輸出------------->
<table border="1" width="100%" cellspacing="0" cellpadding="0" bordercolor="#808080" bordercolorlight="#808080" bordercolordark="#808080">
<jsp:useBean id="teachlession_select" class="teachlessionman.teachlession_operation" scope="page"/>
<%//-----用JavaBean查詢出數(shù)據(jù)，并得到總記錄條數(shù)------
ResultSet rs=teachlession_select.teachlession_select_part(lession_id,teacher_id);
rs.last();
int rowCount=rs.getRow();
rs.beforeFirst();
%>
<jsp:useBean id="teachlession_rsFenYe" class="util.rsFenYe" scope="page"/>
<jsp:setProperty name="teachlession_rsFenYe" property="rs" value="<%=rs%>"/>
<!-------pageSize為每頁(yè)記錄條數(shù)--------->
<jsp:setProperty name="teachlession_rsFenYe" property="pageSize" value="10"/>
<tr>
<td colspan="5" align="center">
<%//-----從請(qǐng)求參數(shù)中得到當(dāng)前頁(yè)碼------
String currentPage=request.getParameter("currentPage");
try{
teachlession_rsFenYe.setCurrentPage(Integer.parseInt(currentPage));
}catch(Exception e)
{//如果參數(shù)不正確，設(shè)置當(dāng)前頁(yè)碼為1
teachlession_rsFenYe.setCurrentPage(1);
}
%>
所有教師授課信息(共<%=rowCount%>條)
<%
String refName[]={"lession_id","teacher_id"};
String refValue[]={lession_id+"",teacher_id+""};
out.print(teachlession_rsFenYe.earn_fenyi_string("teachlessionman.jsp",refName,refValue));
%>
</td>
</tr>
<tr>
<td width="20%" align="center">教師授課信息序號(hào)</td>
<td width="15%" align="center">教師姓名</td>
<td width="25%" align="center">所教課程</td>
<td width="20%" align="center">修改？</td>
<td width="20%" align="center">刪除？</td>
</tr>
<%for(int i=0;i<teachlession_rsFenYe.getPageSize()&&rs.next();i++){%>
<tr>
<td align="center" width="132"><%=rs.getLong("teachlession_id")%></td>
<td align="center" width="163"><%=rs.getString("teacher_name")%></td>
<td align="center" width="234"><%=rs.getString("lession_name")%></td>
<td align="center" width="176">
<a href='teachlession_update1.jsp?teachlession_id=<%=rs.getLong("teachlession_id")%>&lession_id=<%=rs.getLong("lession_id")%>&teacher_id=<%=rs.getLong("teacher_id")%>'>修改</a>
</td>
<td align="center" width="176">
<a href="teachlession_delete.jsp?teachlession_id=<%=rs.getLong("teachlession_id")%>" onclick="return delete_confirm()">×</a>
</td>
</tr>
<%
}
%>
</table><br>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -