peijiandao.java

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

package com.gensou.dao.sheji.peijian;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;


import com.gensou.hibernate.model.Peijianxinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.sheji.peijian.AddPeijianService;
import com.gensou.logic.sheji.peijian.QueryPeijianService;
import com.gensou.logic.sheji.peijian.UpdatePeijianService;
import com.gensou.util.Pagination;

public class PeijianDao {
	/**
	 * 
	 * @param addorderService
	 * @return bo
	 */
	 public boolean addpeijian(AddPeijianService addpeijianService){
			boolean bo=false;
			Query query;
			List list;
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			Peijianxinxi peijian=new Peijianxinxi(); 
			String peijianid=addpeijianService.getPeijianxinxiId();
			query = (Query) session.createQuery("from Peijianxinxi where peijianxinxiId=? and pinming=? and caizhi=? and guige=?");
		    query.setString(0,peijianid);
		    query.setString(1,addpeijianService.getPinMing());
		    query.setString(2,addpeijianService.getCaiZhi());
		    query.setString(3, addpeijianService.getGuiGe());
			list=query.list();
			if(!list.isEmpty()){
				session.flush();
		    	session.close();
				return bo;
			}else{
				peijian.setPeijianxinxiId(peijianid);
				peijian.setPinming(addpeijianService.getPinMing());
				peijian.setCaizhi(addpeijianService.getCaiZhi());
				peijian.setGuige(addpeijianService.getGuiGe());
				peijian.setBeizhu(addpeijianService.getBeiZhu());
				session.save(peijian);
				session.flush();
				tx.commit();
		        session.clear();
				query = (Query) session.createQuery("from Peijianxinxi where peijianxinxiId=?");
			    query.setString(0,peijianid);
			    list=query.list();
			    if(!list.isEmpty()){
			    	session.flush();
			    	session.close();
			    	return bo=true;
			    }else{
			    	session.flush();
			    	session.close();
			    	return bo;
			    }
			}
			
		 }
	 public List querypeijian(String way,String term,int pag,int max){
			List peijian_info = new ArrayList();
			Session session=HibernateSessionFactory.getSession();
			Query query;
			String ways;
			String terms;
			List list=new ArrayList();
			try{
				ways=way;
				terms=term;
				if(way==null||way.equals("")||terms==null||terms.equals("")){
					
					query = (Query) session.createQuery("from Peijianxinxi");
					Pagination pagination=new Pagination();
					peijian_info=pagination.getNowlist(query,pag,max);
					if(!peijian_info.isEmpty()){
					for(int i=0;i<peijian_info.size();i++){
						Peijianxinxi peijian=new Peijianxinxi();
						peijian=(Peijianxinxi)peijian_info.get(i);
						QueryPeijianService querypeijianService=new QueryPeijianService();
						querypeijianService.setPinMing(peijian.getPinming());
						querypeijianService.setPeijianxinxiId(peijian.getPeijianxinxiId());
						querypeijianService.setId(peijian.getId());
						querypeijianService.setCaiZhi(peijian.getCaizhi());
						querypeijianService.setGuiGe(peijian.getGuige());
						querypeijianService.setBeiZhu(peijian.getBeizhu());
						querypeijianService.setZhuangtai(peijian.getZhuangtai());
						list.add(querypeijianService);
					}
					}
				    
				}else{
					String name="%"+term+"%";
					query = (Query) session.createQuery("from Peijianxinxi where "+ways+" like ?");
					query.setString(0,name);
					Pagination pagination=new Pagination();
					peijian_info=pagination.getNowlist(query,pag,max);
					if(!peijian_info.isEmpty()){
					for(int i=0;i<peijian_info.size();i++){
						Peijianxinxi peijian=new Peijianxinxi();
						peijian=(Peijianxinxi)peijian_info.get(i);
						QueryPeijianService querypeijianService=new QueryPeijianService();
						querypeijianService.setPinMing(peijian.getPinming());
						querypeijianService.setPeijianxinxiId(peijian.getPeijianxinxiId());
						querypeijianService.setId(peijian.getId());
						querypeijianService.setCaiZhi(peijian.getCaizhi());
						querypeijianService.setGuiGe(peijian.getGuige());
						querypeijianService.setBeiZhu(peijian.getBeizhu());
						querypeijianService.setZhuangtai(peijian.getZhuangtai());
						list.add(querypeijianService);
					}
					}
				}
			}catch(NullPointerException e){}
			session.flush();
	    	session.close();
			return list; 
		 }
         public void deletepeijian(String pid,String zhuangtai){
			 Session session=HibernateSessionFactory.getSession();
			 Transaction tx=session.beginTransaction();
			 try{
				 Integer id=Integer.parseInt(pid);
				 Peijianxinxi peijian=(Peijianxinxi)session.load(Peijianxinxi.class, id);
				 peijian.setZhuangtai(zhuangtai);
				 session.delete(peijian);
				 session.flush();
				 tx.commit();
			     session.close();
			 }catch(Exception e){
				 tx.rollback();
				 session.close();
			 }
		 }

		 
		 
         public boolean updatepeijian(UpdatePeijianService updatepeijian){
        	 boolean bo=false;
        	 Session session=HibernateSessionFactory.getSession();
        	 Transaction tx=session.beginTransaction();
        	 Peijianxinxi peijian=new Peijianxinxi(); 
        	 try{      		 
     			Integer id=updatepeijian.getId();
     			peijian=(Peijianxinxi)session.load(Peijianxinxi.class, id);
     			peijian.setPinming(updatepeijian.getPinMing());
     			peijian.setCaizhi(updatepeijian.getCaiZhi());
     			peijian.setGuige(updatepeijian.getGuiGe());
     			peijian.setBeizhu(updatepeijian.getBeiZhu());
     			session.update(peijian);
     			session.flush();
     			tx.commit();
		    	session.close();
     			bo=true;
     		 }catch(Exception e){
     			 tx.rollback();
     			 session.close();
     			 e.printStackTrace();
     			 return bo;
     		 }
			return bo;
       }         	 
}