mybatic plus基本使用 连表联查 join

**

1.service

**
Map<String,Object> param = new HashMap<>();
param.put(“tradeFlowNodeId”, tradeFlowNodeId);
param.put(“code”, nodeName);
param.put(“argName”, elementName);
MethodsArgTemplate methodsArg = methodsArgTemplateService.findArgVal(param);

2.service

MethodsArgTemplate findArgVal(Map<String, Object> param);

**

3.实现类MethodsArgTemplateServiceImpl

**
@Override
public MethodsArgTemplate findArgVal(Map<String, Object> param) {
return this.baseMapper.findArgVal(param);
}

**

4.mapper

**
@Select(“SELECT mat.* FROM methods_arg_template mat \r\n” +
“LEFT JOIN methods m ON m.id = mat.methods_id \r\n” +
“WHERE m.code = #{code} \r\n” +
“AND mat.trade_flow_node_id= #{tradeFlowNodeId} \r\n” +
"AND mat.arg_name = #{argName} ")
MethodsArgTemplate findArgVal(Map<String, Object> param);