📄 user.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
<script language=javascript src="../function/admin.js"></script>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY BGCOLOR="#FFCCCC">
<form action=user_so.jsp name=userform method=post>
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY >
<TR>
<TH colSpan=2> 当前位置：系统管理>>普通用户管理</TH>
</TR>
<tr><td>用户搜索：
<SELECT size=1 name=souser>
<OPTION selected value="" >请选择...</OPTION>
<OPTION value=0>用户名</OPTION><OPTION value=1> 性别</OPTION>
<OPTION value=2>地址</OPTION><OPTION value=3> 文化程度</OPTION>
<OPTION value=4 >邮编</OPTION>
</SELECT>
<input type=text name=key size=35 onfocus=this.value='' value=请输入关键字>
<input type=submit name=submit value=半岛搜索 onclick="return suser();"></td>
<td align=right>[所有用户] [<A href="index.jsp">回首页</A>]</td>
</tr>
</TBODY>
</TABLE></form>
<%
try{
int PageSize=10;
int CurPage=1;
ResultSet rs1=null;
int TotalPage=1;
int total=0;
if(request.getParameter("page")!=null)
{
CurPage=Integer.parseInt(request.getParameter("page"));
}
String strsql="select count(*) as recordcount from userinfo";
rs1=DB.executeQuery(strsql);
rs1.next();
total=rs1.getInt("recordcount");
if(total % PageSize==0)
TotalPage=total/PageSize;
else
TotalPage=(total/PageSize)+1;
int count=0;
int Start=(CurPage-1)*PageSize;
rs1=null;
String sql2="select * from userinfo";
rs1=DB.executeQuery(sql2);
out.print("<table align=\"center\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#FFFFFF\" style=\"font-size=12px\" margin-top=\"10px\" width=\"755px\">");
out.print(" <br> ");
out.print("<tr bgcolor=\"#006FDD\"><th>ID</th><th>用户名</th><th>用户实名</th><th>密码</th><th>性 别</th><th>电话</th><th>地址</th><th>邮编</th><th>E-mail</th><th>注册时间 </th><th>生日</th><th>文化程度 </th><th>操作</th></tr>");
%>
<form method="post" name="checkform" >
<%
if(Start!=0) { rs1.absolute(Start); }
while(rs1.next())
{
out.print("<tr bgcolor=\"#9DCEFF\"><td>"+(rs1.getInt("UserID"))+
"</td><td width=40px>"+(rs1.getString("UserName"))+
"</td><td><input type="+"text"+ " class=text1 name=text size=6 value="+(rs1.getString("RealName"))+"></td><td><input type='password' class=text1 size='4' value=" +(rs1.getString("UserPass"))+"></td><td>"+(rs1.getString("Sex"))+
"</td><td><input type="+"text"+ " class=text1 name=text size=5 value="+(rs1.getString("Telephone"))+"></td><td><input type="+"text"+ " class=text1 name=text size=5 value="+(rs1.getString("Address"))+"></td><td>"+(rs1.getString("Post"))+
"</td><td><input type="+"text"+ " class=text1 name=text size=10 value="+(rs1.getString("Email"))+"></td><td><input type="+"text"+ " class=text1 name=text size=8 value="+(rs1.getString("RegTime"))+"></td><td><input type="+"text"+ " class=text1 name=text size=4 value="+(rs1.getString("Birthday"))+"></td><td><input type="+"text"+ " class=text1 name=text size=8 value="+(rs1.getString("Educate"))+"></td><td width=30px><input type="+"checkbox"+ " name=check"+(rs1.getString("UserID"))+" value="+(rs1.getString("UserID"))+"></td></tr>");
count++;
if(count==PageSize){
break;}
}%>
<TABLE align="center" style="width:750px;">
<tr><td> </td></tr>
<TR>
<TD width="300px" align="center" style="margin-top:30px; text-align:center; font-size:14px; ">
<%
if(CurPage==1){
if(CurPage==TotalPage){
out.println("首页 上一页 下一页 尾页");
}else{
out.println("首页 上一页 <a href='#' onclick='javascript:gotoPage("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPage("+TotalPage+")'>尾页</a>");
}
}else{
if(CurPage==TotalPage){
out.println("<a href='#' onclick='javascript:gotoPage(1)'>首页</a> <a href='#' onclick='javascript:gotoPage("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
}else{
out.println("<a href='#' onclick='javascript:gotoPage(1)'>首页</a> <a href='#' onclick='javascript:gotoPage("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPage("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPage("+TotalPage+")'>尾页</a>");
}
}
%></TD>
<td width="200px" align="center" style="margin-top:10px; text-align:center; font-size=14px">
<%
out.print("跳转到第");
out.println("<select size=1 name=\"page\" onChange=\"gotoPage(this.value)\">");
for(int i=1;i<=TotalPage;i++)
{
String selectAdd=(i==CurPage)?" selected":"";
out.println("<option value='"+i+"' "+selectAdd+"> "+i+" </option>");
}
out.println("</select>");
out.print("页");
%></td>
<td> </td>
<td width="150px" align="right" style="margin-top:10px text-align:center "> <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="check2()" /> </td>
<td width="300px" align="center">
<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return dele();">
</td>
</TR>
</TABLE>
</form>
<% out.print("<form action='user_add.jsp' name=addform method=post>");
out.print("<br>"+"<hr color=\"#0033FF\">");
out.print("<table class=\"list\" align=\"center\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\" bgcolor=\"#ffffff\" style=\"font-size=12px\" margin-top=\"10px\" margin-left=\"200px\" width=700px;>");
out.print("<br>");
out.print("<tr bgcolor=\"#006FDD\"><th>用户名</th><th>密码</th><th>性别</th><th>电话</th><th>地址</th><th>邮编</th><th>E-mail</th><th>生日</th><th>文化程度</th><th>操作</th></tr>");
out.print("<tr bgcolor=\"#9DCEFF\"><td><input type="+"text"+
" name=text1 size=6></td><td><input type="+"password"+
" name=password2 size=6></td><td><input type="+"text"+
" name=text2 size=6></td><td><input type="+"text"+
" name=text3 size=6></td><td><input type="+"text"+
" name=text4 size=6></td><td><input type="+"text"+
" name=text5 size=6></td><td><input type="+"text"+
" name=text6 size=6></td><td><input type="+"text"+
" name=text7 size=6></td><td><input type="+"text"+
" name=text8 size=7></td><td><input type="+"image"+
" name=add src="+"../images/add.gif"+" onclick='return tianjia()';></td></tr>");
out.print("</table>");
out.print("</form>");
}catch(SQLException e){out.print(e);}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -