Available parameters are [2, 1, 0, param1, param2, param3]
<select id=
"loginByTeacher"
parameterType=
"String"
resultType=
"User"
>
SELECT * FROM `user` WHERE LoginID=#{
0
} and LoginPwd=#{
1
} AND Role=
2
</select>
Available parameters are [2, 1, 0, param1, param2, param3]
<select id=
"loginByTeacher"
parameterType=
"String"
resultType=
"User"
>
SELECT * FROM `user` WHERE LoginID=#{
0
} and LoginPwd=#{
1
} AND Role=
2
</select>