Mybatis 自定义排序

最新推荐文章于 2024-08-21 09:46:38 发布

tian.tian

最新推荐文章于 2024-08-21 09:46:38 发布

阅读量870

点赞数

本文链接：https://blog.csdn.net/li_tiantian/article/details/103655630

版权

入参javaBean

import lombok.Data;
import java.io.Serializable;
import java.util.List;

@Data
public class UserReq implements Serializable {
    private Long id;
    private String username;
    private String password;
    private List<OrderFiled> orderFields;
}

import lombok.Data;
import java.io.Serializable;
@Data
public class OrderFiled implements Serializable {
    private String orderField;
    private String orderType;
}

Dao

public interface UserMapper {
    List<User> getAllByOrderFiled(UserReq userReq);
}

xml

    <select id="getAllByOrderFiled" parameterType="com.springboot.req.UserReq" resultMap="baseResultMap">
        select id, username, password from user
        <if test="orderFields !=n