IDEA SSM框架整合配置及步骤详解

<?xml version="1.0" encoding="UTF-8"?>
<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/xsd/maven-4.0.0.xsd">
 <modelVersion>4.0.0</modelVersion>
 <build>
  <resources>
   <resource>
    <directory>src/main/java</directory>
    <includes>
     <include>**/*.properties</include>
     <include>**/*.xml</include>
    </includes>
    <filtering>false</filtering>
   </resource>
   <resource>
    <directory>src/main/resources</directory>
    <includes>
     <include>**/*.properties</include>
     <include>**/*.xml</include>
    </includes>
    <filtering>false</filtering>
   </resource>
  </resources>
 </build>

 <groupId>org.example</groupId>
 <artifactId>ssm</artifactId>
 <version>1.0-SNAPSHOT</version>
 <properties>
  <maven.compiler.source>13</maven.compiler.source>
  <maven.compiler.target>13</maven.compiler.target>
 </properties>
 <dependencies>
  <!--Junit-->
  <dependency>
   <groupId>junit</groupId>
   <artifactId>junit</artifactId>
   <version>4.12</version>
  </dependency>
  <!--数据库驱动-->
  <dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.47</version>
  </dependency>
  <!-- 数据库连接池 -->
  <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.2</version>
  </dependency>
  <dependency>
   <groupId>javax.servlet</groupId>
   <artifactId>jstl</artifactId>
   <version>1.2</version>
  </dependency>

  <!--Mybatis-->
  <dependency>
   <groupId>org.mybatis</groupId>
   <artifactId>mybatis</artifactId>
   <version>3.5.2</version>
  </dependency>
  <dependency>
   <groupId>org.mybatis</groupId>
   <artifactId>mybatis-spring</artifactId>
   <version>2.0.6</version>
  </dependency>

  <!--Spring-->
  <dependency>
   <groupId>org.springframework</groupId>
   <artifactId>spring-webmvc</artifactId>
   <version>5.3.4</version>
  </dependency>
  <dependency>
   <groupId>org.springframework</groupId>
   <artifactId>spring-jdbc</artifactId>
   <version>5.3.4</version>
  </dependency>
 </dependencies>

</project>

<?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/beans
  http://www.springframework.org/schema/beans/spring-beans.xsd">

</beans>

<?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>

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

package com.projectname.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Book {
 private int bookID;
 private String bookName;
 private int bookCounts;
 private String detail;

}

package com.projectname.dao;

import com.projectname.pojo.Book;

import java.util.List;

public interface DaoBook {
 //增加一个Book
 int addBook(Book book);

 //根据id删除一个Book
 int deleteBookById(int id);

 //更新Book
 int updateBook(Book books);

 //根据id查询,返回一个Book
 Book queryBookById(int id);

 //查询全部Book,返回list集合
 List<Book> queryAllBook();
}

<?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.kuang.dao.BookMapper">

 <!--增加一个Book-->
 <insert id="addBook" parameterType="Books">
  insert into ssmbuild.books(bookName,bookCounts,detail)
  values (#{bookName}, #{bookCounts}, #{detail})
 </insert>

 <!--根据id删除一个Book-->
 <delete id="deleteBookById" parameterType="int">
  delete from ssmbuild.books where bookID=#{bookID}
 </delete>

 <!--更新Book-->
 <update id="updateBook" parameterType="Books">
  update ssmbuild.books
  set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
  where bookID = #{bookID}
 </update>

 <!--根据id查询,返回一个Book-->
 <select id="queryBookById" resultType="Books">
  select * from ssmbuild.books
  where bookID = #{bookID}
 </select>

 <!--查询全部Book-->
 <select id="queryAllBook" resultType="Books">
  SELECT * from ssmbuild.books
 </select>

</mapper>

<?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>
<mappers>
<mapper resource="com/projectname/dao/BookMapper.xml"/>
</mappers>
</configuration>

package com.projectname.service;

import com.projectname.pojo.Book;

import java.util.List;

public interface BookService {
 //增加一个Book
 int addBook(Book book);
 //根据id删除一个Book
 int deleteBookById(int id);
 //更新Book
 int updateBook(Book books);
 //根据id查询,返回一个Book
 Book queryBookById(int id);
 //查询全部Book,返回list集合
 List<Book> queryAllBook();
}

package com.projectname.service;

import com.projectname.dao.BookMapper;
import com.projectname.pojo.Book;

import java.util.List;

public class BookServiceImpl implements BookService {

 //调用dao层的操作，设置一个set接口，方便Spring管理
 private BookMapper bookMapper;

 public void setBookMapper(BookMapper bookMapper) {
  this.bookMapper = bookMapper;
 }

 public int addBook(Book book) {
  return bookMapper.addBook(book);
 }

 public int deleteBookById(int id) {
  return bookMapper.deleteBookById(id);
 }

 public int updateBook(Book books) {
  return bookMapper.updateBook(books);
 }

 public Book queryBookById(int id) {
  return bookMapper.queryBookById(id);
 }

 public List<Book> queryAllBook() {
  return bookMapper.queryAllBook();
 }
}

<?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 https://www.springframework.org/schema/context/spring-context.xsd">
 <context:property-placeholder location="classpath:database.properties"/>
 <!-- 2.数据库连接池 -->
 <!--数据库连接池
  dbcp 半自动化操作 不能自动连接
  c3p0 自动化操作（自动的加载配置文件 并且设置到对象里面）
 -->
 <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"/>
  <!-- 配置MyBaties全局配置文件:mybatis-config.xml -->
  <property name="configLocation" value="classpath:mybatis-configuration.xml"/>
 </bean>
 <!-- 4.配置扫描Dao接口包，动态实现Dao接口注入到spring容器中 -->
 <!--解释 ：https://www.cnblogs.com/jpfss/p/7799806.html-->
 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  <!-- 注入sqlSessionFactory -->
  <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  <!-- 给出需要扫描Dao接口包 -->
  <property name="basePackage" value="com.projectname.dao"/>
 </bean>
</beans>

<?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 https://www.springframework.org/schema/context/spring-context.xsd">

 <!-- 扫描service相关的bean -->
 <context:component-scan base-package="com.projectname.service" />

 <!--BookServiceImpl注入到IOC容器中-->
 <bean id="BookServiceImpl" class="com.projectname.service.BookServiceImpl">
  <property name="bookMapper" ref="bookMapper"/>
 </bean>

 <!-- 配置事务管理器 -->
 <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <!-- 注入数据库连接池 -->
  <property name="dataSource" ref="dataSource" />
 </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
   version="4.0"> <!-- 配置SpringMVC -->
 <!-- 1.开启SpringMVC注解驱动 -->
 <servlet>
  <servlet-name>DispatcherServlet</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>DispatcherServlet</servlet-name>
  <url-pattern>/</url-pattern>
 </servlet-mapping>

 <!--encodingFilter-->
 <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过期时间-->
 <session-config>
  <session-timeout>15</session-timeout>
 </session-config>
</web-app>

<?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:mvc="http://www.springframework.org/schema/mvc"
  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/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
 <!-- 配置SpringMVC -->
 <!-- 1.开启SpringMVC注解驱动 -->
 <mvc:annotation-driven />
 <!-- 2.静态资源默认servlet配置-->
 <mvc:default-servlet-handler/>

 <!-- 3.配置jsp 显示ViewResolver视图解析器 -->
 <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
  <property name="prefix" value="/WEB-INF/jsp/" />
  <property name="suffix" value=".jsp" />
 </bean>
 <!-- 4.扫描web相关的bean -->
 <context:component-scan base-package="com.projectname.controller" />
</beans>

<?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:mvc="http://www.springframework.org/schema/mvc"
 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/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

 <import resource="spring-dao.xml"/>
 <import resource="spring-service.xml"/>
 <import resource="spring-mvc.xml"/>

</beans>

<settings>
 <setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>