Hibernate笔记总结.docVIP

show_sql:true hibernate.cfg.xml(aa.bb.cc移到?src HibernateSessionFactory:location… 3)主键生成策略:sequence assigned:应用程序指定 dao(UserInfo) 添加,删除，更新 public void saveUser(UserInfo user)throws Exception{ //1得到session Session session=HibernateSessionFactory.getSession(); //2.声明事务 Transaction tx =session.beginTransaction(); //3.保存 session.save(user);//delete,update //4.提交 mit(); //5.关闭 HibernateSessionFactory.closeSession(); } 根据userId得到UserInfo public UserInfo getUserById(userId)throws Exception{ UserInfo user = null; user =(UserInfo)session.get(UserInfo.class,userId); return user; } /** * 根据 id得到商品信息 * * @return */ public String getGoodsById() { HttpServletRequest resquest=ServletActionContext.getRequest(); String[] ids=resquest.getParameterValues(id); for (int i = 0; i ids.length; i++) { try { goods = gb.getGoodsById(Long.parseLong(ids[i])); } catch (Exception e) { e.printStackTrace(); } goodslist.add(goods); System.out.println(goodslist.size()); } if (goodslist != null) { return SUCCESS; } else { return INPUT; } } /** * 根据id得到订单信息 * @return */ public String getOrdersByid() { HttpServletRequest resquest=ServletActionContext.getRequest(); String id=resquest.getParameter(id); try { orders = ob.getOrdersByid(Long.parseLong(id)); } catch (Exception ex) { ex.printStackTrace(); return INPUT; } if(orders!=null) { return SUCCESS; }else { return INPUT; } } 根据userName实现模糊查询 public ListUserInfo getUserByName(uname){ Criteria c = session.createCriteria(Userinfo.class); c.add(Restrictions.like(“userName”,”%”+uname +”%”)); ListUserInfo userList =c.list(); return userList; } public ListUserInfo getUserByName(uname){ String hql=”from UserInfo u where u.userName like ?”; Query q=session.createQuery(hql); q.setString(0,”%”+uname+”%”); ListUserInfo userList =q.list();return userList; } 登陆: public UserInfo getUserByLoginId(String loginId) throws Exception{ UserInf