?? quertstudent.jsp
字號:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<jsp:directive.page import="sql.SQLPag"/>
<jsp:directive.page import="javabean.JavaBean;"/>
<jsp:useBean id="pages" scope="page" class="javabean.JavaPag"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%!
int pageSize=5;//每頁記錄數
String sqlStr="";
String sqlTabel="";
int showPage=1;//當前頁
%>
<%
sqlStr="select * from users where property='student'";
sqlTabel="users";
session.setAttribute("sqlTabel",sqlTabel);
String strPage=null;
pages.initialize(sqlStr,pageSize);
strPage=request.getParameter("showPage");//最下面的提交跳轉
if(strPage==null)
{
showPage=1;
}
else
{
try
{
showPage=Integer.parseInt(strPage);
}
catch(NumberFormatException ex)
{
showPage=1;
}
if(showPage<1)
{
showPage=1;
}
if(showPage>pages.getPageCount())
{
showPage=pages.getPageCount();//JavaBean.java中的方法 獲得邏輯頁數
}
}
//取的要顯示的數據集合
Vector vData=pages.getPage(showPage); //JavaBean.java中的方法傳入參數為當前頁數
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>學生信息</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body bgcolor="#50DBD6">
<h1 align=center>學生信息</h1>
<div align=center>
<table border="1" cellspacing="0" cellpadding="0" width="80%">
<tr align="center">
<th width=12%>帳號</th>
<th width=12%>姓名</th>
<th width=12%>屬性</th>
<th width=12%>年齡</th>
<th width=12%>性別</th>
<th width=12%>班級</th>
<th width=12%>操作</th>
</tr>
<%
for(int i=0;i<vData.size();i++)
{
//顯示數據數
String[] sData=(String[])vData.get(i);
%>
<tr align="center">
<td><%=sData[0]%></td>
<td><%=sData[1]%></td>
<td><%=sData[3]%></td>
<td><%=sData[4]%></td>
<td><%=sData[5]%></td>
<td><%=sData[6]%></td>
<td><a href="http://127.0.0.1:8080/project/Delete?id=<%=sData[0]%>" onclick="return check();">刪除記錄</a>
</tr>
<%} %>
</table>
<p>
<form action="Admin/QuertStudent.jsp" method="get" target="_self">
<p>共<font color=red><%=pages.getRowCount()%></font>條 <%=pageSize%>條/頁 第<font color=red><%=showPage%></font>頁/共<font color=red><%=pages.getPageCount()%></font>頁 [<a href="Admin/QuertStudent.jsp?showPage=1" target="_self">首頁</a>]
<%
//判斷“上一頁”連接是否要顯示
if(showPage>1){
%>
[<a href="Admin/QuertStudent.jsp?showPage=<%=showPage-1%>" target="_self">上一頁</a>]
<%
}
else{
%>
[上一頁]
<%}
//判斷下一頁是否連接
if(showPage<pages.getPageCount())
{
%>
[<a href="Admin/QuertStudent.jsp?showPage=<%=showPage+1%>" target="_self">下一頁</a>]
<%
}
else{
%>
[下一頁]
<%} %>
[<a href="Admin/QuertStudent.jsp?showPage=<%=pages.getPageCount()%>" target="_self">尾頁</a>] 轉到
<select name="select">
<%
for(int x=1;x<pages.getPageCount();x++)
{
%>
<option value="<%=x %>"
<%
if(showPage==x){
out.println("selected");
}
%>><%=x %></option>
<%} %>
</select>
頁
<input type="submit" name="go" value="提交"/>
</p>
</form>
</div>
</body>
</html>
<script language="javascript">
function check()
{
if(confirm("刪除確認"))
{
return true;
}
return false;
}
</script>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -