deluser.jsp

JSP图书管理系统 包括会员管理 图书管理 借阅管理 等等 是非常好的图书管理软件

<%@ page contentType="text/html;charset=gb2312" language="java"%>
<%@ include file="../inc/conn1.jsp"%>
<link href="../css.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>

<style type="text/css">
<!--
.style2 {
	font-size: 14px;
	font-weight: bold;
}
.style3 {font-size: 14px}
-->
</style>
<br>
<table width="95%"   border=0 align="center" cellpadding=0 cellspacing=1>
  <!--DWLayoutTable-->
<tr bgcolor="#E6E6E6">
<td width="112" height="27" valign="middle"><div align="center" class="style2 style3">用户名</div></td>
<td width="107" valign="middle"><div align="center" class="style2">真实姓名</div></td>
<td width="120" valign="middle"><div align="center" class="style2">电话</div></td>
<td width="165" valign="middle"><div align="center" class="style2">E-mail</div></td>
<td width="207" valign="middle"><div align="center" class="style2">地址</div></td>
<td width="133" valign="middle"><div align="center" class="style2">注册时间</div></td>
<td colspan="2" valign="middle"><div align="center" class="style2">操 作</div></td>
</tr>
<%
//public bs=rs.getString("leiID");
  int intPageSize; //一页显示的记录数
  int intRowCount; //记录总数 
  int intPageCount; //总页数 
  int intPage; //待显示页码 
  String  strPage,lei; 
  int i; 
  //设置一页显示的记录数 
 intPageSize =15; 
//取得待显示页码 
strPage = request.getParameter("page"); 
if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
  intPage = 1; 
  } else{//将字符串转换成整型 
intPage = java.lang.Integer.parseInt(strPage); 
}

sql="select * from member";
Statement selstmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=selstmt.executeQuery(sql);
if(intPage< 1){
intPage = 1; 
} 
//获取记录总数 
rs.last(); 
intRowCount = rs.getRow(); 
//记算总页数 
intPageCount = (intRowCount+intPageSize-1) / intPageSize; 
//调整待显示的页码 
if(intPage >intPageCount) intPage = intPageCount; 
if(intPageCount >0){ 
//将记录指针定位到待显示页的第一条记录上 
rs.absolute((intPage-1) * intPageSize+1); 
//显示数据 
}
i = 0; 
while(i< intPageSize && !rs.isAfterLast()){%>
        
        <tr valign="middle" bgcolor="#f8f8f8" height="25" >
<td width="112" height="18" bgcolor="#f8f8f8" ><div align="center"><%=rs.getString("user_name")%></a></div></td>
<td width="107" bgcolor="#f8f8f8" ><%=rs.getString("user_namec")%></td>
<td width="120" bgcolor="#f8f8f8" ><%=rs.getString("user_tel")%></td>
<td width="165" bgcolor="#f8f8f8" ><%=rs.getString("user_mail")%></td>
<td width="207" bgcolor="#f8f8f8" ><%=rs.getString("user_adds")%></td>
<td><%=rs.getString("user_regtime")%></td>
<td colspan="2" nowrap><div align="center"><a href="#">修 改</a>/<a href="#">删 除</a></div>    </td>
  </tr>
        <tr>
          <td height=1 colspan="7" background="../image/dian.gif"><img src="../images/blank.gif" width=378 height=1></td>
          <td width="67" background="../image/dian.gif"></td>
        </tr>
         <%rs.next(); 
   i++; 
}			rs.close();
			selstmt.close();
			conn.close();%>	
</table>
<p align="center">
共<%=intRowCount%>个记录,分<%=intPageCount%>页显示,您所在本页是:第<%=intPageCount%>页
<%for(int j=1;j<=intPageCount;j++)
{out.print("&nbsp;&nbsp;<a href='deluser.jsp?page="+j+"'>"+j+"</a>");
}%>