Hql语句查询
来源:互联网 发布:东莞网络优化 编辑:程序博客网 时间:2024/05/17 08:54
返回一个值 如最大值,最小值
/** * 获取最早激活时间 */public String getStartDate() {// TODO Auto-generated method stubSession session=this.getSessionFactory().openSession();String hql="select min(activ_time) from r_device_active " ;String list=new String();Object results=session.createSQLQuery(hql).uniqueResult();this.closeSession(session);//没有记录if(results == null || "".equals(results)){SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");return sdf.format(new Date()); }return results.toString();}
查询一个字段 ,返回一个list
/** * 获取某条件下的激活时间 */public List<String> getActiveDate(String tradeognm,String custnm,String productdutyempnm,String productnm,String startDate,String endsDate ) {// TODO Auto-generated method stubSession session=this.getSessionFactory().openSession();String Hhql="";if(startDate != null && !"".equals(startDate) && !"null".equals(startDate)){Hhql += " and c.activ_time >='" + startDate + "'";}if(Hhql != null && !"".equals(endsDate) && !"null".equals(endsDate)){Hhql += " and c.activ_time <='" + endsDate + "'";}String hql=" select c.activ_time from r_patternoutlist a" +" join r_product_info b on a.barcode=b.serial_no" +" join r_device_active c on c.mac=b.mac where a .tradeognm='"+tradeognm +"'and a.custnm='"+custnm+"' and a.productdutyempnm ='"+productdutyempnm+"'and a.productnm ='"+productnm+"'"+Hhql;List<String> list=new ArrayList<String>();//results 定义一个list ObjectList<Object> results=session.createSQLQuery(hql).list();try{for(Object obj:results){int i=0;list.add(SimpleTools.CNull(obj).toString());}}catch(Exception e){e.printStackTrace();}this.closeSession(session);return list;}
查询多个字段 ,返回一个list/** * 获取工贸-门店-产品代表-型号 */public List<ManchineOpenedJson> getManchineOpenedJsonList(Page reportPage,HashMap<String, Object> param) {// TODO Auto-generated method stubSession session=this.getSessionFactory().openSession();//工贸String trade = (String)param.get("trade");//门店String store = (String)param.get("store");//产品代表String productDuty = (String)param.get("productDuty");//产品型号String product = (String)param.get("product");//开始时间String startDate = (String)param.get("startDate");//结束时间String endDate = (String)param.get("endDate");String queryHql = "";//查询条件if(trade != null && !"".equals(trade) && !"null".equals(trade)){queryHql += "and tradeognm='" + trade + "'";}if(store != null && !"".equals(store) && !"null".equals(store)){ queryHql += " and custnm='" + store + "'"; }if(productDuty != null && !"".equals(productDuty) && !"null".equals(productDuty)){ queryHql += " and productdutyempnm='" + productDuty + "'"; }if(product != null && !"".equals(product) && !"null".equals(product)){ queryHql+= " and productnm='" + product + "'"; }if(startDate != null && !"".equals(startDate) && !"null".equals(startDate)){queryHql += " and c.activ_time >='" + startDate + "'";}if(endDate != null && !"".equals(endDate) && !"null".equals(endDate)){queryHql += " and c.activ_time <='" + endDate + "'";}String hql="select tradeognm, custnm,productdutyempnm, productnm,count(barcode) " +"from r_patternoutlist a " +" join r_product_info b on a.barcode=b.serial_no "+"join r_device_active c on c.mac=b.mac "+"where 1=1 " +queryHql+" group by(tradeognm, custnm,productdutyempnm, productnm) order by tradeognm asc";List<ManchineOpenedJson> list=new ArrayList<ManchineOpenedJson>();//results 定义一个list Object[]List<Object[]> results=session.createSQLQuery(hql).list();//设置总记录数reportPage.setRecordCount(results.size());//需要分页if(reportPage.isIfPage()){int start = (reportPage.getCurrentPage() - 1) * reportPage.getPageSize();int end = (reportPage.getCurrentPage()) * reportPage.getPageSize(); if(end > results.size()){end = results.size();}try{results = results.subList(start, end);}catch(Exception e){}}ManchineOpenedJson m;for(Object[] obj:results){m=new ManchineOpenedJson();int i=0;//将查询字段 放到javaBean中m.setTrade(obj[i].toString());m.setStore(SimpleTools.CNull(obj[++i]));m.setProductDuty(SimpleTools.CNull(obj[++i]));m.setProduct(SimpleTools.CNull(obj[++i]));m.setActiveSum(SimpleTools.CNull(obj[++i]));list.add(m);}this.closeSession(session);return list;}
- hibernate查询语句--HQL
- hibernate查询语句--HQL
- hibernate查询语句--HQL
- Hibernate查询语句+HQL
- hibernate查询语句---HQL
- hibernate查询语句--HQL
- hql查询语句
- hibernate查询语句--HQL
- hql查询语句
- hibernate查询HQL语句
- Hql查询语句
- hql基本查询语句
- hibernate--HQL查询语句
- Hql语句查询
- HQL查询语句
- hql查询语句大全
- NHibernate查询语句(HQL)
- HQL查询语句
- OGRE+CEGUI游戏教程(2)----NPC对话演示
- ubuntu path
- jquery手册学习--数据缓存--data([key],[value])--removeData([name|list])--jQuery.data(element,[key],[value])
- OGRE+CEGUI游戏教程(3)----角色创建
- 从B 树、B+ 树、B* 树谈到R 树
- Hql语句查询
- FLex3中弹出窗口包含TabNavigator时标签页的标题可能显示不完全的问题及解决方法
- Java:String和Date、Timestamp之间的转换
- 创建jfreechar健康图续(2)
- OGRE+CEGUI游戏教程(4)----游戏逻辑脚本
- 获取地区三级下拉菜单其中的一个值
- 苹果公司独有的“产品包装艺术”
- Cocoa的MVC架构分析
- Android自定义桌面墙纸