【Springboot项目源码】springboot+layui+mybatis商城后台管理系统.zip

<?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.test.dao.PermissionMapper"> <resultMap id="BaseResultMap" type="com.example.test.pojo.Permission"> <id column="id" jdbcType="INTEGER" property="id" /> <result column="name" jdbcType="VARCHAR" property="name" /> <result column="pid" jdbcType="INTEGER" property="pid" /> <result column="zindex" jdbcType="INTEGER" property="zindex" /> <result column="istype" jdbcType="INTEGER" property="istype" /> <result column="descpt" jdbcType="VARCHAR" property="descpt" /> <result column="code" jdbcType="VARCHAR" property="code" /> <result column="icon" jdbcType="VARCHAR" property="icon" /> <result column="page" jdbcType="VARCHAR" property="page" /> <result column="insert_time" jdbcType="TIMESTAMP" property="insert_time" /> <result column="update_time" jdbcType="TIMESTAMP" property="update_time" /> </resultMap> <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer"> delete from permission where id = #{id,jdbcType=INTEGER} </delete> <insert id="insert" > insert into permission (id, name, pid, zindex, istype, descpt, code, icon, page, insert_time, update_time) values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{pid,jdbcType=INTEGER}, #{zindex,jdbcType=INTEGER}, #{istype,jdbcType=INTEGER}, #{descpt,jdbcType=VARCHAR}, #{code,jdbcType=VARCHAR}, #{icon,jdbcType=VARCHAR}, #{page,jdbcType=VARCHAR}, #{insert_time,jdbcType=TIMESTAMP}, #{update_time,jdbcType=TIMESTAMP}) </insert> <update id="updateByPrimaryKey" > update permission set name = #{name,jdbcType=VARCHAR}, pid = #{pid,jdbcType=INTEGER}, zindex = #{zindex,jdbcType=INTEGER}, istype = #{istype,jdbcType=INTEGER}, descpt = #{descpt,jdbcType=VARCHAR}, code = #{code,jdbcType=VARCHAR}, icon = #{icon,jdbcType=VARCHAR}, page = #{page,jdbcType=VARCHAR}, insert_time = #{insert_time,jdbcType=TIMESTAMP}, update_time = #{update_time,jdbcType=TIMESTAMP} where id = #{id,jdbcType=INTEGER} </update> <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select id, name, pid, zindex, istype, descpt, code, icon, page, insert_time, update_time from permission where id = #{id,jdbcType=INTEGER} </select> <select id="selectAll" resultMap="BaseResultMap"> select id, name, pid, zindex, istype, descpt, code, icon, page, insert_time, update_time from permission </select> </mapper>