SSH框架做的增删改查的例子

package com.liuwei.crm.dao.hibernate; import java.util.List; import org.hibernate.Query; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import org.springframework.stereotype.Repository; import com.liuwei.crm.dao.EmployeeDao; import com.liuwei.crm.model.Employee; @Repository("employeeDao") public class EmployeeDaoHibernate extends HibernateDaoSupport implements EmployeeDao { public Employee login(Employee e) { String HQL = "from Employee e where e.name='"+e.getName()+"' and e.password='"+e.getPassword()+"'" ; List<Employee> list = getHibernateTemplate().find(HQL); Employee employee = null; if (list.size() > 0) employee = list.get(0); else employee = null; return employee; } public void create(Employee e) { getHibernateTemplate().save(e); } public void delete(Long id) { Employee e = (Employee)getHibernateTemplate().get(Employee.class, id); getHibernateTemplate().delete(e); } public Employee selectOne(Long id) { return (Employee) getHibernateTemplate().get(Employee.class, id); } public void update(Employee e) { getHibernateTemplate().update(e); } //计算总记录数 public int getAllRecords() { //String HQL="FROM Employee where name like '%a%'";//根据关键字查询得到总记录数 return getHibernateTemplate().find("FROM Employee").size(); } public List<Employee> findEmployees(int startRecord, int offset) { System.out.println(startRecord+","+offset+" +++++++++++"); //String HQL="FROM Employee e where name like '%a%' order by e.id";//根据关键字得到一定数量的用户 Query query = getSession().createQuery("FROM Employee"); query.setFirstResult(startRecord); query.setMaxResults(offset); return query.list(); //Hibernate分页时可能会遇到的问题： // 1.分页查询的时候多点几次上一页或下一页就卡住了。解决办法：spring过滤器要放到struts核心控制器前面 // 2.遇到"Turn your Session into FlushMode. // COMMIT/AUTO or remove 'readOnly' marker from transaction definition."时怎么办? // 解决办法：在applicationContext.xml文件中手动配置事务策略,配置如下： // <!-- 基本事务定义 --> // <tx:advice id="txAdvice" transaction-manager="transactionManager"> // <tx:attributes> // <tx:method name="save*"/> // <tx:method name="update*"/> // <tx:method name="remove*"/> // <tx:method name="delete*"/> // <tx:method name="create*"/> // <!-- other methods are set to read only --> // <tx:method name="*" read-only="true"/> // </tx:attributes> // </tx:advice> // // <aop:config proxy-target-class="true"> // <aop:pointcut id="managerOperation" expression="execution(** com.liuwei.crm.service.*.*(..))"/> // <aop:advisor advice-ref="txAdvice" pointcut-ref="managerOperation"/> // </aop:config> } }