链接数据库,简单的crud不用自己写,话不多说直接上步骤
第一步,自己准备一个数据库,创建一个简答的springboot项目,相信大家都会就不用我演示了
首先配置ymal文件
server:
port: 8081
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/text?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true
driver-class-name: com.mysql.jdbc.Driver
username: root
password: 123456
mybatis-plus:
mapper-locations: classpath*:/mapper/*.xml
global-config:
db-config:
logic-not-delete-value: N
logic-delete-value: Y
id-type: auto
第二步创建实体导报
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus</artifactId>
<version>3.4.3.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-<