常用的mybatis注解

package org.example.demosql.mapper;

import org.apache.ibatis.annotations.MapKey;

import org.apache.ibatis.annotations.Result;

import org.apache.ibatis.annotations.Results;

import org.apache.ibatis.annotations.Select;

import org.example.demosql.domain.OrderEx;

import org.example.demosql.domain.Orders;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**

* @author YD2000

* @description 针对表【orders】的数据库操作Mapper

* @createDate 2024-07-14 02:03:20

* @Entity org.example.demosql.domain.Orders

*/

public interface OrdersMapper extends BaseMapper<Orders> {

    @Select("select id,username,password from account")

    @MapKey("username")

    @Results(id = "Account", value = {

            @Result(column = "id", property = "id"),

            @Result(column = "username", property = "username"),

            @Result(column = "password", property = "password"),

    })

    Map<Long, Account> select();

//    Set<Account> select();

//    List<Account> select();

    @Select("select o.*,a.id userid ,a.user_name " +

            "from account as a left join orders o on a.id = o.account_id")

    @Results(id = "orderExMap", value = {

            @Result(column = "id", property = "id"),

//            @Result(column = "userid", property = "userid"),

//            @Result(column = "user_name", property = "username"),

            @Result(column = "account_id", property = "accountId"),

            @Result(column = "orders_name", property = "ordersName")

    })

    List<Orders> selectOrdersEx();

//    List<OrderEx> selectOrdersEx();

}