package com.impl;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import com.dao.BaseDao;
import com.entity.TestDate;
public class DateImpl extends BaseDao {
// 查询结果
public List<TestDate> getInfo() {
List<TestDate> lt=new ArrayList<TestDate>();
String sql = "select telnum,region,act_type,pre_fee,month_cost,"
+ "templet_id,store_status,sale_status,"
+ "to_char(reserved_time,'yyyy/MM/dd HH:mm:ss')as"
+ "reserved_time from es_telnum_reserve";
List<HashMap> list=super.getAll(sql);
SimpleDateFormat df=new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
if(list!=null||list.size()>1){
for(HashMap hm:list){
TestDate td = new TestDate();
td.setTelnum(hm.get("telnum").toString());
td.setRegion(Integer.valueOf(hm.get("region").toString()));
td.setAct_type(hm.get("act_type").toString());
td.setPre_fee(hm.get("pre_fee").toString());
td.setMonth_cost(hm.get("month_cost").toString());
td.setTemplet_id(hm.get("templet_id").toString());
td.setStore_status(hm.get("store_status").toString());
td.setSale_status(hm.get("sale_status").toString());
//td.setReserved_time(Date.valueOf(hm.get("reserved_time").toString()));
Object str=hm.get("reserved_time");
if(str==null){
str="1111/11/11 11:11:11";
try {
td.setReserved_time(df.parse(str.toString()));
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
try {
td.setReserved_time(df.parse(str.toString()));
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
lt.add(td);
}
}
return lt;
}
}
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import com.dao.BaseDao;
import com.entity.TestDate;
public class DateImpl extends BaseDao {
// 查询结果
public List<TestDate> getInfo() {
List<TestDate> lt=new ArrayList<TestDate>();
String sql = "select telnum,region,act_type,pre_fee,month_cost,"
+ "templet_id,store_status,sale_status,"
+ "to_char(reserved_time,'yyyy/MM/dd HH:mm:ss')as"
+ "reserved_time from es_telnum_reserve";
List<HashMap> list=super.getAll(sql);
SimpleDateFormat df=new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
if(list!=null||list.size()>1){
for(HashMap hm:list){
TestDate td = new TestDate();
td.setTelnum(hm.get("telnum").toString());
td.setRegion(Integer.valueOf(hm.get("region").toString()));
td.setAct_type(hm.get("act_type").toString());
td.setPre_fee(hm.get("pre_fee").toString());
td.setMonth_cost(hm.get("month_cost").toString());
td.setTemplet_id(hm.get("templet_id").toString());
td.setStore_status(hm.get("store_status").toString());
td.setSale_status(hm.get("sale_status").toString());
//td.setReserved_time(Date.valueOf(hm.get("reserved_time").toString()));
Object str=hm.get("reserved_time");
if(str==null){
str="1111/11/11 11:11:11";
try {
td.setReserved_time(df.parse(str.toString()));
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else{
try {
td.setReserved_time(df.parse(str.toString()));
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
lt.add(td);
}
}
return lt;
}
}