bumenxinxidao.java

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

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

import org.hibernate.*;

import com.gensou.hibernate.model.Bumenxinxi;
import com.gensou.hibernate.model.Client;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.bumen.xinxi.AddbmxinxiService;
import com.gensou.logic.bumen.xinxi.UpdatebmxinxiService;
import com.gensou.util.Pagination;

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

public class BumenxinxiDao {
	
	 public boolean addbumenxinxi(AddbmxinxiService addbumenxinxi){
		boolean bool=false;
		Query query;
		List list;
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		Bumenxinxi bumenxinxi=new Bumenxinxi();
		
		String bumenid=addbumenxinxi.getBumenid();
		
	    query = (Query) session.createQuery("from Bumenxinxi where bumenId=?");
	    query.setString(0,bumenid);
		list=query.list();
		if(!list.isEmpty()){
			return bool;
		}else{
			bumenxinxi.setBumenId(bumenid);
			bumenxinxi.setBumenName(addbumenxinxi.getBumenming());
			bumenxinxi.setBeizhu(addbumenxinxi.getBeizhu());
			bumenxinxi.setZhuangtai(addbumenxinxi.getZhuangtai());
		
			session.save(bumenxinxi);
			session.flush();
			tx.commit();
			query = (Query) session.createQuery("from Bumenxinxi where bumenId=?");
		    query.setString(0,bumenid);
		    list=query.list();
		    if(!list.isEmpty()){
		    	session.flush();
		    	session.close();
		    	return bool=true;
		    }else{
		    	session.flush();
		    	session.close();
		    	return bool;
		    }
		}
		
	 }
	 public List querybumenxinxi(String bumenid,int pageI,int maxpage){
		List bmxinxi = new ArrayList();
		Session session=HibernateSessionFactory.getSession();
		Query query;
		String str;
		try{
			str=bumenid;
			if(str==null||str.equals("")){
				query = (Query) session.createQuery("from Bumenxinxi");
				Pagination pageination=new Pagination();
				bmxinxi=pageination.getNowlist(query, pageI, maxpage);
			    
			}else{
				String bmid="%"+bumenid+"%";
				query = (Query) session.createQuery("from Bumenxinxi where bumenId like ?");
			    query.setString(0,bmid);
			    Pagination pageination=new Pagination();
			    bmxinxi=pageination.getNowlist(query, pageI, maxpage);
			}
		}catch(NullPointerException e){}
		session.flush();
    	session.close();
		return bmxinxi; 
	 }
	public void deletebumenxinxi(String bumenid,String zhuangtai){
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 try{
			 Integer id=Integer.parseInt(bumenid);
			 Bumenxinxi cl=(Bumenxinxi)session.load(Bumenxinxi.class, id);
			 cl.setZhuangtai(zhuangtai);
			 session.save(cl);
		     session.flush();
			 tx.commit();
	         session.close();
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
		 }
	 }
	 public boolean updatebumenxinxi(UpdatebmxinxiService updatebumenxinxi){
		 boolean bo=false;
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 Query query;
		 query = (Query) session.createQuery("from Bumenxinxi where bumenId=?");
		 query.setString(0,updatebumenxinxi.getBumenid());
		 List list=query.list();
		 if(!list.isEmpty()){
			 return bo;
		 }
		 Bumenxinxi bumenxinxi=new Bumenxinxi(); 
		 try{
			 
			String cid=updatebumenxinxi.getId();
			Integer id=Integer.parseInt(cid);
			bumenxinxi=(Bumenxinxi)session.load(Bumenxinxi.class, id);
			
			bumenxinxi.setBumenName(updatebumenxinxi.getBumenming());
			bumenxinxi.setBeizhu(updatebumenxinxi.getBeizhu());
			session.update(bumenxinxi);
			session.flush();
			tx.commit();
	    	session.close();
			bo=true;
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
			 return bo;
		 }
		 return bo; 
	 }
	}