1.基本介绍
Spring
Spring是一个开源框架,Spring是于2003 年兴起的一个轻量级的Java 开发框架,由Rod Johnson 在其著作Expert One-On-One J2EE Development and Design中阐述的部分理念和原型衍生而来。它是为了解决企业应用开发的复杂性而创建的。Spring使用基本的JavaBean来完成以前只可能由EJB完成的事情。然而,Spring的用途不仅限于服务器端的开发。从简单性、可测试性和松耦合的角度而言,任何Java应用都可以从Spring中受益。 简单来说,Spring是一个轻量级的控制反转(IoC)和面向切面(AOP)的容器框架。
SpringMVC
Spring MVC属于SpringFrameWork的后续产品,已经融合在Spring Web Flow里面。Spring MVC 分离了控制器、模型对象、分派器以及处理程序对象的角色,这种分离让它们更容易进行定制。
MyBatis
MyBatis 本是apache的一个开源项目iBatis, 2010年这个项目由apache software foundation 迁移到了google code,并且改名为MyBatis 。MyBatis是一个基于Java的持久层框架。iBATIS提供的持久层框架包括SQL Maps和Data Access Objects(DAO)MyBatis 消除了几乎所有的JDBC代码和参数的手工设置以及结果集的检索。MyBatis 使用简单的 XML或注解用于配置和原始映射,将接口和 Java 的POJOs(Plain Old Java Objects,普通的 Java对象)映射成数据库中的记录。
2.整合思路
①表现层,也就是 Controller,由 SpringMVC 来控制,而SpringMVC 是Spring 的一个模块,故不需要整合。
②业务层,也就是 service,通常由 Spring 来管理 service 接口,我们会使用 xml 配置的方式来将 service 接口配置到 spring 配置文件中。而且事务控制一般也是在 service 层进行配置。
③持久层,也就是 dao 层,而且包括实体类,由 MyBatis 来管理,通过 spring 来管理 mapper 接口,使用mapper的扫描器自动扫描mapper接口在spring中进行注册。
很明显,spring 在三大框架的整合中占据至关重要的地位,类似于一个大管家,将 MyBatis 和 SpringMVC 揉合在一起。
3.整合步骤
3.1.准备测试数据
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50521
Source Host : localhost:3306
Source Database : ssm
Target Server Type : MYSQL
Target Server Version : 50521
File Encoding : 65001
Date: 2020-08-04 13:53:35
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userLoginName` varchar(10) DEFAULT NULL,
`userPhone` varchar(255) DEFAULT NULL,
`userAge` int(6) DEFAULT NULL,
`userPwd` varchar(10) DEFAULT NULL,
`userName` varchar(15) DEFAULT NULL,
`state` int(11) DEFAULT NULL COMMENT 'state 1启用 0冻结',
`createTime` date DEFAULT NULL,
`delState` int(11) DEFAULT NULL COMMENT 'delState 删除状态1 删除 0未删除',
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'luoxian', null, null, '123456', '杨晓林', '1', '2018-07-09', '0');
INSERT INTO `t_user` VALUES ('2', '小王', null, null, '123456', '王二小', '1', '2018-07-14', '0');
INSERT INTO `t_user` VALUES ('3', 'qazwsx', null, null, 'qazwsx', '吕杰', '0', '2018-09-05', '1');
INSERT INTO `t_user` VALUES ('4', 'luoxianxin', null, null, '123456', '吕杰', '1', '2018-09-06', '1');
INSERT INTO `t_user` VALUES ('8', 'zhangsan', null, null, '324234', '张三', '1', '2018-09-04', '1');
INSERT INTO `t_user` VALUES ('9', 'lisi', null, null, '1234567', '小张', '0', '2018-09-26', '0');
INSERT INTO `t_user` VALUES ('10', 'lisi1', null, null, '12345671', '小张1', '1', '2018-09-26', '1');
INSERT INTO `t_user` VALUES ('11', 'lisi2', null, null, '12345672', '小张2', '1', '2018-09-26', '1');
INSERT INTO `t_user` VALUES ('12', 'lisi3', null, null, '12345673', '小张3', '1', '2018-09-26', '0');
INSERT INTO `t_user` VALUES ('13', 'lisi4', null, null, '12345674', '小张4', '1', '2018-09-26', '1');
INSERT INTO `t_user` VALUES ('14', 'lisi5', null, null, '12345675', '小张5', '0', '2018-09-26', '1');
INSERT INTO `t_user` VALUES ('15', 'lisi6', null, null, '12345676', '小张6', '1', '2018-09-26', '0');
INSERT INTO `t_user` VALUES ('16', 'lisi7', null, null, '12345677', '小张7', '1', '2018-09-26', '0');
INSERT INTO `t_user` VALUES ('17', 'lisi8', null, null, '12345678', '小张8', '0', '2018-09-26', '0');
3.2.导入依赖
<dependencies>
<!--导入Spring框架和MyBatis框架的所有依赖-->
<!-- Junit测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--导入Spring的依赖-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.3.2</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.14</version>
</dependency>
<!--Lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.18</version>
<scope>provided</scope>
</dependency>
<!-- myBatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!-- mysql驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
<!--Spring和MyBatis整合包专用包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!--数据库连接池依赖-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
</dependencies>
3.3.新建jdbc.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/sm?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
3.4. 新建日志文件log4j.properties
# log4J日志框架的配置文件 文件名字不能改
# DEBUG 表示日志的级别 调试
# Console 日志打印在控制台
log4j.rootLogger=DEBUG, Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
# 哪些日志需要打印
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
3.5. 新建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: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/context http://www.springframework.org/schema/context/spring-context.xsd">
<!--Spring整合MyBatis-->
<!--1.扫描包-->
<context:component-scan base-package="com.sm.*"/>
<!--2.加载数据库配置文件-->
<context:property-placeholder location="classpath:jdbc.properties" file-encoding="UTF-8"/>
<!--3.配置数据源 如何连接数据库-->
<bean id="ds" class="com.alibaba.druid.pool.DruidDataSource">
<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>
<!--4.Spring框架帮MyBatis生成sqlSession MyBatis中的sqlSession交给来了Spring管理-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean">
<!--配置数据源-->
<property name="dataSource" ref="ds"/>
<!--指定MyBatis的Mapper文件位置-->
<property name="mapperLocations" value="classpath*:mappers/*.xml"/>
<!--指定MyBatis实体类的别名-->
<property name="typeAliasesPackage" value="com.sm.bean"/>
</bean>
<!--5.spring框架给Mapper层生成对象-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--Spring 框架会自动通过动态代理模式(反射) 生成对象-->
<property name="basePackage" value="com.sm.mapper"/>
</bean>
</beans>
3.6.新建实体类
package com.sm.bean;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
/**
* @BelongsProject: MyBatis-Spring
* @BelongsPackage: com.sm.bean
* @CreateTime: 2020-10-10 16:37
* @Description: TODO
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private Integer userId;
private String userLoginName;
private String userPhone;
private Integer userAge;
private String userPwd;
private String userName;
private Integer state;
private String createTime;
private Integer delState;
public User(String userLoginName, String userPhone, Integer userAge, String userPwd, String userName) {
this.userLoginName = userLoginName;
this.userPhone = userPhone;
this.userAge = userAge;
this.userPwd = userPwd;
this.userName = userName;
}
}
3.7.新建Mapper层
package com.sm.mapper;
import com.sm.bean.User;
import java.util.List;
/**
* @BelongsProject: MyBatis-Spring
* @BelongsPackage: com.sm.mapper
* @CreateTime: 2020-10-10 16:39
* @Description: TODO
*/
public interface UserMapper {
List<User> findUsers();
int addUser(User user);
}
3.9.新建Mapper.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.sm.mapper.UserMapper">
<select id="findUsers" resultType="User">
select * from t_user where delState=0
</select>
<insert id="addUser">
insert into t_user
values (null,#{userLoginName},#{userPhone},#{userAge},#{userPwd},#{userName},1,now(),0)
</insert>
</mapper>
3.10.新测试类启动测试
package com.sm.test;
import com.sm.bean.User;
import com.sm.service.UserService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import java.util.List;
/**
* @BelongsProject: MyBatis-Spring
* @BelongsPackage: com.sm.test
* @CreateTime: 2020-10-10 17:07
* @Description: TODO
*/
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class TestSpring {
@Autowired
UserService us;
@Test
public void testFindUsers(){
List<User> users = us.findUsers();
for (User user : users) {
System.out.println(user);
}
}
@Test
public void testAddUser(){
//(String userLoginName, String userPhone, Integer userAge, String userPwd, String userName)
User user=new User("admin","1338989090",18,"admin123","小白");
int count = us.addUser(user);
System.out.println(count>0?"新增成功":"新增失败");
}
}