存储过程生成接口

先编写存储过程的函数：

 

 mapper.xml文件编写查询：sql注入（最好用map传参，映射传参尝试了下没成功）

<parameterMap type="Map" id="getMap">
    <parameter property="student_id" jdbcType="VARCHAR" javaType="String" mode="IN"/>
    <parameter property="course_id" jdbcType="VARCHAR" javaType="String" mode="IN"/>
    <parameter property="major_id" jdbcType="VARCHAR" javaType="String" mode="IN"/>
</parameterMap>

<select id="getTableList" parameterMap="getMap" statementType="CALLABLE" resultType="org.jeecg.modules.obe.entity.ViewStudentCouObjScore">
   {CALL select_student_cou_obj_score(?,?,?)}
</select>

controller里编写方法：

@AutoLog(value = "view_student_cou_obj_score-通过多条件查询")
@ApiOperation(value="view_student_cou_obj_score-通过多条件查询", notes="view_student_cou_obj_score-通过多条件查询")
@GetMapping(value = "/getTableList")
public Result<List<ViewStudentCouObjScore>> queryList(@RequestParam(name="studentId",required=true) String studentId, @RequestParam(name="courseId",required=true) String courseId, @RequestParam(name="majorId",required=true) String majorId,HttpServletRequest req) {
 Result<List<ViewStudentCouObjScore>> result = new Result<>();
 List<ViewStudentCouObjScore> list = viewStudentCouObjScoreService.getTableList(studentId, courseId, majorId);
 result.setSuccess(true);
 result.setResult(list);
 return result;
}
service层：

public interface IViewStudentCouObjScoreService extends IService<ViewStudentCouObjScore> {

    List<ViewStudentCouObjScore> getTableList(String studentId, String courseId, String majorId);
}
imp层：

@Service
public class ViewStudentCouObjScoreServiceImpl extends ServiceImpl<ViewStudentCouObjScoreMapper, ViewStudentCouObjScore> implements IViewStudentCouObjScoreService {

    @Autowired
    private ViewStudentCouObjScoreMapper viewStudentCouObjScoreMapper;

    @Override
    public List<ViewStudentCouObjScore> getTableList(String studentId, String courseId, String majorId) {
        Map<String, String> str = new HashMap<>();
        str.put("student_id", studentId);
        str.put("course_id", courseId);
        str.put("major_id", majorId);
        return viewStudentCouObjScoreMapper.getTableList(str);
    }
}

dao层

public interface ViewStudentCouObjScoreMapper extends BaseMapper<ViewStudentCouObjScore> {
    List<ViewStudentCouObjScore> getTableList(Map<String, String> str);
}