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>