1735 字
9 分钟
SSM09-SSM整合
2023-06-26
2023-11-28

详细的描述了Spring中的SSM整合

SSM整合流程#

1.创建工程#

2.SSM整合#

  • Spring
    • SpringConfig
  • MyBatis
    • MybatisConfig
    • JdbcConfig
    • Jdbc.properties
  • SpringMVC
    • ServletConfig
    • SpringMVCConfig

3.功能模块#

  • 表与实体类
  • dao(接口+自动代理)
  • service(接口+实现类)
  • 业务层接口测试(整合JUnit)
  • mapper

设计一个简单的图书管理系统#

总体思路分析#

Spring整合MyBatis#

  • 配置
    • SpringConfig
    • JDBCConfig、jdbc.properties
    • MyBatisconfig
  • 模型
    • Book
  • 数据层标准开发
    • BookDao
  • 业务层标准开发
    • BookService
    • BookServiceImpl
  • 测试接口 BookServiceTest
  • 事务处理
    • 在SpringConfig中开启注解式事务驱动@EnableTransactionManagement
    • 在JdbcConfig中添加事务管理器PlatformTransactionManager
    • 在业务层接口上添加Spring事务管理

Spring整合SpringMVC#

  • Web配置类(详见SSM07样例代码4)
  • SpringMVC配置类 SpringMVCConfig
  • 基于Restful的Controller开发

样例代码以及测试如下#

程序框架#

SSM 图书管理系统的请求、业务、持久层与容器配置

原理示意:图书请求先由 DispatcherServlet 分派给 BookController,再委托 BookService 与 MyBatis 创建的 BookDao 代理访问数据库。结果按调用链返回,由 MVC 转为 JSON 响应。ServletConfig 分别加载根容器与 MVC 子容器配置,前者管理业务、数据源和持久层,后者管理控制器;这解释了程序如何协作,而不是把目录结构当作实际请求路径。

MySQL数据库的设计(简单设计,样例较为简单,用于测试)#

create database ssm_db default charset utf8mb4;
use ssm_db;
create table tbl_book (
id int not null auto_increment comment 'id',
type varchar(20) not null comment '种类',
name varchar(50) not null comment '书名',
description varchar(255) not null comment '简介',
primary key (id)
) COMMENT='商品表';
begin;
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第一版', 'Spring经典教程1');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第二版', 'Spring经典教程2');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第三版', 'Spring经典教程3');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第四版', 'Spring经典教程4');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第五版', 'Spring经典教程5');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第六版', 'Spring经典教程6');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第七版', 'Spring经典教程7');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第八版', 'Spring经典教程8');
insert into tbl_book(type, name, description) values ('计算机理论', 'Spring实战第九版', 'Spring经典教程9');
insert into tbl_book(type, name, description) values ('市场营销', '市场营销第一版', '市场营销教程1');
insert into tbl_book(type, name, description) values ('市场营销', '市场营销第二版', '市场营销教程2');
insert into tbl_book(type, name, description) values ('市场营销', '市场营销第三版', '市场营销教程3');
commit;

详细的代码放到了github,网址如下,需要自取:

小型的SSM图书管理系统

简单的使用postman对其中的增删改查功能进行了测试

按 BookController 的路由,可在 Postman 依次验证:GET /books 查询列表,GET /books/{id} 查询指定图书,POST /books 新增,PUT /books 修改,DELETE /books/{id} 删除。新增和修改请求使用 JSON 请求体,字段对应 Book 的 type、name、description,修改时还需携带 id,并设置 Content-Type 为 application/json。不要只看布尔返回值:本例写操作直接返回 true,验证增删改是否真正生效还应重新查询相应记录;路径中的 id 应使用当前数据中的真实主键。

具体代码如下(较为冗长,用于本人复习和调试)#

Config模块#

JdbcConfig#

package com.wang.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;
import javax.sql.DataSource;
public class JdbcConfig {
@Value("${jdbc.driver}")
private String driver;
@Value("${jdbc.url}")
private String url;
@Value("${jdbc.username}")
private String username;
@Value("${jdbc.password}")
private String password;
@Bean
public DataSource dataSource(){
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName(driver);
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
return dataSource;
}
@Bean
// 2.事务管理器
public PlatformTransactionManager transactionManager(DataSource dataSource){
DataSourceTransactionManager ds = new DataSourceTransactionManager();
ds.setDataSource(dataSource);
return ds;
}
}

MybatisConfig#

package com.wang.config;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class MybatisConfig {
@Bean
public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSource);
factoryBean.setTypeAliasesPackage("com.wang.domain");
return factoryBean;
}
@Bean
public MapperScannerConfigurer mapperScannerConfigurer() {
MapperScannerConfigurer msc = new MapperScannerConfigurer();
msc.setBasePackage("com.wang.dao");
return msc;
}
}

ServletConfig#

package com.wang.config;
import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;
public class ServletConfig extends AbstractAnnotationConfigDispatcherServletInitializer {
protected Class<?>[] getRootConfigClasses() {
return new Class[]{SpringConfig.class};
}
protected Class<?>[] getServletConfigClasses() {
return new Class[]{SpringMvcConfig.class};
}
protected String[] getServletMappings() {
return new String[]{"/"};
}
}

SpringConfig#

package com.wang.config;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;
import org.springframework.transaction.annotation.EnableTransactionManagement;
@Configuration
@ComponentScan("com.wang.service")
@PropertySource("classpath:jdbc.properties")
@Import({JdbcConfig.class, MybatisConfig.class})
// 1.开启注解式事务驱动
@EnableTransactionManagement
public class SpringConfig {
}

SpringMVCConfig#

package com.wang.config;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
@Configuration
@ComponentScan("com.wang.controller")
@EnableWebMvc
public class SpringMvcConfig {
}

Controller(表现层)#

BookController#

package com.wang.controller;
import com.wang.domain.Book;
import com.wang.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
@RestController
@RequestMapping("/books")
public class BookController {
@Autowired
private BookService bookService;
@PostMapping
public boolean save(@RequestBody Book book) {
return bookService.save(book);
}
@PutMapping
public boolean update(@RequestBody Book book) {
return bookService.update(book);
}
@DeleteMapping("/{id}")
public boolean delete(@PathVariable Integer id) {
return bookService.delete(id);
}
@GetMapping("/{id}")
public Book getById(@PathVariable Integer id) {
return bookService.getById(id);
}
@GetMapping
public List<Book> getAll() {
return bookService.getAll( );
}
}

dao(持久层/持久层)#

BookDao#

package com.wang.dao;
import com.wang.domain.Book;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface BookDao {
@Insert("insert into ssm_db.tbl_book(type, name, description) values (#{type}, #{name}, #{description})")
public void save(Book book);
@Update("update ssm_db.tbl_book set type=#{type}, name=#{name}, description=#{description} where id = #{id}")
public void update(Book book);
@Delete("delete from ssm_db.tbl_book where id=#{id}")
public void delete(Integer id);
@Select("select * from ssm_db.tbl_book where id=#{id}")
public Book getById(Integer id);
@Select("select * from ssm_db.tbl_book")
public List<Book> getAll();
}

Service(业务层)#

BookService#

package com.wang.service;
import com.wang.domain.Book;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
/**
* @author Wang
*/
@Transactional
public interface BookService {
/**
* 保存
* @param book
* @return
*/
public boolean save(Book book);
/**
* 修改
* @param book
* @return
*/
public boolean update(Book book);
/**
* 根据id删除
* @param id
* @return
*/
public boolean delete(Integer id);
/**
* 根据id查找
* @param id
* @return
*/
public Book getById(Integer id);
/**
* 查找全部
*
* @return
*/
public List<Book> getAll();
}

BookServiceImpl#

package com.wang.service.impl;
import com.wang.dao.BookDao;
import com.wang.domain.Book;
import com.wang.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class BookServiceImpl implements BookService {
@Autowired
private BookDao bookDao;
public boolean save(Book book) {
bookDao.save(book);
return true;
}
public boolean update(Book book) {
bookDao.update(book);
return true;
}
public boolean delete(Integer id) {
bookDao.delete(id);
return true;
}
public Book getById(Integer id) {
return bookDao.getById(id);
}
public List<Book> getAll() {
return bookDao.getAll();
}
}

Domain(实体类)#

Book#

package com.wang.domain;
public class Book {
private Integer id;
private String type;
private String name;
private String description;
public Book() {
}
public Book(Integer id, String type, String name, String description) {
this.id = id;
this.type = type;
this.name = name;
this.description = description;
}
/**
* 获取
* @return id
*/
public Integer getId() {
return id;
}
/**
* 设置
* @param id
*/
public void setId(Integer id) {
this.id = id;
}
/**
* 获取
* @return type
*/
public String getType() {
return type;
}
/**
* 设置
* @param type
*/
public void setType(String type) {
this.type = type;
}
/**
* 获取
* @return name
*/
public String getName() {
return name;
}
/**
* 设置
* @param name
*/
public void setName(String name) {
this.name = name;
}
/**
* 获取
* @return description
*/
public String getDescription() {
return description;
}
/**
* 设置
* @param description
*/
public void setDescription(String description) {
this.description = description;
}
public String toString() {
return "Book{id = " + id + ", type = " + type + ", name = " + name + ", description = " + description + "}";
}
}

测试类#

BookServiceTest#

package wang;
import com.wang.config.SpringConfig;
import com.wang.domain.Book;
import com.wang.service.BookService;
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;
@RunWith(SpringJUnit4ClassRunner.class )
@ContextConfiguration(classes = SpringConfig.class)
public class BookServiceTest {
@Autowired
private BookService bookService;
@Test
public void testGetById() {
Book book = bookService.getById(1);
System.out.println(book);
}
@Test
public void testGetAll() {
List<Book> books = bookService.getAll();
System.out.println(books);
}
}

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>org.example</groupId>
<artifactId>SSMtest</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>SSMtest Maven Webapp</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<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.16</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.0</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.tomcat.maven</groupId>
<artifactId>tomcat7-maven-plugin</artifactId>
<version>2.1</version>
<configuration>
<port>80</port>
<path>/</path>
</configuration>
</plugin>
</plugins>
</build>
</project>