建表语句和表的数据,以及范例如下:
第1种:直接使用where
<sql id="columnSql">
<trim suffixOverrides=","> <!-- suffixOverrides此时的作用是去除最后一个逗号 -->
id,
username,
password,
sex,
</trim>
</sql>
<select id="findByUsernameAndPwd" resultMap="resultMap">
SELECT
<include refid="columnSql"></include>
FROM t_user
WHERE username = #{username} and password = #{password}
</select>
输入:username:Tom,password:123
2018-02-03 11:54:57,458 -[DEBUG] method:[com.springmvc.dao.UserDao.findByUsernameAndPwd (10629