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
4星 · 超过85%的资源 需积分: 9 20 浏览量
2014-02-23
15:39:53
上传
评论 1
收藏 33.78MB RAR 举报 
精通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就是分得太细了
