mybatis示例：使用@SelectProvider注解，返回列表

最新推荐文章于 2024-06-11 15:13:13 发布

听海边涛声

最新推荐文章于 2024-06-11 15:13:13 发布

阅读量451

点赞数 11

文章标签： mybatis java

本文链接：https://blog.csdn.net/panghuangang/article/details/135362272

版权

mapper接口文件定义：

package com.thb.mapper;

import java.util.List;

import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.builder.annotation.ProviderMethodResolver;
import org.apache.ibatis.jdbc.SQL;

import com.thb.model.User;

public interface UserMapper {

    @SelectProvider(type = UserSqlBuilder.class, method = "selectManyUsers")
    List<User> selectManyUsers();

    public static class UserSqlBuilder {
        public static String selectManyUsers() {
            return new SQL() {{
                SELECT("id as id, user_name as userName, home_town as homeTown");
                FROM("user");
            }}.toString();
        }
    }
}