java登录实现

controller层：

@Api(tags = "系统")
@RestController
@RequestMapping("/login")
public class LoginController extends BaseController{@Autowiredprivate UplusUserService uplusUserService;@ApiOperation(value = "登录")@PostMapping(value = "/userLogin", name = "登录")public Result userLogin(HttpServletRequest request,@RequestBody LoginDto loginDto) {return uplusUserService.userLogin(request,loginDto);}}

入参Dto层：

@Data
@ApiModel(value = "LoginDto",description = "登录入参实体")
public class LoginDto implements Serializable {private static final long serialVersionUID = 1L;@ApiModelProperty(value = "手机号")private String phone;@ApiModelProperty(value = "密码")private String password;@ApiModelProperty(value = "验证码")private String phoneCode;@ApiModelProperty(value = "登录方式：1.验证码登录；2.密码登录")private Integer loginWay;
}

出参Vo层：

@Data
@ApiModel(value = "UserLoginVo",description = "登录出参")
public class UserLoginVo implements Serializable {private static final long serialVersionUID = 1L;@ApiModelProperty("授权码")private String authorization;@ApiModelProperty("用户信息")private UplusUser user;}@Table(name = "UPLUS_USER")
public class UplusUser implements Serializable {@Id@Column(name = "ID")@GeneratedValue(strategy = GenerationType.IDENTITY)private Long id;@Column(name = "DEPOT_ID")private Long depotId;@Column(name = "USER_NAME")private String userName;@Column(name = "PASSWORD")private String password;@Column(name = "PROXY_NUMBER")private String proxyNumber;@Column(name = "NICK_NAME")private String nickName;@Column(name = "PHONE")private String phone;@Column(name = "TYPE_CD")private String typeCd;@Column(name = "TYPE")private String type;@Column(name = "SEX")private String sex;@Column(name = "COMPANY")private String company;@Column(name = "SECURITY_KEY")private String securityKey;@Column(name = "SUPER_USER_ID")private Long superUserId;@Column(name = "LOCK_USER")private String lockUser;@Column(name = "CREATE_DATE")private Date createDate;@Column(name = "CREATE_USER")private Long createUser;@Column(name = "UPDATE_DATE")private Date updateDate;@Column(name = "UPDATE_USER")private Long updateUser;@Column(name = "HEADER_URL")private String headerUrl;@Column(name = "DELETE_DATE")private Date deleteDate;@Column(name = "DELETE_USER")private Long deleteUser;@Column(name = "DELETE_FLAG")private String deleteFlag;@Column(name = "INVITE_CODE")private String inviteCode;@Column(name = "INVITE_END_DATE")private Date inviteEndDate;@Column(name = "PROFIT_DATE")private Date profitDate;@Column(name = "PROFIT")private Integer profit;
}

Service层:

public interface UplusUserService{/*** 	登录* */Result userLogin(HttpServletRequest request,LoginDto loginDto);}

Service层impl:

@Service
public class UplusUserServiceImpl implements UplusUserService {@Autowiredprivate UplusUserDao uplusUserDao;@Autowiredprivate UplusOrderDao uplusOrderDao;@Autowiredprivate UplusMasterDao uplusMasterDao;@Autowiredprivate UPlusWalletFlowDao uPlusWalletFlowDao;@Autowiredprivate RedisUtil redisUtil;@AutowiredUplusBrokerageRecordDao uplusBrokerageRecordDao;@Overridepublic Result userLogin(HttpServletRequest request, LoginDto ldto) {if (null == ldto) {return Result.failure(ResultCode.PARAM_IS_BLANK);}if (null == ldto.getPhone() || "".equals(ldto.getPhone())) {return Result.failure(ResultCode.PARAM_IS_BLANK);}// 根据手机查询用户是否存在UplusUser uu = new UplusUser();uu.setPhone(ldto.getPhone());UplusUser uplusUser = this.uplusUserDao.selectOne(uu);if (uplusUser == null) {return Result.failure(ResultCode.USER_OR_PSW_ERROR);}// 判断用户权限if ((UserEnum.UserTypeEnum.FWS.getValue().equals(uplusUser.getType()))|| (UserEnum.UserTypeEnum.GHS.getValue().equals(uplusUser.getType()))) {return Result.failure(ResultCode.LOGIN_NO_ACCESS);}// 判断当前用户状态if (uplusUser.getLockUser().equals(UserEnum.UserLockEnum.LOCK.getCode().toString())) {return Result.failure(ResultCode.USER_LOCK);}// 验证码登录if (ldto.getLoginWay() == UserEnum.UserLoginWayEnum.CODE.getCode()) {
//			String phoneCode = (String) redisUtil.get(ldto.getPhone());
//			if (null == phoneCode || "".equals(phoneCode)) {
//				return Result.failure(ResultCode.USER_LOGIN_ERROR_NOTPHONEORCODE);
//			}if (!"123456".equals(ldto.getPhoneCode())) {return Result.failure(ResultCode.USER_LOGIN_CODE_OFNOAVAIL);}} else {// 判断用户密码是否正确String pswMD5 = CommonUtil.Md5(ldto.getPassword() + uplusUser.getSecurityKey());if (!pswMD5.equals(uplusUser.getPassword())) {return Result.failure(ResultCode.USER_OR_PSW_ERROR);}}String authorization = JwtUtil.sign(uplusUser.getId(), uplusUser.getSecurityKey());UserLoginVo userLoginVo = new UserLoginVo();userLoginVo.setAuthorization(authorization);userLoginVo.setUser(uplusUser);request.getSession().setAttribute(CommonUtil.Md5(uplusUser.getId().toString()), uplusUser);// 销毁redis验证码redisUtil.delete(ldto.getPhone());return Result.success(userLoginVo);}
}

mapper层：

public interface UplusUserDao extends Mapper {/*** 查询我的团队总人数*/int selectCountById(Long id);Page queryMember(TeamListDto td);Page queryHeadUserSales(TeamListDto td);UserExpand findUserExpandById(Long id);/*** 根据Phone 查询用户*/UserLoginVo findByPhone(String phone);/*** 根据用户id查询用户业绩*/
}


SELECT uu1.*,ud.`NAME` AS depotName,  date_format(uu1.CREATE_DATE, '%Y-%c-%d %k:%i:%s' ) AS CREATE_DATE_TEXT,date_format(uu1.UPDATE_DATE, '%Y-%c-%d %k:%i:%s' ) AS UPDATE_DATE_TEXT,uu2.USER_NAME  AS SUPER_USER_NAME,uu2.PHONE AS SUPER_USER_PHONE ,uu3.USER_NAME AS CREATE_USER_NAME,uu4.USER_NAME AS UPDATE_USER_NAME,um3.`NAME` AS TYPE_NAMEFROM UPLUS_USER uu1LEFT OUTER JOIN UPLUS_USER uu2  on uu1.SUPER_USER_ID=uu2.ID AND uu1.SUPER_USER_ID IS NOT NULLAND uu2.DELETE_FLAG='0'LEFT OUTER JOIN UPLUS_DEPOT ud ON ud.id = uu1.DEPOT_IDLEFT OUTER JOIN UPLUS_USER uu3 ON uu1.CREATE_USER =uu3.ID AND uu1.CREATE_USER IS NOT NULLLEFT OUTER JOIN UPLUS_USER uu4 ON uu1.UPDATE_USER =uu4.ID AND uu1.UPDATE_USER IS NOT NULLLEFT OUTER JOIN UPLUS_MASTER um3 ON uu1.TYPE = um3.code and um3.master_gp= '01'WHERE uu1.DELETE_FLAG='0'AND uu1.PHONE = #{phone}SELECTcount( 1 )FROMUPLUS_USER uuWHEREuu.SUPER_USER_ID = #{userId}AND uu.DELETE_FLAG = '0'AND uu.ID != #{userId}SELECTtb.ID AS id,tb.TYPE AS type,tb.NICK_NAME AS nickName,tb.PHONE AS phone,tb.HEADER_URL AS headerUrl,tb.LOCK_USER AS lockUser,tb.NAME AS masterName,SUM( tb.totlaSale ) AS totlaSalesFROM(	SELECT uu.ID,uu.TYPE,uu.USER_NAME,uu.NICK_NAME,uu.PHONE,uu.HEADER_URL,uu.LOCK_USER,um.NAME,IFNULL( SUM( uo.PAY_PRICE ), 0 ) - IFNULL( SUM( uo.POSTAGE ), 0 ) AS	totlaSaleFROMUPLUS_USER uuLEFT JOIN UPLUS_ORDER uo ON uo.USER_ID = uu.IDAND uo.STATE = 1AND uo.IS_PAY = 1and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') >= #{startDate}and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') <= #{endDate}LEFT JOIN UPLUS_MASTER um ON uu.TYPE = um.CODEWHEREuu.SUPER_USER_ID = #{userId}AND uu.DELETE_FLAG = '0'AND uu.ID != #{userId}GROUP BYuu.ID,um.NAMEUNION ALLSELECTuu.ID,uu.TYPE,uu.USER_NAME,uu.NICK_NAME,uu.PHONE,uu.HEADER_URL,uu.LOCK_USER,um.NAME,IFNULL( SUM( uo.PAY_PRICE ), 0 ) - IFNULL( SUM( uo.POSTAGE ), 0 ) AStotlaSaleFROMUPLUS_USER uuLEFT JOIN UPLUS_USER uu1 ON uu1.DELETE_FLAG = '0'AND uu1.LOCK_USER = 1AND uu1.SUPER_USER_ID = uu.IDLEFT JOIN UPLUS_ORDER uo ON uo.USER_ID = uu1.IDAND uo.STATE = 1AND uo.IS_PAY = 1and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') >= #{startDate}and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') <= #{endDate}LEFT JOIN UPLUS_MASTER um ON uu.TYPE = um.CODEWHEREuu.SUPER_USER_ID = #{userId}AND uu.DELETE_FLAG = '0'AND uu.ID != #{userId}GROUP BYuu.ID,um.NAME) tbAND (tb.USER_NAME like concat( '%', #{searchName}, '%')OR tb.NICK_NAME like concat( '%', #{searchName}, '%')OR tb.PHONE like concat( '%', #{searchName}, '%'))GROUP BYID,TYPE,NICK_NAME,PHONE,HEADER_URL,LOCK_USER,NAMEORDER BYtotlaSales DESCSELECTuu.ID as id,uu.TYPE as type,uu.NICK_NAME as nickName,uu.PHONE asphone,uu.HEADER_URL as headerUrl,uu.LOCK_USER as lockUser,um.NAME ASmasterName,IFNULL( SUM( uo.PAY_PRICE ), 0 ) - IFNULL( SUM(uo.POSTAGE), 0 ) AStotlaSalesFROMUPLUS_USER uuINNER JOIN UPLUS_MASTERum ONum.MASTER_GP = '01'LEFT JOIN UPLUS_ORDER uo ON uo.USER_ID =uu.IDANDuo.STATE = 1AND uo.IS_PAY = 1and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') >= #{startDate}and DATE_FORMAT(uo.PAY_TIME,'%Y-%m-%d') <= #{endDate}WHEREuu.SUPER_USER_ID = #{userId}AND um.`CODE` = uu.TYPEAND uu.TYPE ='XSY'AND uu.DELETE_FLAG = '0'AND (uu.USER_NAME like "%"#{searchName}"%"OR uu.NICK_NAMElike "%"#{searchName}"%"OR uu.PHONE like "%"#{searchName}"%")GROUP BYuu.ID,uu.NICK_NAME,uu.HEADER_URL,uu.PHONE,uu.LOCK_USER,um.NAMEORDER BYtotlaSales DESCSELECTum.NAME,uu.*FROMUPLUS_USER uuLEFT JOIN UPLUS_MASTER umON uu.TYPE = um.CODEAND um.MASTER_GP = '01'WHEREuu.ID = #{id}AND uu.DELETE_FLAG = '0'

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！