dao 表优化

最新推荐文章于 2021-03-23 21:41:41 发布

angelbill3

最新推荐文章于 2021-03-23 21:41:41 发布

阅读量76

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/angelbill3/article/details/84020455

版权

java 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

//列表ticket 底层hql语言 可以去掉一些字段 比如简介
String hql = "select new Ticket(id,name,address,activeDate,saleBeginTime,saleEndTime,thumbnail,pic,enteringman,enteringdate,status,datasource) from "+table+" where status = '已审核' order by "+orderby+" "+desc;

   
ticket方法重载
public Ticket(Integer id, String name, String address, String activeDate, Object saleBeginTime, Object saleEndTime,
			String thumbnail, String pic, String enteringman,
			Object enteringdate, String status, String datasource) {
		super();
		this.id = id;
		this.name = name;
		this.address = address;
		this.activeDate = activeDate;
		this.saleBeginTime = stringToTimestamp(saleBeginTime.toString());
		this.saleEndTime = stringToTimestamp(saleEndTime.toString());
		this.thumbnail = thumbnail;
		this.pic = pic;
		this.enteringman = enteringman;
		this.enteringdate = stringToTimestamp(enteringdate.toString());
		this.status = status;
		this.datasource = datasource;
	}

    // Property accessors
    /**
	* Timestamp
	* @param dateStr
	* @return
	*/
	public static Timestamp stringToTimestamp(String dateStr){

	   SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	   Calendar cal = Calendar.getInstance();
	   try {
	    Date date = sdf.parse(dateStr);
	    date.getTime();
	    cal.setTime(date);
	    return new Timestamp(cal.getTimeInMillis());
	   } catch (ParseException e) {
	    e.printStackTrace();
	   }

	   cal.setTime(new Date());
	   return new Timestamp(cal.getTimeInMillis());
	}