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

青旅半醒 2022-12-13 00:44 236阅读 0赞

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>