短信管理接口实现类
| 22 | * |
| 23 | */ |
| 24 | @Repository |
| 25 | @Transactional |
| 26 | public class SmsRepositoryImpl extends DaoSupport<SmsInterface> implements SmsRepository { |
| 27 | private static final Logger logger = LogManager.getLogger(SmsRepositoryImpl.class); |
| 28 | |
| 29 | |
| 30 | /** |
| 31 | * 根据Id查询短信接口 |
| 32 | * @param smsInterfaceId 短信接口Id |
| 33 | * @return |
| 34 | */ |
| 35 | @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) |
| 36 | public SmsInterface findSmsInterfaceById(Integer smsInterfaceId){ |
| 37 | Query query = em.createQuery("select o from SmsInterface o where o.id=?1"); |
| 38 | //给SQL语句设置参数 |
| 39 | query.setParameter(1, smsInterfaceId); |
| 40 | List<SmsInterface> smsInterfaceList= query.getResultList(); |
| 41 | if(smsInterfaceList != null && smsInterfaceList.size() >0){ |
| 42 | for(SmsInterface o: smsInterfaceList){ |
| 43 | return o; |
| 44 | } |
| 45 | } |
| 46 | return null; |
| 47 | } |
| 48 | /** |
| 49 | * 查询所有短信接口 |
| 50 | * @return |
| 51 | */ |
| 52 | @Transactional(readOnly=true,propagation=Propagation.NOT_SUPPORTED) |
| 53 | public List<SmsInterface> findAllSmsInterface(){ |
| 54 | Query query = em.createQuery("select o from SmsInterface o "); |
| 55 | return query.getResultList(); |
| 56 | } |
| 57 | /** |
| 58 | * 保存短信接口 |
| 59 | * @param smsInterface 短信接口 |
| 60 | */ |
| 61 | @CacheEvict(value="smsRepositoryImpl_cache",allEntries=true) |
| 62 | public void saveSmsInterface(SmsInterface smsInterface){ |
| 63 | this.save(smsInterface); |
| 64 | } |
| 65 | |
| 66 | /** |
| 67 | * 修改短信接口 |
| 68 | * @param smsInterface 短信接口 |
| 69 | */ |
| 70 | @CacheEvict(value="smsRepositoryImpl_cache",allEntries=true) |
| 71 | public Integer updateSmsInterface(SmsInterface smsInterface){ |
| 72 | Query query = em.createQuery("update SmsInterface o set o.name=?1,o.dynamicParameter=?2,o.sort=?3,o.sendService=?4,o.version=?5 where o.id=?6") |
| 73 | .setParameter(1, smsInterface.getName()) |
| 74 | .setParameter(2, smsInterface.getDynamicParameter()) |
| 75 | .setParameter(3, smsInterface.getSort()) |
| 76 | .setParameter(4, smsInterface.getSendService()) |
| 77 | .setParameter(5, smsInterface.getVersion()) |
| 78 | .setParameter(6, smsInterface.getId()); |
| 79 | int i = query.executeUpdate(); |
| 80 | |
| 81 | return i; |
nothing calls this directly
no outgoing calls
no test coverage detected
searching dependent graphs…