企业建网站的步骤,公司网站制作仿站,餐饮企业网站设计,邢台建一个网站多少钱springboot整合mybatis-plus超级详细 一、环境二、springboot整合myBatisPlus2.1新建2.2 添加Mybatis-plus和mysql依赖2.3 修改配置文件2.4 新建包和文件2.5 新建表2.6 创建实体类2.7 创建Mapper接口2.8 创建Service接口2.9 创建Service实现类2.10 增删改查 MyBatis-Plus#… springboot整合mybatis-plus超级详细 一、环境二、springboot整合myBatisPlus2.1新建2.2 添加Mybatis-plus和mysql依赖2.3 修改配置文件2.4 新建包和文件2.5 新建表2.6 创建实体类2.7 创建Mapper接口2.8 创建Service接口2.9 创建Service实现类2.10 增删改查 MyBatis-Plus如其名所示是MyBatis的一个功能增强工具。它旨在对MyBatis的核心功能进行拓展而不会对其原有结构或行为做出任何修改。
一、环境
系统windows 11 软件IntelliJ IDEA 2022.2.3 mavenmaven3.8.6 JDK1.8.0_351 springboot2.5.3 myBatisPlus3.3.1
二、springboot整合myBatisPlus
2.1新建
设置项目名、groupID、artfactid、version
设置选择springboot版本和基础依赖
2.2 添加Mybatis-plus和mysql依赖
在pom.xml中引入依赖
!--Mybatis-plus的依赖--
dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-boot-starter/artifactIdversion3.3.1/version
/dependency!--mysql的依赖--
dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.31/version
/dependency2.3 修改配置文件
application.properties改为application.yml
# 端口号8080
server:port: 8080# 数据库名mysql用户名root密码123456
spring:datasource:username: rootpassword: 123456url: jdbc:mysql://192.168.17.128:3306/test?characterEncodingutf-8useSSLfalseserverTimezoneUTCrewriteBatchedStatementstruedriver-class-name: com.mysql.cj.jdbc.Driver# mybatis-plus配置
mybatis-plus:# xml文件位置mapper-locations: classpath:mapper/*.xml2.4 新建包和文件
/src/main/java/com.gsj.springbootmp下新建包 servicecontrollermapperentity
/src/main/resouces下设置mapping文件夹
如图
2.5 新建表
新建数据库测试表
CREATE TABLE user (id int(11) NOT NULL AUTO_INCREMENT,name varchar(20) NOT NULL DEFAULT COMMENT 名称,age int(11) NOT NULL COMMENT 年龄,PRIMARY KEY (id) USING BTREE
) ENGINEInnoDB COMMENT用户表;2.6 创建实体类
com/gsj/springbootmp/entity/User.java
package com.gsj.springbootmp.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 lombok.NoArgsConstructor;Data
NoArgsConstructor
TableName(user)
public class User {TableId(type IdType.AUTO)private Integer id;TableField(name)private String name;TableField(age)private Integer age;}
2.7 创建Mapper接口
com/gsj/springbootmp/mapper/UserMapper.java
package com.gsj.springbootmp.mapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.gsj.springbootmp.entity.User;
import org.apache.ibatis.annotations.Mapper;Mapper
public interface UserMapper extends BaseMapperUser {}2.8 创建Service接口
com/gsj/springbootmp/service/UserService.java
package com.gsj.springbootmp.service;import com.baomidou.mybatisplus.extension.service.IService;
import com.gsj.springbootmp.entity.User;public interface UserService extends IServiceUser {
}
2.9 创建Service实现类
com/gsj/springbootmp/service/impl/UserServiceImpl.java
package com.gsj.springbootmp.service.impl;import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.gsj.springbootmp.entity.User;
import com.gsj.springbootmp.mapper.UserMapper;
import com.gsj.springbootmp.service.UserService;
import org.springframework.stereotype.Service;Service
public class UserServiceImpl extends ServiceImplUserMapper, User implements UserService {
}
2.10 增删改查
com/gsj/springbootmp/controller/UserController.java
package com.gsj.springbootmp.controller;import com.gsj.springbootmp.entity.User;
import com.gsj.springbootmp.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;import java.util.List;RestController
RequestMapping(user)
public class UserController {Autowiredprivate UserService userService;RequestMapping(list)public ListUser list(){return userService.list();}RequestMapping(getUser/{id})public User getUser(PathVariable String id){return userService.getById(id);}/*** 插入学生信息* param User*/RequestMapping(/insert)public void insertInfo(User User){User infonew User();info.setName(User.getName());info.setAge(User.getAge());userService.save(info);}/*** 根据id更新学生表信息* param User*/RequestMapping(/update)public void updateById(User User){User infonew User();info.setId(User.getId());info.setName(User.getName());info.setAge(User.getAge());userService.updateById(info);}/*** 根据id删除学生信息* param id*/RequestMapping(/delete)public void deleteById(String id){userService.removeById(id);}
}
我们可通过启动应用程序进行测试以验证其能否顺利运作并准确从数据库提取数据。若一切正常则表明已成功运用Spring Boot与MyBatis-Plus进行了有效集成。
