Shulou(Shulou.com)06/02 Report--

It is believed that many inexperienced people have no idea about how to use MyBatis-Plus to achieve CRUD in SpringCloud. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

1. Add Mybatis-Plus dependency

Com.baomidou

Mybatis-plus-boot-starter

3.2.0

two。 Configure the driver of the data source import database to view mysql version 5.7.29

Mark

Go to the maven warehouse to check the applicable mysql driver. There is no mysql driver in 5.7, and 8.0 is compatible with 5.7.So choose 8.0 driver.

Mysql

Mysql-connector-java

8.0.17

3. Configure MyBatis-Plus

Add application.yml file configuration data source

File path: / passjava-question/src/main/resources/application.yml

Spring:

Datasource:

Driver-class-name:com.mysql.cj.jdbc.Driver

Url:jdbc:mysql://129.211.188.xxx:3306/passjava_admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai

Username:root

Password:xxx

Configure the mapper mapping file path

Smart prompt mybatis-plus when configuring mabatis-plus:

Mapper-locations: classpath:/mapper/**/*.xml

Global-config:

Db-config:

Id-type: auto

Add MapperScan comment

@ MapperScan ("com.jackson0714.passjava.question.dao")

@ SpringBootApplication

Publicclass PassjavaQuestionApplication {

Public static void main (String [] args) {

SpringApplication.run (PassjavaQuestionApplication.class, args)

}

}

4. Test the CRUD method of mybatis-plus

Create type data of type javaBasic

@ Autowired

TypeService typeService

/ / create a question type

@ Test

Void testCreateType () {

TypeEntity typeEntity = new TypeEntity ()

TypeEntity.setType ("javaBasic")

TypeService.save (typeEntity)

System.out.println ("created successfully")

}

Create type data of type javaBasic

Update the table data of id=1

/ / Update type=jvm

@ Test

Void testUpdateType () {

TypeEntity typeEntity = new TypeEntity ()

TypeEntity.setId (1L)

TypeEntity.setType ("jvm")

TypeService.updateById (typeEntity)

System.out.println ("modified successfully")

}

Update the table data of id=1

Query the table data of id=1

/ / query question type

@ Test

Void testSelectType () {

List typeEntityList = typeService.list (new QueryWrapper () .eq ("id", 1L))

TypeEntityList.forEach ((item)-> {

System.out.println (item)

});

System.out.println (query success)

}

Query the table data of id=1

Delete id=1 table data

/ / Delete the record of question type

@ Test

Void testRemoveType () {

TypeService.removeById (1L)

System.out.println ("deleted successfully")

}

Delete id=1 table data after reading the above, do you know how to use MyBatis-Plus to achieve CRUD in SpringCloud? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.