前言:主要是为熟悉Springboot项目的搭建
1.建一个maven项目,在pom.xml文件添加依赖
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.5.9</version>
<relativePath/>
</parent>
在把jdk配上 (我是17)
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>17</maven.compiler.source>
<maven.compiler.target>17</maven.compiler.target>
</properties>
springboot的依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
日志依赖
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.2</version>
</dependency>
数据库连接的依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
数据库数据源(可以不加,Springboot有默认的)
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.19</version>
</dependency>
mybatis的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>3.0.2</version>
</dependency>
mybatisplus依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.3</version>
</dependency>
2.配置Application
新建一个application.yml文件(application.properties文件)
可以在里面配置项目要求的端口号,数据源,mybatis
server:
port: 8090
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai
username: root
password: root
type: com.alibaba.druid.pool.DruidDataSource//druid数据源的配置
# servlet:
# multipart:
# maxFileSize: 10MB
//mybatis-plus的配置
mybatis-plus:
#指定entity扫描包位置让mybatis自动扫描到指定义的entity包下
type-aliases-package: com.sunshine.entity
#指定位置扫描Mapper接口对应的XML文件 classpath:xml文件位置
mapper-locations: classpath*:mappers/*Mapper.xml
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mybatis的配置
/*
mybatis:
mapper-locations: classpath*:mappers/*.xml
type-aliases-package: com.jdfs.entity
*/
3.创建需要的entity层,mapper、service、cotroller层
entity层代码
package com.sunshine.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import java.io.Serializable;
import java.util.List;
@Data
@TableName("member")
public class MemberEntity implements Serializable {
@TableId(type = IdType.AUTO)
private Long mid;
private String account;
private String password;
private String nickname;
}
mapper层代码
package com.sunshine.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sunshine.entity.MemberEntity;
import java.util.List;
public interface MemberMapper extends BaseMapper<MemberEntity> {
public IPage<MemberEntity> queryPage(IPage<MemberEntity> iPage, String account);
public List<MemberEntity> queryPageList(IPage<MemberEntity> iPage, String account);
}
为mapper层配置的xml文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.example1.mapper.MemberMapper">
<select id="queryPage" resultType="MemberEntity">
select * from member where account=#{account}
</select>
</mapper>
service层代码
package com.sunshine.service;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sunshine.entity.MemberEntity;
import com.sunshine.mapper.MemberMapper;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Slf4j
@Service
public class MemberService {
@Autowired
MemberMapper memberMapper;
public List<MemberEntity> getList(){
Map<String,Object> map = new HashMap<>();
map.put("account","acc1");
//只支持等于
List<MemberEntity> memberEntities = memberMapper.selectByMap(map);
// 也可以带条件 支持更多
memberEntities = memberMapper.selectList(null);
return memberEntities;
}
public IPage queryPage(String account){
Page<MemberEntity> page = new Page<MemberEntity>(1,6);
IPage<MemberEntity> page1 = memberMapper.queryPage(page,account);
return page1;
}
public int remove(int id){
int i = memberMapper.deleteById(id);
return i;
}
public int addMember(MemberEntity entity){
int i = memberMapper.insert(entity);
log.info("id:{}",entity.getMid());
return i;
}
}
cotroller层代码
package com.sunshine.web;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sunshine.entity.MemberEntity;
import com.sunshine.service.MemberService;
import lombok.extern.slf4j.Slf4j;
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;
@RestController
@Slf4j
public class MemberController {
@Autowired
MemberService memberService;
@RequestMapping("/queryMember")
public String queryMember(){
List<MemberEntity> list = memberService.getList();
for (MemberEntity memberEntity : list) {
log.info("nickName:{}",memberEntity.getNickname());
log.info("id:{}",memberEntity.getMid());
}
return "success";
}
@RequestMapping("/removeMember")
public String remove(){
memberService.remove(60);
return "success remvoe";
}
@RequestMapping("saveMember")
public String addMember(){
MemberEntity entity = new MemberEntity();
entity.setAccount("account1");
entity.setPassword("password1");
entity.setNickname("nickName1");
memberService.addMember(entity);
return "add success";
}
@RequestMapping("queryMemberPage")
public String queryMemberPage(){
Page page = (Page) memberService.queryPage("account1");
//当前页的数据集合
List<MemberEntity> records = page.getRecords();
log.info("==================================records=====================================");
for (MemberEntity record : records) {
log.info("mid:{}",record.getMid());
log.info("nickname:{}",record.getNickname());
}
long pages = page.getPages();
log.info("==================================pages=====================================");
log.info("共有多少页:{}",pages);
log.info("当前页current:{}",page.getCurrent());
log.info("total:{}", page.getTotal());
log.info("next:{}", page.hasNext());
log.info("prev:{}", page.hasPrevious());
log.info("size:{}", page.getSize());
return "add success";
}
}
4.创建配置类和application(测试)类
1.配置类
package com.sunshine.config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
@MapperScan("com.sunshine.mapper")
public class MybatisPlusConfig {
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));//如果配置多个插件,切记分页最后添加
return interceptor;
}
}
2.application
package com.sunshine;
import lombok.extern.slf4j.Slf4j;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@Slf4j(topic = "e")
@SpringBootApplication
public class App {
public static void main(String[] args) {
SpringApplication.run(App.class);
}
}