📄 delete.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<style type="text/css">
<!--
.STYLE1 {color: #006600}
.STYLE3 {color: #006600; font-weight: bold; }
-->
</style>
<body background= "images/1.bmp">
<%!
//每页显示的记录个数
int size = 16;
//当前页号
int p = 1;
//全部的页数
int totalPage = 1;
String str = "";
//显示页号为p的一页
public String printPage(ResultSet rs, int p, int size)
{
str = "";
//将访问游标定位到页号为p的页要显示的第一条记录的位置
try {
for(int k=0;k<(p-1)*size;k++)
rs.next();
}
catch(SQLException e) { }
for(int iPage=1; iPage<=size; iPage++) {
str += printRow(rs,iPage);
try {
if(!rs.next()) break;
}
catch(Exception e) { }
}
return str;
}
//显示单行记录
public String printRow( ResultSet rs ,int i)
{
String temp = "";
try {
if(i%2==1)
temp+="<tr bgcolor='#e7e7e7'>";
else
temp+="<tr bgcolor='#f7f7f7'>";
String id=rs.getString("id");
temp+="<td><a href='update.jsp?updateid="+id+"' target='left'>"+id+"</a></td>";
temp+="<td>"+rs.getString("name")+"</td>";
temp+="<td>"+rs.getString("sex")+"</td>";
temp+="<td>"+rs.getString("age")+"</td>";
temp+="<td>"+rs.getString("email")+"</td>";
temp+="<td align='center'><input type='checkbox' name='isdel' value='"+id+"'></td>";
temp += "</TR>";
}
catch(SQLException e) { }
return temp;
}
%>
<%
ResultSet rs=null;
rs = conn.executeQuery("select * from user order by id");
%>
<center>
<table width="80%" border="1" bordercolor="#6633FF" borderColorLight="#5e5e00" borderColorDark="#ffffec" >
<form method="post" action="dealdelete.jsp">
<table border="1" borderColorDark="#ffffec" borderColorLight="#5e5e00" width="80%">
<tr align="center" bordercolor="#6600CC" bgcolor="#FFCC66">
<th><span class="STYLE1">id号</span></th>
<th><span class="STYLE1">用户名</span></th>
<th><span class="STYLE1">性别</span></th>
<th><span class="STYLE1">年龄</span></th>
<th><span class="STYLE1">电子邮件</span></th>
<th><span class="STYLE1">是否删除</span></th>
<%
ResultSet rsTmp=null;
rsTmp = conn.executeQuery("select count(*) as mycount from user");
int totalrecord=0;
if(rsTmp.next())
totalrecord = rsTmp.getInt("mycount");
// 如果记录数是页数的整数倍
if(totalrecord % size ==0) totalPage = totalrecord / size;
// 如果最后还空余一页
else totalPage = (int) Math.floor( totalrecord / size ) + 1;
if(totalPage == 0) totalPage = 1;
rsTmp.close();
try {
if(request.getParameter("p")==null|| request.getParameter("p").equals(""))
{
if(session.getAttribute("deletep")==null)
p = 1;
else
p = ((Integer)session.getAttribute("deletep")).intValue();
}
else
{
p = Integer.parseInt(request.getParameter("p")); session.setAttribute("deletep",new Integer(p));
}
}
// 捕获用户从浏览器地址拦直接输入非数字信息而引出的异常
catch(NumberFormatException e) { p = 1;}
if(p < 1) p = 1;
if(p > totalPage) p = totalPage;
if(rs.next())
out.println(printPage(rs,p,size));
%>
</table>
<p>
<input type="submit" class="STYLE3" value="删除">
<input type="reset" class="STYLE3" value="重置">
</form>
<form Action="delete.jsp" Method="GET">
<%
for(int i=1;i<=totalPage;i++) {
out.println("<a href=delete.jsp?p=" + i + ">" + i + "</a> ");
}
%>
<p><span class="STYLE3">输入页数：</span>
<input name="p" type="text" class="STYLE3" size="3">
<span class="STYLE3">页数：</span><font color="red"><%=p%>/<%=totalPage%></font> </p>
</form>
</center>
<SCRIPT LANGUAGE="JavaScript">
<!-- Begin
fCol = '000000'; //face colour.
sCol = 'ff0000'; //seconds colour.
mCol = '000000'; //minutes colour.
hCol = '000000'; //hours colour.
H = '....';
H = H.split('');
M = '.....';
M = M.split('');
S = '......';
S = S.split('');
Ypos = 0;
Xpos = 0;
Ybase = 8;
Xbase = 8;
dots = 12;
ns = (document.layers)?1:0;
if (ns) {
dgts = '1 2 3 4 5 6 7 8 9 10 11 12';
dgts = dgts.split(' ');
for (i = 0; i < dots; i++) {
document.write('<layer name=nsDigits'+i+' top=0 left=0 height=30 width=30><center><font face=Arial,Verdana size=1 color='+fCol+'>'+dgts[i]+'</font></center></layer>');
}
for (i = 0; i < M.length; i++) {
document.write('<layer name=ny'+i+' top=0 left=0 bgcolor='+mCol+' clip="0,0,2,2"></layer>');
}
for (i = 0; i < H.length; i++) {
document.write('<layer name=nz'+i+' top=0 left=0 bgcolor='+hCol+' clip="0,0,2,2"></layer>');
}
for (i = 0; i < S.length; i++) {
document.write('<layer name=nx'+i+' top=0 left=0 bgcolor='+sCol+' clip="0,0,2,2"></layer>');
}
}
else {
document.write('<div style="position:absolute;top:0px;left:0px"><div style="position:relative">');
for (i = 1; i < dots+1; i++) {
document.write('<div id="ieDigits" style="position:absolute;top:0px;left:0px;width:30px;height:30px;font-family:Arial,Verdana;font-size:10px;color:'+fCol+';text-align:center;padding-top:10px">'+i+'</div>');
}
document.write('</div></div>')
document.write('<div style="position:absolute;top:0px;left:0px"><div style="position:relative">');
for (i = 0; i < M.length; i++) {
document.write('<div id=y style="position:absolute;width:2px;height:2px;font-size:2px;background:'+mCol+'"></div>');
}
document.write('</div></div>')
document.write('</div></div>')
document.write('<div style="position:absolute;top:0px;left:0px"><div style="position:relative">');
for (i = 0; i < H.length; i++) {
document.write('<div id=z style="position:absolute;width:2px;height:2px;font-size:2px;background:'+hCol+'"></div>');
}
document.write('</div></div>')
document.write('<div style="position:absolute;top:0px;left:0px"><div style="position:relative">');
for (i = 0; i < S.length; i++) {
document.write('<div id=x style="position:absolute;width:2px;height:2px;font-size:2px;background:'+sCol+'"></div>');
}
document.write('</div></div>')
}
function clock() {
time = new Date ();
secs = time.getSeconds();
sec = -1.57 + Math.PI * secs/30;
mins = time.getMinutes();
min = -1.57 + Math.PI * mins/30;
hr = time.getHours();
hrs = -1.57 + Math.PI * hr/6 + Math.PI*parseInt(time.getMinutes())/360;
if (ns) {
Ypos = window.pageYOffset+window.innerHeight-60;
Xpos = window.pageXOffset+window.innerWidth-80;
}
else {
Ypos = document.body.scrollTop + window.document.body.clientHeight - 60;
Xpos = document.body.scrollLeft + window.document.body.clientWidth - 60;
}
if (ns) {
for (i = 0; i < dots; ++i){
document.layers["nsDigits"+i].top = Ypos - 5 + 40 * Math.sin(-0.49+dots+i/1.9);
document.layers["nsDigits"+i].left = Xpos - 15 + 40 * Math.cos(-0.49+dots+i/1.9);
}
for (i = 0; i < S.length; i++){
document.layers["nx"+i].top = Ypos + i * Ybase * Math.sin(sec);
document.layers["nx"+i].left = Xpos + i * Xbase * Math.cos(sec);
}
for (i = 0; i < M.length; i++){
document.layers["ny"+i].top = Ypos + i * Ybase * Math.sin(min);
document.layers["ny"+i].left = Xpos + i * Xbase * Math.cos(min);
}
for (i = 0; i < H.length; i++){
document.layers["nz"+i].top = Ypos + i * Ybase * Math.sin(hrs);
document.layers["nz"+i].left = Xpos + i * Xbase * Math.cos(hrs);
}
}
else{
for (i=0; i < dots; ++i){
ieDigits[i].style.pixelTop = Ypos - 15 + 40 * Math.sin(-0.49+dots+i/1.9);
ieDigits[i].style.pixelLeft = Xpos - 14 + 40 * Math.cos(-0.49+dots+i/1.9);
}
for (i=0; i < S.length; i++){
x[i].style.pixelTop = Ypos + i * Ybase * Math.sin(sec);
x[i].style.pixelLeft = Xpos + i * Xbase * Math.cos(sec);
}
for (i=0; i < M.length; i++){
y[i].style.pixelTop = Ypos + i * Ybase * Math.sin(min);
y[i].style.pixelLeft = Xpos + i * Xbase * Math.cos(min);
}
for (i=0; i < H.length; i++){
z[i].style.pixelTop = Ypos + i * Ybase*Math.sin(hrs);
z[i].style.pixelLeft = Xpos + i * Xbase*Math.cos(hrs);
}
}
setTimeout('clock()', 50);
}
if (document.layers || document.all) window.onload = clock;
// End -->
</script>
<%
rs.close();
conn.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -