如何判断接口响应结果（复杂json）是否和数据库查询结果一致

liuheng1

接口响应数据为{"content":{"appList":[{"appSummary":{"appName":"智能厅堂系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70466},"attention":false,"healthDegree":100},{"appSummary":{"appName":"综合柜面系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70512},"attention":false,"healthDegree":100},{"appSummary":{"appName":"综合业务系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70211},"attention":false,"healthDegree":100},{"appSummary":{"appName":"规则引擎","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70219},"attention":false,"healthDegree":100},{"appSummary":{"appName":"PE流程引擎","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70221},"attention":false,"healthDegree":100},{"appSummary":{"appName":"旧版网上银行系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70355},"attention":false,"healthDegree":100},{"appSummary":{"appName":"微信银行系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70373},"attention":false,"healthDegree":100},{"appSummary":{"appName":"电话银行系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70391},"attention":false,"healthDegree":100},{"appSummary":{"appName":"村镇银行综合业务系统","categoryId":1001002,"groupId":1,"groupName":"综合业务","l1CateName":"应用群组","l2CateName":"生产应用系统","l3CateName":"规划类","objectId":70327},"attention":false,"healthDegree":100}]},"status":true}
BeanShell断言目的：想要判断上面接口响应结果是否和数据库查询结果select s.object_name,s.cate_id,g.group_id,g.group_name,s.l1_cate_name from cmdb_app_group g,cmdb_app_group_detail d,cmdb_object_summary s where g.group_id=d.group_id and d.object_id=s.object_id and g.group_id="+objid+"一致
BeanShell断言内容：
import java.sql.*;  
import java.util.*;  
import java.lang.*;  
import org.apache.regexp.*;  
import com.google.gson.JsonObject;   
import com.google.gson.JsonParser;   



//数据库连接字段  
String drive = "com.mysql.jdbc.Driver";  
String url = "jdbc:mysql://10.9.3.210:3306";  
String dbName = "camadev";  
String user = "root";  
String pass = "root";  


String history = "";  
String response = "";  
String failuer = "";  

//vars.get是Jmeter提供的方法，可以取到变量值，这个caseno是用来关联用例和数据库中结果的  
String objId = vars.get("objId");  

//下面是查询的SQL  
String query="select s.object_name,s.cate_id,g.group_id,g.group_name,s.l1_cate_name from cmdb_app_group g,cmdb_app_group_detail d,cmdb_object_summary s where g.group_id=d.group_id and d.object_id=s.object_id and g.group_id="+objid+"";

//JDBC声明  
Connection Mycon = null;  
Statement Mystmt = null;  
ResultSet Myrset = null;  

//try中获取数据库连接  
try{  
        Mycon = DriverManager.getConnection("jdbc:mysql://10.9.3.210:3306/camadev", "root", "root");  

}   catch(SQLException e){  

}  
Mystmt = Mycon.createStatement();  
Myrset = Mystmt.executeQuery(query);  


//prev.getResponseDataAsString是Jmeter提供的方法，可以调取上次请求的响应字符串  
response = prev.getResponseDataAsString();  

//如果取到库中的数据，赋值给history  
while (Myrset.next()){  
        history = Myrset.getString(1);  
}  

Myrset.close();  
Mystmt.close();  


//Gson提供的方法，原理笔者也不明白，效果是把字符串生成Json对象  

JsonParser parser = new JsonParser();   
JsonObject responseObj = (JsonObject) parser.parse(response);   
JsonParser parser1 = new JsonParser();            
JsonObject historyObj = (JsonObject) parser1.parse(history);   


if(history == "")  
{  
        Failure = true;  
        FailureMessage = "连接数据库失败或者数据库内没有历史数据";   

//调用Gson提供的Json对象euqals方法判断是否一致  
}else if(responseObj.equals(historyObj) == false)  
{   
        //把断言失败置为真   
Failure = true;  
FailureMessage = "和历史数据不匹配";   
        }  
else{
                //把断言失败置为真   
Failure = false;  
FailureMessage = "和历史数据匹配";   
}

执行后BeanShell断言报错信息：Assertion error: true
Assertion failure: false
Assertion failure message: org.apache.jorphan.util.JMeterException: Error invoking bsh method: eval        Sourced file: inline evaluation of: ``import java.sql.*;   import java.util.*;   import java.lang.*;   import org.apac . . . ''
请问大师们，怎样调试我的BeanShell断言，或者有什么别的简单方法。