创建项目的过程见上一篇博客,Springboot整合Mybatis项:https://blog.youkuaiyun.com/bat_xu/article/details/81710785
这里只展示项目的编写。
项目结构:
一、编写实体类Category
package com.example.springboot.entity;
public class Category {
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
二、持久层
持久层使用的MyBatis框架,所以这里是Category.xml和CategoeyMapper接口,展示一套增删改查操作。
Category.xml:
<?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.example.springboot.mapper.CategoryMapper">
<select id="findAll" resultType="Category">
select * from category
</select>
<select id="findById" parameterType="_int" resultType="Category">
SELECT * FROM category WHERE id=#{id}
</select>
<insert id="add" parameterType="Category">
INSERT INTO category (id,name) VALUES (#{id},#{name})
</insert>
<delete id="delete" parameterType="_int">
DELETE FROM category WHERE id=#{id}
</delete>
<update id="update" parameterType="Category">