@Controller
public class UserController {
@Resource
private UserBiz userBiz;
/**
*
@author jerry
版本:1.0
*/
@RequestMapping(value="/userShow")
public String show(Model model){
List<User> userList=userBiz.getUserList();
model.addAttribute("userList", userList);
System.out.println(userList);
return "userList2";
}
/**
*
@author jerry
版本:1.0
*/
@RequestMapping(value="/freezeUser",method=RequestMethod.GET)
public String freeze(int isFreeze,int userId,Model model){
String msg=null;
if(isFreeze==1){
User user=new User();
user.setIsFreeze(isFreeze);
user.setUserId(userId);
int rows=userBiz.freezeUser(user);
System.out.println("冻结"+user);
System.out.println("冻结"+rows);
msg="freezeSuccess!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}else if(isFreeze==0){
msg="freezed!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}
msg="!!!!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}
/**
*
@author jerry
版本:1.0
*/
@RequestMapping(value="/removeFreeze",method=RequestMethod.GET)
public String remove(int isFreeze,int userId,Model model){
String msg=null;
if(isFreeze==0){
User user=new User();
user.setIsFreeze(isFreeze);
user.setUserId(userId);
int rows=userBiz.removeFreeze(user);
System.out.println("解冻"+rows);
msg="removeSuccess!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}else if(isFreeze==1){
msg="removed!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}
msg="!!!!";
model.addAttribute("msg", msg);
return "forward:/userShow";
}
}
userMapper.xml中的代码
<?xml version="1.0" encoding="UTF-8"?>
<!--
<!DOCTYPE mapper SYSTEM "C:\Users\Administrator\Desktop\org\apache\ibatis\builder\xml\mybatis-3-mapper.dtd" >
-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.bdqn.dao.UserMapper">
<select id="getUserList" resultType="User">
select * from user
</select>
<!-- 登录查询sql -->
<select id="getUserByName" parameterType="User" resultType="User">
select * from user where telephone = #{telephone}
</select>
<delete id="daleteUser" parameterType="User">
delete from User where userId=#{userId}
</delete>
<!-- 用户冻结 -->
<update id="freezeUser" parameterType="User">
<if test="isFreeze==1">
update User set isFreeze=0 where userId=#{userId}
</if>
</update>
<!-- 用户解冻 -->
<update id="removeFreeze" parameterType="User">
<if test="isFreeze==0">
update User set isFreeze=1 where userId=#{userId}
</if>
</update>
</mapper>
jsp页面的代码:
<tr>
<td><h3>操作</h3></td>
<td colspan="2">
<input type="hidden" value="${user.isFreeze}" id="isFreeze" >
<a class="btn btn-info" type="button" id="remove" href="removeFreeze?isFreeze=${user.isFreeze}&userId=${user.userId}">
<i class="icon-edit icon-white"></i>
解除冻结
</a><span id="freezeMsg"></span>
<a class="btn btn-danger" type="button" id="freeze${status.count }" href="freezeUser?isFreeze=${user.isFreeze}&userId=${user.userId}">
<i class="icon-trash icon-white"></i>
点击冻结
</a><span id="freezeMsg">${msg }</span>
</td>
</tr>