ssh增删改查实例源码（通过测试）

package org.fkit.test.impl; import java.util.ArrayList; import java.util.List; import org.fkit.test.dao.PersonnelDAO; import org.fkit.test.model.Personnel; import org.fkit.test.util.HibernateUtil; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; public class PersonnelDAOImpl implements PersonnelDAO{ @Override public void update(Personnel personnel) { // TODO Auto-generated method stub if(exists(personnel.getName())){ Personnel p = getByName(personnel.getName()); int id = p.getId(); SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); if(id > 0){ System.out.println(id); personnel.setId(id); session.update(personnel); session.getTransaction().commit(); } }else{ SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); session.save(personnel); session.getTransaction().commit(); } } @Override public void removeById(int id) { // TODO Auto-generated method stub Personnel personnel = new Personnel(); personnel.setId(id); SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); session.delete(personnel); session.getTransaction().commit(); } @Override public void remove(Personnel personnel) { // TODO Auto-generated method stub removeById(personnel.getId()); } @SuppressWarnings("unchecked") @Override public List<Personnel> list() { // TODO Auto-generated method stub List<Personnel> personnels = new ArrayList<Personnel>(); SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); Query query = (Query) session.createQuery("from Personnel"); personnels = (List<Personnel>)query.list(); session.getTransaction().commit(); return personnels; } @Override public Personnel getByName(String name) { // TODO Auto-generated method stub SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); Personnel personnel = (Personnel) session.createQuery("from Personnel p where p.name = ?") .setString(0, name) .uniqueResult(); session.getTransaction().commit(); return personnel; } @Override public boolean exists(String name) { // TODO Auto-generated method stub SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.getCurrentSession(); session.beginTransaction(); long count = (Long)session.createQuery("select count(*) from Personnel personnel where personnel.name = ?") .setString(0, name) .uniqueResult(); session.getTransaction().commit(); if(count > 0){ return true; }else{ return false; } } }