摘要：
最近，再次进行了接口自动化测试。有几个重要的方法。1.获取http状态代码/**返回接口状态代码**/publicstaticStringgetHttpCode（Stringurl）｛Stringcode=null；try｛URLu=newURL（url）；URLConnectionuc=u.openConnection（）；HttpURLConnectionhuc=（HttpURLConnection）
最近再做接口自动化测试，其中有几个方法比较重要
1.获取http状态码
/* * 返回接口状态码 * */ public static String getHttpCode(String url) { String code = null; try { URL u = new URL(url); URLConnection uc = u.openConnection(); HttpURLConnection huc = (HttpURLConnection)uc; code = new Integer(huc.getResponseCode()).toString(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return code; }
2.获取json
/* * 3个参数 * */ public static String getJson(String base_url, String para1, String value1, String para2, String value2, String para3, String value3) { String url = base_url + para1 + "=" + value1 + "&" + para2 + "=" + value2 + "&" + para3 + "=" + value3; String result = ""; String code = getHttpCode(url); if(!code.startsWith("2")) { result = "*******接口的状态码为："+code+"*******"+url; }else { StringBuilder json = new StringBuilder(); try { URL u = new URL(url); URLConnection uc = u.openConnection(); BufferedReader bd = new BufferedReader(new InputStreamReader(uc.getInputStream(),"UTF-8")); String s = null; while((s=bd.readLine())!=null) { json.append(s); } bd.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } result = json.toString(); } return result; }
3.获取json中的某个值，如{"a":"1"}
public static String getJsonValue(String json, String name){ String s = null; JSONObject jobj = JSONObject.fromObject(json); //JSONObject jobj = JSONObject.fromObject("{'total':'0','message':'用户编号不能为空','data':'','code':'2','rows':''}"); Iterator it = jobj.keys(); while(it.hasNext()){ String key = it.next().toString(); String value = jobj.getString(key); if(key.equals(name)) { s = value.trim(); } } return s; }
4.获取双重json中第二维json的某个值，如{"a":"1",{"b":"1"}}
public static String getJsonValue(String json,String jdate, String name){
JSONObject jobj = JSONObject.fromObject(json);
JSONObject dataList=jobj.getJSONObject(jdate);
String balance =dataList.getString(name);
return balance;
} 5.获取json中包含数组中的第N个json，如{"a":"1","b":"[{"a2":"1"},{"b2":"1"}]"}
/*获取jsonArray*/ public static String getJsonArray(String json, String arr_name, int index) { JSONObject jobj = JSONObject.fromObject(json); JSONArray childs= jobj.getJSONArray(arr_name); JSONObject job = childs.getJSONObject(index); return job.toString(); }
XIAOBAI
static void getVo(){ String result = HttpClientUtil.httpGet("http://127.0.0.1:8080/test/vo?id=100"); JSONObject jsonObject = JSONObject.parseObject(result); JSONObject userObject = jsonObject.getJSONObject("user"); Object object = userObject.get("mobile"); System.out.println("mobile="+object); //获取json中message的string值 String message = jsonObject.getString("message"); System.out.println(message); //获取json中code的int值 int code = jsonObject.getIntValue("code"); System.out.println(code); //获取json数组 JSONArray jsonArray = jsonObject.getJSONArray("users"); JSONObject userJson = jsonArray.getJSONObject(1); System.out.println(userJson.get("id")); }
6.连接数据库
public static List<String> connectSqlList(String sql,String userNum, String col) {
String url = "jdbc:mysql://172.16.30.209:3306/a_test";
String name = "gmsd";
Connection con = null;
ResultSet rs = null;
String rssql = null;
List<String> list = new ArrayList<String>();
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url,name,"dlnu1234");
PreparedStatement pst = con.prepareStatement(sql);
pst.setString(1, userNum);
rs = pst.executeQuery();
while(rs.next()) {
rssql = rs.getString(col);
list.add(rssql);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
rs.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return list;
}