mybatis plus mysql_springboot+mybatis plus+mysql

一、配置pom.xml

4.0.0

com.wuxi

springboot_demo1

0.0.1-SNAPSHOT

org.springframework.boot

spring-boot-starter-parent

2.1.12.RELEASE

org.springframework.boot

spring-boot-starter-web

com.baomidou

mybatis-plus-boot-starter

3.2.0

mysql

mysql-connector-java

com.alibaba

druid-spring-boot-starter

1.1.10

com.alibaba

druid

1.1.10

org.apache.maven.plugins

maven-compiler-plugin

1.8

1.8

二、配置application.yml

#服务端口及模块名

server:

port:8080servlet:

context-path: /ygst

spring:

#数据源配置

datasource:

name: sp

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

url: jdbc:mysql://192.168.2.120:3306/sp?characterEncoding=utf8&useSSL=false

username: root

password:123456type: com.alibaba.druid.pool.DruidDataSource

filters: stat

maxActive:20initialSize:1maxWait:60000minIdle:1timeBetweenEvictionRunsMillis:60000minEvictableIdleTimeMillis:300000validationQuery:select 'x'testWhileIdle:truetestOnBorrow:falsetestOnReturn:falsepoolPreparedStatements:truemaxOpenPreparedStatements:20mybatis-plus:

#默认扫描mapper.xml的目录

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

三、入口程序

package com.wuxi;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.boot.SpringApplication;

import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication(scanBasePackages= {"com.wuxi"})

@MapperScan("com.wuxi.dao")public classMyApplication {//入口

public static voidmain(String[] args) {

SpringApplication.run(MyApplication.class, args);

}

}

四、bean

package com.wuxi.bean;public classPerson {privateInteger id;privateString name;privateInteger age;privateInteger sex;publicInteger getId() {returnid;

}public voidsetId(Integer id) {this.id =id;

}publicString getName() {returnname;

}public voidsetName(String name) {this.name =name;

}publicInteger getAge() {returnage;

}public voidsetAge(Integer age) {this.age =age;

}publicInteger getSex() {returnsex;

}public voidsetSex(Integer sex) {this.sex =sex;

}

@OverridepublicString toString() {return "Person{" +

"id=" + id +

", name='" + name + '\'' +

", age=" + age +

", sex=" + sex +

'}';

}

}

五、dao

package com.wuxi.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import com.wuxi.bean.Person;

import org.springframework.stereotype.Repository;/**

* Created by dingcaiyan on 2020/3/31.*/@Repositorypublic interface PersonMapper extends BaseMapper{

}

六、service

package com.wuxi.service;

import com.wuxi.bean.Person;

import com.wuxi.dao.PersonMapper;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import org.springframework.transaction.annotation.Transactional;

import java.util.List;/**

* Created by dingcaiyan on 2020/3/31.*/@Service

@Transactionalpublic classPersonService {

@AutowiredprivatePersonMapper personMapper;public ListselectAllPerson(){

List personList = personMapper.selectList(null);returnpersonList;

}

}

七、controller

package com.wuxi.controller;

import com.wuxi.bean.Person;

import com.wuxi.service.PersonService;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestControllerpublic classPersonController {

@AutowiredprivatePersonService personService;

@RequestMapping("/linlong")publicObject getAllPerson() {

List personList =personService.selectAllPerson();returnpersonList;

}

}