需求:在Spring,SpringMVC的基础上整合Mybatis
IDE工具:Eclipse
搭建环境:jdk1.8 tomcat8.5
目前的项目结构如下:
说明:在集成mybatis的时候,将项目的名称换成了SSMTest3。
开整。
1. 添加mybatis依赖,mysql连接依赖,druid连接池依赖,mybatis/spring整合依赖等,完整的pom.xml如下:
<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.yzptest</groupId>
<artifactId>SSMTest3</artifactId>
<packaging>war</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>SSMTest Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<!-- Spring依赖 -->
<!-- Spring核心依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- Spring dao依赖 -->
<!-- spring-jdbc包括了一些如jdbcTemplate的工具类 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- Spring web依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- Spring test依赖:方便做单元测试和集成测试 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- 添加lombok依赖 -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.4</version>
<scope>provided</scope>
</dependency>
<!-- 添加aspectjrt依赖 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>1.9.2</version>
</dependency>
<!-- 添加servlet依赖 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<!-- 添加jstl依赖 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- 添加druid连接池依赖 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.12</version>
</dependency>
<!-- 添加mysql依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
<!-- 添加mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.2</version>
</dependency>
<!-- mybatis/spring依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
</dependencies>
<build>
<finalName>SSMTest3</finalName>
</build>
</project>
2. 添加完依赖后,编写applicationContext.xml文件,指定jdbc.properties的文件路径,配置数据源,事务管理器等,全部内容如下:
<?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:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">
<!-- 配置自动扫描的(Spring IOC 容器不扫描Controller) -->
<context:component-scan base-package="com.yzpt">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Component" />
<context:include-filter type="annotation" expression="org.springframework.stereotype.Repository" />
<context:include-filter type="annotation" expression="org.springframework.stereotype.Service" />
</context:component-scan>
<!-- 测试类 -->
<bean id="book" class="com.yzpt.entity.Book">
<property name="bookId" value="10086"></property>
<property name="bookName" value="中国移动"></property>
<property name="writer" value="test"></property>
<property name="publishingHouse" value="HaoYiTec"></property>
</bean>
<!-- 加载配数据源配置文件 jdbc.properties -->
<context:property-placeholder location="classpath:jdbc.properties" />
<!-- 配置 Druid 数据源 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="url" value="${jdbc.jdbcUrl}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="driverClassName" value="${jdbc.driverClass}"/>
</bean>
<!-- 事务管理器 (JDBC) -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 启动声明式事务驱动 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- MyBatis 整合 spring -->
<!-- spring 通过 sqlSessionFactoryBean 获取 sqlSessionFactory 工厂类 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mappers.xml文件 -->
<property name="mapperLocations" value="classpath:mapper/*.xml"></property>
<!-- mybatis配置文件 -->
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
</bean>
<!-- 打开 sqlSession 会话对象(扫描映射配置文件:XXXmapper.xml/XXXmapper.java) -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.yzpt.mapper" />
<!-- 注意使用 sqlSessionFactoryBeanName 避免出现spring 扫描组件失效问题 -->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>
</beans>
3. 编写jdbc.properties文件
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&useSSL=false
jdbc.username=root
jdbc.password=123456
4. 编写mybatis-config.xml文件(目前关于mybaits的配置已经在applicationContext.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>
</configuration>
5. 补充一下springMVC.xml和web.xml的全部内容
5.1 springMVC.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"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
<!-- 配置自动扫描的包,SpringMVC IOC 容器只扫描Controller -->
<context:component-scan base-package="com.yzpt">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller" />
</context:component-scan>
<!-- 配置视图解析器 -->
<bean id="internalResourceViewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!-- 处理静态资源,默认 Servlet 处理 -->
<mvc:default-servlet-handler />
<!-- 启动 MVC 注解驱动 -->
<mvc:annotation-driven />
<!--启用AOP -->
<aop:aspectj-autoproxy></aop:aspectj-autoproxy>
</beans>
5.2 web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1">
<display-name>SSMTest2</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<!-- 指定Spring配置文件,配置context监听 -->
<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>
<!-- 配置SpringMVC -->
<servlet>
<servlet-name>springMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMVC.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springMVC</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 配置编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>
6. 编写测试
6.1 建表,SQL如下:
CREATE TABLE T_SSM_USER (
ID INT(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
USERNAME VARCHAR(20) DEFAULT NULL COMMENT '姓名',
AGE VARCHAR(20) DEFAULT NULL COMMENT '年龄',
SEX VARCHAR(20) DEFAULT NULL COMMENT '性别',
PRIMARY KEY (ID)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=UTF8;
6.2 插入几条数据,SQL如下:
INSERT INTO T_SSM_USER (USERNAME,AGE,SEX) VALUES('张三','13','男');
INSERT INTO T_SSM_USER (USERNAME,AGE,SEX) VALUES('王丽','15','女');
INSERT INTO T_SSM_USER (USERNAME,AGE,SEX) VALUES('赵媛','16','女');
6.3 创建User类,内容如下:
package com.yzpt.entity;
import lombok.Getter;
import lombok.Setter;
@Setter
@Getter
public class User {
private String username; //用户姓名
private String age; //年龄
private String sex; //性别
}
6.4 mapper层创建UserMapper接口,内容如下:
package com.yzpt.mapper;
import com.yzpt.entity.User;
public interface UserMapper {
User getUserInfor(int id);
}
6.5 web层BookController类中添加如下:
package com.yzpt.web;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.yzpt.entity.Book;
import com.yzpt.entity.User;
import com.yzpt.mapper.UserMapper;
@Controller
@RequestMapping
public class BookController {
private UserMapper userMapper;
@Autowired
public BookController(UserMapper userMapper) {
this.userMapper = userMapper;
}
@RequestMapping(value ="/test" , produces = "application/json;charset=utf-8")
@ResponseBody
public String getResult() {
return "Hello,EveryOne,I'm ZhaZhaHui!\n大家好,我是渣渣辉!";
}
@RequestMapping(value ="/Test")
public String getTestInfo(HttpServletRequest request) {
Book book = new Book();
book.setBookId("10086");
book.setWriter("YZP");
book.setBookName("论客户的重要性");
book.setPublishingHouse("HaoYiTec");
request.setAttribute("book",book);
return "test";
}
@RequestMapping(value ="/ssm")
public String getUserInfo(HttpServletRequest request) {
String strid = request.getParameter("id");
User user;
try {
user = userMapper.getUserInfor(Integer.valueOf(strid));
request.setAttribute("user", user);
}catch (Exception e) {
System.out.println("获取User信息失败 :" + e );
}
return "user";
}
}
6.6 在mapper文件夹下创建UserMapper.xml,写入SQL:
如图:
UserMapper.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.yzpt.mapper.UserMapper">
<!-- 根据id查询User -->
<select id="getUserInfor" parameterType="java.lang.Integer" resultType="com.yzpt.entity.User">
SELECT T.USERNAME ,T.AGE ,T.SEX FROM T_SSM_USER T WHERE ID = #{ID}
</select>
</mapper>
6.7 启动项目,成功,如下图:
6.8 测试
输入测试的URL: http://localhost:8080/SSMTest3/ssm?id=1,结果如图:
将id改为2,结果如图:
6.9 测试成功
7. SSM整合过程中可能会出现各种问题,需要耐心的去查找解决问题,希望大家多多交流。