方法如下
public List queryByDate(String belongDateA,String belongDateB) {
Session session = this.getSession();
List list = null;
Transaction tr = session.beginTransaction();
try {
Query query = session.createSQLQuery("select * from taxreportdetail t " +
"where t.d_belongdatea>=to_date(belongDateA,'yyyy-mm-dd') and t.d_belongdateb<=to_date(belongDateB,'yyyy-mm-dd') ");
list = query.list();
tr.commit();
list获取不了,上面传进来的是一个字符串型
多谢
public List queryByDate(String belongDateA,String belongDateB) {
Session session = this.getSession();
List list = null;
Transaction tr = session.beginTransaction();
try {
Query query = session.createSQLQuery("select * from taxreportdetail t " +
"where t.d_belongdatea>=to_date(belongDateA,'yyyy-mm-dd') and t.d_belongdateb<=to_date(belongDateB,'yyyy-mm-dd') ");
list = query.list();
tr.commit();
list获取不了,上面传进来的是一个字符串型
多谢
Query query = session.createSQLQuery("select * from taxreportdetail t where t.d_belongdatea>=to_date(:belongDateA,'yyyy-mm-dd') and t.d_belongdateb <=to_date(:belongDateB,'yyyy-mm-dd')");
query.setString("belongDateA",belongDateA);
query.setString("belongDateB",belongDateB);
query.list();
恶心恶心
List l=this.getSession().createSQLQuery(sql).addEntity(TblEnCn.class).list();
只有使用HQL的时候返回的是LIST啊,