后台管理增删查改统一性代码--若依前后端分离版本

controller:
@PreAuthorize("@ss.hasPermi('system:role:list')")  //和数据库中的menu中的字段有关系
@GetMapping("list")
public TableDataInfo list(SysRole role){
  startPage();
  List<SysRole> list = roleService.selectRoleList(role);
  return getDataInfo(list);
}

表格分页数据对象
public class TableDataInfo implements Serializable{
  private static final long serialVersionUID = 1L;
  //总记录数量
  private long total;
  //列表数据
  private List<?> rows;
  //消息状态码
  private int code;
  //消息内容
  private String msg;

  //表格数据对象 ==无参构造
  public TableDataInfo(){}

  //有参数构造，分页，list列表数据，total总记录数
  public TableDataInfo(List<?> list,int total){
    this.rows = list;
    this.total = total;
  }
  public long getTotal(){
     return total;
  }
  public void setTotal(long total){
    this.total = total;
  }
  public List<?> getRows(){
    return rows;
  }
  public List<?> setRows(List<?> rows){
    this.rows = rows
  }
  public int getCode(){
    return code;
  }
  public void setCode(int code){
    this.code = code;
  }
  public String getMsg(){
    return msg;
  }
  public void setMsg(String msg){
    this.msg = msg;
  }

}

mapper.xml
<sql id="selectRoleVo">  连表查询的sql语句，写一遍就不用在单独写了 </sql>
列表展示和列表查询展示角色信息的sql
<select id="selectRoleList" parameterType="SysRole" resultMap="SysRoleResult">
  <include refid="selectRoleVo"/>
  where r.del_flag='0'
  <if test="roleName !=null and roleName!=''">
    and r.role_name like concat('%',#{roleName},'%')
  </if>
  <if test="beginTime !=null and beginTime !=''">
    and r.create_time >= TO_DATE(#{beginTime},'YYYY-MM-DD HH24-MI-SS')
  </if>
</select>
统一性修改角色信息表的sql
<update id="updateRole" parameterType="SysRole">
  update sys_role
  <set>
    <if test="roleName!=null and roleName!=''">role_name=#{roleName},</if>
    <if test="status!=null and status!=''">status=#{status},</if>
    update_time= now()  或者是 current_timestamp
  </set>
  where role_id=#{roleId}
</update>
批量删除角色信息的sql
<delete id="deleteRoleByIds" parameterType="String">
  update sys_role set del_flag = '2' where role_id  in 
  <foreach collection="array" item="roleId" open="(" separator="," close=")">
    #{roleId}
  </foreach>
</delete>
增加角色信息的统一性sql
<insert id="insertRole" parameterType="SysRole">
  insert into sys_role(
    <if test="roleId!=null and roleId!=''">role_id,</if>
    <if test="roleName!=null and roleName!=''">role_name,</if>
    create_time
  ) values(
    <if test="roleId!=null and roleId!=''">#{roleId},</if>
    <if test="roleName!=null and roleName!=''">#{roleName},</if>
    current_timestamp
  )
</insert>