spring + struts2 + mybatis整合

我接触最多的java持久层的框架应该是hibernate了，但是看一些企业招聘好多都要求会mybatis，所以学习了并整合了一下。

对于hibernate和mybatis的优缺点下片文章再细讲，我们先来整合。

首先整合spring+struts2，引入他们的jar包，这里直接给出我引入所有包的图：

 

首先在web.xml文件中配置spring的监听器：

<listener>
	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

classpath下添加spring的配置文件spring.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:context="http://www.springframework.org/schema/context" xsi:schemaLocation="
http://www.springframework.org/schema/beans 
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd 
http://www.springframework.org/schema/context 
http://www.springframework.org/schema/context/spring-context-3.0.xsd
">

	<!-- 自动扫描dao和service包(自动注入) -->
	<context:component-scan base-package="com.dxy.service" />

</beans>

在web.xml文件中添加：

<context-param>
	<param-name>contextConfigLocation</param-name>
	<param-value>classpath:spring.xml,classpath:springmybatis.xml</param-value>
</context-param>

用来指定spring的配置文件。

注意：让spring来管理你的action，我们得添加struts2-spring-plugin.jar。

然后在classpath下添加struts.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>

	<!-- 指定由spring负责action对象的创建 -->
	<constant name="struts.objectFactory" value="spring" />
	<!-- 所有匹配*.action的请求都由struts2处理 -->
	<constant name="struts.action.extension" value="action" />
	<!-- 是否启用开发模式 -->
	<constant name="struts.devMode" value="true" />
	<!-- struts配置文件改动后，是否重新加载 -->
	<constant name="struts.configuration.xml.reload" value="true" />
	<!-- 设置浏览器是否缓存静态内容 -->
	<constant name="struts.serve.static.browserCache" value="false" />
	<!-- 请求参数的编码方式 -->
	<constant name="struts.i18n.encoding" value="utf-8" />
	<!-- 每次HTTP请求系统都重新加载资源文件，有助于开发 -->
	<constant name="struts.i18n.reload" value="true" />
	<!-- 文件上传最大值 -->
	<constant name="struts.multipart.maxSize" value="104857600" />
	<!-- 让struts2支持动态方法调用 -->
	<constant name="struts.enable.DynamicMethodInvocation" value="true" />
	<!-- Action名称中是否还是用斜线 -->
	<constant name="struts.enable.SlashesInActionNames" value="false" />
	<!-- 允许标签中使用表达式语法 -->
	<constant name="struts.tag.altSyntax" value="true" />
	<!-- 对于WebLogic,Orion,OC4J此属性应该设置成true -->
	<constant name="struts.dispatcher.parametersWorkaround" value="false" />
	
	<!--用于WEB-INF下的页面的跳转 -->
	<package name="skip" namespace="/skip" extends="struts-default">
	</package>
</struts>

注意：让spring帮我们来管理action，struts.xml文件中得加入

<!-- 指定由spring负责action对象的创建 -->
<constant name="struts.objectFactory" value="spring" />

上文中已加入。

接着整合mybatis，在classpath下添加springmybatis.xml文件：

springmybatis.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: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-3.0.xsd
     http://www.springframework.org/schema/context
     http://www.springframework.org/schema/context/spring-context-3.0.xsd
     http://www.springframework.org/schema/mvc
     http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">
 
    <context:property-placeholder location="classpath:jdbc.properties" />
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <property name="driverClassName" value="${jdbc.driver}" />
       <property name="url" value="${jdbc.url}" />
       <property name="username" value="${jdbc.username}" />
       <property name="password" value="${jdbc.password}" />
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       <property name="dataSource" ref="dataSource" />
       <property name="mapperLocations" value="classpath:com/dxy/mapper/*.xml" />
       <property name="typeAliasesPackage" value="com.dxy.model" />
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
       <property name="basePackage" value="com.dxy.mapper" />
    </bean>
</beans>

感觉和spring整合hibernate差别不大。

 

创建自己的类：

Blog.java

package com.dxy.model;

public class Blog {
	
	private int id;
	
	private String title;
	
	private String content;
	
	private String owner;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getTitle() {
		return title;
	}

	public void setTitle(String title) {
		this.title = title;
	}

	public String getContent() {
		return content;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public String getOwner() {
		return owner;
	}

	public void setOwner(String owner) {
		this.owner = owner;
	}
	
}

BlogService.java

package com.dxy.service;

import java.util.List;

import com.dxy.model.Blog;

public interface BlogService {
	
	public Blog selectBlog(int id);
	   
    public void insertBlog(Blog blog);
   
    public void updateBlog(Blog blog);
   
    public void deleteBlog(int id);
   
    public List<Blog> selectAll();
}

创建BlogMapper.java:

package com.dxy.mapper;
import java.util.List;

import com.dxy.model.Blog;

 
public interface BlogMapper {
 
    public Blog selectBlog(int id);
   
    public void insertBlog(Blog blog);
   
    public void updateBlog(Blog blog);
   
    public void deleteBlog(int id);
   
    public List<Blog> selectAll();
   
}

创建BlogMapper.java的配置文件BlogMapper.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.dxy.mapper.BlogMapper">

<resultMap type="com.dxy.model.Blog" id="blogMapper">
	<result property="id" column="id"/>
	<result property="title" column="title"/>
	<result property="content" column="content"/>
	<result property="owner" column="owner"/>
</resultMap>

<!--  新增记录  -->
    <insert id="insertBlog" parameterType="Blog" useGeneratedKeys="true" keyProperty="id">
        insert into t_blog(title,content,owner) values(#{title},#{content},#{owner})
    </insert>
<!--  查询单条记录  -->
    <select id="selectBlog" parameterType="int" resultMap="blogMapper">
       select * from t_blog where id = #{id}
    </select>
<!--  修改记录  -->
    <update id="updateBlog" parameterType="Blog">
        update t_blog set title = #{title},content = #{content},owner = #{owner} where id = #{id}
    </update>
<!--  查询所有记录  -->
    <select id="selectAll" resultMap="blogMapper">
        select * from t_blog
    </select>
<!--  删除记录  -->
    <delete id="deleteBlog" parameterType="int">
       delete from t_blog where id = #{id}
    </delete>
   
</mapper>

创建service的实现类BlogServiceImpl.java：

package com.dxy.service.impl;

import java.util.List;

import javax.annotation.Resource;

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

import com.dxy.mapper.BlogMapper;
import com.dxy.model.Blog;
import com.dxy.service.BlogService;
@Service("blogService")
public class BlogServiceImpl implements BlogService {
	
	private BlogMapper blogMapper;

	@Override
	public Blog selectBlog(int id) {
		return blogMapper.selectBlog(id);
	}

	@Override
	public void insertBlog(Blog blog) {
		blogMapper.insertBlog(blog);
		
	}

	@Override
	public void updateBlog(Blog blog) {
		blogMapper.updateBlog(blog);
	}

	@Override
	public void deleteBlog(int id) {
		blogMapper.deleteBlog(id);
	}

	@Override
	public List<Blog> selectAll() {
		return blogMapper.selectAll();
	}

	public BlogMapper getBlogMapper() {
		return blogMapper;
	}
	@Resource
	public void setBlogMapper(BlogMapper blogMapper) {
		this.blogMapper = blogMapper;
	}


}

在添加BlogMapper.xml时，在查询时有查询结果，在BlogMapper.xml文件中得定义resultMap：

<resultMap type="com.dxy.model.Blog" id="blogMapper">
	<result property="id" column="id"/>
	<result property="title" column="title"/>
	<result property="content" column="content"/>
	<result property="owner" column="owner"/>
</resultMap>

接下来添加action类BlogAction.java：

package com.dxy.action;

import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.Result;
import org.apache.struts2.convention.annotation.Results;
import org.springframework.beans.factory.annotation.Autowired;

import com.dxy.model.Blog;
import com.dxy.service.BlogService;

@Namespace("/")
@Results({
	@Result(name="addBlog",location="/index.jsp")
})
@Action("blogAction")
public class BlogAction {
	
	private BlogService blogService;
	
	public String addBlog() {
		Blog blog = new Blog();
		blog.setTitle("test");
		blog.setContent("test1");
		blog.setOwner("test3");
		blogService.insertBlog(blog);
		System.out.println("test");
		Blog blog2 = blogService.selectBlog(1);
		System.out.println(blogService.selectBlog(1));
		System.out.println(blog2.getContent());
		return "addBlog";
	}

	public BlogService getBlogService() {
		return blogService;
	}
	@Autowired
	public void setBlogService(BlogService blogService) {
		this.blogService = blogService;
	}
}

部署到tomcat上，浏览器运行http://localhost:8080/springmybatis/blogAction!addBlog.action

检查数据库和后台输出。数据库有数据后台打印test，整合完成。

经检验，上述程序正常运行。