SSM整合配置及处理器与分页等工具类

Spring : 春天 —>给软件行业带来了春天

2002年，Rod Jahnson首次推出了Spring框架雏形interface21框架。

2004年3月24日，Spring框架以interface21框架为基础，经过重新设计，发布了1.0正式版。

官网 : Spring | Home

MVC是模型(Model)、视图(View)、控制器(Controller)的简写，是一种软件设计规范。

是将业务逻辑、数据、显示分离的方法来组织代码。

MVC主要作用是降低了视图与业务逻辑间的双向偶合。

MVC不是一种设计模式，MVC是一种架构模式。当然不同的MVC存在差异。

MyBatis 是一款优秀的持久层框架。

MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集的过程。

MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 实体类 【Plain Old Java Objects,普通的 Java对象】映射成数据库中的记录。

Mybatis官方文档 : mybatis – MyBatis 3 | 简介

asm-3.3.1.jar
cglib-2.2.2.jar
com.springsource.com.mchange.v2.c3p0-0.9.1.2.jar
com.springsource.org.aopalliance-1.0.0.jar
com.springsource.org.apache.commons.logging-1.1.1.jar
com.springsource.org.apache.log4j-1.2.15.jar
com.springsource.org.aspectj.weaver-1.6.8.RELEASE.jar
commons-fileupload-1.2.2.jar
commons-io-2.4.jar
fastjson-1.2.47.jar
jackson-annotations-2.4.0.jar
jackson-core-2.4.2.jar
jackson-databind-2.4.2.jar
javassist-3.17.1-GA.jar
jsqlparser-1.0.jar
jstl-1.2.jar
log4j-1.2.17.jar
log4j-api-2.0-rc1.jar
log4j-core-2.0-rc1.jar
mybatis-3.2.7.jar
mybatis-spring-1.2.2.jar
mysql-connector-java-5.1.7-bin.jar
pagehelper-5.0.0.jar
slf4j-api-1.7.5.jar
slf4j-log4j12-1.7.5.jar
spring-aop-4.2.4.RELEASE.jar
spring-aspects-4.2.4.RELEASE.jar
spring-beans-4.2.4.RELEASE.jar
spring-context-4.2.4.RELEASE.jar
spring-core-4.2.4.RELEASE.jar
spring-expression-4.2.4.RELEASE.jar
spring-jdbc-4.2.4.RELEASE.jar
spring-test-4.2.4.RELEASE.jar
spring-tx-4.2.4.RELEASE.jar
spring-web-4.2.4.RELEASE.jar
spring-webmvc-4.2.4.RELEASE.jar

mybatis

SqlMapConfig.xml

    
    
        
        
    
​
    
    
        
        
            
            
        
    

​

spring

applicationContext-dao.xml

​
    
    
​
    
    
        
        
        
        
    
​
    
    
        
        
        
        
    
​
    
    
        
        
    
​

​

applicationContext-service.xml

​
    
    
​

​

applicationContext-trans.xml

​
    
    
        
        
    
​
    
    
        
            
            
            
        
    
​
    
    
        
    
​

​

springmvc.xml

​
    
    
​
    
    
​
    
    
​
    
    
        
            
                
            
        
    
​
    
    
​
    
    
        
        
    
​
    
    
        
            
             
登录拦截器 
interceptor
 
HandlerInterceptor1
 
package com.wh.interceptor;
​
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
​
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.servlet.HandlerInterceptor;
import org.springframework.web.servlet.ModelAndView;
​

public class HandlerInterceptor1 implements HandlerInterceptor {
​
    @Autowired
    private LoginService LoginService;
​
    
    public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object arg2, Exception arg3)
            throws Exception {
​
    }
​
    
    public void postHandle(HttpServletRequest request, HttpServletResponse response, Object arg2, ModelAndView arg3)
            throws Exception {
​
    }
​
    
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object obj) throws Exception {
        
        return false;
    }
​
}
​
 
分页 
utils
 
NavigationTag
 
package com.wh.utils;
​
import java.io.IOException;
import java.util.Map;
​
import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.TagSupport;
​
import com.github.pagehelper.PageInfo;
​

public class NavigationTag extends TagSupport {
    static final long serialVersionUID = 2372405317744358833L;
​
    
    private String bean = "page";
​
    
    private String url = null;
​
    
    private int number = 5;
​
    @Override
    public int doStartTag() throws JspException {
        JspWriter writer = pageContext.getOut();
        HttpServletRequest request = (HttpServletRequest) pageContext.getRequest();
        PageInfo page = (PageInfo) request.getAttribute(bean);
        if (page == null)
            return SKIP_BODY;
        url = resolveUrl(url, pageContext);
        try {
            // 计算总页数
            Long pageCount = page.getTotal() / page.getPageSize();
            if (page.getTotal() % page.getPageSize() > 0) {
                pageCount++;
            }
            writer.print("");
        } catch (IOException e) {
            e.printStackTrace();
        }
        return SKIP_BODY;
    }
​
    private String append(String url, String key, int value) {
​
        return append(url, key, String.valueOf(value));
    }
​
    
    private String append(String url, String key, String value) {
        if (url == null || url.trim().length() == 0) {
            return "";
        }
​
        if (url.indexOf("?") == -1) {
            url = url + "?" + key + "=" + value;
        } else {
            if (url.endsWith("?")) {
                url = url + key + "=" + value;
            } else {
                url = url + "&" + key + "=" + value;
            }
        }
​
        return url;
    }
​
    
    private String resolveUrl(String url, javax.servlet.jsp.PageContext pageContext) throws JspException {
        // UrlSupport.resolveUrl(url, context, pageContext)
        Map params = pageContext.getRequest().getParameterMap();
        for (Object key : params.keySet()) {
            if ("page".equals(key) || "rows".equals(key))
                continue;
            Object value = params.get(key);
            if (value == null)
                continue;
            try {
                if (value.getClass().isArray()) {
                    // 解决GET乱码问题
                    // value = new String(((String[])
                    // value)[0].getBytes("ISO-8859-1"), "UTF-8");
​
                    value = ((String[]) value)[0];
                    url = append(url, key.toString(), value.toString());
                } else if (value instanceof String) {
                    // 解决GET乱码问题
                    // value = new String(((String)
                    // value).getBytes("ISO-8859-1"), "UTF-8");
                    value = (String) value;
                    url = append(url, key.toString(), value.toString());
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        return url;
    }
​
    
    public String getBean() {
        return bean;
    }
​
    
    public void setBean(String bean) {
        this.bean = bean;
    }
​
    
    public String getUrl() {
        return url;
    }
​
    
    public void setUrl(String url) {
        this.url = url;
    }
​
    public void setNumber(int number) {
        this.number = number;
    }
​
}
​
 
WEB-INF——>tld
 
commons.tld
 



    2.0
    1.2
    common
    http://com.wh.com/common/
    Common Tag
    Common Tag library
​
    
        page
        com.wh.utils.NavigationTag
        JSP
        create navigation for paging
        
            bean
            true
        
        
            number
            true
        
        
            url
            true
            true
        
    

​
​
​
注：.jsp
<%@ taglib prefix="wh" uri="http://com.wh.com/common/"%>
 
代码片段 
Mapper 
mapper头文本
 



    
 
crud
 

    
    
        SELECT LAST_INSERT_ID()
    
    insert into 表名(字段名) values(字段值)



    delete from 表名 where id = #{id}


update 表名

    
        字段名 = #{字段值},
    
    
        字段名 = #{字段值},
    
    where id = #{id}



    select * from 表名
    
        
            and 字段名 = #{字段值}
        
        
            and 字段名 = #{字段值}
        
    
 
 
JSP 
jsp
 
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>







    ${pageContext.request.contextPath}

 
c
 
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
 
fmt
 
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>