public List execureQuery(String hql, Object[] param, int start, int pageSize) {
List ret = null;
try {
SQLQuery query = this.getSession().createSQLQuery(hql);
int len = param.length;
for (int i = 0; i < len; i++) {
query.setParameter(i, param);
}
query.setFirstResult(start);
query.setMaxResults(pageSize);
ret = query.list();
} catch (RuntimeException re) {
log.error("HistoryLocationDAOImpl execureQuery failed", re);
throw re;
}
return ret;
}
public void testHql() {
HistoryLocationDAOImpl dao = new HistoryLocationDAOImpl();
List paramList = new ArrayList();
String a = "";
String b = "";
String c = "";
StringBuffer sb = new StringBuffer();
sb.append(" select * from stafferinfo where 1=1 ");
if (null != a && !"".equals(a)) {
sb.append(" and staffergender= ? ");
paramList.add(a);
}
if (null != b && !"".equals(b)) {
sb.append(" and groupid= ? ");
paramList.add(b);
}
if (null != c && !"".equals(c)) {
sb.append(" and departmentid= ? ");
paramList.add(c);
}
Object[] obj = paramList.toArray();
dao.execureQuery(sb.toString(), obj, 1, 5); }
各位的做法呢?
List ret = null;
try {
SQLQuery query = this.getSession().createSQLQuery(hql);
int len = param.length;
for (int i = 0; i < len; i++) {
query.setParameter(i, param);
}
query.setFirstResult(start);
query.setMaxResults(pageSize);
ret = query.list();
} catch (RuntimeException re) {
log.error("HistoryLocationDAOImpl execureQuery failed", re);
throw re;
}
return ret;
}
public void testHql() {
HistoryLocationDAOImpl dao = new HistoryLocationDAOImpl();
List paramList = new ArrayList();
String a = "";
String b = "";
String c = "";
StringBuffer sb = new StringBuffer();
sb.append(" select * from stafferinfo where 1=1 ");
if (null != a && !"".equals(a)) {
sb.append(" and staffergender= ? ");
paramList.add(a);
}
if (null != b && !"".equals(b)) {
sb.append(" and groupid= ? ");
paramList.add(b);
}
if (null != c && !"".equals(c)) {
sb.append(" and departmentid= ? ");
paramList.add(c);
}
Object[] obj = paramList.toArray();
dao.execureQuery(sb.toString(), obj, 1, 5); }
各位的做法呢?
解决方案 »
- 大牛们来帮帮!ajax 交互成功后的 刷新问题,要给力阿
- struts2 <s:if>传值比较的问题o(╯□╰)oo(╯□╰)oo(╯□╰)oo(╯□╰)oo(╯□╰)o
- 如何获取客户端中的ip地址和mac地址?
- 析软开源论坛开放注册,致力于开源软件的日常应用,欢迎大家注册、发帖、讨论
- 给大家推荐一个非常专业的研发论坛 - 52RD研发论坛
- 關于J2ME与J2EE的通信問題
- java读取数据库数据的问题
- 新手入门-怎样返回表的总数??
- 学习struts源码的时候,在eclipse中发现有的方法名有横线,是什么意思?
- 高分求助,作业,急!!!
- hibernate支持第三方事务吗
- ibatis操作数据库错误
你这个方法名是不是写错了?
for(Object o:list){
Object[] oo=(Object[])o;
}
由将SQL查询结果转化为pojo的想到的
http://blog.csdn.net/warison2008/archive/2009/10/26/4728590.aspx