我这里写的项目名称是EquipTest,测试的是设备类,引入的pom.xml如下
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.11</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.zhen</groupId>
<artifactId>EquipTest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>EquipTest</name>
<description>EquipTest</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-devtools</artifactId>
<scope>runtime</scope>
<optional>true</optional>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- Log4j依赖-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.2</version>
</dependency>
<!-- mybatis-generator-core 反向生成java代码-->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.7</version>
</dependency>
<!-- MyBatis分页插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.3</version>
</dependency>
</dependencies>
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.yml</include>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
</resource>
</resources>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
在项目包下新建如下包:controlller, entity, mapper, service, utils
干完这些以后就是第一步了,首先在entity实体类包下新建Equipment实体类,并结合数据库表中的字段赋各个变量的值
@Data
public class Equipment extends Entity {
private Integer equ_id;
private Integer fac_id;
private String equ_name;
private String equ_type;
private String equ_purchasedate;
private String equ_purchaser;
private float equ_singleprice;
private String equ_unit;
private String equ_spec;
private Integer equ_total;
private Integer equ_curr;
private String equ_position;
private Integer del;
}
在Mapper层下写对应的数据库Mapper接口用于操作数据库以及对应的xml文件,如果你装了插件的话应该可以看见文件头有蓝色小鸟和红色小鸟
Mapper接口类如下,定义增删改查四种方法,以及查看详情
@Mapper
public interface EquipmentMapper {
int insert(Equipment equipment);
int delete(Integer equ_id);
int update(Equipment equipment);
List<Equipment> query(Equipment equipment);
Equipment detail(Integer equ_id);
}
xml如下,主要是SQL语句的编写,id需要和接口中方法名保持一致,resultMap和parameterType为返回类型,可以是类名,也可以自己用resultMap定义
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC
"-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zhen.equiptest.mapper.EquipmentMapper">
<resultMap id="Equipment" type="com.zhen.equiptest.entity.Equipment">
<id column="equ_id" property="equ_id"></id>
<result column="fac_id" property="fac_id"></result>
<result column="equ_name" property="equ_name"></result>
<result column="equ_type" property="equ_type"></result>
<result column="equ_purchasedate" property="equ_purchasedate"></result>
<result column="equ_purchaser" property="equ_purchaser"></result>
<result column="equ_singleprice" property="equ_singleprice"></result>
<result column="equ_unit" property="equ_unit"></result>
<result column="equ_spec" property="equ_spec"></result>
<result column="equ_total" property="equ_total"></result>
<result column="equ_curr" property="equ_curr"></result>
<result column="equ_position" property="equ_position"></result>
<result column="del" property="del"></result>
</resultMap>
<insert id="insert" parameterType="com.zhen.equiptest.entity.Equipment">
insert into equipment(equ_id,fac_id,equ_name,equ_type,equ_purchasedate,equ_purchaser,
equ_singleprice,equ_unit,equ_spec,equ_total,equ_curr,equ_position,del)
values (#{equ_id},#{fac_id},#{equ_name},#{equ_type},#{equ_purchasedate},#{equ_purchaser},
#{equ_singleprice},#{equ_unit},#{equ_spec},#{equ_total},#{equ_curr},#{equ_position},#{del})
</insert>
<update id="update" parameterType="com.zhen.equiptest.entity.Equipment">
update equipment set equ_id = #{equ_id},fac_id = #{fac_id},equ_name = #{equ_name},equ_type = #{equ_type},equ_purchasedate = #{equ_purchasedate},equ_purchaser = #{equ_purchaser},
equ_singleprice = #{equ_singleprice},equ_unit = #{equ_unit},equ_spec = #{equ_spec},equ_total = #{equ_total},equ_curr = #{equ_curr},equ_position = #{equ_position},del = #{del}
where equ_id = #{equ_id}
</update>
<delete id="delete">
delete from equipment where equ_id = #{equ_id}
</delete>
<select id="query" resultMap="Equipment">
select * from equipment
<include refid="WhereEquipment"></include>
</select>
<sql id="WhereEquipment">
<if test="equ_id != null">and equ_id = #{equ_id}</if>
<if test="equ_name != null and equ_name != ''">and user_name = #{user_name}</if>
</sql>
<select id="detail" resultMap="Equipment">
select * from equipment where equ_id = #{equ_id}
</select>
</mapper>
第三步,在服务层Service文件夹中写对应的Services类,需要在类上方添加@Service
注解,注意Service中需要建立Mapper接口变量并@Autowired
@Service
public class EquipmentService {
@Autowired
private EquipmentMapper equipmentMapper;
public int insert(Equipment equipment){
return equipmentMapper.insert(equipment);
}
public int delete(Integer equ_id){
return equipmentMapper.delete(equ_id);
}
public int update(Equipment equipment){
return equipmentMapper.update(equipment);
}
public PageInfo<Equipment> query(Equipment equipment){
if (equipment != null && equipment.getPage() != null){
PageHelper.startPage(equipment.getPage(), equipment.getLimit());
}
PageInfo<Equipment> pageInfo = new PageInfo<>(equipmentMapper.query(equipment));
return pageInfo;
}
public Equipment detail(Integer equ_id){
return equipmentMapper.detail(equ_id);
}
}
最后写Controller层,对应的增删改查接口在Controller中配置,这里我目前都用@GetMapping
,这里@RequestMapping
注解为这个控制类访问的全局目录,如我这里就是localhost:8080/equip
,如果调用插入方法就在equip后面加入/insert
@RestController
@RequestMapping("/equip")
public class EquipmentController {
@Autowired
private EquipmentService equipmentService;
@GetMapping("insert")
public void insert(){
Equipment equipment = new Equipment();
equipment.setEqu_id(4567);
equipment.setEqu_name("Apple MacBook Pro 2021");
equipmentService.insert(equipment);
}
@GetMapping("delete")
public void delete(Integer equ_id){
equipmentService.delete(equ_id);
}
@GetMapping("update")
public void update(){
Equipment equipment = new Equipment();
equipment.setEqu_id(4567);
equipment.setEqu_name("Apple iMac Pro 2021");
equipmentService.update(equipment);
}
@GetMapping("detail")
public Equipment detail(Integer equ_id){
return equipmentService.detail(equ_id);
}
@GetMapping("query")
public PageInfo<Equipment> query(Equipment equipment){
return equipmentService.query(equipment);
}
}
最后我给实体类查询做了一个分页操作,在utils包下新建Entity类设置分页参数,页码和每页大小,主要在上述代码中query操作中使用
// Mybatis分页参数, 页码和大小
@Data
public class Entity {
private Integer page; // 页码数
private Integer limit = 10; // 页面大小
}
写完之后记得在主启动类下注解你的mapper地址,不然启动类可能找不到
接下来就是yaml文件夹下的基本配置了
server:
port: 8080 # 指定端口
# 数据库配置
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://127.0.0.1:3306/qing?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
# mybatis配置
mybatis:
mapper-locations: com/zhen/equiptest/mapper/*.xml
# 日志
logging:
level:
com:
zhen:
equiptest:
mapper: debug
# 分页
pagehelper:
helper-dialect: mysql
大功告成,下面是一些运行截图