String hql = "select new list(o.customer.name, o.tradeDate, o.status, o.amount) from Order o"
+ " where o.tradeDate between '2015-05-01' and '2015-05-30' and o.status in ('已发货','已付款') and o.amount>500"
+ " order by o.status asc, o.tradeDate desc, o.amount desc";
+ " where o.tradeDate between '2015-05-01' and '2015-05-30' and o.status in ('已发货','已付款') and o.amount>500"
+ " order by o.status asc, o.tradeDate desc, o.amount desc";
String str = "北京";
String hql = "from Customer c where c.address like :param";
Query query = session.createQuery(hql).setString("param", "%"+str+"%");
String hql = "from Customer c where c.address like :param";
Query query = session.createQuery(hql).setString("param", "%"+str+"%");
2016-09-15
据说这是hibernate3.0 like子句处理中文的一个问题, 3.1已得到修正。3.0版可以通过设置参数解决。改正如下:
String str = "张";
String hql = "from Customer c where c.name like :param";
Query query = session.createQuery(hql).setString("param", str+"_");
String str = "张";
String hql = "from Customer c where c.name like :param";
Query query = session.createQuery(hql).setString("param", str+"_");
2016-09-15