modeldao.java

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

package com.gensou.dao.sheji.model;

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.util.HibernateSessionFactory;
import com.gensou.logic.sheji.client.UpdateclientService;
import com.gensou.logic.sheji.model.AddModelService;
import com.gensou.logic.sheji.model.UpdateModelService;
import com.gensou.util.Pagination;

public class ModelDao {
  public boolean addmodel(AddModelService addmodel){
	  boolean bool=false;
		Query query;
		List list;
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		Mujuxinxi model=new Mujuxinxi(); 
		String modelid=addmodel.getMujuxinxiId();
		
	    query = (Query) session.createQuery("from Mujuxinxi where mujuxinxiId=?");
	    query.setString(0,modelid);
		list=query.list();
		if(!list.isEmpty()){
			session.flush();
	    	session.close();
			return bool;
		}else{
			model.setMujuxinxiId(modelid);
			model.setMujuGuige(addmodel.getMujuGuige());
			model.setZongchang(addmodel.getZongchang());
			model.setShuliang(addmodel.getShuliang());
			model.setBeizhu(addmodel.getBeizhu());
			model.setZhuangtai(addmodel.getZhuangtai());
			session.save(model);
			tx.commit();
			query = (Query) session.createQuery("from Mujuxinxi where mujuxinxiId=?");
		    query.setString(0,modelid);
		    list=query.list();
		    if(!list.isEmpty()){
		    	session.flush();
		    	session.close();
		    	return bool=true;
		    }else{
		    	session.flush();
		    	session.close();
		    	return bool;
		    }
		}
  }
  
  public List querymodel(String ways,String terms,int pag,int max){
		List model_info = 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 Mujuxinxi");
				Pagination pagination=new Pagination();
				model_info=pagination.getNowlist(query,pag,max);
			    
			   
			    
			}else{
				String name="%"+term+"%";
				query = (Query) session.createQuery("from Mujuxinxi where "+way+" like ?");
			    query.setString(0,name);
			    model_info=query.list();
			}
		}catch(NullPointerException e){}
		session.flush();
    	session.close();
		return model_info; 
	 }
  
  public boolean updatemodel(UpdateModelService updatemodel){
		 boolean bo=false;
		 Session session=HibernateSessionFactory.getSession();
		 Transaction tx=session.beginTransaction();
		
		 Mujuxinxi model=new Mujuxinxi(); 
		 try{
			 
			 model=(Mujuxinxi)session.load(Mujuxinxi.class, updatemodel.getId());
			 
			 model.setMujuGuige(updatemodel.getMujuGuige());
			 model.setZongchang(updatemodel.getZongchang());
			 model.setShuliang(updatemodel.getShuliang());
			 model.setBeizhu(updatemodel.getBeizhu());
			session.update(model);
			session.flush();
			tx.commit();
	    	session.close();
			bo=true;
		 }catch(Exception e){
			 tx.rollback();
			 session.close();
			 return bo;
		 }
		 return bo; 
	 }
}