Examples of com.founder.fix.fixflow.core.impl.db.SqlCommand.queryForList()

Package com.founder.fix.fixflow.core.impl.db

Class com.founder.fix.fixflow.core.impl.db.SqlCommand

Examples of com.founder.fix.fixflow.core.impl.db.SqlCommand.queryForList()

com.founder.fix.fixflow.core.impl.db.SqlCommand.queryForList()
以List对象形式返回查询一组结果 @param sql @param data @return List> 结果集 @throws DAOException

      String supGroupIdField = getGroupInfo().getSupGroupIdField();
      String sqlText = getGroupInfo().getSqlText();
      SqlCommand sqlCommand = getSqlCommand();
      // 部门编号,父级编号，部门名称
      // 获取这个部门的所有子部门
      List<Map<String, Object>> listMap = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE");
      for (Map<String, Object> map : listMap) {
        // 部门编号
        String groupDbId = StringUtil.getString(StringUtil.getString(map.get(groupIdField)));
        // 部门名称
        String groupDbName = StringUtil.getString(StringUtil.getString(map.get(groupNameField)));

View Full Code Here

        String userIdField = userInfo.getUserIdField();
        String userNameField = userInfo.getUserNameField();
        String groupIdField = userInfo.getGroupIdField();
        String sqlText = userInfo.getSqlText();
        // 这里可能会出现重复记录人名的问题
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("select USERTABLE.* FROM (" + sqlText + ") USERTABLE WHERE USERTABLE."
            + groupIdField + " in (" + sqlInString + ")", objectParamWhere);
        List<UserTo> userTos = new ArrayList<UserTo>();
        for (Map<String, Object> map : dataObj) {
          UserTo userTo = new UserTo(StringUtil.getString(map.get(userIdField)), StringUtil.getString(map.get(userNameField)), map);
          userTos.add(userTo);

View Full Code Here

        UserInfo userInfo = getGroupInfo().getUserInfo();
        String userIdField = userInfo.getUserIdField();
        String userNameField = userInfo.getUserNameField();
        String groupIdField = userInfo.getGroupIdField();
        String sqlText = userInfo.getSqlText();
        List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM (" + sqlText + ") USERTABLE where USERTABLE."
            + groupIdField + "=?", objectParamWhere);
        List<UserTo> userTos = new ArrayList<UserTo>();
        for (Map<String, Object> map : dataObj) {
          UserTo userTo = new UserTo(StringUtil.getString(map.get(userIdField)), StringUtil.getString(map.get(userNameField)), map);
          userTos.add(userTo);

View Full Code Here

        String supGroupIdField = getGroupInfo().getSupGroupIdField();
        String sqlText = getGroupInfo().getSqlText();
        SqlCommand sqlCommand = getSqlCommand();
        List<Object> objectParamWhere = new ArrayList<Object>();
        objectParamWhere.add(groupId);
        List<Map<String, Object>> dataObj = sqlCommand.queryForList(" SELECT USERTABLENEW.* FROM (" + sqlText
            + ") USERTABLENEW WHERE USERTABLENEW." + groupIdField + " IN (SELECT USERTABLE." + supGroupIdField + " FROM (" + sqlText
            + ") USERTABLE where USERTABLE." + groupIdField + "=?)", objectParamWhere);
        if (dataObj.size() == 0) {
          return null;
        }

View Full Code Here

    }
    
    stringBuffer.append("'");
    
    SqlCommand sqlCommand=new SqlCommand(Context.getDbConnection());
    List<Map<String, Object>> productMapList= sqlCommand.queryForList(stringBuffer.toString());
    
    List<String> quehuoproductlist = new ArrayList<String>();
    
    //查看库存是否足够
    for(Map<String, Object> detailmap : detailMapList) {

View Full Code Here


      List<Object> objectParamWhere = new ArrayList<Object>();


      objectParamWhere.add(userId);


      List<Map<String, Object>> dataObj = sqlCommand.queryForList("SELECT USERTABLE.* FROM ("+sqlText+") USERTABLE where USERTABLE."+userIdField+"=?", objectParamWhere);


      if(dataObj.size()==0){
        return null;
      }

View Full Code Here

    int count = Integer.parseInt(sqlCommand.queryForValue(countSql).toString());
    if (page != null) {
      Pagination pagination = Context.getProcessEngineConfiguration().getDbConfig().getPagination();
      sql = pagination.getPaginationSql(sql, page.getFirstResult(), page.getMaxResults(), "*",null);
    }
    List<Map<String, Object>> dataObj = sqlCommand.queryForList(sql, null);
    
    for(int i= 0;i<dataObj.size();i++){
      if (dataObj.get(i).get(userIdField) != null) {
        UserTo userTo = new UserTo(StringUtil.getString(dataObj.get(i).get(userIdField)), StringUtil.getString(dataObj.get(i).get(userNameField)), dataObj.get(i));
        resultList.add(userTo);

View Full Code Here

    List<Object> paramList = new ArrayList<Object>();
    paramList.add(bizkey);
    String bizObjName = StringUtil.getString(ExpressionMgmt.execute("Fix_BizName", executionContext));
    String bizField = StringUtil.getString(ExpressionMgmt.execute("Fix_BizKeyFile", executionContext));
    SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection(dataBaseId));
    List<Map<String, Object>> dataObjList = sqlCommand.queryForList("SELECT " + field + " FROM " + bizObjName + " WHERE " + bizField + "=?", paramList);


    return dataObjList;


  }

View Full Code Here

    List<Object> paramList = new ArrayList<Object>();
    paramList.add(bizkey);
    String bizObjName = StringUtil.getString(ExpressionMgmt.execute("Fix_BizName", executionContext));
    String bizField = StringUtil.getString(ExpressionMgmt.execute("Fix_BizKeyFile", executionContext));
    SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection(dataBaseId));
    List<Map<String, Object>> dataObjList = sqlCommand.queryForList("SELECT " + field + " FROM " + bizObjName + " WHERE " + bizField + "=?", paramList);
    if (dataObjList.size() == 0) {
      return null;
    } else {
      return dataObjList.get(0).get(field);
    }

View Full Code Here

    List<Object> paramList = new ArrayList<Object>();
    paramList.add(bizkey);
    String bizObjName = StringUtil.getString(ExpressionMgmt.execute("Fix_BizName", executionContext));
    String bizField = StringUtil.getString(ExpressionMgmt.execute("Fix_BizKeyFile", executionContext));
    SqlCommand sqlCommand = new SqlCommand(Context.getDbConnection(dataBaseId));
    List<Map<String, Object>> dataObjList = sqlCommand.queryForList("SELECT " + field + " FROM " + bizObjName + " WHERE " + bizField + "=?", paramList);


    return dataObjList;


  }

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.