taobao 下dao改造以及删除dao

yujian

2019-03-20 1e53e5f28c55ece70b28c752fa318e2fd951e643

 fanli/src/main/java/com/yeshi/fanli/service/impl/user/ShamUserServiceImpl.java

@@ -1,157 +1,43 @@
package com.yeshi.fanli.service.impl.user;



import java.math.BigDecimal;

import java.text.DecimalFormat;

import java.util.ArrayList;

import java.util.Collections;

import java.util.Comparator;

import java.util.List;



import javax.annotation.Resource;



import net.sf.json.JSONArray;



import org.hibernate.HibernateException;

import org.hibernate.SQLQuery;

import org.hibernate.Session;

import org.springframework.orm.hibernate4.HibernateCallback;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;



import com.yeshi.fanli.dao.mybatis.user.ShamUserMapper;

import com.yeshi.fanli.dao.user.ShamUserDao;

import com.yeshi.fanli.entity.bus.user.HongBaoMessage;

import com.yeshi.fanli.entity.bus.user.ShamUser;

import com.yeshi.fanli.service.inter.config.ConfigService;

import com.yeshi.fanli.service.inter.user.ShamUserService;

import com.yeshi.fanli.util.Constant;

import com.yeshi.fanli.util.StringUtil;

import com.yeshi.fanli.util.Utils;



import net.sf.json.JSONArray;



@Service

public class ShamUserServiceImpl implements ShamUserService {

	
   @Resource

   private ShamUserDao dao;

	


   @Resource

   private ShamUserMapper shamUserMapper;

	


   @Resource

   private ConfigService configService;

	
	


   @Transactional

   public void addShamUser(ShamUser shamUser) {

      dao.save(shamUser);

      shamUserMapper.insertSelective(shamUser);

   }



   public List<ShamUser> getAll() {

      return dao.list("from ShamUser");

      return shamUserMapper.listAll();

   }



	
   @SuppressWarnings("unchecked")

   public List<ShamUser> findShamUserList(int sum){

      return (List<ShamUser>) dao.excute(new HibernateCallback<List<ShamUser>>() {



         public List<ShamUser> doInHibernate(Session session)

               throws HibernateException {

            SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_sham_user").addEntity(ShamUser.class);

            query.setFirstResult(0);

            query.setMaxResults(sum);

            List<ShamUser> list = query.list();

            return list;

         }

      });

   }

	
   @SuppressWarnings("unchecked")

   public List<HongBaoMessage> getManyData() {

		
      return (List<HongBaoMessage>) dao.excute(new HibernateCallback<List<HongBaoMessage>>() {



         public List<HongBaoMessage> doInHibernate(Session session)

               throws HibernateException {

            SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_sham_user ORDER BY RAND()").addEntity(ShamUser.class);

            query.setFirstResult(0);

            query.setMaxResults(Constant.PAGE_SIZE);

            List<ShamUser> list = query.list();

            List<HongBaoMessage> hbmList=new ArrayList<HongBaoMessage>();

            if(list.size()>0){

               HongBaoMessage hbm = null;

               DecimalFormat df = new DecimalFormat("######0.00");  
               for (ShamUser shamUser : list) {

                  hbm=new HongBaoMessage();

                  hbm.setName(shamUser.getName());

                  hbm.setPicUrl(shamUser.getPicUrl());

                  double random = (Math.random()+0.01)*20;

                  String format = df.format(random);

                  hbm.setContent("悄悄领取了"+format+"元红包");

                  hbmList.add(hbm);

               }

            }

            return hbmList;

         }

      });

   }

   @Transactional

   public void delete(final long id) {

      dao.excute(new HibernateCallback() {

         public Object doInHibernate(Session session)

               throws HibernateException {

               session.createQuery(" delete ShamUser su where su.id = ? ").setParameter(0, id).executeUpdate();

            return null;

         }

      });

   }



   @SuppressWarnings("unchecked")

   public List<HongBaoMessage> findShamThreeSaleInfo() {



      return (List<HongBaoMessage>) dao.excute(new HibernateCallback<List<HongBaoMessage>>() {



         public List<HongBaoMessage> doInHibernate(Session session)

               throws HibernateException {

            SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_sham_user ORDER BY RAND()").addEntity(ShamUser.class);

            query.setFirstResult(0);

            query.setMaxResults(5);

            List<ShamUser> list = query.list();

            List<HongBaoMessage> hbmList=new ArrayList<HongBaoMessage>();

            if(list.size()>0){

               HongBaoMessage hbm = null;

               DecimalFormat df = new DecimalFormat("######0.00");  
               for (ShamUser shamUser : list) {

                  String name = shamUser.getName();

                  if(name != null){

                     if(name.length() > 2){

                        name = Utils.getStarString(name,1,name.length()-1);

                     }else{

                        name = name.substring(0, 1)+"**"+name.substring(name.length()-1);

                     }

                  }

                  shamUser.setName(name);

                  hbm=new HongBaoMessage();

                  hbm.setName(shamUser.getName());

                  hbm.setPicUrl(shamUser.getPicUrl());

                  double random = (Math.random()+100)*10;

                  String format = df.format(random);

                  hbm.setContent(format+"");

                  hbmList.add(hbm);

               }

            }

            Collections.sort(hbmList, new Comparator<HongBaoMessage>() {

               public int compare(HongBaoMessage o1, HongBaoMessage o2) {

                  double o1m = Double.parseDouble(o1.getContent());

                  double o2m = Double.parseDouble(o2.getContent());

                  double m=o1m-o2m;

                  return m<0?1:-1;

               }

            });

            return hbmList;

         }

      });

	
   public List<ShamUser> findShamUserList(int sum) {

      return shamUserMapper.listShamUserByKey(0, sum, null);

   }



   @Override

@@ -183,23 +69,22 @@
   public int updateByPrimaryKey(ShamUser record) {

      return shamUserMapper.updateByPrimaryKey(record);

   }

	
	


   @Override

   public List<ShamUser> listDistinctPicUrl(long start, int count) {

      return shamUserMapper.listByDistinctPicUrl(start, count);

   }

	


   @Override

   public int insertBatch(List<ShamUser> list) {

      return shamUserMapper.insertBatch(list);

   }

	


   @Override

   public int updateBatchSelective(List<ShamUser> list) {

      return shamUserMapper.updateBatchSelective(list);

   }

	


   @Override

   public List<ShamUser> listRandCouponUser(int count, int smallTime, int largeTime) {

      List<Integer> listTime = new ArrayList<Integer>();

@@ -228,7 +113,7 @@


   @Override

   public List<ShamUser> listRandShareUser(int count, BigDecimal shareMoney, int small, int large) {

		


      List<Integer> listMultiple = new ArrayList<Integer>();



      while (listMultiple.size() < count) {

@@ -261,8 +146,9 @@
            shamUser.setShareBonusPic((String) imgList.get(randBonusPic));

         }



         BigDecimal money = shareMoney.multiply(new BigDecimal(((Integer) listMultiple.get(i)).intValue())).setScale(2, 1);

         // 必须包含 【奖金¥】  这3个符号，  用于前端颜色区分

         BigDecimal money = shareMoney.multiply(new BigDecimal(((Integer) listMultiple.get(i)).intValue()))

               .setScale(2, 1);

         // 必须包含 【奖金¥】 这3个符号， 用于前端颜色区分

         shamUser.setMsg("分享了这个商品,累计获得奖金¥" + money);

      }



@@ -271,7 +157,7 @@


   public void transformId(ShamUser shamUser) {

      String id = shamUser.getId() + "";

		


      if (id.length() == 1) {

         shamUser.setShowId("2****" + id);

      } else {

@@ -279,4 +165,8 @@
      }

   }



   @Override

   public List<ShamUser> listRandUser(int count) {

      return shamUserMapper.listRand(count);

   }

}