MyBatis学习 之 二、SQL语句映射文件(2)增删改查、参数、缓存
-
<!-- 查询学生,根据id -->
-
<select id="getStudent" parameterType="String" resultMap="studentResultMap">
-
SELECT ST.STUDENT_ID,
-
ST.STUDENT_NAME,
-
ST.STUDENT_SEX,
-
ST.STUDENT_BIRTHDAY,
-
ST.CLASS_ID
-
FROM STUDENT_TBL ST
-
WHERE ST.STUDENT_ID = #{studentID}
-
</select>