资源简介
在线订购子系统(JSP+JavaBean)
代码片段和文件信息
package com.buy.bean.coin;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.buy.bean.comm.database.DBConnect;
public class AddcoinSelectBean {
String s_year= “1700“ s_month = “1“ s_day= “1“ e_year= “2099“ e_month= “1“ e_day= “1“type=“0“num=null;
public AddcoinSelectBean(){
}
public void setNum(String num) {
this.num = num;
}
public void setType(String type){
this.type = type;
}
public void setS_year(String s_year) {
this.s_year = s_year;
}
public void setS_month(String s_month) {
this.s_month = s_month;
}
public void setS_day(String s_day) {
this.s_day = s_day;
}
public void setE_year(String e_year) {
this.e_year = e_year;
}
public void setE_month(String e_month) {
this.e_month = e_month;
}
public void setE_day(String e_day) {
this.e_day = e_day;
}
public StringBuffer selectAddcoin(String userID){
String type1 = null;
int j = Integer.parseInt(type);
switch (j){
case 0:
type1 = “Any“;break;
case 1:
type1 = “在线充值“;break;
case 2:
type1 = “个人银行充值“;break;
case 3:
type1 = “代理充值“;break;
case 4:
type1 = “汇款充值“;break;
}
String s_date = s_year + “-“ + s_month + “-“ + s_day;
String e_date = e_year + “-“ + e_month + “-“ + e_day;
String condition;
if(num!=null){
condition = “select addidtypecoindatetime from buy.add where USERID =‘“+ userID + “‘ and addid = “+num+““;
}else{
condition = “select addidtypecoindatetime from buy.add where USERID =‘“+ userID + “‘ and datetime <= ‘“+ e_date+ “‘and datetime >= ‘“ + s_date +“‘“;
if(j != 0){
condition += “and type =‘“+type1+“‘“;
}
}
ResultSet rs = null;
String type coin datenum;
Statement sql = null;
StringBuffer buffer = new StringBuffer();
try {
Connection conn = DBConnect.getConnection();
sql = conn.createStatement();
rs = sql.executeQuery(condition);
int i = 1;
buffer.append(““);
buffer.append(““);
buffer.append(“ + “cal_td12“ + “>充值编号“);
buffer.append(“ + “cal_td12“ + “>充值类型“);
buffer.append(“ + “cal_td12“ + “>充值金额“);
buffer.append(“ + “cal_td12“ + “>充值时间“);
buffer.append(“ “);
while (rs.next()) {
buffer.append(““);
num = rs.getString(1);//取得第一个字段的值
if(i%2==1){//根据奇偶行显示不同的样式
buffer.append(“ + “ class=“ + “cal_td06“ + “>“ + num + ““);
type = rs.getString(2);//取得第二个字段的值
buffer.append(“ + “ class=“ + “cal_td06“ + “>“ + type + ““);
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
文件 433 2007-11-19 10:18 02\Buy\.classpath
目录 0 2008-10-08 08:28 02\Buy\.myeclipse
文件 282 2007-11-19 10:18 02\Buy\.mymetadata
文件 1221 2007-11-19 10:18 02\Buy\.project
文件 88 2007-11-19 10:18 02\Buy\.settings\org.eclipse.core.resources.prefs
目录 0 2008-10-08 08:28 02\Buy\.settings
文件 4262 2007-11-19 10:18 02\Buy\src\com\buy\bean\coin\AddcoinSelectBean.java
文件 3831 2007-11-19 10:18 02\Buy\src\com\buy\bean\coin\ConsumeSelectBean.java
文件 1217 2007-11-19 10:18 02\Buy\src\com\buy\bean\coin\ConsumeSelectBean1.java
文件 5755 2007-11-19 10:18 02\Buy\src\com\buy\bean\coin\OrderSelectBean.java
文件 1911 2007-11-19 10:18 02\Buy\src\com\buy\bean\coin\UsercoinSelectBean.java
目录 0 2008-10-08 08:28 02\Buy\src\com\buy\bean\coin
文件 784 2007-11-19 10:18 02\Buy\src\com\buy\bean\comm\database\Config.java
文件 162 2007-11-19 10:18 02\Buy\src\com\buy\bean\comm\database\config.properties
文件 783 2007-11-19 10:18 02\Buy\src\com\buy\bean\comm\database\DBConnect.java
目录 0 2008-10-08 08:28 02\Buy\src\com\buy\bean\comm\database
目录 0 2008-10-08 08:28 02\Buy\src\com\buy\bean\comm
目录 0 2008-10-08 08:28 02\Buy\src\com\buy\bean
文件 3302 2007-11-19 10:18 02\Buy\src\com\buy\util\EncodingFilter.java
目录 0 2008-10-08 08:28 02\Buy\src\com\buy\util
目录 0 2008-10-08 08:28 02\Buy\src\com\buy
目录 0 2008-10-08 08:28 02\Buy\src\com
目录 0 2008-10-08 08:28 02\Buy\src
目录 0 2008-10-08 08:28 02\Buy\WebRoot\Buy\scripts
文件 15760 2007-11-19 10:18 02\Buy\WebRoot\Buy\style\cal\rightcal_style01.css
目录 0 2008-10-08 08:28 02\Buy\WebRoot\Buy\style\cal
文件 14654 2007-11-19 10:18 02\Buy\WebRoot\Buy\style\style.css
目录 0 2008-10-08 08:28 02\Buy\WebRoot\Buy\style
目录 0 2008-10-08 08:28 02\Buy\WebRoot\Buy
文件 9647 2007-11-19 10:18 02\Buy\WebRoot\COIN\addcoinrecord.jsp
............此处省略37个文件信息
- 上一篇:Java开发的游戏 贪吃蛇 完整源代码
- 下一篇:xUtils-2.6.14.jar
相关资源
评论
共有 条评论