# boot-template-single

**Repository Path**: lhzlx/boot-template-single-2.4.2

## Basic Information

- **Project Name**: boot-template-single
- **Description**: boot-template-single
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-01-06
- **Last Updated**: 2024-07-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#### 1、项目打包

>  clean install package -DskipTests=true -P prod/test

#### 2、响应说明

>  将返回格式统一写到controller层

#### 3、param、entity、vo等结构

> model文件分为vo、entity、param、dto
>
> param和entity通常一一对应，如果查询、创建内容和更新内容传参区别较大时，则分为QueryXXXParam,AddXXXParam,UpdateXXXParam
>
> 返回给前端时，通常可以使用entity，但是返回数据差别较大时，建立vo类进行返回

#### 4、SQL补充


```sql
<!--批量删除-->
<delete id="deleteByPrimaryKeys" parameterType="java.util.List">
    delete from sys_role
    where id in
    <foreach close=")" collection="list" item="id" open="(" separator=",">
        #{id,jdbcType=VARCHAR}
    </foreach>
</delete>
        <!--批量插入-->
<insert id="insertBatch" parameterType="java.util.List">
insert into sys_role (id, `name`,
`status`, create_time
)
values
<foreach collection="list" item="record" separator=",">
    (#{record.id,jdbcType=VARCHAR}, #{record.name,jdbcType=VARCHAR},
    #{record.status,jdbcType=BIT}, #{record.createTime,jdbcType=TIMESTAMP}
    )
</foreach>
</insert>

        <!--xml范围查询-->
<where>
1=1
<choose>
    <when test="range != null and range =='all'">
        and id is not null
    </when>
    <when test="range != null and range =='company'">
        and c.id = #{companyId}
    </when>
    <when test="range != null and range =='dept'">
        and d.id = #{deptId}
    </when>
    <when test="range != null and range =='person'">
        and u.id = #{userId}
    </when>
    <otherwise>
        limit 0
    </otherwise>
</choose>
</where>
<insert id="addWaringPublish" parameterType="list">
insert into tb_employee_publish
(id,index_id,employee_id,is_publish,type)
values
<foreach collection="list" item="config" separator=",">
    (#{config.id},#{config.indexId},#{config.employeeId},#{config.isPublish},#{config.type})
</foreach>
</insert>

<update id="updateByPrimaryKeySelective"
        parameterType="com.youngyield.digitcons.model.entity.message.StationMessage">
update tb_station_message
<set>
    <if test="messageType != null">
        message_type = #{messageType,jdbcType=INTEGER},
    </if>
    <if test="subMessageType != null">
        sub_message_type = #{subMessageType,jdbcType=INTEGER},
    </if>
    <if test="subMessageTypeName != null">
        sub_message_type_name = #{subMessageTypeName,jdbcType=VARCHAR},
    </if>
    <if test="title != null">
        title = #{title,jdbcType=VARCHAR},
    </if>
</set>
where id = #{id,jdbcType=VARCHAR}
</update>
```