📄 listteacher.jsp
字号:
<%
/*
程序员:苏楠
用途:老师列表
时间:2003-8-19 10:30
*/
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding
String PrivXP="浏览教师信息";
String PrivME="00204";
String PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>
<link href="../css/style.css" rel="stylesheet" type="text/css">
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool" />
<%
/* String rank=request.getParameter("rank");
if (rank == null || rank.equals(""))
rank = "id";
*/
String query="select id,name,teach_level,phone,status,gender from lrn_teacher_info order by reg_time desc";
//out.print(query);
//String query="select teacher_id,teacher_name,teach_level,address,zip_code,phone,status,gender,site,site_name from (select a.id as teacher_id,a.name as teacher_name,a.teach_level as teach_level,a.address as address,a.zip_code as zip_code,a.phone as phone,a.status as status,a.gender as gender,a.site as site,b.name as site_name from lrn_teacher_info a,lrn_site_info b where a.site=b.id (+) order by a." + rank + ")";
/*if(!admin_site_id.equals("0000"))
{
query = "select teacher_id,teacher_name,teach_level,address,zip_code,phone,status,gender,site,site_name from (select a.id as teacher_id,a.name as teacher_name,a.teach_level as teach_level,a.address as address,a.zip_code as zip_code,a.phone as phone,a.status as status,a.gender as gender,a.site as site,b.name as site_name from lrn_teacher_info a,lrn_site_info b where a.site='" + admin_site_id + "' and a.site=b.id order by a." + rank + ")";
}
*/
//----------分页开始---------------
int pagesize =0;
int totalItems = work.countselect(query);
String temp_pagesize = (String)session.getValue("pagesize");
if (temp_pagesize == null || temp_pagesize.length() == 0 || temp_pagesize.equals("null"))
{
pagesize = 10;
}
else
{
pagesize = Integer.parseInt(temp_pagesize);
}
String spageInt = request.getParameter("pageInt");
if(null == spageInt || spageInt.equals(""))
spageInt = "1";
int pageInt = Integer.parseInt(spageInt);
if (totalItems <= (pageInt - 1) * pagesize)
{
pageInt = pageInt - 1;
if(pageInt < 1)
{
pageInt = 1;
}
}
int maxPage = (totalItems + pagesize - 1) / pagesize;
if(pageInt > maxPage)
pageInt = maxPage;
int pageNext = pageInt + 1;
int pageLast = pageInt - 1;
String link="";
//----------分页结束---------------
com.dbConnection.MyResultSet RS=work.execute_oracle_page(query,pageInt,pagesize);
//com.dbConnection.MyResultSet RS=work.executeQuery(query);
int row_count=0;
%>
<html><head><title>教师列表</title></head>
<body topmargin=0 leftmargin=0 bgcolor=FFFFFF>
<table width="80%" border="0" align=center cellpadding="2" cellspacing="1" bgcolor="3F6C61">
<tr class="t08_bgwhite_p2"><td colspan="9" align="center">教师列表</td><tr>
<tr><td class="t12_14_bgE3EAE9">教师ID</td>
<td class="t12_14_bgE3EAE9">教师姓名</td>
<td class="t12_14_bgE3EAE9">性别</td>
<td class="t12_14_bgE3EAE9">类别</td>
<td class="t12_14_bgE3EAE9">电话</td>
<td class="t12_14_bgE3EAE9">教师状态</td>
</tr>
<%
//while(RS != null && RS.next())
while(RS != null && RS.next())
{
String id=RS.getString("id");
String name=RS.getString("name");
String teach_level=RS.getString("teach_level");
String phone=RS.getString("phone");
String status=RS.getString("status");
String gender=RS.getString("gender");
String sstatus=status;
if(status.equals("0000")){
sstatus="有效";
}
if(status.equals("1111")){
sstatus="无效";
}
if(status.equals("2222")){
sstatus="过期";
}
%>
<tr> <td class="t08_bgwhite_p2"><%=id%></td>
<td class="t08_bgwhite_p2"><a href="teacher_edit.jsp?id=<%=id%>&pageInt=<%=pageInt%>"><%=name%></a></td>
<td class="t08_bgwhite_p2"><%=gender%></td>
<td class="t08_bgwhite_p2"><%=teach_level%></td>
<td class="t08_bgwhite_p2"><%=phone%></td>
<td class="t08_bgwhite_p2"><%=sstatus%>|<%
if(status.equals("0000")){
%>
<!-- <a href="courseteacher.jsp?id=<%=id%>&name=<%=name%>"> 承担课程</a>-->
<%
}
%></td>
</tr>
<%}
work.close(RS);
%>
</table>
<%@ include file="../pub/dividepage.jsp" %>
<p align=center><a href="teacher_main.jsp">返回管理界面</a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -