MCPcopy Create free account
hub / github.com/diyhi/bbs / SmsRepositoryImpl

Class SmsRepositoryImpl

src/main/java/cms/repository/sms/impl/SmsRepositoryImpl.java:24–158  ·  view source on GitHub ↗

短信管理接口实现类

Source from the content-addressed store, hash-verified

22 *
23 */
24@Repository
25@Transactional
26public 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;

Callers

nothing calls this directly

Calls

no outgoing calls

Tested by

no test coverage detected

Used in the wild real call sites across dependent graphs

searching dependent graphs…