Mybatis入门二－动态SQL

在Mybatis入门一的基础上修改

ListServlet.java

//List<User> list = session.selectList("User.queryList");User u = new User();u.setId(new Long(1));List<User> list = session.selectList("User.queryListWhere",u);

User.xml添加一项

<select id="queryListWhere" parameterType="com.model.User" resultMap="UserResult">    SELECT * FROM user where 1=1    <if test="id != null">      AND id like #{id}    </if> </select>