Hibernate笔记总结

1） 2）

show_sql:true

hibernate.cfg.xml?aa.bb.cc移到 src HibernateSessionFactory:location…

3)主键生成策略:sequence

assigned:应用程序指定 -------------------dao(UserInfo) 1)

添加,删除，更新

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.提交 tx.commit(); //5.关闭

HibernateSessionFactory.closeSession(); } 2)

根据userId得到UserInfo

public UserInfo getUserById(userId)throws Exception{ UserInfo user = null;

user =(UserInfo)session.get(UserInfo.class,userId); return user; } /**

* 根据 id得到商品信息 * (复选框多个id传递) * @return */

public String getGoodsById() {

HttpServletRequest resquest=ServletActionContext.getRequest(); String[] ids=resquest.getParameterValues(\); 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 */(单个id传递)

public String getOrdersByid() {

HttpServletRequest resquest=ServletActionContext.getRequest(); String id=resquest.getParameter(\); try {

orders = ob.getOrdersByid(Long.parseLong(id)); } catch (Exception ex) { ex.printStackTrace();

return INPUT; }

if(orders!=null) {

return SUCCESS;

}else {

return INPUT; }

}

3) 根据userName实现模糊查询

public List getUserByName(uname){ Criteria c = session.createCriteria(Userinfo.class); c.add(Restrictions.like(“userName”,”%”+uname +”%”)); List userList =c.list(); return userList; }

public List getUserByName(uname){

String hql=”from UserInfo u where u.userName like ?”; Query q=session.createQuery(hql); q.setString(0,”%”+uname+”%”);

List userList =q.list();return userList; } 4)

登陆:

public UserInfo getUserByLoginId(String loginId)

throws Exception{ UserInfo user = null;

Criteria c =session.createCriteria(UserInfo.class); c.add(Restrictions.eq(“loginId”,loginId)); user=(UserInfo)c.uniqueResult(); return user; } 5)

得到总的记录数(分页)

public int getTotalCount()throws Exception{

Query query =session.createQuery(“from UserInfo”); int num=query.list().size(); return num; }

public int getTotalCount()throws Exception{ Criteria c =session.createCriteria(UserInfo.class); int num= c.list().size(); return num; }

public int getTotalCount()throws Exception{

Query query=session.createQuery(“select count(u) from UserInfo u”); int num=(Integer)query.uniqueResult(); return num; } 6)

分页:

public List getUserListByPage(int nowpage,int pageSize)throws Exception{