<%@ page contenttype="text/html; charset=gb2312" language="java"%>
<%@ page import = "java.util.*"%>
<%@ page import = "java.io.*"%>
<%@ page import = "java.sql.*"%>
<html>
<head>
<title>教師信息查詢</title>
<style type="text/css">
<!--
.style1 {
font-family: "華文行楷";
color: #ffffff;
}
-->
</style>
<link href="default.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style6 {
color: #000000;
font-size: 24px;
}
.style9 {font-size: 24px}
-->
</style>
</head>
<body bgcolor="#ffffff">
<%session.getattribute("a_name");%>
<h1 align="center" class="style1 style6 style9">教師信息查詢</h1>
<hr />
<jsp:usebean id="tmessgebean" scope="page" class="computer.sqlbean"/>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr align="center" bgcolor="#00ffff">
<td colspan="5" bgcolor="#666666" class="style4"><div align="right"><a href="index.html">返回首頁</a></div></td>
</tr>
<tr align="center" bgcolor="#999999">
<td class="style4">教號</td>
<td class="style4">姓名</td>
<td class="style4">系別</td>
<td class="style4">專業</td>
<td class="style4">操作選項</td>
</tr>
<%
request.setcharacterencoding("gb2312");
int nowpages;//當前頁
int pages;//請求頁數
int countperpage = 10 ; //每頁顯示條數
int pagecount;//總頁數
int recordcount=tmessgebean.getcounter("select count(*) from dysf_teacher ");
pagecount = (int)math.ceil((recordcount + countperpage-1) / countperpage);//算出總頁數
if(request.getparameter("pages") == null){
pages = 1;
}else{
pages = new integer(request.getparameter("pages")).intvalue();
}
if(pages > pagecount){
nowpages = 1;
}else{
nowpages = pages;
}
resultset rs = tmessgebean.executequery("select top "+ countperpage +" * from dysf_teacher where id not in (select top "+ (nowpages-1)*countperpage +" id from dysf_teacher order by id desc) order by id desc ");
while(rs.next()){
string id = rs.getstring("id");
string tdepartment = rs.getstring("department");
string tspecial = rs.getstring("special");
string tname = rs.getstring("name");
%>
<tr>
<td width="20%" align="center"><%= id %></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tname %></div></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tdepartment %></div></td>
<td width="20%"><div align="center"></div>
<div align="center"><%= tspecial %></div></td>
<td align="center"><a href="atdelete.jsp?id=<%= id %>">刪除</a></td>
</tr>
<%
}
rs.close();
%>
<tr align="right">
<td colspan="5">共有<font color=red><%= recordcount %></font>條記錄 當前<font color=red><%= nowpages %>/<%= pagecount %></font>頁
<% if(pagecount > 1){ %>
<% if(pages > 1){%>
<a href="">首頁</a>
<%}if(pages < pagecount){%>
<a href="?pages=<%= nowpages+1 %>">下一頁</a>
<%}if(pages != 1){%>
<a href="?pages=<%= nowpages - 1 %>">上一頁</a>
<%}%>
<a href="?pages=<%= pagecount %>">尾頁</a>
<% } %>跳轉到
<select name="pages" onchange="javascript:this.form.submit();">
<% for(int i=1;i<=pagecount;i++){%>
<option value="<%= i %>" <% if(nowpages == i){%>selected<% } %>><%= i %></option>
<% } %>
</select>頁</td>
</tr>
</table>
<hr />
</body>
</html>
新聞熱點
疑難解答
