📄 consumerecord.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
session.setAttribute("USERID", "1");
%>
<%@ page import="com.buy.bean.coin.ConsumeSelectBean"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="selectBean" class="com.buy.bean.coin.ConsumeSelectBean"
scope="request">
</jsp:useBean>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<style type="text/css">
<!--
@import url("../Buy/style/cal/rightcal_style01.css");
-->
</style>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>导航</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body topmargin="0">
<FORM action="" Method="post">
<div align="center">
<%@ include file="/COIN/left.jsp"%>
<tr>
<td width="10" rowspan="2" align="center">
</td>
<td height="15" colspan="2" align="center">
</td>
</tr>
<tr>
<td valign="top" bgcolor="#FFFFFF" class="cal_content02">
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td height="25" class="scal_content04">
<span class="scal_content04"> 您的消费情况如下：</span>
</td>
</tr>
<tr>
<td class="cal_td06">
<!—设置JavaBean的属性值-->
<jsp:setProperty name="selectBean" property="s_year"
param="s_year" />
<jsp:setProperty name="selectBean" property="s_month"
param="s_month" />
<jsp:setProperty name="selectBean" property="s_day"
param="s_day" />
<jsp:setProperty name="selectBean" property="e_year"
param="e_year" />
<jsp:setProperty name="selectBean" property="e_month"
param="e_month" />
<jsp:setProperty name="selectBean" property="e_day"
param="e_day" />
<jsp:setProperty name="selectBean" property="type" param="type" />
<jsp:setProperty name="selectBean" property="num" param="num" />
<!—在JSP中使用JavaBean，先获得session中userid的值。再根据值作为参数调用JavaBean-->
<%
String ID = (String) session.getAttribute("USERID");
StringBuffer result = selectBean.selectConsume(ID);
%>
<!—显示查询结果-->
<%=result%>
</td>
</tr>
<tr>
<td height="40" align="left" valign="bottom" class="q03">
<span class="scal_content04"> 查询 </span>
</td>
</tr>
<tr>
<td height="25" align="center" class=>
<table width="100%" height="25" border="0" cellpadding="0"
cellspacing="0" class="left_content_01">
</table>
</td>
</tr>
<tr>
<td height="25" align="left" bgcolor="#FFFFFF"
class="scal_content04">
<span> 充值编号：</span><span><span> <input name="num"
class=scal_content04 size=20> </span> </span>
</td>
</tr>
<tr>
<td height="48" valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25">
<strong class="scal_content04">充值时间：</strong>
</td>
</tr>
<tr>
<td height="25" class="left_content">
起始时间：
<select name="s_year" class="gen-frame">
<option selected value="1700">
请选择
</option>
<option>
2005
</option>
<option>
2006
</option>
<option>
2007
</option>
</select>
年
<select name="s_month" class="gen-frame">
<option selected value="1">
请选择
</option>
<option>
1
</option>
<option>
2
</option>
<option>
3
</option>
<option>
4
</option>
<option>
5
</option>
<option>
6
</option>
<option>
7
</option>
<option>
8
</option>
<option>
9
</option>
<option>
10
</option>
<option>
11
</option>
<option>
12
</option>
</select>
月
<select name="s_day" class="gen-frame">
<option selected value="1">
请选择
</option>
<option>
1
</option>
<option>
2
</option>
<option>
3
</option>
<option>
4
</option>
<option>
5
</option>
<option>
6
</option>
<option>
7
</option>
<option>
8
</option>
<option>
9
</option>
<option>
10
</option>
<option>
11
</option>
<option>
12
</option>
</select>
日 -截止日期：
<select name="e_year" class="gen-frame">
<option selected value="2099">
请选择
</option>
<option>
2005
</option>
<option>
2006
</option>
<option>
2007
</option>
</select>
年
<select name="e_month" class="gen-frame">
<option selected value="1">
请选择
</option>
<option>
1
</option>
<option>
2
</option>
<option>
3
</option>
<option>
4
</option>
<option>
5
</option>
<option>
6
</option>
<option>
7
</option>
<option>
8
</option>
<option>
9
</option>
<option>
10
</option>
<option>
11
</option>
<option>
12
</option>
</select>
月
<select name="e_day" class="gen-frame">
<option selected value="1">
请选择
</option>
<option>
1
</option>
<option>
2
</option>
<option>
3
</option>
<option>
4
</option>
<option>
5
</option>
<option>
6
</option>
<option>
7
</option>
<option>
8
</option>
<option>
9
</option>
<option>
10
</option>
<option>
11
</option>
<option>
12
</option>
</select>
日
</td>
</tr>
<td width="12" align="left">
<INPUT type="Submit" name="button1" value="查询" />
</td>
<tr>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</div>
</FORM>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -