第1关:用户注册
SSM_proj_user/resource/mappers/UserMapper.xml
<insert id="insert" parameterType="com.pojo.User" >
<!-- 在这里编写插入用户的sql语句 第一关请在此编写代码 -->
insert into t_user (username, password, phone,avatar,last_login, user_register_time )
values (#{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR},
#{phone,jdbcType=INTEGER},
#{avatar,jdbcType=VARCHAR},
now(), now())
</insert>
SSM_proj_user/src/com/service/impl/UserServiceImpl.java
//注册
public ServerResponse register(User user) {
//校验用户名是否存在
ServerResponse response = checkValid(user.getUsername(),USER_TYPE);
if (response.getStatus() == ServerResponse.ERROR) {
return response;
}
//校验手机号是否存在
response = checkValid(user.getPhone(), PHONE_TYPE);
if (response.getStatus() == ServerResponse.ERROR) {
return response;
}
//MD5加密
user.setPassword(MD5Util.getMD5(user.getPassword()));
//设置默认头像
user.setAvatar("/img/image.jpg");
//实现用户注册
int result = userMapper.insert(user);
if (result == 0) {
return new ServerResponse("注册失败", ServerResponse.ERROR);
}
return new ServerResponse("注册成功", ServerResponse.SUCCESS);
}
SSM_proj_user/src/com/controller/UserController.java
@RequestMapping("register.do")
@ResponseBody
public ServerResponse register(User user) {
//实现注册功能
ServerResponse response = userService.register(user);
return response;
}
第2关:用户登陆
SSM_proj_user/resource/mappers/UserMapper.xml
<select id="selectByUserInfo" resultMap="BaseResultMap" parameterType="map" >
<!-- 在这里编写查询用户的sql语句 第二关请在此编写代码 -->
select
<include refid="Base_Column_List" />
from t_user
where (username = #{username} OR email = #{username} OR phone = #{password}) AND password = #{password}
</select>
SSM_proj_user/src/com/service/impl/UserServiceImpl.java
// 登陆
public ServerResponse loginByUserNameAndPwd(String username, String password) {
password = MD5Util.getMD5(password);
User user = userMapper.selectByUserInfo(username, password);
if (user != null) {
// 登录成功
return new ServerResponse("登录成功", ServerResponse.SUCCESS, user);
}
return new ServerResponse("登录失败,用户名或密码错误!", ServerResponse.ERROR);
}
SSM_proj_user/src/com/controller/UserController.java
@RequestMapping("login.do")
@ResponseBody
public ServerResponse login(@RequestParam("username") String username,@RequestParam("password") String password, HttpSession session, HttpServletRequest request) {
//实现登陆功能
ServerResponse response = userService.loginByUserNameAndPwd(username, password);
if (response.getStatus() == ServerResponse.SUCCESS) {
session.setAttribute("userInfo", response.getData());
}
return response;
}