接口字段更新，批量更新測試案例

 1 public class UpdateTest {
　　　//鏈接數據庫，找出更新的接口，根據接口id找出測試案例
 2   public static void main(String[] args) {
 3     String dbConfig = "{\n" +
 4             "    \"host\": \"jdbc:mysql://localhost:3306\"," +
 5             "    \"user\": \"root\"," +
 6             "    \"password\": \"qwer1234!\"," +
 7             "    \"db\": \"ittest\"," +
 8             "    \"charset\": \"useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false&allowPublicKeyRetrieval=true\"," +
 9             "    \"autocommit\": true" +
10             "}";
11     JdbcUtil jdbcUtil = new JdbcUtil();
12     jdbcUtil.getdb(dbConfig);
13     List<Map<String, Object>> map =jdbcUtil.queryForListMap("SELECT id,request_data FROM tb_test_case WHERE interface_id = 77");
14     testcaseupdate(map,jdbcUtil);
15   }
16 
17   /**
18    * 新增字段
19    * @param map
20    * @param jdbcUtil
21    */
22   public static void  testcaseAdd(List<Map<String, Object>> map,JdbcUtil jdbcUtil){
         //遍歷案例，獲取請求體，put新增字段
23       if (map != null) {
24         for (int i = 0; i < map.size(); i++) {
25           System.out.println(map.get(i).get("request_data"));
26           String str = (String) map.get(i).get("request_data");
27           JSONObject jsonObject = JSONObject.parseObject((String) map.get(i).get("request_data"));
28           JSONObject req_json = jsonObject.getJSONObject("json");
29           req_json.put("sex","#at_sex#");
30           jsonObject.put("json",req_json);
31           String sql = "UPDATE tb_test_case SET request_data = '"+jsonObject+"' WHERE id = "+map.get(i).get("id");
32           System.out.println("======sql======="+sql);
33           jdbcUtil.update(sql);
34         }
35       }
36   }
37 
38   /**
39    * 修改value值
40    * @param map
41    * @param jdbcUtil
42    */
43   public static void testcaseupdate(List<Map<String, Object>> map,JdbcUtil jdbcUtil){
44     if (map != null) {
45       for (int i = 0; i < map.size(); i++) {
46         System.out.println(map.get(i).get("request_data"));
47         String str = (String) map.get(i).get("request_data");
48         str = str.replace("#at_email#","12345@qq.com");
49         String sql = "UPDATE tb_test_case SET request_data = '"+str+"' WHERE id = "+map.get(i).get("id");
50         System.out.println("======sql======="+sql);
51         jdbcUtil.update(sql);
52       }
53     }
54   }
55 
56 }