企業(yè)權(quán)限管理系統(tǒng)講義6s日志

1、SSMAOP日志1.數(shù)據(jù)庫與表結(jié)構(gòu)1.1.日志表信息描述sysLog1.2.sql語句CREATE TABLE sysLog(id VARCHAR2(32) default SYS_GUID() PRIMARY KEY,visitTime timestamp, username VARCHAR2(50), ip VARCHAR2(30),url VARCHAR2(50),executionTime int, method VARCHAR2(200)1.3.實(shí)體類北京市昌平區(qū)建材城西路 龍辦公樓一層：序號字段名稱字段類型字段描述1idVARCHAR2主鍵 無意義uuid2visitTimetim

2、estamp時(shí)間3usernameVARCHAR2操作者用戶名4ipVARCHAR2ip5urlVARCHAR2url6executionTimeint執(zhí)行時(shí)長7methodVARCHAR方法public class SysLog private String id; private Date visitTime;private String visitTimeStr; private String username; private String ip;private String url; private Long executionTime; private String method;

3、2.基于AOP日志處理2.1. 頁面syslog-list.jsp詳細(xì)內(nèi)容請查看 中頁面信息2.2. 創(chuàng)建切面類處理日志北京市昌平區(qū)建材城西路 龍辦公樓一層：Component Aspectpublic class LogAop Autowiredprivate HttpServletRequest request;Autowiredprivate ISysLogService sysLogService;private Date startTime; / 時(shí)間private Class executionClass;/ 的類private Method executionMethod; /

4、的方法/ 主要獲取 時(shí)間、 的類、 的方法Before("execution(* com.itheima.ssm.controller.*.*(.)")public void doBefore(JoinPoint jp) throws NoSuchMethodException, SecurityException startTime = new Date(); / 時(shí)間/ 獲取 的類executionClass = jp.getTarget().getClass();/ 獲取 的方法String methodName = jp.getSignature().getName

5、();/ 獲取 的方法的名稱Object args = jp.getArgs();/ 獲取 的方法的參數(shù)if (args = null | args.length = 0) / 無參數(shù)executionMethod = executionClass.getMethod(methodName); / 只能獲取無參數(shù)方法 else / 有參數(shù)，就將args中所有元素遍歷，獲取對應(yīng)的Class,裝入到一個(gè)Class Class classArgs = new Classargs.length;北京市昌平區(qū)建材城西路 龍辦公樓一層：for (int i = 0; i < args.length;

6、 i+) classArgsi = argsi.getClass();executionMethod = executionClass.getMethod(methodName, classArgs);/ 獲取有參數(shù)方法/ 主要獲取日志中其它信息，時(shí)長、ip、url. After("execution(* com.itheima.ssm.controller.*.*(.)") public void doAfter(JoinPoint jp) throws Exception / 獲取類上的RequestMapping對象if (executionClass != SysL

7、ogController.class) RequestMapping classAnnotation = (RequestMapping)executionClass.getAnnotation(RequestMapping.class); if (classAnnotation != null) / 獲取方法上的RequestMapping對象RequestMapping methodAnnotation = executionMethod.getAnnotation(RequestMapping.class);if (methodAnnotation != null) String url

8、 = "" / 它的值應(yīng)該是類上的RequestMapping的value+方法上的RequestMapping的valueurl = classAnnotation.value()0 + methodAnnotation.value()0; SysLog sysLog = new SysLog();/ 獲取 時(shí)長Long executionTime = new Date().getTime() - startTime.getTime();/ 將sysLog對象屬性封裝sysLog.setExecutionTime(executionTime); sysLog.setUrl

9、(url);/ 獲取ipString ip = request.getRemoteAddr(); sysLog.setIp(ip);/ 可以通過securityContext獲取，也可以從request.getSession中獲取SecurityContext context = SecurityContextHolder.getContext(); / request.getSession().getAttribute("SPRING_SECURITY_CONTEXT")String username = (User) (context.getAuthentication

10、().getPrincipal().getUsername();sysLog.setUsername(username);sysLog.setMethod("類名" + executionClass.getName() + "方法名" + executionMethod.getName();sysLog.setVisitTime(startTime);/ 調(diào)用Service，調(diào)用dao將sysLog insert數(shù)據(jù)庫sysLogService.save(sysLog);在切面類中我們需要獲取登錄用戶的username，還需要獲取ip地址，我們怎么處理？

11、username獲取SecurityContextHolder獲取ip地址獲取ip地址的獲取我們可以通過request.getRemoteAddr()方法獲取到。在Spring中可以通過ReqontextListener來獲取request或session對象。2.3.SysLogControllerRequestMapping("/sysLog") Controllerpublic class SysLogController Autowiredprivate ISysLogService sysLogService;RequestMapping("/findA

12、ll.do")public M AndView findAll() throws Exception M AndView mv = new M AndView();List<SysLog> sysLogs = sysLogService.findAll(); mv.addObject("sysLogs", sysLogs); mv.setViewName("syslog-list");return mv;2.4.Service北京市昌平區(qū)建材城西路 龍辦公樓一層：Service Transactionalpublic class S

13、ysLogServiceImpl implements ISysLogService Autowiredprivate ISysLogDao sysLogDao;Overridepublic void save(SysLog log) throws Exception sysLogDao.save(log);Override2.5.Daopublic interface ISysLogDao Select("select * from syslog") Results(Result(id=true,column="id",property="i

14、d"), Result(column="visitTime",property="visitTime"), Result(column="ip",property="ip"), Result(column="url",property="url"), Result(column="executionTime",property="executionTime"), Result(column="method",property="method"), Result(column="username",property="username")public List<SysLog> findAll() throws Exception;Insert("insert into syslog(visitTime,username,ip,url,exe