mobildao.java

beijing donggandidai shoufeifanghao

package com.bj.admin.dao.hibernate;

import java.util.List;

import javax.servlet.http.HttpServletRequest;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.springframework.orm.hibernate3.HibernateTemplate;

import com.bj.admin.bean.po.ComBjmobilTmobiles;
import com.bj.admin.bean.po.ComBjmobilToperator;
import com.bj.admin.dao.IMobilDAO;
import com.bj.admin.util.page;

public class mobilDAO implements IMobilDAO{
	private SessionFactory sf;
    private HibernateTemplate template;
    public void setSf(SessionFactory sf) {
		this.sf = sf;
		template = new HibernateTemplate(sf);
	}
	public void addComBjmobilTmobiles(HttpServletRequest httpServletRequest) {
		SessionFactory sf1 = template.getSessionFactory();
		Session s = sf1.openSession();
		Transaction ts = s.beginTransaction();
		String select = httpServletRequest.getParameter("radiobutton");
		String numb = httpServletRequest.getParameter("numbegin");
		long a = Long.parseLong(numb);
		long b = Long.parseLong(httpServletRequest.getParameter("numend"));
		long l = b-a;
		try
		{	
			ts.begin();
			for(int i = 0 ; i < l ; i++)
			{
				ComBjmobilTmobiles mobil = new ComBjmobilTmobiles();
				mobil.setMobileNumber(numb);
				mobil.setIsAvailable("y");
				String numc = "";
				//随机生成10位卡号
				for(int j = 0; j<10 ; j++)
				{
					
					int number = (int)(Math.random()*11);
					numc=numc+number;
				}
				
				mobil.setCardNumber(numc);
				mobil.setMobileType(select);
				s.save(mobil);
			}
			ts.commit();
		}
		catch (Exception ex)
		{
			ts.rollback();
			throw new RuntimeException();
		}
		finally
		{
			s.close();
		}
	}

	public void deleteComBjmobilTmobiles(ComBjmobilTmobiles mobil) {
		template.delete(mobil);
		
	}

	public List findAll(String hql) {
		List list = template.find(hql);
		return list;
	}

	public ComBjmobilTmobiles searchByID(Long id) {
		ComBjmobilTmobiles mobil = 
			(ComBjmobilTmobiles) template.get(ComBjmobilTmobiles.class, id);
		return mobil;
	}

	public void updateComBjmobilTmobiles(ComBjmobilTmobiles mobil) {
		template.update(mobil);
		
	}
	public List findAll(int currow, int pagesize, String hql) {
			  List list = null;
			  SessionFactory sfa = template.getSessionFactory();
			  Session s = sfa.openSession();
		      Query q=s.createQuery(hql);
		      q.setFirstResult(currow);
		      q.setMaxResults(pagesize);
		      list=q.list();
		      s.close();
		      return list;
	}
	

}