?? merchantbizgroupfavoritedao.java
字號:
/*
* 作者:劉云云
* 時間:2007年11月28日
* 功能:我的商業(yè)合作->關(guān)注中的商圈
* 查看自已關(guān)注的商圈
*/
package com.mole.struts.dao;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import com.mole.struts.bean.MerchantBizGroupInfoBean;
public class MerchantBizGroupFavoriteDAO extends AbstractDAO {
// 獲取關(guān)注的商圈的記錄集
public MerchantBizGroupInfoBean[] getFavoriteBizGroup(String sql) {
ArrayList<Object[]> arrayList = executeQuery(sql);
MerchantBizGroupInfoBean[] records = new MerchantBizGroupInfoBean[arrayList
.size()];
Iterator<Object[]> it = arrayList.iterator();
int i = 0;
while (it.hasNext()) {
Object[] obj = it.next();
MerchantBizGroupInfoBean record = new MerchantBizGroupInfoBean();
record.setId(obj[0].toString());
record.setName(obj[1].toString());
record.setActivityDes(obj[2].toString());
record.setStartDate(obj[3].toString().substring(0, 10));
record.setEndDate(obj[4].toString().substring(0, 10));
record.setState(Integer.valueOf(obj[5].toString()));
record.setStoreName(obj[6].toString());
record.setTypeName(obj[7].toString());
record.setCityName(obj[8].toString());
record.setAreaName(obj[9].toString());
record.setTypeName2(obj[10].toString());
record.setTypeName3(obj[11].toString());
record.setTypeName4(obj[12].toString());
Date currentDate = new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
String dateString = formatter.format(currentDate);
if (record.getState() == 3) {
record.setTig("delete");
} else if (record.getState() == 2
|| (record.getState() == 1 && dateString.compareTo(record
.getEndDate()) > 0)
|| (record.getState() == 0 && dateString.compareTo(record
.getEndDate()) > 0)) {
record.setTig("end");
} else if (record.getState() == 1
|| (record.getState() == 0
&& dateString.compareTo(record.getEndDate()) <= 0 && dateString
.compareTo(record.getStartDate()) >= 0)) {
record.setTig("start");
} else {
record.setTig("ready");
}
records[i++] = record;
}
return records;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -