MyBatis的常用多表注解及实用操作

常用注解

@Select(“查询的 SQL 语句”)：执行查询操作注解

@Insert(“查询的 SQL 语句”)：执行新增操作注解

@Update(“查询的 SQL 语句”)：执行修改操作注解

@Delete(“查询的 SQL 语句”)：执行删除操作注解

配置MyBatisConfig.xml 直接使用mapper接口

    <mappers>
        <mapper class="mapper.PhoneMapper"></mapper>
    </mappers>

注解方式 直接在dao接口中进行多表注解

/**
 * (Phone)表数据库访问层
 *
 * @author makejava
 * @since 2022-03-10 09:35:22
 */
public interface PhoneMapper {
    @Select("select * from phone,brand where phone.bid = brand.bid")
    @Results(id = "phoneMap",value = {
            //id表示主键
            @Result(id = true,column = "pid",property = "pid"),
            @Result(column = "pname",property = "pname"),
            @Result(column = "pcolor",property = "pcolor"),
            @Result(column = "price",property = "price"),
            @Result(column = "bname",property = "brand.bname"),
    })
    @Delete("delete from phone where pid = #{pid}")
    int deleteById(String pid);
}

希望对大家有帮助哦~