Examples with QueryReleasePlanResponse beans.response.QueryReleasePlanResponse used on opensource projects

Example 1 with QueryReleasePlanResponse

use of beans.response.QueryReleasePlanResponse in project MSEC by Tencent.

the class QueryReleasePlan method exec.

public QueryReleasePlanResponse exec(ReleasePlan request) {
    QueryReleasePlanResponse resp = new QueryReleasePlanResponse();
    String result = checkIdentity();
    if (!result.equals("success")) {
        resp.setStatus(99);
        resp.setMessage(result);
        return resp;
    }
    DBUtil util = new DBUtil();
    if (util.getConnection() == null) {
        resp.setStatus(100);
        resp.setMessage("db connect failed!");
        return resp;
    }
    List<ReleasePlan> planList;
    String sql = "select plan_id, first_level_service_name,second_level_service_name," + "config_tag,idl_tag, sharedobject_tag, status,memo,backend_task_status from t_release_plan ";
    List<Object> params = new ArrayList<Object>();
    boolean hasWhere = false;
    if (request.getPlan_id() != null && request.getPlan_id().length() > 0) {
        sql += " where plan_id like ? ";
        params.add(request.getPlan_id());
        hasWhere = true;
    }
    String flsn = request.getFirst_level_service_name();
    String slsn = request.getSecond_level_service_name();
    if (flsn != null && flsn.length() > 0 && slsn != null && slsn.length() > 0) {
        if (hasWhere) {
            sql = sql + " and first_level_service_name=? and second_level_service_name=? ";
        } else {
            sql = sql + " where first_level_service_name=? and second_level_service_name=? ";
        }
        hasWhere = true;
        params.add(flsn);
        params.add(slsn);
    }
    sql = sql + " order by plan_id desc";
    try {
        planList = util.findMoreRefResult(sql, params, ReleasePlan.class);
    } catch (Exception e) {
        resp.setStatus(100);
        resp.setMessage("db query exception!");
        e.printStackTrace();
        return resp;
    } finally {
        util.releaseConn();
    }
    resp.setPlan_list((ArrayList<ReleasePlan>) planList);
    resp.setMessage("success");
    resp.setStatus(0);
    return resp;
}