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

This article mainly introduces "the usage of springboot integrated mybatisplus". In daily operation, I believe many people have doubts about the usage of springboot integrated mybatisplus. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "the usage of springboot integrated mybatisplus"! Next, please follow the editor to study!

Introduction:

Mybatis-Plus (MP for short) is an enhancement tool of Mybatis, which is only enhanced but not changed on the basis of Mybatis, in order to simplify development and improve efficiency. (from the official website of mybatis-plus) although Mybatis has provided us with great convenience, it still has its shortcomings. The existence of MP is to slightly make up for the deficiency of Mybatis. When we use Mybatis, we will find that whenever we want to write a business logic, we have to write a method in the DAO layer, and then a SQL, even if it is a simple conditional query, even if we only change a condition, we have to add a method in the DAO layer. To solve this problem, MP is a framework that combines the advantages of Mybatis and Hibernate. It provides the convenience of Hibernate's single-table CURD operation while retaining the characteristics of Mybatis.

This chapter only teaches you how to use MybatisPlus. If you want to understand how the bottom layer is implemented, you can go to the official website to download the source code for interpretation.

First, create a project

Here is not step by step, I directly give the created project structure, at the end of this chapter I will give the source code address to see the effect can be downloaded.

Second, introduce dependence

3. Edit application.yml

Server: port: 8080spring: mvc: view: prefix: / WEB-INF/jsp/ suffix: .jsp datasource: url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC username: root password: dacian821 driver-class-name: com.mysql.jdbc.Drivermybatis: mapper-locations: classpath:mapper/*.xml type-aliases-package: com.cdq.springboot_mybatisplus.domain

4. Reverse generation of pojo,mapper

Create generatorConfig.xml

Maven runs generator

The structure of the generated project is as follows

V. Integration of mybatisplus

Create a service interface and a service implementation class

Package com.cdq.springboot_mybatisplus.service;import com.cdq.springboot_mybatisplus.dao.domain.Person;import java.util.List;public interface PersonService {List getPerson (); boolean insert (Person person);} package com.cdq.springboot_mybatisplus.service.impl;import com.cdq.springboot_mybatisplus.dao.domain.Person;import com.cdq.springboot_mybatisplus.dao.mapper.PersonMapper;import com.cdq.springboot_mybatisplus.service.PersonService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service Import java.util.List;@Servicepublic class PersonServiceImpl implements PersonService {@ Autowired private PersonMapper personMapper; @ Override public List getPerson () {return personMapper.selectAll ();} @ Override public boolean insert (Person person) {int insert = personMapper.insert (person); if (insert > = 1) {return true;} return false;}}

Create Controller

Package com.cdq.springboot_mybatisplus.controller;import com.cdq.springboot_mybatisplus.dao.domain.Person;import com.cdq.springboot_mybatisplus.service.PersonService;import com.cdq.springboot_mybatisplus.service.impl.PersonServiceImpl;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import org.springframework.web.servlet.ModelAndView;import java.util.List @ RestController@RequestMapping ("/ person") public class PersonController {@ Autowired PersonService personService; @ RequestMapping ("/ findAllPerson") List findAllPerson () {return personService.getPerson ();} boolean insertPerson (Person person) {return personService.insert (person);}}

Here my mapper does not write sql, some simple sqlmybatiplus are sealed, saving a lot of development time, if it is some complex sql, you can also write native sql to achieve

Insert some data

Package com.cdq.springboot_mybatisplus;import com.cdq.springboot_mybatisplus.dao.domain.Person;import com.cdq.springboot_mybatisplus.service.PersonService;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.test.context.SpringBootTest;import org.springframework.test.context.junit4.SpringRunner;@RunWith (SpringRunner.class) @ SpringBootTestpublic class SpringbootMybatisplusApplicationTests {@ Autowired PersonService personService @ Test public void contextLoads () {for (int I = 1; I)

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.