汽车4S店客户管理系统源码.zip

package business.basic; import java.io.Serializable; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.Transaction; public class iHibBaseDAOImpl implements iHibBaseDAO { public static final int INSERT = 1;// 代表添加操作 public static final int UPDATE = 2;// 代表更新操作 public static final int DELETE = 3;// 代表删除操作 // private static final Log log=LogFactory.getLog(iHibBaseDAOImpl.class); @Override public Object insert(Object obj) {// obj必须是符合hibernate的pojo对象 Session session = HibSessionFactory.getSession(); Transaction tx = null; try { tx = session.beginTransaction();// 开始事务 Serializable key = session.save(obj); tx.commit();// 持久化操作 session.close(); return key; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.insert", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (tx != null) tx.rollback();// 撤销 if (session != null) session.close(); } return null; } @Override public boolean insert(List<Object> list) { Session session = HibSessionFactory.getSession(); Transaction tx = null; try { tx = session.beginTransaction();// 开始事务 for (Object obj : list) { session.save(obj); } tx.commit();// 持久化操作 session.close(); return true; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.insert", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (tx != null) tx.rollback();// 撤销 if (session != null) session.close(); } return false; } @Override public boolean delete(Class cls, Serializable id) { Session session = HibSessionFactory.getSession(); Transaction tx = null; try { tx = session.beginTransaction();// 开始事务 // 先用cls和id查询出要删除的对象 session.delete(session.get(cls, id)); tx.commit();// 持久化操作 session.close(); return true; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.delete", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (tx != null) tx.rollback();// 撤销 if (session != null) session.close(); } return false; } @Override public boolean delete(Object obj) { Session session = HibSessionFactory.getSession(); Transaction tx = null; try { tx = session.beginTransaction();// 开始事务 session.delete(obj); tx.commit();// 持久化操作 session.close(); return true; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.delete", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (tx != null) tx.rollback();// 撤销 if (session != null) session.close(); } return false; } @Override public boolean update(Object obj) { Session session = HibSessionFactory.getSession(); Transaction tx = null; try { tx = session.beginTransaction();// 开始事务 session.update(obj); tx.commit();// 持久化操作 session.close(); return true; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.update", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (tx != null) tx.rollback();// 撤销 if (session != null) session.close(); } return false; } @Override public List select(String hql) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); List list = query.list(); session.close(); return list; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.select", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return null; } @Override public List select(String hql, int startIndex, int length) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); query.setFirstResult(startIndex);// 设置起始记录位置 query.setMaxResults(length);// 设置返回记录数 List list = query.list(); session.close(); return list; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.select", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return null; } @Override public List select(String hql, Object[] para) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); // 根据para设置参数 for (int i = 0; i < para.length; i++) { query.setParameter(i, para[i]); } List list = query.list(); session.close(); return list; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.select", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return null; } @Override public List select(String hql, Object[] para, int startIndex, int length) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); // 根据para设置参数 for (int i = 0; i < para.length; i++) { query.setParameter(i, para[i]); } query.setFirstResult(startIndex);// 设置起始记录位置 query.setMaxResults(length);// 设置返回记录数 List list = query.list(); session.close(); return list; } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.select", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return null; } @Override public int selectValue(String hql) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); Object obj = query.uniqueResult(); session.close(); if (obj instanceof Long) { return ((Long) obj).intValue(); } else if (obj instanceof Integer) { return ((Integer) obj).intValue(); } } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.selectValue", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return 0; } @Override public int selectValue(String hql, Object[] para) { Session session = HibSessionFactory.getSession(); try { Query query = session.createQuery(hql); // 根据para设置参数 for (int i = 0; i < para.length; i++) { query.setParameter(i, para[i]); } Object obj = query.uniqueResult(); session.close(); if (obj instanceof Long) { return ((Long) obj).intValue(); } else if (obj instanceof Integer) { return ((Integer) obj).intValue(); } } catch (Exception e) { // TODO Auto-generated catch block // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.selectValue", // e));//向日志输出error级别的日志信息 e.printStackTrace(); if (session != null) session.close(); } return 0; } @Override public int selectPages(String hql, int pageSize) { Session session = HibSessionFactory.getSession(); long pages_all = 0; try { Query query = session.createQuery(hql); List list = query.list(); // 获取查询记录总数 long records = list.size(); // 计算分页 pages_all = records % pageSize == 0 ? records / pageSize : records / pageSize + 1;// 获取总页数 session.close(); return (int) pages_all; } catch (Exception e) { // log.error(LogUtil.error("Basic.iHibBaseDAOImpl.selectPages", // e));//向日志输出error级别的日志信