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>
