岗位管理界面 /system/post
SysPostController控制岗位管理
@Controller
@RequestMapping ( "/system/post" )
public class SysPostController extends BaseController
{
private String prefix = "system/post" ;
@Autowired
private ISysPostService postService;
@RequiresPermissions ( "system:post:view" )
@GetMapping ( )
public String operlog ( )
{
return prefix + "/post" ;
}
查询岗位列表 /system/post/list
@RequiresPermissions ( "system:post:list" )
@PostMapping ( "/list" )
@ResponseBody
public TableDataInfo list ( SysPost post)
{
startPage ( ) ;
List< SysPost> list = postService. selectPostList ( post) ;
return getDataTable ( list) ;
}
service层
@Override
public List< SysPost> selectPostList ( SysPost post)
{
return postMapper. selectPostList ( post) ;
}
dao层
< select id = " selectPostList" parameterType = " SysPost" resultMap = " SysPostResult" >
< include refid = " selectPostVo" />
< where>
< if test = " postCode != null and postCode != ' ' " >
AND post_code like concat('%', #{postCode}, '%')
</ if>
< if test = " status != null and status != ' ' " >
AND status = #{status}
</ if>
< if test = " postName != null and postName != ' ' " >
AND post_name like concat('%', #{postName}, '%')
</ if>
</ where>
</ select>
pojo - sys_post 岗位表
package com. ruoyi. system. domain;
import javax. validation. constraints. *;
import org. apache. commons. lang3. builder. ToStringBuilder;
import org. apache. commons. lang3. builder. ToStringStyle;
import com. ruoyi. common. annotation. Excel;
import com. ruoyi. common. annotation. Excel. ColumnType;
import com. ruoyi. common. core. domain. BaseEntity;
public class SysPost extends BaseEntity
{
private static final long serialVersionUID = 1 L;
@Excel ( name = "岗位序号" , cellType = ColumnType. NUMERIC)
private Long postId;
@Excel ( name = "岗位编码" )
private String postCode;
@Excel ( name = "岗位名称" )
private String postName;
@Excel ( name = "岗位排序" , cellType = ColumnType. NUMERIC)
private String postSort;
@Excel ( name = "状态" , readConverterExp = "0=正常,1=停用" )
private String status;
private boolean flag = false ;
public Long getPostId ( )
{
return postId;
}
public void setPostId ( Long postId)
{
this . postId = postId;
}
@NotBlank ( message = "岗位编码不能为空" )
@Size ( min = 0 , max = 64 , message = "岗位编码长度不能超过64个字符" )
public String getPostCode ( )
{
return postCode;
}
public void setPostCode ( String postCode)
{
this . postCode = postCode;
}
@NotBlank ( message = "岗位名称不能为空" )
@Size ( min = 0 , max = 50 , message = "岗位名称长度不能超过50个字符" )
public String getPostName ( )
{
return postName;
}
public void setPostName ( String postName)
{
this . postName = postName;
}
@NotBlank ( message = "显示顺序不能为空" )
public String getPostSort ( )
{
return postSort;
}
public void setPostSort ( String postSort)
{
this . postSort = postSort;
}
public String getStatus ( )
{
return status;
}
public void setStatus ( String status)
{
this . status = status;
}
public boolean isFlag ( )
{
return flag;
}
public void setFlag ( boolean flag)
{
this . flag = flag;
}
@Override
public String toString ( ) {
return