Mybatis动态Sql

1.查询功能

(1)UserMapper.java

//动态sql=案例1 通过用户名和密码查询列表
    public List<User> findByUserNameAndPwd(@Param("userName") String userName,@Param("userPassword") String userPassword);
    

(2)UserMapper.xml

<select id="findByUserNameAndPwd" resultType="cn.kgc.entity.User">
        select * from smbms_user a where 1=1
        <if test="userName !=null and userName != ''">
            and userName like concat('%',#{userName},'%')
        </if>
        <if test="userPassword != null and userPassword !=''">
            and userPassword = #{userPassword}
        </if>
    </select>

(3)TestUserMapper.java

@Test
    public void testfindByUserNameAndPwd() {
        SqlSession sqlSession = MyBatisUtil.createSqlSession();
        String userName = "王";
        String userPassword = "";
        List<User> list= sqlSession.getMapper(UserMapper.class).findByUserNameAndPwd(userName,userPassword);
       for (User u :list){
           System.out.println("姓名："+u.getUserName()+"   出生日期："+u.getBirthday());
       }
        sqlSession.close();
    }

(4)测试结果

 

2.添加功能

(1)UserMapper.java

 //添加功能动态sql
    public Integer addUserNew(User user);

(2)UserMapper.xml

 <insert id="addUserNew" parameterType="cn.kgc.entity.User">
        insert into smbms_user(
        <tri