spring boot整合mybatis对数据库表的操作

最新推荐文章于 2024-08-09 17:52:16 发布

嚯哈哈哈哈~

最新推荐文章于 2024-08-09 17:52:16 发布

阅读量161

点赞数

文章标签： spring boot java postman

本文链接：https://blog.csdn.net/m0_67819160/article/details/125350908

版权

1.导包：

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.2.2</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2.编写实体类：

public class Source {
    String name;
    int score;
    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getScore() {
        return score;
    }
    public void setScore(int score) {
        this.score = score;
    }
}

3.编写mapper接口（没写更新操作）

import com.example.mybatismy.db.Source;
import org.apache.ibatis.annotations.*;

@Mapper
public interface UserMapper {
    @Insert("insert into source(name,score) values(#{name},#{score})")
    public void insert(Source source);
    @Select("select * from source where name=#{name}")
    public Source select(String name);
   @Delete("delete from source where name=#{name}")
    public Boolean delete(String name);

}

4.数据库连接配置文件

spring.datasource.url = jdbc:mysql://localhost:3306/mydb?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true 
spring.datasource.username = root
spring.datasource.password= 123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

5.完成，接下来就可以直接调用mapper中的方法进行数据库的操作了