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 OrderSelectBean {
String s_year = "1700", s_month = "1", s_day = "1", e_year = "2099",
e_month = "1", e_day = "1", status = "0", num=null;
public void setNum(String num) {
this.num = num;
}
public void setStatus(String status) {
this.status = status;
}
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 selectOrder(String userID) {
String type1 = null;
int j = Integer.parseInt(status);
switch (j) {
case 0:
type1 = "Any";
break;
case 1:
type1 = "正在处理";
break;
case 2:
type1 = "支付成功";
break;
case 3:
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 orderid,type,price,datetime,productname from buy.order where USERID ='"+ userID + "' and orderid = "+num+"";
}else{
condition = "select orderid,type,price,datetime,productname from buy.order where USERID ='"+ userID + "' and datetime <= '"+ e_date+ "'and datetime >= '" + s_date +"'";
if(j != 0){
condition += "and type ='"+type1+"'";
}
}
System.out.println(condition);
ResultSet rs = null;
Statement sql = null;
String status, coin, date, num,name;
StringBuffer buffer = new StringBuffer();
try {
Connection conn = DBConnect.getConnection();
System.out.println(conn.isClosed());
sql = conn.createStatement();
rs = sql.executeQuery(condition);
int i = 1;
buffer.append("<table width=" + "100%" + " border=" + "0"
+ " cellpadding=" + "0" + " cellspacing=" + "1" + ">");
buffer.append("<tr align=" + "center" + ">");
buffer.append("<td width=" + "150" + "height=" + "25"
+ " class=" + "cal_td12" + ">订单号</td>");
buffer.append("<td width=" + "180" + "height=" + "25"
+ " class=" + "cal_td12" + ">订单状态</td>");
buffer.append("<td width=" + "150" + "height=" + "25"
+ " class=" + "cal_td12" + ">金额</td>");
buffer.append("<td width=" + "150" + "height=" + "25"
+ " class=" + "cal_td12" + ">订单创建时间</td>");
buffer.append("<td width=" + "150" + "height=" + "25"
+ " class=" + "cal_td12" + ">订购商品名称</td>");
buffer.append("</TR>");
while (rs.next()) {
buffer.append("<tr align=" + "center" + ">");
if (i % 2 == 1) {
//取得结果集中一条记录的第一个字段,付给num
num = rs.getString(1);
buffer.append("<TD width=" + 180 + " height=" + "20"
+ " class=" + "cal_td06" + ">" + num
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
status = rs.getString(2);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td06" + ">" + status
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
coin = rs.getString(3);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td06" + ">" + coin
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
date = rs.getString(4);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td06" + ">" + date
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
name = rs.getString(5);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td06" + ">" + name
+ "</TD>");
} else {
// 取得结果集中一条记录的第一个字段,付给num
num = rs.getString(1);
buffer.append("<TD width=" + 180 + " height=" + "20"
+ " class=" + "cal_td08" + ">" + num
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
status = rs.getString(2);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td08" + ">" + status
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
coin = rs.getString(3);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td08" + ">" + coin
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
date = rs.getString(4);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td08" + ">" + date
+ "</TD>");
// 取得结果集中一条记录的第一个字段,付给num
name = rs.getString(5);
buffer.append("<TD width=" + 150 + " height=" + "20"
+ " class=" + "cal_td08" + ">" + name
+ "</TD>");
}
buffer.append("</TR>");
i++;
}
buffer.append("</Table>");
rs.close();
sql.close();
conn.close();
// }
} catch (SQLException ex) {
System.out.println("TradeDB SQLException: " + ex.getMessage());
return new StringBuffer("查询错误");
}
return buffer;
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
精通J2EE—Eclipse Struts Hibernate Spring 整合应用案例源代码2
共1190个文件
java:190个
class:190个
jar:151个
4星 · 超过85%的资源 需积分: 9 41 下载量 107 浏览量
2014-02-23
15:39:53
上传
评论 1
收藏 33.78MB RAR 举报
温馨提示
精通J2EE—Eclipse Struts Hibernate Spring 整合应用案例源代码,这是剩下一部分。
资源推荐
资源详情
资源评论
收起资源包目录
精通J2EE—Eclipse Struts Hibernate Spring 整合应用案例源代码2 (1190个子文件)
EnrolDAOImp.class 5KB
CourseDAOImp.class 5KB
SaveBookAction.class 5KB
User.class 5KB
OrderSelectBean.class 5KB
Forum.class 5KB
Notice.class 5KB
LoginAction.class 4KB
AddcoinSelectBean.class 4KB
User.class 4KB
ConsumeSelectBean.class 4KB
CheckPowerAction.class 4KB
Teacher_Manager.class 4KB
SearchBookAction.class 4KB
SubmitArticleAction.class 4KB
Response.class 4KB
PayAction.class 4KB
Student_Manager.class 4KB
ListStudent.class 4KB
NewsTag.class 4KB
ListCourseForStu.class 4KB
Bookinfo.class 4KB
RegisterAction.class 4KB
ListClasses.class 4KB
PopTag.class 4KB
News.class 4KB
Project_Manager.class 4KB
UserEditAction.class 4KB
OrderDetailAction.class 4KB
Admin_Manager.class 4KB
NewUserAction.class 3KB
DisplayTag.class 3KB
ShoppingCartAction.class 3KB
ListCourse.class 3KB
Topic.class 3KB
TopicListAction.class 3KB
TeacherDAOImp.class 3KB
StudentDAOImp.class 3KB
AdminDAOImp.class 3KB
ListTeacher.class 3KB
ClassesDAOImp.class 3KB
UserEditAction.class 3KB
News4news.class 3KB
DBUtil.class 3KB
AdminLoginAction.class 3KB
JDBCTest.class 3KB
NewsTag4guest.class 3KB
LoginAction.class 3KB
ForumCreateAction.class 3KB
EditBookForm.class 3KB
RegistrationAction.class 3KB
ListScore.class 3KB
BookDetailAction.class 3KB
ForumEditSubmitAction.class 3KB
Userinfo.class 3KB
UserLoginAction.class 3KB
TopicDeleteAction.class 3KB
Student.class 3KB
UserManagerAction.class 3KB
AdminLoginAction.class 3KB
UserDeleteAction.class 3KB
UserLoginAction.class 3KB
ModifyAction.class 3KB
ForumDeleteAction.class 3KB
UserSearchAction.class 3KB
ForumManagerAction.class 3KB
StudentForm.class 3KB
EditBookAction.class 3KB
HibernateUtil.class 3KB
HibernateUtil.class 3KB
TopicDisp.class 3KB
NoticeBean.class 3KB
NoticeBean.class 3KB
Pageable.class 3KB
ClassesForm.class 3KB
RegisterForm.class 3KB
ViewCartAction.class 3KB
DeleteBookAction.class 3KB
Order.class 3KB
Pageable.class 3KB
NoticeModifyAction.class 2KB
CourseForm.class 2KB
ForumEditAction.class 2KB
AddClasses.class 2KB
AddStudent.class 2KB
Note_Manager.class 2KB
DataProcess.class 2KB
EditClasses.class 2KB
InsertNewNoticeAction.class 2KB
InsertNewNoticeAction.class 2KB
TopicSearchAction.class 2KB
ResponseListAction.class 2KB
SearchUserAction.class 2KB
AddTeacher.class 2KB
EditStudent.class 2KB
LoginServlet.class 2KB
EditCourse.class 2KB
TeacherForm.class 2KB
NewTopicAction.class 2KB
Grade_Manager.class 2KB
共 1190 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12
资源评论
- oopsyguy2014-05-11不太清楚,但还不错
- bing_bing2014-08-02就是分得太细了
雪妍520
- 粉丝: 1
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于SpringBoot Mybatis-Plus TypeScript的微服务多租户SaaS管理快速开发框架 .zip
- 论文复现:QA-GNN: Reasoning with Language Models and Knowledge
- ipp(intel-oneAPI)下载地址.txt
- 基于spring-boot dubbox搭建的java分布式系统的前端管理.zip
- VLC+Qt demoVLC+Qt demo
- 海彪&龙梅子 - 寂寞的人伤心的歌 (DJ版) [mqms2].ogg
- 530springboot + vue 旅游管理系统.zip(可运行源码+数据库文件+文档)
- 基于SpringBoot + Thymeleaf + Layui + Apache Shiro 的后台管理系统 .zip
- 表1:长江大学文理学院课外学分申请表.et
- base.apk
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功