溯弥 2023-02-22 14:57 采纳率: 33.3%
浏览 176
已结题

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>
  • 写回答

8条回答 默认 最新

  • yuye9427 2023-02-22 15:04
    关注

    img

    img

    评论

报告相同问题?

问题事件

  • 已结题 (查看结题原因) 2月23日
  • 修改了问题 2月23日
  • 修改了问题 2月23日
  • 修改了问题 2月22日
  • 展开全部