@Transactional server实现层添加事务
hql语句
1.条件查找
String hql="from Users where userName=? and userPassword=?";
List<Users> list=(List<Users>) this.getHibernateTemplate().find(hql,new String[]{userName,userPassword} );
2.添加
this.getHibernateTemplate().save(user);
3.删除
Users user=(Users) this.getHibernateTemplate().get(Users.class, id);
this.getHibernateTemplate().delete(user);
4修改
Users user=(Users) this.getHibernateTemplate().get(Users.class, id);
user.setUserPassword(pwd1);
this.getHibernateTemplate().update(user);
sql语句
增删改方法通用
String sql="update cart set ITEM_NUM=ITEM_NUM+"+itemnum+" where ID="+id;
SQLQuery query = this.hibernateTemplate.getSessionFactory().getCurrentSession().createSQLQuery(sql);
query.executeUpdate();
( String sql="insert into cart(IS_Delete,DELETE_STATUS,USER_ID,ITEM_ID,ITEM_NUM,ITEM_PRICE,ITEM_STANDARD,CREATE_TIME) values(1,1,"+userid+","+itemid+","+itemnum+","+price+","+standardid+",'"+date+"')";
SQLQuery query = this.hibernateTemplate.getSessionFactory().getCurrentSession().createSQLQuery(sql);
query.executeUpdate();)