<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%> <%@page import="util.Info"%> <%@page import="dao.CommDAO"%> <%@page import="util.PageManager"%> 用户注册

已有用户注册列表:

搜索: 用户名: 姓名: QQ: 邮箱: 电话: 身份证:
<% new CommDAO().delete(request,"yonghuzhuce"); String url = "yonghuzhuce_list.jsp?1=1"; String sql = "select * from yonghuzhuce where 1=1 "; if(request.getParameter("yonghuming")=="" ||request.getParameter("yonghuming")==null ){}else{sql=sql+" and yonghuming like '%"+request.getParameter("yonghuming").trim()+"%'";} if(request.getParameter("xingming")=="" ||request.getParameter("xingming")==null ){}else{sql=sql+" and xingming like '%"+request.getParameter("xingming").trim()+"%'";} if(request.getParameter("QQ")=="" ||request.getParameter("QQ")==null ){}else{sql=sql+" and QQ like '%"+request.getParameter("QQ").trim()+"%'";} if(request.getParameter("youxiang")=="" ||request.getParameter("youxiang")==null ){}else{sql=sql+" and youxiang like '%"+request.getParameter("youxiang").trim()+"%'";} if(request.getParameter("dianhua")=="" ||request.getParameter("dianhua")==null ){}else{sql=sql+" and dianhua like '%"+request.getParameter("dianhua").trim()+"%'";} if(request.getParameter("shenfenzheng")=="" ||request.getParameter("shenfenzheng")==null ){}else{sql=sql+" and shenfenzheng like '%"+request.getParameter("shenfenzheng").trim()+"%'";} sql+=" order by id desc"; //out.print(sql); ArrayList list = PageManager.getPages(url,10,sql, request ); int i=0; for(HashMap map:list){ i++; %> <% } %>
序号 用户名 密码 姓名 性别 出生年月 QQ 邮箱 电话 身份证 头像 地址 备注 添加时间 审核 操作
<%=i %> <%=map.get("yonghuming") %><%=map.get("mima") %><%=map.get("xingming") %><%=map.get("xingbie") %><%=map.get("chushengnianyue") %><%=map.get("QQ") %><%=map.get("youxiang") %><%=map.get("dianhua") %><%=map.get("shenfenzheng") %><%=map.get("dizhi") %><%=map.get("beizhu") %> <%=map.get("addtime") %> &yuan=<%=map.get("issh")%>&tablename=yonghuzhuce" onClick="return confirm('确定要执行此操作?');"><%=map.get("issh")%>

${page.info }