Silentdoer

导航

整合Spring+Struts2+Mybatis加spring单元测试等

前言

自己是在CentOS7的IntelliJ IDEA里开发的,里面中文输入法有问题经常用不了,所以这里用了很多chinglish,希望不要介意;

一:pom依赖

<?xml version="1.0" encoding="UTF-8"?>
<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>me.silentdoer</groupId>
    <artifactId>combine-spring-struts2-mybatis</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <spring.group>org.springframework</spring.group>
        <spring.version>4.3.4.RELEASE</spring.version>

        <logback.group>ch.qos.logback</logback.group>
        <logback.version>1.2.3</logback.version>

        <slf4j.group>org.slf4j</slf4j.group>
        <slf4j.version>1.7.25</slf4j.version>

        <mybatis.group>org.mybatis</mybatis.group>
        <mybatis.version>3.4.4</mybatis.version>
        <mybatis-spring.version>1.3.1</mybatis-spring.version>

        <mysql.group>mysql</mysql.group>
        <mysql-connector.version>5.1.41</mysql-connector.version>

        <alibaba.group>com.alibaba</alibaba.group>
        <druid.version>1.1.6</druid.version>
        <fastjson.version>1.2.41</fastjson.version>

        <dom4j.group>dom4j</dom4j.group>
        <dom4j.version>1.6.1</dom4j.version>

        <junit.group>junit</junit.group>
        <junit.version>4.12</junit.version>
    </properties>

    <dependencies>
        <!-- spring -->
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
            <!-- scope 默认是compile的 -->
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-beans</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-context-support</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-expression</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.10</version>
        </dependency>

        <!-- struts2 -->
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-core</artifactId>
            <version>2.3.20</version>
        </dependency>
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-convention-plugin</artifactId>
            <version>2.3.20</version>
        </dependency>
        <dependency>
            <groupId>org.apache.struts</groupId>
            <artifactId>struts2-spring-plugin</artifactId>
            <version>2.3.20</version>
        </dependency>

        <!-- database begin -->
        <dependency>
            <groupId>${mybatis.group}</groupId>
            <artifactId>mybatis</artifactId>
            <version>${mybatis.version}</version>
        </dependency>
        <dependency>
            <groupId>${mybatis.group}</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>${mybatis-spring.version}</version>
        </dependency>
        <dependency>
            <groupId>${mysql.group}</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql-connector.version}</version>
        </dependency>
        <dependency>
            <groupId>${alibaba.group}</groupId>
            <artifactId>druid</artifactId>
            <version>${druid.version}</version>
        </dependency>
        <!-- database end -->

        <!-- tool begin -->
        <dependency>
            <groupId>${alibaba.group}</groupId>
            <artifactId>fastjson</artifactId>
            <version>${fastjson.version}</version>
        </dependency>
        <dependency>
            <groupId>${dom4j.group}</groupId>
            <artifactId>dom4j</artifactId>
            <version>${dom4j.version}</version>
        </dependency>
        <dependency>
            <groupId>com.thoughtworks.xstream</groupId>
            <artifactId>xstream</artifactId>
            <version>1.4.9</version>
        </dependency>

        <!-- log begin -->
        <dependency>
            <groupId>${slf4j.group}</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>${slf4j.version}</version>
        </dependency>
        <dependency>
            <groupId>${logback.group}</groupId>
            <artifactId>logback-core</artifactId>
            <version>${logback.version}</version>
        </dependency>
        <dependency>
            <groupId>${logback.group}</groupId>
            <artifactId>logback-classic</artifactId>
            <version>${logback.version}</version>
        </dependency>
        <!-- log end -->

        <dependency>
            <groupId>cglib</groupId>
            <artifactId>cglib-nodep</artifactId>
            <version>3.1</version>
        </dependency>

        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.5</version>
        </dependency>

        <!-- 用于测试 begin -->
        <dependency>
            <groupId>${spring.group}</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring.version}</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>${junit.group}</groupId>
            <artifactId>junit</artifactId>
            <!-- version据说还可以是一个范围值 -->
            <version>${junit.version}</version>
            <!-- 表示这个jar包是用于测试,打包时不会将此jar包打包进去 -->
            <scope>test</scope>
        </dependency>
        <!-- 用于测试 end -->

        <!-- 依赖jar包依赖的组件 begin-->
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.2</version>
            <!-- compile 表示编译时和运行时都需要(但IDE可能有bug,不行的话还是自己主动将jar包放到lib目录 -->
            <scope>compile</scope>
        </dependency>

        <!-- mq and cache -->
        <!--<dependency>
            <groupId>redis.clients</groupId>
            <artifactId>jedis</artifactId>
            <version>2.9.0</version>
        </dependency>
        <dependency>
            <groupId>com.rabbitmq</groupId>
            <artifactId>amqp-client</artifactId>
            <version>4.1.0</version>
        </dependency>-->
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

二:配置web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">

    <!--spring-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- other filters -->

    <!--struts2, use with last filter-->
    <filter>
        <filter-name>struts2</filter-name>
        <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
</web-app>

三:配置struts2/mybatis/spring/mapper配置文件

注:均放在resources目录里

1.struts.xml

(struts1和2都可以用这个名字,struts2会自动加载就像logback.xml一样)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
                        "http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>
    <constant name="struts.enable.DynamicMethodInvocation" value="false" />

    <!-- use development mode, when exception occur will show in the response body -->
    <constant name="struts.devMode" value="true" />

    <!-- ke yi bu yao -->
    <!--<constant name="struts.objectFactory" value="spring" />-->
    <constant name="struts.i18n.encoding" value="utf-8" />

    <!-- use to separate diff func action, extends is important for link struts2-spring -->
    <!-- namespace like RequestMapping on controller -->
    <!-- if namespace is /, then http://localhost:8090/getStudent?uid=1, if namespace is /entity, ..8090/entity/getStudent?uid=1 -->
    <package name="entity-resolver" extends="struts-default" namespace="/entity">
        <!-- name is in Struts registry key&context/student, class is the action class or spring beanName -->
        <!-- method attr is for special method to be handlerMethod -->
        <action name="getStudent" class="studentAction">
            <result name="success">/WEB-INF/content/vo/student.jsp</result>
            <result name="error">/WEB-INF/content/common/error.jsp</result>
        </action>
    </package>

    <package name="index" extends="struts-default" namespace="/">
        <!-- Struts2 process url also bu xu yao suffix -->
        <action name="index" class="indexAction">
            <result name="success">/index.html</result>
        </action>
    </package>

    <!--<package name="about-permission" extends="struts-default"></package>-->

</struts>

 

2.mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <typeAliases>
        <typeAlias type="me.silentdoer.ssmdemo.pojo.Student" alias="User"/>
    </typeAliases>

    <!--<environments default="development">
              <environment id="development">
                      <transactionManager type="JDBC"/>
                      <dataSource type="POOLED">
                              <property name="driver" value="com.mysql.jdbc.Driver"/>
                              <property name="url" value="jdbc:mysql://localhost:3306/db_test"/>
                              <property name="username" value="test"/>
                              <property name="password" value="test"/>
                      </dataSource>
              </environment>
      </environments>-->

    <mappers>
        <!-- must absolute path -->
        <mapper resource="config/mybatis/mapper/StudentMapper.xml"/>
    </mappers>
</configuration>

 

3.applicationContext.xml

<?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:aop="http://www.springframework.org/schema/aop"
       xmlns:tx="http://www.springframework.org/schema/tx"
       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://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

    <!--<tx:annotation-driven transaction-manager="txManager" />-->

    <!--配置事务管理器-->
    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- transaction -->
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="select*" read-only="true"/>
            <tx:method name="insert*" propagation="REQUIRED"/>
            <tx:method name="update*" propagation="REQUIRED"/>
            <tx:method name="delete*" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>

    <!-- first * is all visit qualifier -->
    <!-- aop -->
    <aop:config>
        <aop:pointcut id="pointcut" expression="execution(* me.silentdoer.ssmdemo.dao.impl.StudentDaoImpl.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/>
    </aop:config>

    <!-- datasource, can be replace with Druid -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/db_test"/>
        <property name="username" value="test"/>
        <property name="password" value="test"/>
    </bean>

    <!-- 配置sessionFacfory -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 加载dataSource -->
        <property name="dataSource" ref="dataSource"/>
        <!--加载usermapper.xml-->
        <property name="configLocation" value="classpath:mybatis-config.xml"/>
    </bean>

    <context:component-scan base-package="me.silentdoer.ssmdemo">
        <!-- exclude by regex, also can use aspectj ex to exclude -->
        <context:exclude-filter type="regex" expression="me.silentdoer.ssmdemo.pojo..*"/>
    </context:component-scan>

    <!-- userDao, it's extends SqlSessionDapSupport -->
    <!--<bean id="studentDao" class="me.silentdoer.ssmdemo.dao.impl.StudentDaoImpl">
        &lt;!&ndash; in setSqlsessionFactory method: this.sqlSession = new SqlSessionTemplate(sqlSessionFactory) &ndash;&gt;
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>-->

    <!--userService-->
    <!--<bean id="studentService" class="me.silentdoer.ssmdemo.service.impl.StudentServiceImpl">
        <property name="studentDao" ref="studentDao"/>
    </bean>-->

    <!--userAction-->
    <!--<bean id="userAction" class="me.silentdoer.ssmdemo.action.student.StudentAction">
        <property name="studentService" ref="studentService"/>
    </bean>-->
</beans>

4.StudentMapper.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="me.silentdoer.ssmdemo.pojo.StudentMapper">
    <resultMap id="studentResultMap" type="me.silentdoer.ssmdemo.pojo.Student">
        <id property="uid" column="uid"/>
        <result property="name" column="name"/>
        <result property="gender" column="gender"/>
        <result property="createTime" column="create_time"/>
        <result property="updateTime" column="update_time"/>
    </resultMap>

    <!--<insert id="insertOne">
        insert into student(name values (#{name})
    </insert>-->

    <select id="selectOne" resultMap="studentResultMap">
        select uid, name, gender, create_time, update_time from student where uid=#{uid}
    </select>
</mapper>

四:代码实现

1.pojo层的编码

package me.silentdoer.ssmdemo.pojo;

import java.io.Serializable;
import java.sql.Timestamp;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 2:11 PM
 */
public class Student implements Serializable {
    private long uid;
    private String name;
    private int gender;
    private Timestamp createTime;  // Timestamp is implements java.util.Date
    private Timestamp updateTime;

    public long getUid() {
        return uid;
    }

    public void setUid(long uid) {
        this.uid = uid;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getGender() {
        return gender;
    }

    public void setGender(int gender) {
        this.gender = gender;
    }

    public Timestamp getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Timestamp createTime) {
        this.createTime = createTime;
    }

    public Timestamp getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Timestamp updateTime) {
        this.updateTime = updateTime;
    }

    @Override
    public String toString(){
        return String.format("[uid=%s, name=%s, gender=%s, createTime=%s, updateTime=%s]", this.uid, this.name, this.gender, this.createTime, this.updateTime);
    }
}

 

2.dao层的编码

package me.silentdoer.ssmdemo.dao;

import me.silentdoer.ssmdemo.pojo.Student;
import org.apache.ibatis.annotations.Param;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 1:40 PM
 */
public interface StudentDao {
    Student selectOne(@Param("uid") long uid);
}
package me.silentdoer.ssmdemo.dao.impl;

import me.silentdoer.ssmdemo.dao.StudentDao;
import me.silentdoer.ssmdemo.pojo.Student;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Repository;

import javax.annotation.Resource;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 2:31 PM
 */
// this.sqlSessionProxy.selectOne(statement), proxy will use invoke method to call sqlSessionFactory.openSession();
    // this session is sqlSession = new SqlSessionTemplate(sqlSessionFactory); not real SqlSession, in template use proxy to exec
@Repository("studentDao")  // default singleton, but in the inside it's will use SqlSessionFactory to openSession(), so can be singleton.
public class StudentDaoImpl extends SqlSessionDaoSupport implements StudentDao {

    public Student selectOne(long uid) {
        final SqlSession session = this.getSqlSession();
        String statement = "me.silentdoer.ssmdemo.pojo.StudentMapper.selectOne";
        return session.selectOne(statement, uid);
    }

    /*@Autowired  // by type
    @Qualifier("sqlSessionFactory")*/
    @Resource  // by name and default is setter rm set and lower first char
    @Override
    public void setSqlSessionFactory(SqlSessionFactory sqlSessionFactory) {
        super.setSqlSessionFactory(sqlSessionFactory);
    }
}

 

3.service层的编码

package me.silentdoer.ssmdemo.service;

import me.silentdoer.ssmdemo.pojo.Student;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 2:43 PM
 */
public interface StudentService {
    // ERP Logic layer, like login process etc.
    Student getOneUserWithLogic(Long uid);
}
package me.silentdoer.ssmdemo.service.impl;

import me.silentdoer.ssmdemo.dao.StudentDao;
import me.silentdoer.ssmdemo.pojo.Student;
import me.silentdoer.ssmdemo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 2:43 PM
 */
@Service("studentService")  // need trans to studentService, otherwise will be studentServiceImpl will occur can not get bean by name
public class StudentServiceImpl implements StudentService {
    // field name can diff with it's getter&setter; in structure is use getter&setter name.
    private StudentDao studentDao;

    @Autowired
    @Qualifier("studentDao")
    public void setStudentDao(StudentDao studentDao) {
        this.studentDao = studentDao;
    }

    public Student getOneUserWithLogic(Long uid) {
        // some logic impl
        if(uid == null){
            throw new IllegalArgumentException("uid is not null, please check.");
        }
        System.out.println(String.format("uid is:%s", uid));
        Student student = this.studentDao.selectOne(uid);
        return student;
    }
}

 

4.action层的编码(controller)

package me.silentdoer.ssmdemo.action.index;

import com.opensymphony.xwork2.ActionSupport;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 10:53 PM
 */
@Controller
public class IndexAction extends ActionSupport {
}
package me.silentdoer.ssmdemo.action.student;

import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;
import me.silentdoer.ssmdemo.pojo.Student;
import me.silentdoer.ssmdemo.service.StudentService;
import org.apache.struts2.interceptor.RequestAware;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;

import javax.annotation.Resource;
import java.util.Map;

/**
 * @author silentdoer
 * @version 1.0
 * @description the description
 * @date 4/21/18 2:45 PM
 */
@Scope("prototype")  // must be set prototype
@Controller("studentAction")  // Or @Component for component-scan by annotation-filter
public class StudentAction extends ActionSupport /*implements RequestAware*/ {
    private static final long serialVersionUID = 1L;  // ActionSupport implements Serializable
    private Long uid;
    private Student student;
    @Resource
    private StudentService studentService;

    // like SpringMVC InternalResourceViewResolver to search success mapping file
    @Override
    public String execute(){
        // setter for jsp usage, struts2 will purge the map to request attr when after execute().
        Map request = (Map) ActionContext.getContext().get("request");
        // request obj is generate&store by struts2, so request.put is also struts2 to put key-value to request attr.
        request.put("requestAttrKey", "value8888888");
        try {
            Student student = this.studentService.getOneUserWithLogic(this.uid);
            System.out.println(String.format("The student is: %s", student));
            this.student = student;
        }catch (Exception ex){
            // to log exception
            ex.printStackTrace();
            request.put("error", ex.getMessage());
            return ERROR;  // error page
        }
        return SUCCESS;  // normal page
    }

    public void setStudentService(StudentService studentService) {
        this.studentService = studentService;
    }

    public void setUid(Long uid) {
        this.uid = uid;
    }

    // student will put to request attr, key is student
    public Student getStudent() {
        return student;
    }
}

五:数据库和表的建立

数据库名为db_test,表名为student,里面就五个字段,可以参考pojo建立;

六:源码地址

github地址:https://github.com/Silentdoer/demos.git的Combine-Spring-Struts2-Mybatis项目

posted on 2018-04-21 15:06  Silentdoer  阅读(589)  评论(0编辑  收藏  举报