SSM书籍管理（环境搭建）

整合SSM：Spring+SpringMVC+Mybatis

环境要求：IDEA、MySQL5+、Tomcat9+、Maven3+

数据库搭建

数据库准备以下数据用于后续实验：创建一个ssmbuild数据库，表books，该表有4个字段，并且插入3条数据用于后续。

CREATE DATABASE `ssmbuild`use `ssmbuild`drop TABLE IF exists `books`CREATE TABLE `books`(`bookID` int(10) not null auto_increment comment'书id',`bookName` varchar(100) not null comment'书名',`bookCounts` int(11) not null comment'数量',`detail` varchar(200) not null comment'描述',key `bookID`(`bookID`)
)engine=innodb default charset=utf8insert into `books`(`bookID`,`bookName`,`bookCounts`,`detail`)VALUES
(1,'java',1,'Java介绍'),
(2,'C',10,'C语言介绍'),
(3,'数据库',8,'数据库介绍')

项目准备

pom.xml引入依赖：junit、数据库驱动、连接池、servlet、jsp、mybatis、mybatis-spring、spring、lombok、

<dependencies><!-- Mysql连接依赖 数据库驱动--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.21</version></dependency><!--数据库连接池 可以用c3p0或dbcp--><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!--servlet-jsp 这三个一般一起使用--><dependency><groupId>javax.servlet</groupId><artifactId>servlet-api</artifactId><version>2.5</version></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.1</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><!--mybatis 以下两个一般一起使用--><!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.6</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>2.0.6</version></dependency><!--Spring--><!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc --><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.3.20</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.3.20</version></dependency><!-- https://mvnrepository.com/artifact/junit/junit --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.13.1</version><scope>test</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.24</version></dependency>
</dependencies><!--在build中配置resources, 来防止我们资源导出失败问题-->
<build>
<resources><resource><directory>src/main/resources</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>true</filtering></resource><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>true</filtering></resource>
</resources>
</build>
</project>

连接数据库

建立包：

建立mybatis-config.xml文件，导入头文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration></configuration>

建立applicationContext.xml文件，导入Spring的头文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beanshttps://www.springframework.org/schema/beans/spring-beans.xsd"></beans>

建立数据库配置文件database.properties，注意ssmbuild是数据库名

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
username=root
password=123456

配置Mybatis

1、编写实体类Books，该类中的属性对应数据库表book中的字段：

/*Date注解可以自动生成set与get方法与无参，AllArgsConstructor注解注入有参，NoArgsConstructor无参*/
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {private int bookID;private String bookName;private int bookCounts;private String detail;
}

2、编写接口BookMapper。

public interface BookMapper {//增加一本书int addBook(Books books);//删除一本书int deteleBookById(@Param("bookID") int id);//更新一本书int updateBook(Books books);//根据id查询一本书Books queryBookById(@Param("bookID") int id);//查询全部的书List<Books> queryAllBook();
}

3、编写接口实现文件，BookMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.serenity.dao.BookMapper"><!--每个mapper都需要绑定一个接口--><insert id="addBook" parameterType="Books">insert into ssmbuild.books(bookName,bookCounts,detail)values (#{bookName},#{bookCounts},#{detail})</insert><delete id="deleteBookById" parameterType="_int">delete from ssmbuild.books where bookID=#{bookID}</delete><update id="updateBook" parameterType="Books">update ssmbuild.booksset bookName=#{bookName},bookCounts=#{bookCouts},detail=#{detail}where bookID=#{bookID}</update><select id="queryBookById" resultType="Books">select * from ssmbuild.books where bookID=#{bookID}</select><select id="queryAllBook" resultType="Books">select * from ssmbuild.books</select>
</mapper>

4、将mapper文件注册到mybatis-config文件中

<!--设置标准日志输出--><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings>
<!--配置数据源，交给Spring了--><typeAliases><package name="com.serenity.pojo"/></typeAliases><mappers><mapper class="com.serenity.dao.BookMapper"/></mappers>

5、编写业务层中的Bookservice接口

public interface BookService {//增加一本书int addBook(Books books);//删除一本书int deteleBookById(int id);//更新一本书int updateBook(Books books);//根据id查询一本书Books queryBookById(int id);//查询全部的书List<Books> queryAllBook();
}

6、编写业务层的实现类BookServiceImpl

public class BookServiceImpl implements BookService {//service调dao层，所以该地需要组合dao层private BookMapper bookMapper;public void setBookMapper(BookMapper bookMapper) {this.bookMapper = bookMapper;}public int addBook(Books books) {return bookMapper.addBook(books);}public int deteleBookById(int id) {return bookMapper.deteleBookById(id);}public int updateBook(Books books) {return bookMapper.updateBook(books);}public Books queryBookById(int id) {return bookMapper.queryBookById(id);}public List<Books> queryAllBook() {return bookMapper.queryAllBook();}
}

Spring层

1、编写Spring-dao.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/beanshttps://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttps://www.springframework.org/schema/context/spring-context.xsd"><!--1、关联数据库文件--><context:property-placeholder location="classpath:database.properties"/><!--2、连接池datasource--><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><!--c3p0连接池的私有属性--><property name="maxPoolSize" value="30"/><property name="minPoolSize" value="10"/><!--关闭连接后不自动commit--><property name="autoCommitOnClose" value="false"/><!--获取连接超时时间--><property name="checkoutTimeout" value="10000"/><!--获取连接失败重试次数--><property name="acquireRetryAttempts" value="2"/></bean><!--3、sqlSessionFactory--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><!--绑定mybatis配置文件--><property name="configLocation" value="classpath:mybatis-config.xml"/></bean><!--4、配置dao接口扫描包,动态实现了Dao接口可以注入Spring容器中--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!--注入sqlSessionFactory--><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><!--要扫描的dao包--><property name="basePackage" value="com.serenity.dao"/></bean></beans>

2、整合service层，编写spring-service.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/beanshttps://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"><!--1、扫描service下的包--><context:component-scan base-package="com.serenity.service"/><!--2、将所有业务内注入到Spring，可以通过配置或注解实现，此处所有配置--><bean id="BookServiceImpl" class="com.serenity.service.BookServiceImpl"><property name="bookMapper" ref="bookMapper"/></bean>
<!--3、声明式事务--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><!--注入数据源--><property name="dataSource" ref="dataSource"/></bean>
</beans>

注意各配置文件关联起来。

SpringMVC层

1、增加web的支持

2、编写web.xml文件内容

<!--DispatcherServlet--><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:applicationContext.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><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><!--Session-->

3、编写spring-mvc.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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttps://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"><!--1、注解驱动--><mvc:annotation-driven/><!--2、静态资源过滤--><mvc:default-servlet-handler/><!--3、扫描包：controller--><context:component-scan base-package="com.serenity.controller"/><!--4、视图解析器--><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/jsp"/><property name="suffix" value=".jsp"/></bean>
</beans>

配置结束：