S2SH 关键字查询怎么实现? 实现S2SH 的关键字查询功能,各位大侠帮帮忙,谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 兄在吗,我写了,你看我的代码对不,谢谢。我是直接查询某个数,不是模糊查询public List<Bid> getBidListByName(String name) { System.out.println("**********list()***getBidListByName********"+name); return getHibernateTemplate().find("from Bid where bidName = '" + "name" + "'"); } SessionFactory sessionFactory = addressDAO.getSessionFactory(); Session session= sessionFactory.openSession(); int id=address.getId(); Transaction tx = session.beginTransaction(); Query query = session.createQuery("from Address as u where u.id=" + id); List list = query.list(); if (!list.isEmpty()) { address1 = (Address) list.get(0); address1.setUserCountry(address.getUserCountry()); address1.setCity(address.getCity()); public Map findAll(int currentPage,int pageSize,String type,String condition) { Map map = null; List dataList = null; Session session=null; try { map = new HashMap(); session=getSession(); Query queryObject=null; StringBuffer sb = new StringBuffer("from City city where 1=1 "); if(condition!=null&&!condition.trim().equals("")&&type!=null){ if(type.equals("1")){ sb.append("and city.cityName like :cond"); } queryObject = session.createQuery(sb.toString()); queryObject.setString("cond", "%"+condition+"%"); }else{ queryObject = session.createQuery(sb.toString()); } queryObject.setFirstResult((currentPage-1) * pageSize).setMaxResults( pageSize); dataList=queryObject.list(); map.put("dataList", dataList); StringBuffer sb1 =new StringBuffer("select count(*) from City city where 1=1"); if(condition!=null&&!condition.trim().equals("")&&type!=null){ if(type.equals("1")){ sb1.append("and city.cityName like :cond"); } queryObject = session.createQuery(sb1.toString()); queryObject.setString("cond", "%"+condition+"%"); }else{ queryObject = session.createQuery(sb1.toString()); } map.put("totalCount", queryObject.list().get(0)); } catch (RuntimeException re) { log.error("find all failed", re); throw re; }finally{ if(session!=null) closeSession(); } return map; } tomcat 后台 getOutputStream 浏览器子页面 文件下载求助 大量电子书下载 wap表单提交乱码问题? 广告联盟 jsp的源码 java中的最短路径问题(矩阵太大怎么办) 这是什么错误 问几个hibernate的问题 两个jboss的MQ怎样通信? jboss文档谁有? 毕业论文中要求有 测试方案 上哪里弄啊! 急等。。。。。。。。。。。。。。。。。。。。。 ibatis+struts+sping求一个完整的增删改查例子 急救:关于EBCDIC
你看我的代码对不,谢谢。
我是直接查询某个数,不是模糊查询
public List<Bid> getBidListByName(String name) {
System.out.println("**********list()***getBidListByName********"+name);
return getHibernateTemplate().find("from Bid where bidName = '" + "name" + "'"); }
Session session= sessionFactory.openSession();
int id=address.getId();
Transaction tx = session.beginTransaction();
Query query = session.createQuery("from Address as u where u.id=" + id);
List list = query.list();
if (!list.isEmpty()) {
address1 = (Address) list.get(0);
address1.setUserCountry(address.getUserCountry());
address1.setCity(address.getCity());
Map map = null;
List dataList = null;
Session session=null;
try {
map = new HashMap();
session=getSession();
Query queryObject=null;
StringBuffer sb = new StringBuffer("from City city where 1=1 ");
if(condition!=null&&!condition.trim().equals("")&&type!=null){
if(type.equals("1")){
sb.append("and city.cityName like :cond");
}
queryObject = session.createQuery(sb.toString());
queryObject.setString("cond", "%"+condition+"%");
}else{
queryObject = session.createQuery(sb.toString());
}
queryObject.setFirstResult((currentPage-1) * pageSize).setMaxResults(
pageSize);
dataList=queryObject.list();
map.put("dataList", dataList);
StringBuffer sb1 =new StringBuffer("select count(*) from City city where 1=1");
if(condition!=null&&!condition.trim().equals("")&&type!=null){
if(type.equals("1")){
sb1.append("and city.cityName like :cond");
}
queryObject = session.createQuery(sb1.toString());
queryObject.setString("cond", "%"+condition+"%");
}else{
queryObject = session.createQuery(sb1.toString());
}
map.put("totalCount", queryObject.list().get(0));
} catch (RuntimeException re) {
log.error("find all failed", re);
throw re;
}finally{
if(session!=null)
closeSession();
}
return map;
}