iBatis调用存储过程

    public String saveShootSetting(Map map) {
    try {
      Map createTableMap = new HashMap();
      String flag = "";
      createTableMap.put("tableName", map.get("shootTableName"));
      createTableMap.put("leftFieldName", map.get("leftFieldName"));
      createTableMap.put("rightFieldName", map.get("rightFieldName"));
      createTableMap.put("flag", flag);
      dao.queryForList("MapService.createRelationTable", createTableMap);

      flag = (String) createTableMap.get("flag");
      if (!flag.equals("1"))
        return flag;

      Map levelCodeMap = new HashMap();
      String levelCode = "";
      levelCodeMap.put("levelCode", levelCode);
      dao.queryForList("MapService.getLevelCode", levelCodeMap);
      levelCode = (String) levelCodeMap.get("levelCode");

      List itemCodeList = dao.queryForList("MapService.getItemCode");
      String itemCode = (String) itemCodeList.get(0);

      Map tableMap = new HashMap();
      tableMap.put("itemCode", itemCode);
      tableMap.put("itemName", map.get("shootName"));
      tableMap.put("levelCode", levelCode);
      tableMap.put("tableName", map.get("shootTableName"));

      dao.insert("MapService.saveShootTable", tableMap);

      List itemCodeList1 = dao.queryForList("MapService.getItemCode");
      String itemCode1 = (String) itemCodeList1.get(0);
      Map leftFieldMap = new HashMap();
      leftFieldMap.put("fieldName", map.get("leftFieldName"));
      leftFieldMap.put("refTable", map.get("leftParentCode"));
      leftFieldMap.put("itemCode", itemCode1);
      leftFieldMap.put("itemName", map.get("leftDesName"));
      leftFieldMap.put("parentCode", itemCode);
      leftFieldMap.put("levelCode", levelCode + "001");

      dao.insert("MapService.saveShootField", leftFieldMap);

      List itemCodeList2 = dao.queryForList("MapService.getItemCode");
      String itemCode2 = (String) itemCodeList2.get(0);
      Map rightFieldMap = new HashMap();
      rightFieldMap.put("fieldName", map.get("rightFieldName"));
      rightFieldMap.put("refTable", map.get("rightParentCode"));
      rightFieldMap.put("itemCode", itemCode2);
      rightFieldMap.put("itemName", map.get("rightDesName"));
      rightFieldMap.put("parentCode", itemCode);
      rightFieldMap.put("levelCode", levelCode + "002");

      dao.insert("MapService.saveShootField", rightFieldMap);

      Map relationMap = new HashMap();
      relationMap.put("itemCode", itemCode);
      relationMap.put("mainField", itemCode1);
      relationMap.put("selectField", itemCode2);
      relationMap.put("productCode", map.get("productCode"));
      dao.insert("MapService.saveShootRelation", relationMap);

      return "1";

    } catch (SQLException e) {
      log.error(e);
      throw new RuntimeException(e);
    }
  }

---------------------------------------------------------------------------------------------------
 
parameterMap id="deleteShootMap" class="java.util.HashMap">
       
    /parameterMap>
   
    procedure id="deleteShootSetting" parameterMap="deleteShootMap">
        {call sp_pd_base_deleteshoot(?)}
    /procedure>
   
    parameterMap id="levelCodeMap" class="java.util.HashMap">
       
    /parameterMap>
   
    procedure id="getLevelCode" parameterMap="levelCodeMap">
        {call sp_get_max(?)}  
    /procedure>
   
    parameterMap id="createTableMap" class="java.util.HashMap">   
       
       
       
       
    /parameterMap>
   
    procedure id="createRelationTable" parameterMap="createTableMap">
        {call sp_pd_base_shootsetting(?,?,?,?)}  
    /procedure>