mybatis---parameterType参数传递

最新推荐文章于 2023-03-30 22:24:34 发布

HelloWorld. py

最新推荐文章于 2023-03-30 22:24:34 发布

阅读量357

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/AK47red/article/details/118111576

版权

Java 专栏收录该内容

94 篇文章 0 订阅

订阅专栏

1. 只有一个参数时可以不写

User getUserById(int id);

<select id="getUserById" resultType="com.wy.bean.User">
    SELECT * FROM users WHERE id = #{id}
</select>

public void testGetUserById() {
    SqlSession session = MyBatisUtils.getSession();
    UserDao userDao = session.getMapper(UserDao.class);
    System.out.println(userDao.getUserById(2));
    MyBatisUtils.close(session);
}

2. 有多个参数时, parameterType不写

2.1 可以通过类对象进行传递

User getUsersByNameAndPassword(User user);

<select id="getUsersByNameAndPassword" resultType="com.wy.bean.User" >
    SELECT * FROM users WHERE username = #{username} AND PASSWORD = #{password}
</select>

public void testGetUsersByNameAndPassword() {
    SqlSession session = MyBatisUtils.getSession();
    UserDao userDao = session.getMapper(UserDao.class);
    User user = new User();
    user.setUsername("张三");
    user.setPassword("1000");
    System.out.println(userDao.getUsersByNameAndPassword(user));
    MyBatisUtils.close(session);
}

2.2 可以通过map进行传递

User getUserByNameAndPassword2(Map<String, Object> map);

<select id="getUserByNameAndPassword2" resultType="com.wy.bean.User">
    SELECT * FROM users WHERE username = #{username} AND PASSWORD = #{password}
</select>

public void testGetUserByNameAndPassword2() {
    SqlSession session = MyBatisUtils.getSession();
    UserDao userDao = session.getMapper(UserDao.class);
    Map<String, Object> map = new HashMap<>();
    map.put("username", "张三");
    map.put("password", "1000");
    System.out.println(userDao.getUserByNameAndPassword2(map));
    MyBatisUtils.close(session);
}

2.3 设置别名

void updateUserByNameAndPassword(@Param("username") String username, @Param("password") String password,  @Param("money") int money);

<update id="updateUserByNameAndPassword">
    UPDATE users SET money = #{money} WHERE username = #{username} AND PASSWORD = #{password}
</update>

public void testUpdateUserByNameAndPassword() {
    SqlSession session = MyBatisUtils.getSession();
    UserDao userDao = session.getMapper(UserDao.class);
    userDao.updateUserByNameAndPassword("张三", "1000", 18000);
    session.commit();
    MyBatisUtils.close(session);
}

2.4 直接获取参数列表中的参数

void updateUserByNameAndPassword2(String username, String password, int money);

<update id="updateUserByNameAndPassword2">
    UPDATE users SET money = #{arg2} WHERE username = #{arg0} AND PASSWORD = #{arg1}
</update>

public void testUpdateUserByNameAndPassword2() {
    SqlSession session = MyBatisUtils.getSession();
    UserDao userDao = session.getMapper(UserDao.class);
    userDao.updateUserByNameAndPassword2("张三", "1000", 38000);
    session.commit();
    MyBatisUtils.close(session);
}