# Set root category priority to INFO and its only appender to CONSOLE.
#log4j.rootCategory=INFO, CONSOLE debug info warn error fatal
log4j.rootCategory=debug, CONSOLE, LOGFILE
# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n
LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=D://logData/log4j.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n
8.Controller.java
package com.qyf.controller;
import com.github.pagehelper.PageInfo;
import com.qyf.dao.IUserInfoDao;
import com.qyf.domain.Role;
import com.qyf.domain.UserInfo;
import com.qyf.service.IUserService;
import com.qyf.service.impl.UserServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
@Controller
@RequestMapping("/user")
public class UserController {
@Autowired
IUserService userService;
@RequestMapping("/addRoleToUser")
public String addRoleToUser(@RequestParam(name = "userId",required = true) String userId,@RequestParam(name = "ids",required = true) String[] roleIds){
userService.addRoleToUser(userId,roleIds);
return "redirect:findAll.do?";
}
@RequestMapping("/findUserByIdAndAllRole.do")
public ModelAndView findUserByIdAndAllRole( String id){
ModelAndView mav = new ModelAndView("user-role-add");
//根据用户ID查询该用户可以添加的角色信息
mav.addObject("roleList",userService.findRoleByUserId(id));
return mav;
}
@RequestMapping("/findAll.do")
public ModelAndView findAll(@RequestParam(defaultValue = "1") int pageNum,@RequestParam(defaultValue = "4") int pageSize){
ModelAndView mav = new ModelAndView("user-list");
List<UserInfo> userList = userService.findAll(pageNum,pageSize);
//插件分页对象
PageInfo pageInfo = new PageInfo(userList);
mav.addObject("pageInfo",pageInfo);
return mav;
}
@RequestMapping("/save.do")
public String save(UserInfo userInfo){
userService.save(userInfo);
return "redirect:findAll.do";
}
/**
* 查看详情
*/
@RequestMapping("/findById.do")
public ModelAndView findById(String id){
ModelAndView mav = new ModelAndView("user-show");
mav.addObject("user",userService.findById(id));
return mav;
}
}
package com.qyf.dao;
import com.qyf.domain.Permission;
import com.qyf.domain.Role;
import org.apache.ibatis.annotations.*;
import java.util.List;
public interface IRoleDao {
//根据用户ID查询处所有对应的角色和角色对应的权限
@Select("select * from role where id in(select roleid from users_role where userid=#{userid})")
@Results({
@Result(column = "id",property = "permissions",many = @Many(select = "com.qyf.dao.IPermissionDao.findByRoleId"))
})
List<Role> findByUserId(String userId);
@Select("select * from role")
List<Role> findAll();
@Insert("insert into role(id,rolename,roledesc)values(default,#{roleName},#{roleDesc})")
void save(Role role);
@Select("select * from role where id=#{roleId}")
Role findByRoleId(String roleId);
@Select("select * from permission where id not in(select permissionid from role_permission where roleid=#{roleId})")
List<Permission> findPermissionsByRoleId(String roleId);
@Insert("insert into role_permission(permissionid,roleid)values(#{permissionid},#{roleId})")
void savePermissionsByRoleId(@Param("roleId") String roleId,@Param("permissionid") String permissionId);
}
package com.qyf.dao;
import com.qyf.domain.Role;
import com.qyf.domain.UserInfo;
import org.apache.ibatis.annotations.*;
import java.util.List;
public interface IUserInfoDao {
@Select("select * from users")
List<UserInfo> findAll();
@Select("select * from users where username=#{username}")
@Results({
@Result(column = "id",many = @Many(select = "com.qyf.dao.IRoleDao.findByUserId"),
property = "roles")
})
UserInfo findByUser(String username);
@Insert("insert into users(id,email,username,password,phonenum,status) values" +
"(default,#{email},#{username},#{password},#{phoneNum},#{status})")
void save(UserInfo userInfo);
@Select("select * from users where id=#{id}")
@Results({
@Result(column = "id",many = @Many(select = "com.qyf.dao.IRoleDao.findByUserId"),
property = "roles")
})
UserInfo findById(String id);
@Select("select * from role where id not in(select roleid from users_role where userid=#{id})")
List<Role> findRoleByUserId(String id);
@Insert("insert into users_role (userid,roleid)values(#{userid},#{roleid})")
void addRoleToUser(@Param("userid") String userId,@Param("roleid") String roleId);
}