📄 guest.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>兑奖</title>
<%@page language="java" contentType="text/html;charset=utf-8" %>
<%@page import="sql_db.ConnSql"%>
<%@page import="java.sql.*"%>
</head>
<body>
<table align="center" width="90%" height="50">
<tr>
<td width="90"><a href="queryMOMT.jsp">上下行查询</a></td>
<td width="90"><a href="home.jsp">赛事安排</a></td>
<td width="110"><a href="news.jsp?type=1">赛前各队综合分析</a></td>
<td width="110"><a href="news.jsp?type=2">临场专家博彩推荐</a></td>
<td width="100"><a href="news.jsp?type=3">PK终极推介</a></td>
<td width="100"><a href="news.jsp?type=4">各洲际赔率信息</a></td>
<td width="100"><a href="news.jsp?type=6">世界杯热点资讯</a></td>
<td width="100"><a href="news.jsp?type=7">明星动态及趣事</a></td>
<td width="50"><a href="guest.jsp">用户报名</a></td>
<td ><a href=""></a></td>
</tr>
</table>
<%
String action;
String type;
String Id; //未兑奖记录Id
String Name;
String IDCard;
String mobile;
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
String strPage;
int i;
intPageSize = 60; //设置一页显示的记录数
//取得待显示页码
strPage = request.getParameter("page");
if(strPage==null || strPage.compareTo("")==0){ //表明在QueryString中没有page这一个参数，此时显示第一页数据
intPage = 1;
}
else{ //将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
Cookie[] cookies = request.getCookies();
String cookUser = "";
Cookie temp = null;
for(i = 0 ;i < cookies.length ; i ++){
temp = cookies[i];
if(temp.getName().equals("operator"))
cookUser = temp.getValue();
}
if (request.getParameter("action")==null){
action="view";
}else{
action=request.getParameter("action");
}
if (request.getParameter("type")==null){
type="1";
}else{
type=request.getParameter("type");
}
if (request.getParameter("Id")==null){
Id="1";
}else{
Id=request.getParameter("Id");
}
if (request.getParameter("Name")==null){
Name="";
}else{
Name=request.getParameter("Name");
Name=new String(Name.getBytes("8859_1"),"utf-8");
}
if (request.getParameter("IDCard")==null){
IDCard="0";
}else{
IDCard=request.getParameter("IDCard");
i=0;
while (i<IDCard.length()){
if (java.lang.Character.isDigit(IDCard.charAt(i))){
i++;
}else{
i=IDCard.length();
IDCard="0";
}
}
}
if (request.getParameter("mobile")==null){
mobile="";
}else{
mobile=request.getParameter("mobile").trim();
i=0;
while (i<mobile.length()){
if (java.lang.Character.isDigit(mobile.charAt(i))){
i++;
}else{
i=mobile.length()+1;
mobile="";
}
}
if (i==mobile.length() && mobile.length()!=0)
mobile=mobile+"%";
}
String sql;
ConnSql connSql = new ConnSql();
connSql.setConnectDatabase();
if (action.compareTo("alt")==0){
sql="update wap_User set IsDeleted=1 where Id="+Id;
if (connSql.executeUpdate(sql) != 1){
out.println("修改数据库出错!");
}
}
if (type.compareTo("1")==0){
sql="select a.Id,a.Remark,b.name as Bar,a.Mobile,a.Name,a.Sex from wap_User a,wap_Bar b where a.BarId=b.Id and isnull(a.IsDeleted,0)<>1 and DATEDIFF(day, getdate(), a.Remark)>=0 order by a.Remark,a.BarId,a.Sex";
ResultSet rs;
rs=connSql.executeQuery(sql);
//获取记录总数
rs.last();//光标在最后一行
intRowCount = rs.getRow();//获得当前行号
intPageCount = (intRowCount+intPageSize-1) / intPageSize; //记算总页数
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
%>
<table border="1" align="center" width="80%">
<tr bgcolor="DDDDDD">
<td width="20%">入场时间</td>
<td width="20%">酒吧</td>
<td width="20%">手机号码</td>
<td width="15%">姓名</td>
<td width="10%">性别</td>
<td>操作</td>
</tr>
<%
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
rs.absolute((intPage-1) * intPageSize + 1);
//显示数据
i = 0;
while(i<intPageSize && !rs.isAfterLast()){
%>
<tr>
<td><%=rs.getString("Remark")%></td>
<td><%=rs.getString("Bar")%></td>
<td><%=rs.getString("Mobile")%></td>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("Sex")%></td>
<td><a href="guest.jsp?Id=<%=rs.getString("Id")%>&action=alt">联系</a></td>
</tr>
<%
rs.next();
i++;
}} %>
</table>
<% if (intPageCount>1){%>
<table align="center" width="80%" height="50">
<tr><td>
<form name="form1" method="POST" action="home.jsp">
第<%=intPage%>页 共<%=intPageCount%>页 <br/>
<%if(intPage<intPageCount){%><a href="home.jsp?type=<%=type%>&page=<%=intPage+1%>">下一页</a><%}%>
<%if(intPage>1){%><a href="home.jsp?type=<%=type%>&page=<%=intPage-1%>">上一页</a><%}%>
转到第:<input type="text" name="page" size="4"> 页
<span><input type="hidden" name="type" value="1">
<input type="submit" value="跳转"></span>
</form>
</td></tr>
</table>
<%}
}
if (type.compareTo("2")==0){
sql="select a.Id,a.Mobile,a.Name,a.IDCard,a.AwardId,b.Code,b.Address,a.AwardDT from wap_Award a,wap_Operator b where a.State=2 and a.Operator=b.Id order by a.AwardDT desc";
ResultSet rs;
rs=connSql.executeQuery(sql);
//获取记录总数
rs.last();//光标在最后一行
intRowCount = rs.getRow();//获得当前行号
intPageCount = (intRowCount+intPageSize-1) / intPageSize; //记算总页数
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
%>
<table border="1" align="center" width="90%" >
<tr bgcolor="DDDDDD">
<td width="10%">用户手机号</td>
<td width="8%">中奖者</td>
<td width="15%">身份证号码</td>
<td width="10%">奖品</td>
<td width="10%">操作员</td>
<td width="20%">兑奖点</td>
<td width="20%">兑换奖品时间</td>
</tr>
<%
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
rs.absolute((intPage-1) * intPageSize + 1);
//显示数据
i = 0;
while(i<intPageSize && !rs.isAfterLast()){
%>
<tr>
<td><%=rs.getString("Mobile")%></td>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("IDCard")%></td>
<td><%=rs.getString("AwardId")%></td>
<td><%=rs.getString("Code")%></td>
<td><%=rs.getString("Address")%></td>
<td><%=rs.getString("AwardDT")%></td>
</tr>
<%
rs.next();
i++;
}} %>
</table>
<%
if (intPageCount>1){%>
<table align="center" width="90%" height="50">
<tr><td>
<form name="form2" method="POST" action="home.jsp">
第<%=intPage%>页 共<%=intPageCount%>页 <br/>
<%if(intPage<intPageCount){%><a href="home.jsp?type=<%=type%>&page=<%=intPage+1%>">下一页</a><%}%>
<%if(intPage>1){%><a href="home.jsp?type=<%=type%>&page=<%=intPage-1%>">上一页</a><%}%>
转到第:<input type="text" name="page" size="4" > 页
<span><input type="hidden" name="type" value="2">
<input type="submit" value="跳转"></span>
</form>
</td></tr>
</table>
<%}
}
if (type.compareTo("3")==0){
sql="select a.Id,a.Mobile,a.Name,a.IDCard,a.AwardId,b.Code,b.Address,a.CreateDT,a.AwardDT,a.State,Stat=case a.State when 1 then '未兑奖品' when 2 then '奖品已兑' end from wap_Award a,wap_Operator b where a.Operator=b.Id and Mobile like '"+mobile+"' order by a.CreateDT desc";
ResultSet rs;
rs=connSql.executeQuery(sql);
%>
<form action="home.jsp" method="post">
<table align="center" width="90%">
<tr><td align="left" width="30%">输入手机号:<input type="text" name="mobile"></td>
<td align="left"><input type="hidden" name="type" value="3">
<input type="submit" value="查询"></td></tr>
</talbe>
</form>
<table border="1" align="center" width="90%">
<tr bgcolor="DDDDDD">
<td width="8%">用户手机号</td>
<td width="8%">中奖者</td>
<td width="12%">身份证号码</td>
<td width="5%">奖品</td>
<td width="8%">操作员</td>
<td width="15%">兑奖点</td>
<td width="15%">短信兑奖时间</td>
<td width="15%">兑换奖品时间</td>
<td width="8%">兑奖状态</td>
<td>操作</td>
</tr>
<%while (rs.next()){
int istate=java.lang.Integer.parseInt(rs.getString("State"));
%>
<tr>
<td><%=rs.getString("Mobile")%></td>
<td><%=rs.getString("Name")%></td>
<td><%=rs.getString("IDCard")%></td>
<td><%=rs.getString("AwardId")%></td>
<td><%=rs.getString("Code")%></td>
<td><%=rs.getString("Address")%></td>
<td><%=rs.getString("CreateDT")%></td>
<td><%=rs.getString("AwardDT")%></td>
<td><%=rs.getString("Stat")%></td>
<td><%if (istate==1){%><a href="exchange.jsp?Id=<%=rs.getString("Id")%>">兑奖</a><%}%></td>
</tr>
<%} %>
</table>
<%}%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -