1082d8b9f4a9001b1135cac680bc3f0f

gensou.rar为某渔具厂的一个简单ERP系统。为比较基础的工程

package com.gensou.dao.yuangong.xinxi;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.*;

import com.gensou.hibernate.model.Bumenxinxi;
import com.gensou.hibernate.model.Yuangongxinxi;

import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.yuangong.xinxi.AddygxinxiService;
import com.gensou.logic.yuangong.xinxi.UpdateygxinxiService;

import com.gensou.util.Pagination;

	/*
	import com.gensou.hibernate.util.HibernateSessionFactory;
	*/

public class YuangongxinxiDao {
	
	 public static boolean addygxinxi(AddygxinxiService addygxinxi){
		boolean bool=false;
		Query query;
		List list;
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		
		Yuangongxinxi yuangongxinxi=new Yuangongxinxi();
		String yuangongid=addygxinxi.getYuangongid();
		try{                                                          
	    query = (Query) session.createQuery("from Yuangongxinxi where yuangongId=?");
	    query.setString(0,yuangongid);
		list=query.list();
		if(!list.isEmpty()){
			return bool;
		}else{
			yuangongxinxi.setYuangongId(yuangongid);
			yuangongxinxi.setYuangongName(addygxinxi.getYuangongname());
			yuangongxinxi.setYuangongSex(addygxinxi.getYuangongsex());
			yuangongxinxi.setYuangongBirth(addygxinxi.getYuangongbirth());
			yuangongxinxi.setYuangongTel1(addygxinxi.getYuangongtel1());
			yuangongxinxi.setYuangongTel2(addygxinxi.getYuangongtel2());
			yuangongxinxi.setYuangongAddress(addygxinxi.getYuangongaddress());
			Bumenxinxi bumen= (Bumenxinxi) session.load(Bumenxinxi.class, addygxinxi.getBid());
			yuangongxinxi.setBumenxinxi(bumen);
			yuangongxinxi.setBeizhu(addygxinxi.getBeizhu());
			yuangongxinxi.setZhuangtai(addygxinxi.getZhuangtai());
			session.save(yuangongxinxi);
			tx.commit();
			session.flush();
			session.close();
			query = (Query) session.createQuery("from Yuangongxinxi where yuangongId=?");
		    query.setString(0,yuangongid);
		    list=query.list();
		    if(!list.isEmpty()){
		    	return bool=true;
		    }else{
		    	return bool;
		    }
		}
		}catch(Exception e){
			e.printStackTrace();
			session.flush();
			
			session.close();
			return bool;
		}
		
	 }
	 public static List queryygxinxi(String ways,String terms,int pageI,int maxpage){
		List ygxinxi = new ArrayList();
		Session session=HibernateSessionFactory.getSession();
		Query query;
		String way;
		String  term;
		try{
			way=ways;
			term=terms;
			if(way==null||way.equals("")||term==null||term.equals("")){
				query = (Query) session.createQuery("from Yuangongxinxi");
				Pagination pageination=new Pagination();
				ygxinxi=pageination.getNowlist(query, pageI, maxpage);
			    
			}else{
				String name="%"+term+"%";
				query = (Query) session.createQuery("from Yuangongxinxi where "+way+" like ?");
			    query.setString(0,name);
			    Pagination pageination=new Pagination();
			    ygxinxi=pageination.getNowlist(query, pageI, maxpage);
			}
		}catch(NullPointerException e){}
		
		return ygxinxi; 
	 }
	public static void deleteygxinxi(String yuangongid,String zhuangtai){
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 try{
			 Integer id=Integer.parseInt(yuangongid);
			 Yuangongxinxi cl=(Yuangongxinxi)session.load(Yuangongxinxi.class, id);
			 cl.setZhuangtai(zhuangtai);
			 session.save(cl);
		     tx.commit();
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
		 }
	 }
	 public static boolean updateygxinxi(UpdateygxinxiService updateygxinxi){
		 boolean bo=false;
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 try{
		   Bumenxinxi bumenxinxi=(Bumenxinxi)session.load(Bumenxinxi.class, updateygxinxi.getBumenid()) ;
		   Yuangongxinxi yuangongxinxi=new Yuangongxinxi();
		 
			Integer id=Integer.parseInt(updateygxinxi.getId());
			yuangongxinxi=(Yuangongxinxi)session.load(Yuangongxinxi.class, id);
			yuangongxinxi.setYuangongName(updateygxinxi.getYuangongname());
			yuangongxinxi.setYuangongSex(updateygxinxi.getYuangongsex());
			yuangongxinxi.setYuangongBirth(updateygxinxi.getYuangongbirth());
			yuangongxinxi.setYuangongTel1(updateygxinxi.getYuangongtel1());
			yuangongxinxi.setYuangongTel2(updateygxinxi.getYuangongtel2());
			yuangongxinxi.setYuangongAddress(updateygxinxi.getYuangongaddress());
			yuangongxinxi.setBumenxinxi(bumenxinxi);
			yuangongxinxi.setBeizhu(updateygxinxi.getBeizhu());
			session.save(yuangongxinxi);
			tx.commit();
			bo=true;
			session.flush();
			session.close();
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
			 e.printStackTrace();
			 return bo;
		 }
		 return bo; 
	 }
	}