MyBatis查Java优学网存储过程调用：高效实现数据库操作与性能优化

{call sp_get_user_info(

#{userId,mode=IN,jdbcType=INTEGER},
#{userName,mode=OUT,jdbcType=VARCHAR}

)}

{call sp_update_student_score(

#{studentId,mode=IN,jdbcType=INTEGER},
#{courseId,mode=IN,jdbcType=VARCHAR},
#{score,mode=IN,jdbcType=DECIMAL}

)}

{call sp_get_course_categories(

#{updateTime,mode=IN,jdbcType=TIMESTAMP}

)}