mybatin-plus报错:无效的绑定语句(未找到)

照着敲的
这各种报错 估计是pom的导包有问题
或者有木有那位老哥有可以运行的源码看看
mybatis-plus
项目结构与源码

img


User实体类

@Data
@NoArgsConstructor
@AllArgsConstructor
@TableName("pw_userid")
public class User {
    @TableId(value = "User_id",type= IdType.AUTO)
    private Integer User_id;
    @TableField(value = "UserName")
    private String UserName;
    @TableField(value = "Password")
    private String Password;
}

mapper接口

//@Repository//代表持久层
@Mapper
public interface Usermapper extends BaseMapper<User> {
    //所有的CRUD都操作完成
}
@SpringBootTest
@MapperScan(value = {"com.example.mybatisplus.mapper"})
class MybatisPlusApplicationTests {
    @Autowired
    private Usermapper usermapper;
    @Test
    void contextLoads() {
        //查询所有用户
        List<User> users=usermapper.selectList(null);
//        users.forEach(System.out::println);
        System.out.println(users);
    }
}

主类

@SpringBootApplication
//@ComponentScan(basePackages = "com.example.mybatisplus.mapper")
@MapperScan(value = {"com.example.mybatisplus.mapper"})
public class MybatisPlusApplication {
    public static void main(String[] args) {
        SpringApplication.run(MybatisPlusApplication.class, args);
    }
}

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.7.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
<!--        <relativePath/>-->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>Mybatis-plus</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>Mybatis-plus</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>17</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--        导入mybatis-plue-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-annotation</artifactId>
            <version>3.4.2</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>3.4.2</version>
        </dependency>
<!--        <dependency>-->
<!--            <groupId>com.baomidou</groupId>-->
<!--            <artifactId>mybatis-plus-generator</artifactId>-->
<!--            <version>3.4.2</version>-->
<!--        </dependency>-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus</artifactId>
            <version>3.4.0</version>
        </dependency>
        <!--结束mybatis-plue -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.24</version>
            <!--            <optional>true</optional>-->
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>

        <dependency>
            <groupId>org.webjars.npm</groupId>
            <artifactId>jquery</artifactId>
            <version>3.6.0</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-freemarker</artifactId>
            <version>2.7.6</version>
        </dependency>
        <dependency>
            <groupId>org.junit.platform</groupId>
            <artifactId>junit-platform-commons</artifactId>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>2.3.7.RELEASE</version>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

img

img

给报错的测试类(xxxxTests)打个断点试下,看是不是启动执行到这个测试类,里面的bean对象(Usermapper)注入失败

调整mapper层和resource里面的xml的路径;
第一种:像这种无效的绑定语一般都是 mapper 层和你写 sql 的 xml 不是同一个级别的路径;
比如:你第一层 mapper 层有个第二层的 usermapper 的 package,而你的 xml 就直接在 resource 根目录下,就会找不到
第二种:就是你配置扫描 xml 的路径不对,如下图:

img

实体类上加 @TableName("表名称") 试试

应该是缺少jar包
mybatis-plus-boot-starter
mybatis-plus-annotation
mybatis-plus-extension
你看pom.xml是不是缺少哪个包

启动类添加@MapperScan

@MapperScan(value = {"com.example.mybatisplus.mapper"})
不应该是
@MapperScan(value = {com.example.sbcnm.mapper"})
吗?
参考下https://www.cnblogs.com/liuyj-top/p/12976396.html

img