DP开发手册

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="net.chenlin.dp.shiro.dao.SysUserMapper">

  <select id="listForPage" resultType="SysUserEntity">
    
  </select>      

</mapper>

@MapperScan
public interface SysUserMapper extends BaseMapper<SysUserEntity> {

	SysUserEntity getByUserName(String username);
	
	List<Long> listAllMenuId(Long userId);
	
	int updatePswdByUser(Query query);
	
	int updateUserStatus(Query query);
	
	int updatePswd(SysUserEntity user);
	
}

public class SysUserEntity implements Serializable {
  
  private static final long serialVersionUID = 1L;

  /**
   * 用户id
   */
  private Long userId;
  
  /**
   * 用户名
   */
  private String username;

  public SysUserEntity() {
    super();
  }

 /* 此处省去 get 和 set 方法， 实际开发添加  */

}

public interface SysUserManager {
  
  List<SysUserEntity> listUser(Page<SysUserEntity> page, Query search);
  
}

@Component("sysUserManager")
public class SysUserManagerImpl implements SysUserManager {

  @Autowired
  private SysUserMapper sysUserMapper;
  
  @Autowired
  private SysMenuMapper sysMenuMapper;
  
  @Autowired
  private SysRoleMapper sysRoleMapper;
  
  @Autowired
  private SysUserRoleMapper sysUserRoleMapper;
  
  
  @Override
  public List<SysUserEntity> listUser(Page<SysUserEntity> page, Query search) {
    return sysUserMapper.listForPage(page, search);
  }

}

public interface SysUserService {
  
  Page<SysUserEntity> listUser(Map<String, Object> params);
  
}

@Service("sysUserService")
public class SysUserServiceImpl implements SysUserService {

        @Autowired
  private SysUserManager sysUserManager;
  
  @Override
  public Page<SysUserEntity> listUser(Map<String, Object> params) {
    Query form = new Query(params);
    Page<SysUserEntity> page = new Page<>(form);
    sysUserManager.listUser(page, form);
    return page;
  }

}

@RestController
@RequestMapping("/sys/user")
public class SysUserController extends AbstractController {
  
  @Autowired
  private SysUserService sysUserService;
  
  /**
   * 用户列表
   * @param params
   * @return
   */
  @RequestMapping("/list")
  public Page<SysUserEntity> list(@RequestBody Map<String, Object> params) {
    if(getUserId() != SystemConstant.SUPER_ADMIN) {
      params.put("userIdCreate", getUserId());
    }
    return sysUserService.listUser(params);
  }
    
  /**
   * 新增用户
   * @param user
   * @return
   */
  @SysLog("新增用户")
  @RequestMapping("/save")
  public R save(@RequestBody SysUserEntity user) {
    user.setUserIdCreate(getUserId());
    return sysUserService.saveUser(user);
  }
  
}

CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '密码',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `status` tinyint(255) DEFAULT NULL COMMENT '状态 0:禁用，1:正常',
  `user_id_create` bigint(255) DEFAULT NULL COMMENT '创建用户id',
  `gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户';

public class Query extends HashMap<String, Object> {
	
	private static final long serialVersionUID = 1L;
	
	public Query() {
		super();
	}

	public Query(Map<String, Object> params){
        this.putAll(params);
    }
	
	public Double getAsDouble(String name) {
        Object value = this.get(name);
        if (value != null)
            return Double.valueOf(value.toString());
        return null;
    }

    public String getAsString(String name) {
        return this.get(name).toString();
    }

    public Long getAsLong(String name) {
        Object value = this.get(name);
        if (value != null)
            return Long.valueOf(value.toString());
        return null;
    }

    public Integer getAsInt(String name) {
        Object value = this.get(name);
        if (value != null)
            return Integer.valueOf(value.toString());
        return null;
    }

    public Boolean getAsBoolean(String name) {
        Object value = this.get(name);
        if (value != null)
            return Boolean.valueOf(value.toString());
        return null;
    }

    public java.util.Date getAsDate(String name) {
    	Object value = this.get(name);
        if (value != null)
        	return Date.valueOf(value.toString());
        return null;
    }

    public Object getObj(String name) {
        return this.get(name);
    }
	
}

public class CommonUtils {
	
	/**
	 * 新增，修改提示
	 * @param count
	 * @return
	 */
	public static R msg(int count) {
		if(isIntThanZero(count)){
			return R.ok(MsgConstant.MSG_OPERATION_SUCCESS);
		}
		return R.error(MsgConstant.MSG_OPERATION_FAILED);
	}
	
	/**
	 * 查询详情提示
	 * @param data
	 * @return
	 */
	public static R msg(Object data) {
		if(isNullOrEmpty(data)){
			return R.error(MsgConstant.MSG_INIT_FORM);
		}
		return R.ok().put(SystemConstant.DATA_ROWS, data);
	}
	
	/**
	 * 返回数据
	 * @param data
	 * @return
	 */
	public static R msgNotCheckNull(Object data) {
		return R.ok().put(SystemConstant.DATA_ROWS, data);
	}
	
	/**
	 * 删除提示
	 * @param total
	 * @param count
	 * @return
	 */
	public static R msg(Object[] total, int count) {
		if(total.length == count){
			return R.ok(MsgConstant.MSG_OPERATION_SUCCESS);
		}else{
			if(isIntThanZero(count)){
				return R.error(MsgConstant.removeFailed(total.length, count));
			}else{
				return R.error(MsgConstant.MSG_OPERATION_FAILED);
			}
		}
	}
	
}

@MapperScan
public interface SysUserMapper extends BaseMapper<SysUserEntity> {
	
	List<Long> listAllOrgId(Long userId);	
	
}