SpringMVC+MyBatis（最新） -

hello123654789

浏览: 12742 次

最近访客更多访客>>

fhtwins

youcp999

wangchaoyong

scholers

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (14)

社区版块

存档分类

2017-04 ( 14)
更多存档...

SpringMVC+MyBatis（最新）

spring mvc 框架 bean struts

目前主流的Web MVC框架，除了Struts这个主力外，还有Spring MVC，主要是由于Spring MVC配置比较简单，使用起来也十分明了，非常灵活，与Spring 集成较好，对RESTful API的支持也比struts要好。
MyBatis是ibatis的升级版，作为hibernate的老对手，它是一个可以自定义SQL、存储过程和高级映射的持久层框架。
与hibernate的主要区别就是mybatis是半自动化的，而hibernate是全自动的，所以当应用需求越来越复杂的时候，自动化的sql显得比较笨拙。
由于前段时间接了个项目要用springmvc做，所以我抱着练手的态度，又玩起了整合框架的游戏。经常搭框架的人应该都清楚，框架搭建的核心就是配置文件。所以我主要贴下几个配置文件的代码。还是那句话，我都是写好配置文件之后，运行报错再加jar。这里列一下我用的jar包（应该是最少的）：

备注：上图有一些额外的jar，比如我用的数据库连接池是阿里巴巴的druid、日志框架式logback，所以引入了相关jar。关于这两个框架的使用和配置都是非常简单的，所以这里就不细说。
1.整合SpringMVC
springMybatis-servlet.xml：

[html] view plain copy

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

        
    <mvc:annotation-driven>
    </mvc:annotation-driven>

    
    <context:component-scan base-package="com.alibaba.controller" />
    <context:component-scan base-package="com.alibaba.service"/>


    
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/" />
        <property name="suffix" value=".jsp" /> 
    </bean>

    
    <mvc:interceptors>
        <mvc:interceptor>
            
            <mvc:mapping path="/" />
            <mvc:mapping path="/user/**" />
            <mvc:mapping path="/test/**" />

            <bean class="com.alibaba.interceptor.CommonInterceptor"></bean>
        </mvc:interceptor>
        
    </mvc:interceptors>

</beans>

2.整合Mybatis

spring-dao.xml:

[html] view plain copy

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mybatis="http://mybatis.org/schema/mybatis-spring"
       xmlns:context="http://www.springframework.org/schema/context"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
       http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    
    <mybatis:scan base-package="com.alibaba.dao"/>
    
    <context:property-placeholder location="classpath:configuration.properties"/>

    
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        
        <property name="initialSize"><value>1</value></property>
        <property name="maxActive"><value>5</value></property>
        <property name="minIdle"><value>1</value></property>
        
        <property name="maxWait"><value>60000</value></property>
        
        <property name="filters"><value>stat</value></property>
        
        <property name="timeBetweenEvictionRunsMillis"><value>60000</value></property>
        
        <property name="minEvictableIdleTimeMillis"><value>300000</value></property>
        
    </bean>

    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
    </bean>
</beans>

3.web.xml整合SpringMVC和Mybatis

[html] view plain copy

<?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" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">
    
    
    <servlet-mapping>
        <servlet-name>default</servlet-name>
        <url-pattern>/js/*</url-pattern>
        <url-pattern>/css/*</url-pattern>
        <url-pattern>/images/*</url-pattern>
        <url-pattern>/fonts/*</url-pattern>
    </servlet-mapping>

    
    <filter>
        <filter-name>encodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    
    <servlet>
        <servlet-name>springMybatis</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>springMybatis</servlet-name>
        
        <url-pattern>/</url-pattern>
    </servlet-mapping>

    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/config/spring-*.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
    <servlet>
        <servlet-name>DruidStatView</servlet-name>
        <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DruidStatView</servlet-name>
        <url-pattern>/druid/*</url-pattern>
    </servlet-mapping>

    <error-page>
        <error-code>404</error-code>
        <location>/error/404.jsp</location>
    </error-page>
    <error-page>
        <error-code>500</error-code>
        <location>/error/500.jsp</location>
    </error-page>
</web-app>

4.logback.xml日志配置

[html] view plain copy

<?xml version="1.0" encoding="UTF-8"?>
<configuration>

<appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
    <encoder>
        <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
    </encoder>
</appender>

<logger name="test.LogbackTest" level="TRACE"/>

<logger name="com.alibaba.controller.TestController" level="TRACE"/>

<logger name="org.springframework.web.servlet.DispatcherServlet" level="DEBUG" />
<logger name="druid.sql" level="INFO" />
<root level="debug">
    <appender-ref ref="STDOUT" />
</root>
</configuration>

5.configuration.properties配置

[html] view plain copy

jdbc.url=jdbc\:mysql\://localhost\:3306/druid?useUnicode\=true&characterEncoding\=UTF-8&zeroDateTimeBehavior\=convertToNull
jdbc.username=root
jdbc.password=123456

6.测试搭建是否成功，后台代码

首先是登录，用了加密，可以去掉

[java] view plain copy

package com.alibaba.controller;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;

import org.apache.commons.codec.digest.DigestUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import com.alibaba.model.User;
import com.alibaba.service.UserService;
import com.alibaba.util.RequestUtil;

/**
* @author tfj
* 2014-7-26
*/
@Controller
public class SystemController {
    private final Logger log = LoggerFactory.getLogger(SystemController.class);
    @Resource
    private UserService userService;

    @RequestMapping(value = "/",method = RequestMethod.GET)
    public String home() {
        log.info("返回首页！");
        return "index";
    }

    @RequestMapping(value = "/test/hello",method = RequestMethod.GET)
    public String testHello() {
        log.info("执行了testHello方法！");
        return "testHello";
    }

    @RequestMapping(value = "/login",method = RequestMethod.POST)
    public String testLogin(HttpServletRequest request,@RequestParam String username, @RequestParam String password) {
        log.info("执行了testLogin方法！");
        User user = userService.findUserByName(username);
        if(user!=null){
            if(user.getPassword().equals(DigestUtils.md5Hex(password))){
                request.getSession().setAttribute("userId", user.getId());
                request.getSession().setAttribute("user", username);
                return "redirect:" + RequestUtil.retrieveSavedRequest();//跳转至访问页面
            }else{
                log.info("密码错误");
                request.getSession().setAttribute("message", "用户名密码错误，请重新登录");
                return "login";
            }
        }else{
            log.info("用户名不存在");
            request.getSession().setAttribute("message", "用户名不存在，请重新登录");
            return "login";
        }
    }
}

关于service和model就不写了，写一下mybatis的mapper类映射

[html] view plain copy

<?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.alibaba.dao.UserMapper">
    <select id="findUserByName" resultType="com.alibaba.model.User">
        select id, username , password from sysuser where username = #{username}
    </select>
</mapper>

源码来源: minglisoft.cn/technology

分享到：