mybatis注解动态sql

最新推荐文章于 2024-08-05 18:33:11 发布

李智正在学习中

最新推荐文章于 2024-08-05 18:33:11 发布

阅读量2.1k

点赞数 1

分类专栏： mybatis 文章标签： mybatis sql 注解动态

本文链接：https://blog.csdn.net/Melod_bc/article/details/51879841

版权

mybatis 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

package vo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import vo.User;

public interface UserMapper
{
    @Insert("INSERT INTO user (name, age, gender, experience) VALUES (<a href="http://www.oschina.net/tweet-topic/%7Bname%7D%2C" target="_blank">#{name},#</a>{age}, <a href="http://www.oschina.net/tweet-topic/%7Bgender%7D%2C" target="_blank">#{gender},#</a>{experience})")
    @Options(useGeneratedKeys = true, keyProperty = "id")
    int createUser(User user);

    @Insert("INSERT INTO user_interest (user_id, interest_id) VALUES (<a href="http://www.oschina.net/tweet-topic/%7BuserId%7D%2C" target="_blank">#{userId},#</a>{interestId})")
    int createUserInterest(@Param("userId") int userId, @Param("interestId") int interestId);

    @Delete("DELETE FROM user WHERE id = #{id}")
    int deleteUser(int id);

    @Delete("DELETE FROM user_interest WHERE user_id = #{userId}")
    int deleteUserInterest(int userId);

    // findUsers(String, int) 的执行策略定义在 UserMapper.xml 中
    List<User> findUsers(@Param("name") String name, @Param("experience") int experience);

    @Select("SELECT interest_id FROM user_interest WHERE user_id = #{userId} ORDER BY id")
    List<Integer> findUserInterests(int userId);

    // queryInterest(int, int) 的执行策略定义在 UserMapper.xml 中
    List<User> queryInterest(@Param("gender") int gender, @Param("experience") int experience);
}