mybatis 注解开发 多参数传递

1.顺序传递

接口语句写法

点击查看代码

    //02_1 多参传递，顺序传递法,param
    @Select("select * from users where username=#{param1} and usersex = #{param2}")
    List<Users> selectUsersByNameAndSexOrder(String param1, String param2);

2.注解

写法

点击查看代码

//02_2 多参传递，注解传递
    @Select("select * from users where username=#{name} and usersex = #{sex}")
    List<Users> selectUsersByNameAndSexInter(@Param("name") String username, @Param("sex") String usersex);

2.pojo传递

点击查看代码

//02_3 多参传递 pojo传递
    @Select("select * from users where username=#{username} and usersex=#{usersex}")
    List<Users> selectUsersByNameAndSexPOJO(Users users);

3.map传递

点击查看代码

//02_4 多参传递 Map传递 根据 key名字，获取value
    @Select("select * from users where username=#{namekey} and usersex=#{sexkey}")
    List<Users> selectUsersByNameAndSexMap(Map<String, String> map);