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>原文：http://www.cnblogs.com/hoge/p/6254606.html