| package com.matrix; | 
|   | 
| import com.matrix.core.tools.StringUtils; | 
| import com.matrix.system.constance.Dictionary; | 
| import com.matrix.system.hive.bean.MoneyCardUse; | 
| import com.matrix.system.hive.bean.ShoppingGoods; | 
| import com.matrix.system.hive.bean.SysSourceFlow; | 
| import com.matrix.system.hive.bean.SysVipInfo; | 
| import com.matrix.system.hive.dao.MoneyCardUseDao; | 
| import com.matrix.system.hive.dao.ShoppingGoodsDao; | 
| import com.matrix.system.hive.dao.SysSourceFlowDao; | 
| import com.matrix.system.hive.dao.SysVipInfoDao; | 
| import org.junit.Test; | 
| import org.junit.runner.RunWith; | 
| import org.springframework.beans.factory.annotation.Autowired; | 
| import org.springframework.boot.test.context.SpringBootTest; | 
| import org.springframework.test.annotation.Rollback; | 
| import org.springframework.test.context.junit4.SpringRunner; | 
| import org.springframework.transaction.annotation.Transactional; | 
|   | 
| import javax.sql.DataSource; | 
| import java.util.List; | 
|   | 
| /** | 
|  * 测试类示例 | 
|  *  | 
|  * @author jiangyouyao | 
|  * @email 512061637@qq.com | 
|  * @date 2019年2月25日 | 
|  */ | 
| @RunWith(SpringRunner.class) | 
| @SpringBootTest | 
| public class SourceFlowTests { | 
|   | 
|     @Autowired | 
|     DataSource dataSource; | 
|   | 
|     @Test | 
|     public void contextLoads() { | 
|         System.out.println(dataSource.getClass()); | 
|     } | 
|   | 
|   | 
|     @Autowired | 
|     private SysSourceFlowDao sysSourceFlowDao; | 
|   | 
|     @Autowired | 
|     private ShoppingGoodsDao shoppingGoodsDao; | 
|   | 
|   | 
|     @Autowired | 
|     private SysVipInfoDao vipInfoDao; | 
|   | 
|   | 
|   | 
|     @Test | 
|     @Transactional | 
|     @Rollback | 
|     public void insertFlow() { | 
|         SysSourceFlow sysSourceFlow=new SysSourceFlow(); | 
|         sysSourceFlow.setCreateBy("1"); | 
|         sysSourceFlow.setUpdateBy("2"); | 
|   | 
|         sysSourceFlowDao.insert(sysSourceFlow); | 
|     } | 
|   | 
|   | 
|     @Test | 
|     @Transactional | 
|     @Rollback(false) | 
|     public void initGoodsPingyin() { | 
|   | 
|         List<ShoppingGoods> shoppingGoods = shoppingGoodsDao.selectByModel(null); | 
|         shoppingGoods.forEach(shoppingGood -> { | 
|             shoppingGood.setZjm(StringUtils.toHanyuPinyin(shoppingGood.getName())+","+StringUtils.toHeadWordHanyuPinyin(shoppingGood.getName())); | 
|             ShoppingGoods s=new ShoppingGoods(); | 
|             s.setId(shoppingGood.getId()); | 
|             s.setZjm(shoppingGood.getZjm()); | 
|             shoppingGoodsDao.update(s); | 
|         }); | 
|   | 
|     } | 
|   | 
|   | 
|     @Test | 
|     @Transactional | 
|     @Rollback(false) | 
|     public void initVipInfoPingyin() { | 
|   | 
|         List<SysVipInfo> vipInfoList = vipInfoDao.selectByModel(null); | 
|         vipInfoList.forEach(sysVipInfo -> { | 
|             if(StringUtils.isNotBlank(sysVipInfo.getVipName())){ | 
|                 String name=  sysVipInfo.getVipName().replaceAll("[\\x{10000}-\\x{10FFFF}]", ""); | 
|                 sysVipInfo.setZjm(StringUtils.toHanyuPinyin(name)+","+StringUtils.toHeadWordHanyuPinyin(name)); | 
|                 SysVipInfo s=new SysVipInfo(); | 
|                 s.setId(sysVipInfo.getId()); | 
|                 s.setZjm(sysVipInfo.getZjm()); | 
|                 vipInfoDao.update(s); | 
|             } | 
|   | 
|         }); | 
|   | 
|     } | 
|   | 
|   | 
| } |