1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
| //package com.xzx.admin;
| //
| //import cn.hutool.core.date.DateUtil;
| //import com.xzx.log.LogApplication;
| //import com.xzx.log.entity.IntefaceAdminLog;
| //import com.xzx.log.mapper.IntefaceAdminLogMapper;
| //import com.xzx.log.service.MailService;
| //import freemarker.template.TemplateException;
| //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.context.ActiveProfiles;
| //import org.springframework.test.context.junit4.SpringRunner;
| //
| //import javax.mail.MessagingException;
| //import java.io.IOException;
| //
| //
| //@RunWith(SpringRunner.class)
| //@SpringBootTest(classes = {LogApplication.class})
| //@ActiveProfiles("dev")
| //public class SpringTest {
| //
| //
| // @Autowired
| // private IntefaceAdminLogMapper intefaceAdminLogMapper;
| //
| //
| // @Autowired
| // private MailService mailService;
| //
| // @Test
| // public void 邮件发送() throws MessagingException, IOException, TemplateException {
| //
| // IntefaceAdminLog intefaceAdminLog=new IntefaceAdminLog();
| // intefaceAdminLog.setId("12");
| // intefaceAdminLog.setUserId("aaaaaaaaaa");
| // intefaceAdminLog.setSqlParameter("UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )" +
| // "UPDATE xzx_user_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE user_id = 'YH1206494029815349248';SELECT user_id,mobile_phone,avatar,login_account,password,salt,name,nick_name,birthday,sex,user_type,open_id,country,province,city,del_flag,regist_time,longitude,latitude,regist_type,is_prohibit FROM xzx_user_info WHERE user_id = 'YH1206494029815349248' AND del_flag = 0 AND is_prohibit = false;UPDATE xzx_user_target_info SET longitude = '112.94013977050781',latitude = '28.128612518310547' WHERE ( ( mobile = '15574380477' and longitude is null ) )");
| // intefaceAdminLog.setIntoParameter("{\n" +
| // " \"code\": \"043kTMjj0zcKts134Pij0uHzjj0kTMjb\",\n" +
| // " \"pageNo\": 1,\n" +
| // " \"start\": 0,\n" +
| // " \"pageSize\": 5,\n" +
| // " \"smsType\": 0,\n" +
| // " \"notCheckLoginFlag\": 0,\n" +
| // " \"end\": 0,\n" +
| // " \"returnSessionKey\": 0\n" +
| // " }");
| // intefaceAdminLog.setCreateTime(DateUtil.date());
| // intefaceAdminLog.setImplementType("2");
| // intefaceAdminLog.setLogLevel("2");
| // mailService.sendEmail(intefaceAdminLog);
| // System.out.println("测试完成");
| //
| // }
| //
| //
| // @Test
| // public void add(){
| // IntefaceAdminLog intefaceAdminLog=new IntefaceAdminLog();
| // intefaceAdminLog.setId("12");
| // intefaceAdminLog.setUserId("aaaaaaaaaa");
| // intefaceAdminLogMapper.save(intefaceAdminLog);
| // }
| //
| //
| //
| //
| //}
|
|
