本文详细介绍了如何在项目中整合Struts2、Spring和MyBatis（SSM）三大框架，包括必要的Maven依赖配置、Spring核心配置文件、MyBatis配置文件、Struts配置文件及web.xml配置等内容，并提供了关键代码示例。
1.导入相关的包 pom.xml
struts2、spring、mybatis、mybatis-spring整合的、struts2-spring整合的、mysql、c3p0连接池、spring-jdbc，还有日志包和jstl的包
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-core</artifactId>
<version>2.5.10.1</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.4.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.3.RELEASE</version>
</dependency>
<dependency>
<groupId>org.apache.struts</groupId>
<artifactId>struts2-spring-plugin</artifactId>
<version>2.5.10.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.21</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
</dependencies>
最开始忘记导入struts2-spring的包，结果报空指针错：Action代码中的dao对象是空的，dao对象没有注入成功。加了这个包就正常了。现在仍然觉得很奇怪：缺struts2-spring的包，action生成了dao没生成？
##2.配置applicationContext.xml文件，参考代码注释 <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:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.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 http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!--启动annotation注解，当component-scan开启的时候，这个配置默认就会开启了，可以省略--> context:annotation-config</context:annotation-config> <!--启动包扫描，它会扫描com.doris下的所有子包--> <context:component-scan base-package="com.doris"></context:component-scan> <!--引入外部的配置文件--> <context:property-placeholder location="classpath:db.properties"/> <!--我用的c3p0，所以通过c3p0配置dabaSource。如果你用的其他数据源，更换class即可--> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${driver}"/> <property name="jdbcUrl" value="${url}"/> <property name="user" value="${dbname}"/> <property name="password" value="${password}"/> </bean> <!--配置mybatis的sqlSessionFactory--> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:mybatis-config.xml"/> <!--自动扫描所有的mapper文件--> <property name="mapperLocations" value="classpath:*Mapper.xml"/> </bean> <!--下面的配置是通过MapperFactoryBean生成指定Mapper接口的实例。 但每个Mapper都配很麻烦，就可以用下面的MapperScannerConfigurer扫描所有的Mapper/Dao文件，不需要单独配置了--> <!--<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">--> <!--<property name="mapperInterface" value="com.doris.dao.UserDAO"/>--> <!--<property name="sqlSessionFactory" ref="sqlSessionFactory"/>--> <!--</bean>--> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.doris.dao" /> </bean> <!-- 事务配置 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource" /> </bean> <!-- 使用annotation注解方式配置事务 --> <tx:annotation-driven transaction-manager="transactionManager"/> </beans>
3.配置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>
<!--引入外部配置文件-->
<!--<properties resource="db.properties"></properties>-->
<typeAliases>
<!--<typeAlias type="com.doris.entity.User" alias="User"></typeAlias>-->
<!--启用别名包扫描,路径到包即可-->
<package name="com.doris.entity"></package>
</typeAliases>
<!--环境 被spring的配置代替了
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
mapper也不要再配了，因为spring已经配置了自动扫描所有的mapper文件 mapperLocations classpath:*Mapper.xml
<mappers>
<mapper resource="UserDAOMapper.xml"/>
<mapper resource="NoteDAOMapper.xml"/>
</mappers>-->
</configuration>
上述配置大量内容都被注释了。保留注释只是为了让大家更清楚看到省略了哪些配置。
4.配置ApplicationContext.xml中引入的db.properties文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/notesystem?useUnicode=true&characterEncoding=UTF-8
dbname=root
password=root
这里遇到的一个大坑是我把dbname写成username。结果控制台报错access denied for Administrator@localhost，页面报错Connections could not be acquired from the underlying database! 看来username在配置文件中有特殊含义，被解析成了Administrator。
5.struts.xml的配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.5//EN"
"http://struts.apache.org/dtds/struts-2.5.dtd">
<struts>
<constant name="struts.devMode" value="true"></constant>
<constant name="struts.i18n.encoding" value="UTF-8"></constant>
<package name="user" namespace="/user" extends="struts-default">
<!--struts2.5的新版本默认不支持通配符了，要加上这个配置才行。我踩过的坑呐！-->
<global-allowed-methods>regex:.*</global-allowed-methods>
<action name="*_*" class="com.doris.action.{1}Action" method="{2}">
<result name="list">/list.jsp</result>
<result name="success">/success.jsp</result>
<result name="login">/index.jsp</result>
</action>
</package>
</struts>
6.web.xml文件的配置
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!--指定applicationContext.xml的文件位置。默认去WEB-INF下寻找。
我放在resources目录，在classpath中-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<filter>
<filter-name>struts2</filter-name>
<filter-class>
<!--struts2.5的filter-class不是dispatcher.ng.filter了-->
org.apache.struts2.dispatcher.filter.StrutsPrepareAndExecuteFilter
</filter-class>
</filter>
<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--配置spring监听器-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
至此所有的框架配置文件就结束啦，接下里是代码部分和Mapper的配置
UserAction.java
[@Controller](https://my.oschina.net/u/1774615)
public class UserAction extends ActionSupport implements RequestAware {
private UserDAO userDAO;
private Map<String, Object> request;
public String list() {
List<User> users = userDAO.queryAll();
request.put("users", users);
return "list";
}
public void setRequest(Map<String, Object> request) {
this.request = request;
}
@Resource(name = "userDAO")
public void setUserDAO(UserDAO userDAO) {
this.userDAO = userDAO;
}
}
UserDAO.java
@Repository("userDAO")
@Transactional
public interface UserDAO {
public List<User> queryAll();
public User queryById(int id);
public int save(User user);
public void delete(int id);
public void update(User user);
//模糊查询
public List<User> queryByName(@Param("name")String name);
}
UserDAOMapper.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.doris.dao.UserDAO">
<select id="queryAll" resultType="User">
select * from user
</select>
<select id="queryById" resultType="User" parameterType="int">
select * from user where id = #{id}
</select>
<update id="update">
update user set username=#{username},password=#{password} where id=#{id}
</update>
<delete id="delete" parameterType="int">
DELETE FROM user where id=#{id}
</delete>
<!--userGeneratedKeys 采用主键自增策略
keyProperty java对象中的id属性名
keyColumn sql中的id属性名
当keyProperty == keyColumn时，keyColumn可以省略-->
<insert id="save" useGeneratedKeys="true" parameterType="User" keyProperty="id" keyColumn="id">
INSERT into user(username,password) values( #{username},#{password})
</insert>
<select id="queryByName" resultType="User" >
select * from user where username like '%${username}%'
</select>
</mapper>
User.java
public class User {
private int id;
private String username;
private String password;
public User() {
}
public User(int id, String name, String password) {
this.id = id;
this.username = name;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
index.jsp
<html>
<body>
<a href="user/User_list">查询所有学员</a>
</body>
</html>
list.jsp
<%@ page contentType="text/html;charset=UTF-8" isELIgnored="false" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<c:forEach items="${requestScope.users}" var="user">
${user.username}====${user.password}<br>
</c:forEach>
</body>
</html>
扫一扫
1368
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
