企业招聘平台-02-行业信息管理功能的开发-CSDN博客

创建行业信息表

CREATE TABLE `industry` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '行业名称',
  `content` text COLLATE utf8mb4_unicode_ci COMMENT '行业描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='行业信息表';

Entity

public class Industry {
   
   
    private Integer id;
    private String name;
    private String content;

}

Mapper

public interface IndustryMapper {
   
   

    int insert(Industry industry);

    void updateById(Industry industry);

    void deleteById(Integer id);

    @Select("select * from `industry` where id = #{id}")
    Industry selectById(Integer id);

    List<Industry> selectAll(Industry industry);

}
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.IndustryMapper">

    <select id="selectAll" resultType="com.example.entity.Industry">
        select * from `industry`
        <where>
            <if test="name != null"> and title like concat('%', #{
   
   name}, '%')</if>
        </where>
    </select>

    <delete id="deleteById">
        delete from `industry`