Spring+Struts2+Mybatis整合

1. 创建项目

2. 添加Spring能力

使用MyEclipse自动加载Struts2和Spring的jar包和配置文件，并在web.xml文件中添加上下文和监听器

web.xml文件如下：

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

<web-app version="2.5"

	xmlns="http://java.sun.com/xml/ns/javaee"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee

	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

  <!-- 上下文 -->

  <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>

  <welcome-file-list>

    <welcome-file>index.jsp</welcome-file>

  </welcome-file-list>

  <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>

3. 添加mybatis.jar、mybatis-spring-1.2.0.jar和mysql-connector-java-5.1.26-bin.jar

4. 编写mybatis和spring配置文件

创建mybatis的配置和实体类的映射文件

在spring配置文件中添加数据源和sqlSessionFactory，spring可以管理实体bean的映射文件，自动创建别名，这样子就可以省略mybatis.xml配置文件

实体java代码：

package com.it.entity;

import java.sql.Date;

public class Stu {

	private int sid;

	private String sname;

	private String ssex;

	private Date sbirth;

	public Stu() {

		super();

		// TODO Auto-generated constructor stub

	}

	public Stu(int sid, String sname, String ssex, Date sbirth) {

		super();

		this.sid = sid;

		this.sname = sname;

		this.ssex = ssex;

		this.sbirth = sbirth;

	}

	public int getSid() {

		return sid;

	}

	public void setSid(int sid) {

		this.sid = sid;

	}

	public String getSname() {

		return sname;

	}

	public void setSname(String sname) {

		this.sname = sname;

	}

	public String getSsex() {

		return ssex;

	}

	public void setSsex(String ssex) {

		this.ssex = ssex;

	}

	public Date getSbirth() {

		return sbirth;

	}

	public void setSbirth(Date sbirth) {

		this.sbirth = sbirth;

	}

}

实体映射文件Stu.xml:

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

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >

<mapper namespace="stu">

	<select id="findAll" resultType="Stu">

		<!-- CDATA节 -->

		<![CDATA[select * from stu]]>

	</select>

</mapper>

application.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:p="http://www.springframework.org/schema/p"

	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">

	<!-- 数据源 -->

	<bean id="ds" class="org.apache.commons.dbcp.BasicDataSource">

		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>

		<property name="url" value="jdbc:mysql://localhost:3306/mydb"/>

		<property name="username" value="root"/>

		<property name="password" value="ok"/>

	</bean>

	<!-- session工厂 -->

	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

		<property name="dataSource" ref="ds"/>

		<!-- spring管理实体bean的映射文件 -->

		<property name="mapperLocations">

			<list>

				<value>classpath:com/it/entity/Stu.xml</value>

			</list>

		</property>

		<!-- 自动创建别名 -->

		<property name="typeAliasesPackage" value="com.it.entity"/>

	</bean>

	<!-- Dao -->

	<bean id="stuDao" class="com.it.dao.impl.StuDaoImpl">

		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>

	</bean>

	<!-- Biz -->

	<bean id="stuBiz" class="com.it.biz.impl.StuBizImpl">

		<property name="stuDao" ref="stuDao"/>

	</bean>

	<!-- Action -->

	<bean id="stuAction" class="com.it.action.StuAction">

		<property name="stuBiz" ref="stuBiz"/>

	</bean>

</beans>

5. 编写代码

DaoImple继承SqlSessionDaoSupport,自动获取sqlSession，不需要人为的去创建和关闭

代码依次为entity、Dao、DaoImpl、Biz、BizImpl、Action和Test，最后创建jsp文件和配置struts.xml

DaoImpl.java文件如下：

package com.it.dao.impl;

import java.util.List;

import org.mybatis.spring.support.SqlSessionDaoSupport;

import com.it.dao.StuDao;

import com.it.entity.Stu;

public class StuDaoImpl extends SqlSessionDaoSupport implements StuDao {

	public List<Stu> findAll() {

		return this.getSqlSession().selectList("stu.findAll");

	}

}

struts.xml文件如下：

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

<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">

<struts>

	<package name="xx" namespace="/" extends="struts-default">

		<action name="doList" class="stuAction" method="doList">

			<result>list.jsp</result>

		</action>

	</package>

</struts>

巴特西

Spring+Struts2+Mybatis整合

最新文章

热门文章