org.apache.ibatis.binding.BindingException: Mapper method ‘mapper.OrderMapper.findAll‘ has an unsupp

最新推荐文章于 2024-02-26 11:21:32 发布

原创最新推荐文章于 2024-02-26 11:21:32 发布 · 139 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #mybatis #开发语言

异常系列专栏收录该内容

34 篇文章

订阅专栏

在OrderMapper接口中，发现一个使用错误的@Insert注解。该注解被用于执行一个查询，而正确的注解应为@Select。修复此问题后，方法findAll()将能正确地从orders和user表中获取数据并映射到Order对象及其关联的User对象。

错误原因：注解使用错误@Insert

public interface OrderMapper {
    @Insert("select *,o.id oid from orders o,user u where o.uid = u.id")
    @Results({
            @Result(column = "oid",property = "id"),
            @Result(column = "ordertime",property = "ordertime"),
            @Result(column = "total",property = "total"),
            @Result(column = "uid",property = "user.id"),
            @Result(column = "username",property = "user.username"),
            @Result(column = "password",property = "user.password")
    })
    public List<Order> findAll();
}

改正注解：@Select