matterdao.java

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

package com.gensou.dao.sheji.matter;

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.Client;
import com.gensou.hibernate.model.Mujuxinxi;
import com.gensou.hibernate.model.Sucaixinxi;
import com.gensou.hibernate.util.HibernateSessionFactory;
import com.gensou.logic.sheji.client.AddClientService;
import com.gensou.logic.sheji.matter.AddmatterService;
import com.gensou.logic.sheji.matter.QuerymatterService;
import com.gensou.logic.sheji.matter.UpdatematterService;
import com.gensou.logic.sheji.model.UpdateModelService;
import com.gensou.util.Pagination;

public class MatterDao {
	public boolean addclient(AddmatterService addmatter){
		boolean bo=false;
		Query query;
		List list;
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		try{
			Sucaixinxi sucaixinxi=new Sucaixinxi(); 
			Mujuxinxi model=(Mujuxinxi) session.load(Mujuxinxi.class,addmatter.getModelid());
		    query = (Query) session.createQuery("from Sucaixinxi where sucaixinxiId=?");
		    query.setString(0,addmatter.getSucaixinxiId());
			list=query.list();
			if(!list.isEmpty()){
				session.flush();
		    	session.close();
				return bo;
			}else{
				sucaixinxi.setSucaixinxiId(addmatter.getSucaixinxiId());
				sucaixinxi.setBeizhu(addmatter.getBeizhu());
				sucaixinxi.setBuguige(addmatter.getBuguige());
				sucaixinxi.setChangdu(addmatter.getChangdu());
				sucaixinxi.setMeipiangeshu(addmatter.getMeipiangeshu());
				sucaixinxi.setMujuxinxi(model);
				session.save(sucaixinxi);
				session.flush();
				tx.commit();
		    	session.close();
				return bo=true;
			}
		}catch(Exception e){
			e.printStackTrace();
			return bo;
		}
	}
	
	
	 public List querymatter(String ways,String terms,int pag,int max){
			List matter_info = new ArrayList();
			Session session=HibernateSessionFactory.getSession();
			Query query;
			String way;
			String term;
			List list;
			try{
				way=ways;
				term=terms;
				if(way==null||way.equals("")||term==null||term.equals("")){
					
					query = (Query) session.createQuery("from Sucaixinxi");
					Pagination pagination=new Pagination();
					list=pagination.getNowlist(query,pag,max);
				    if(!list.isEmpty()){
				    	for(int i=0;i<list.size();i++){
				            QuerymatterService matter=new QuerymatterService((Sucaixinxi)list.get(i));
				            matter_info.add(matter);
				    	}
				    }else{
			    		return matter_info;
			    	}
				}else{
					String name="%"+term+"%";
					query = (Query) session.createQuery("from Sucaixinxi where "+way+" like ?");
				    query.setString(0,name);
				    list=query.list();
				    if(!list.isEmpty()){
				    	for(int i=0;i<list.size();i++){
				            QuerymatterService matter=new QuerymatterService((Sucaixinxi)list.get(i));
				            matter_info.add(matter);
				    	}
				    }else{
			    		return matter_info;
			    	}
				}
			}catch(NullPointerException e){}
			session.flush();
	    	session.close();
			return matter_info; 
		 }
	 
	 public boolean updatematter(UpdatematterService updatematter){
		 boolean bo=false;
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		 
		 try{
			 Mujuxinxi model=(Mujuxinxi) session.load(Mujuxinxi.class,updatematter.getModelid());
			 Sucaixinxi sucai=(Sucaixinxi)session.load(Sucaixinxi.class, updatematter.getId());
			 sucai.setBeizhu(updatematter.getBeizhu());
			 sucai.setBuguige(updatematter.getBuguige());
			 sucai.setChangdu(updatematter.getChangdu());
			 sucai.setMeipiangeshu(updatematter.getMeipiangeshu());
			 sucai.setMujuxinxi(model);
			 session.update(model);
			 session.flush();
			 tx.commit();
	    	 session.close();
			bo=true;
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
			 e.printStackTrace();
			 return bo;
		 }
		 return bo; 
	 }
}