WebRoot/yonghuzhuce_list.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java"  pageEncoding="gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<html>
  <head>
    <base href="<%=basePath%>">
    <title>用户注册</title><LINK href="CSS.css" type=text/css rel=stylesheet>
  </head>
  <body >
  <p>已有用户注册列表：</p>
  <form name="form1" id="form1" method="post" action="">
   搜索: 用户名：<input name="yonghuming" type="text" id="yonghuming" /> 姓名：<input name="xingming" type="text" id="xingming" /> QQ：<input name="QQ" type="text" id="QQ" /> 邮箱：<input name="youxiang" type="text" id="youxiang" /> 电话：<input name="dianhua" type="text" id="dianhua" /> 身份证：<input name="shenfenzheng" type="text" id="shenfenzheng" />
   <input type="submit" name="Submit" value="查找" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse">  
  <tr>
    <td width="30" align="center" bgcolor="CCFFFF">序号</td>
    <td width="76" bgcolor='#CCFFFF'>用户名</td><td width="53" bgcolor='#CCFFFF'>密码</td><td width="53" bgcolor='#CCFFFF'>姓名</td><td width="53" bgcolor='#CCFFFF'>性别</td><td width="86" bgcolor='#CCFFFF'>出生年月</td><td width="50" bgcolor='#CCFFFF'>QQ</td><td width="53" bgcolor='#CCFFFF'>邮箱</td><td width="53" bgcolor='#CCFFFF'>电话</td><td width="76" bgcolor='#CCFFFF'>身份证</td><td width="113" bgcolor='#CCFFFF'>头像</td>
    <td width="58" bgcolor='#CCFFFF'>服务积分</td>
    <td width="53" bgcolor='#CCFFFF'>地址</td><td width="57" bgcolor='#CCFFFF'>类型</td>
    <td width="90" align="center" bgcolor="CCFFFF">操作</td>
  </tr>
  <%
     String sql="";
  sql="select * from yonghuzhuce where 1=1";
  
if(request.getParameter("yonghuming")=="" ||request.getParameter("yonghuming")==null ){}else{sql=sql+" and yonghuming like '%"+new String(request.getParameter("yonghuming").getBytes("8859_1"))+"%'";}
if(request.getParameter("xingming")=="" ||request.getParameter("xingming")==null ){}else{sql=sql+" and xingming like '%"+new String(request.getParameter("xingming").getBytes("8859_1"))+"%'";}
if(request.getParameter("QQ")=="" ||request.getParameter("QQ")==null ){}else{sql=sql+" and QQ like '%"+new String(request.getParameter("QQ").getBytes("8859_1"))+"%'";}
if(request.getParameter("youxiang")=="" ||request.getParameter("youxiang")==null ){}else{sql=sql+" and youxiang like '%"+new String(request.getParameter("youxiang").getBytes("8859_1"))+"%'";}
if(request.getParameter("dianhua")=="" ||request.getParameter("dianhua")==null ){}else{sql=sql+" and dianhua like '%"+new String(request.getParameter("dianhua").getBytes("8859_1"))+"%'";}
if(request.getParameter("shenfenzheng")=="" ||request.getParameter("shenfenzheng")==null ){}else{sql=sql+" and shenfenzheng like '%"+new String(request.getParameter("shenfenzheng").getBytes("8859_1"))+"%'";}
 
  sql=sql+" order by id desc";
 ResultSet RS_result=connDbBean.executeQuery(sql);
 String id="";
 String yonghuming="";String mima="";String xingming="";String xingbie="";String chushengnianyue="";String QQ="";String youxiang="";String dianhua="";String shenfenzheng="";String touxiang="";String dizhi="";String leixing="";String jifen="";
 String addtime="";String issh="";
 
 
 
 int i=0;
 while(RS_result.next()){
 i=i+1;
 id=RS_result.getString("id");
yonghuming=RS_result.getString("yonghuming");mima=RS_result.getString("mima");xingming=RS_result.getString("xingming");xingbie=RS_result.getString("xingbie");chushengnianyue=RS_result.getString("chushengnianyue");QQ=RS_result.getString("QQ");youxiang=RS_result.getString("youxiang");dianhua=RS_result.getString("dianhua");shenfenzheng=RS_result.getString("shenfenzheng");touxiang=RS_result.getString("touxiang");dizhi=RS_result.getString("dizhi");leixing=RS_result.getString("leixing");
 addtime=RS_result.getString("addtime");issh=RS_result.getString("issh");jifen=RS_result.getString("jifen");
%>
  <tr>
    <td width="30" align="center"><%=i %></td>
    <td><%=yonghuming %></td><td><%=mima %></td><td><%=xingming %></td><td><%=xingbie %></td><td><%=chushengnianyue %></td><td><%=QQ %></td><td><%=youxiang %></td><td><%=dianhua %></td><td><%=shenfenzheng %></td><td><a href='<%=touxiang %>' target='_blank'><img src='<%=touxiang %>' width=88 height=99 border=0 /></a></td>
    <td><%=jifen %></td>
    <td><%=dizhi %></td><td><%=leixing %></td>
    <td width="90" align="center"><a href="yonghuzhuce_updt.jsp?id=<%=id%>">修改</a>  <a href="del.jsp?id=<%=id %>&tablename=yonghuzhuce" onClick="return confirm('真的要删除？')">删除</a> <a href="yonghuzhuce_detail.jsp?id=<%=id%>" target="_blank">详细</a></td>
  </tr>
  	<%