http://localhost/ssm-v1/log/doFindPageObjects.do?pageCurrent=1

業(yè)務(wù)架構(gòu)mvc

sys_logs

/ssm-v1/pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.jt</groupId>
    <artifactId>ssm-v1</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.5.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>
    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>4.3.9.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.40</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.29</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>2.8.5</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.9.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
    </dependencies>
</project>

/ssm-v1/src/main/resources/config.properties

jdbcDriver=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql:///jtsys?useUnicode=true&characterEncoding=utf-8
jdbcUsername=root
jdbcPassword=123456

/ssm-v1/src/main/resources/spring-configs.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:util="http://www.springframework.org/schema/util" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xsi:schemaLocation="  
       http://www.springframework.org/schema/beans   
       http://www.springframework.org/schema/beans/spring-beans-4.3.xsd  
       http://www.springframework.org/schema/mvc   
       http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd   
       http://www.springframework.org/schema/tx   
       http://www.springframework.org/schema/tx/spring-tx-4.3.xsd   
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-4.3.xsd
       http://www.springframework.org/schema/data/jpa 
       http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    <context:component-scan base-package="com.jt"/>
    <import resource="classpath:spring-mvc.xml" />
    <import resource="classpath:spring-mybatis.xml" />
</beans>

/ssm-v1/src/main/resources/spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:util="http://www.springframework.org/schema/util" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xsi:schemaLocation="  
       http://www.springframework.org/schema/beans   
       http://www.springframework.org/schema/beans/spring-beans-4.3.xsd  
       http://www.springframework.org/schema/mvc   
       http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd   
       http://www.springframework.org/schema/tx   
       http://www.springframework.org/schema/tx/spring-tx-4.3.xsd   
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-4.3.xsd
       http://www.springframework.org/schema/data/jpa 
       http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    <mvc:annotation-driven />
    <!--配置springMVC視圖解析器(負責(zé)視圖解析操作) -->
    <bean id="viewResolver"
        class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!--前綴 -->
        <property name="Prefix" value="/WEB-INF/pages/"></property>
        <property name="Suffix" value=".jsp"></property>
    </bean>
</beans>

/ssm-v1/src/main/resources/mapper/sys/SysLogMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jt.dao.SysLogDao">
    <sql id="queryWhereId">
        <where>
            <if test="username!=null and username!=''">
                username like concat('%',#{username},'%')
            </if>
        </where>
    </sql>
    <select id="findPageObjects" resultType="com.jt.entity.SysLog">
        select * from sys_logs
        <include refid="queryWhereId" />
        order by createdTime desc
        limit #{startIndex},#{pageSize}
    </select>
    <select id="getRowCount" resultType="int">
        select count(*) from sys_logs
        <include refid="queryWhereId" />
    </select>
</mapper>

/ssm-v1/src/main/resources/spring-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:p="http://www.springframework.org/schema/p" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:util="http://www.springframework.org/schema/util" xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    xsi:schemaLocation="  
       http://www.springframework.org/schema/beans   
       http://www.springframework.org/schema/beans/spring-beans-4.3.xsd  
       http://www.springframework.org/schema/mvc   
       http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd   
       http://www.springframework.org/schema/tx   
       http://www.springframework.org/schema/tx/spring-tx-4.3.xsd   
       http://www.springframework.org/schema/aop 
       http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
       http://www.springframework.org/schema/util 
       http://www.springframework.org/schema/util/spring-util-4.3.xsd
       http://www.springframework.org/schema/data/jpa 
       http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd
       http://www.springframework.org/schema/context
       http://www.springframework.org/schema/context/spring-context-4.3.xsd">
    <util:properties id="cfg" location="classpath:config.properties"></util:properties>
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
        init-method="init" destroy-method="close" lazy-init="false">
        <property name="driverClassName" value="#{cfg.jdbcDriver}"></property>
        <property name="url" value="#{cfg.jdbcUrl}"></property>
        <property name="username" value="#{cfg.jdbcUsername}"></property>
        <property name="password" value="#{cfg.jdbcPassword}"></property>
        <!-- 配置獲取連接等待超時的時間 -->
        <property name="maxWait" value="1800" />
        <property name="MaxActive" value="10" />
    </bean>

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="BasePackage" value="com.jt.**.dao"/>
        <!--下面這行可以不寫，但是有多個 sqlSessionFactory會報錯 -->
        <property name="SqlSessionFactoryBeanName" value="sqlSessionFactory" />
    </bean>
    <!--整合SqlSessionFactoryBean對象(通過此對象創(chuàng)建SqlSession)  -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" lazy-init="true">
        <property name="dataSource" ref="dataSource"></property>
    <property name="mapperLocations" value="classpath:mapper/sys/*Mapper.xml"/>
    </bean>
</beans>

/ssm-v1/src/main/webapp/index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>首頁</title>
</head>
<body>
    SpringMVC
</body>
</html>

/ssm-v1/src/main/webapp/WEB-INF/web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
  <display-name>ssm-v1</display-name>
 <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
  <!--配置SpringMVC前端控制器-->
    <!--注冊前端控制器-->
    <servlet>
        <servlet-name>DispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!--初始化參數(shù)讀取配置文件-->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-configs.xml</param-value>
        </init-param>
        <!--配置servlet在服務(wù)啟動時加載(數(shù)字越小，優(yōu)先級越高)
        配置如下選項以后哈恰，tomcat啟動時會初始化這個servlet
        這個servlet在初始化時會讀取contextConfigLocation參數(shù)對應(yīng)的配置文件。-->
        <load-on-startup>1</load-on-startup>
    </servlet>
    <!--配置前端控制器-->
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>*.do</url-pattern>
    </servlet-mapping>
</web-app>

/ssm-v1/src/main/java/com/jt/common/exception/ServiceException.java

package com.jt.common.exception;

public class ServiceException extends RuntimeException {

    private static final long serialVersionUID = 1L;

    public ServiceException() {
        super();
        // TODO Auto-generated constructor stub
    }

    public ServiceException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) {
        super(message, cause, enableSuppression, writableStackTrace);
        // TODO Auto-generated constructor stub
    }

    public ServiceException(String message, Throwable cause) {
        super(message, cause);
        // TODO Auto-generated constructor stub
    }

    public ServiceException(String message) {
        super(message);
        // TODO Auto-generated constructor stub
    }

    public ServiceException(Throwable cause) {
        super(cause);
        // TODO Auto-generated constructor stub
    }
    

}

/ssm-v1/src/main/java/com/jt/common/vo/JsonResult.java

package com.jt.common.vo;


public class JsonResult {
    //狀態(tài)碼：1表示正確唉侄，0表示錯誤
    private int state=1;
    //狀態(tài)碼對應(yīng)的信息
    private String message="OK";
    //正確數(shù)據(jù)通過此屬性進行封裝，例如查詢的結(jié)果
    private Object data;
    public JsonResult(){}
    public JsonResult(String message){
        this.message=message;
    }
    //初始化正確的數(shù)據(jù)
    public JsonResult(Object data) {
        this.data=data;
    }
    /**出現(xiàn)異常時可以通過此方法初始化異常信息*/
    public JsonResult(Throwable e){
        this.state=0;//表示錯誤信息
        this.message=e.getMessage();
    }
    public int getState() {
        return state;
    }
    public void setState(int state) {
        this.state = state;
    }
    public String getMessage() {
        return message;
    }
    public void setMessage(String message) {
        this.message = message;
    }
    public Object getData() {
        return data;
    }
    public void setData(Object data) {
        this.data = data;
    }
    
}

/ssm-v1/src/main/java/com/jt/common/vo/PageObject.java

對象要序列化需要實現(xiàn)序列化接口
添加序列化ID是為了反序列化的時候起作用，比方說序列化的時候有四個字段，但是后面對對象做了改動如又加了字段酒繁，或少了字段，或加了方法控妻，類變化了州袒，要想反序列化，沒有序列化ID就失敗弓候。

package com.jt.common.vo;

import java.io.Serializable;
import java.util.List;
/**
 * 業(yè)務(wù)層值對象郎哭，負責(zé)封裝業(yè)務(wù)層數(shù)據(jù)
 * @param <T>
 */
public class PageObject<T> implements Serializable{
    private static final long serialVersionUID = 1L;
//類泛型
    /**下面這些值和表沒有對應(yīng)關(guān)系，可以用int*/
    /**當(dāng)前頁的記錄信息*/
    private List<T> records;
    /**總記錄數(shù)*/
    private int rowCount;
    /**總頁數(shù)*/
    private int pageCount;
    /**頁面大小*/
    private int pageSize=3;
    /**當(dāng)前頁的頁碼*/
    private int pageCurrent=1;
    public List<T> getRecords() {
        return records;
    }
    public void setRecords(List<T> records) {
        this.records = records;
    }
    public int getRowCount() {
        return rowCount;
    }
    public void setRowCount(int rowCount) {
        this.rowCount = rowCount;
    }
    public int getPageCount() {
        return pageCount;
    }
    public void setPageCount(int pageCount) {
        this.pageCount = pageCount;
    }
    public int getPageSize() {
        return pageSize;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
    public int getPageCurrent() {
        return pageCurrent;
    }
    public void setPageCurrent(int pageCurrent) {
        this.pageCurrent = pageCurrent;
    }
    @Override
    public String toString() {
        return "PageObject [records=" + records + ", rowCount=" + rowCount + ", pageCount=" + pageCount + ", pageSize="
                + pageSize + ", pageCurrent=" + pageCurrent + "]";
    }
    
}

/ssm-v1/src/main/java/com/jt/common/web/GlobalExceptionHandler.java

package com.jt.common.web;

import org.springframework.web.bind.annotation.ControllerAdvice;
import org.springframework.web.bind.annotation.ExceptionHandler;
import org.springframework.web.bind.annotation.ResponseBody;

import com.jt.common.vo.JsonResult;
@ControllerAdvice
public class GlobalExceptionHandler {
    /**
     * 處理運行時異常
     * @return
     */
    @ExceptionHandler(RuntimeException.class)
    @ResponseBody
    public JsonResult doHandleRuntimeException(RuntimeException e){
        /**
         * 封裝異常信息
         */
        e.printStackTrace();
        return new JsonResult(e);
    }
}

/ssm-v1/src/main/java/com/jt/controller/SysLogController.java

package com.jt.controller;

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.ResponseBody;

import com.jt.common.vo.JsonResult;
import com.jt.service.SysLogService;

@RequestMapping("/log/")
@Controller
public class SysLogController {
    @Autowired
    private SysLogService SysLogService;
    
    @RequestMapping("doFindPageObjects")
    @ResponseBody
    public JsonResult doFindPageObjects(String username,Integer pageCurrent){
        return new JsonResult(SysLogService.findPageObjects(username,pageCurrent));
    }
}

/ssm-v1/src/main/java/com/jt/dao/SysLogDao.java

username在動態(tài)sql中使用了菇存，需要在dao中的方法加@Param修飾夸研。如果沒有注解修飾，在基于名字進行查詢時會出現(xiàn)There is no getter for property named 'username' in class java.lang.String

package com.jt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.jt.entity.SysLog;

public interface SysLogDao {
    /**
     * 基于條件分頁查詢?nèi)罩拘畔?     * @param username 查詢條件(查詢哪個用戶的日志信息)
     * @param startIndex 當(dāng)前頁的起始位置
     * @param pageSize 當(dāng)前頁面的大小
     * @return 當(dāng)前頁的日志記錄信息
     * 數(shù)據(jù)庫中每條日志信息封裝到一個SysLog對象中
     */
    List<SysLog> findPageObjects(@Param("username")String username,@Param("startIndex")Integer startIndex,@Param("pageSize")Integer pageSize);
    /**
     * 基于條件查詢總記錄數(shù)
     * @param username 查詢條件(基于用戶名查詢)
     * @return 總記錄數(shù)(基于這個結(jié)果可以計算總頁數(shù))
     */
    int getRowCount(@Param("username")String username);
}

/ssm-v1/src/main/java/com/jt/service/impl/SysLogServiceImpl.java

package com.jt.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.jt.common.exception.ServiceException;
import com.jt.dao.SysLogDao;
import com.jt.entity.SysLog;
import com.jt.service.SysLogService;
import com.jt.common.vo.PageObject;
@Service
public class SysLogServiceImpl implements SysLogService {

    @Autowired
    private SysLogDao sysLogDao;
    public SysLogDao getSysLogDao() {
        return sysLogDao;
    }
    public void setSysLogDao(SysLogDao sysLogDao) {
        this.sysLogDao = sysLogDao;
    }
    @Override
    public PageObject<SysLog> findPageObjects(String username, Integer pageCurrent) {
        //1.參數(shù)有效性驗證(只驗證pageCurrent)
        if(pageCurrent==null||pageCurrent<1)
            throw new IllegalArgumentException("頁碼值有誤");
        //2.查詢總記錄數(shù)并進行驗證
        int rowCount = sysLogDao.getRowCount(username);
        if(rowCount==0)
            throw new ServiceException("沒有對應(yīng)記錄");
        //3.查詢當(dāng)前頁日志數(shù)據(jù)
        int pageSize=2;
        int startIndex=(pageCurrent-1)*pageSize;
        List<SysLog> records = sysLogDao.findPageObjects(username, startIndex, pageSize);
        //4.對查詢結(jié)果進行封裝
        PageObject<SysLog>po=new PageObject<SysLog>();
        po.setRecords(records);
        po.setRowCount(rowCount);
        po.setPageSize(pageSize);
        po.setPageCurrent(pageCurrent);
    /*  int pageCount=rowCount/pageSize;
        if(rowCount%pageSize!=0){
            pageCount++;
        }*/
        po.setPageCount((rowCount-1)/pageSize+1);
        //5.返回結(jié)果
        return po;
    }

}

/ssm-v1/src/main/java/com/jt/service/SysLogService.java

package com.jt.service;

import com.jt.common.vo.PageObject;
import com.jt.entity.SysLog;

public interface SysLogService {
    /**
     * 依據(jù)條件分頁查詢?nèi)罩拘畔?     * @param username 用戶名
     * @param pageCurrent 當(dāng)前頁碼
     * @return 對查詢結(jié)果的封裝
     */
    PageObject<SysLog> findPageObjects(String username,Integer pageCurrent);
}