You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

65 lines
1.8 KiB

<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="util.Info"%>
<%@page import="dao.CommDAO"%>
<%@page import="util.PageManager"%>
<html>
<head>
<title>充值信息</title>
<link rel="stylesheet" href="images/hsgcommon/common.css" type="text/css">
<link rel="stylesheet" href="images/hsgcommon/div.css" type="text/css">
<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
</head>
<body >
<p>已有充值信息列表:</p>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="cccccc" >
<tr>
<td width="35" height="30" align="center" bgcolor="cccccc">序号</td>
<td bgcolor='#cccccc'>用户名</td>
<td bgcolor='#cccccc'>姓名</td>
<td bgcolor='#cccccc'>日期</td>
<td bgcolor='#cccccc'>充值金额</td>
</tr>
<%
new CommDAO().delete(request,"chongzhixinxi");
String url = "chongzhixinxi_list.jsp?1=1";
String sql = "select * from chongzhixinxi where 1=1";
if(request.getParameter("yonghuming")=="" ||request.getParameter("yonghuming")==null ){}else{sql=sql+" and yonghuming like '%"+request.getParameter("yonghuming")+"%'";}
if(request.getParameter("xingming")=="" ||request.getParameter("xingming")==null ){}else{sql=sql+" and xingming like '%"+request.getParameter("xingming")+"%'";}
sql+=" order by id desc";
ArrayList<HashMap> list = PageManager.getPages(url,15,sql, request);
int i=0;
for(HashMap map:list){
i++;
%>
<tr>
<td width="35" align="center"><%=i %></td>
<td><%=map.get("yonghuming") %></td>
<td><%=map.get("xingming") %></td>
<td><%=map.get("riqi") %></td>
<td><%=map.get("chongzhijine") %></td>
</tr>
<%
}
%>
</table>
<br>
<p class="fy">${page.info }</p>
</body>
</html>