# BulidSSMStudy

**Repository Path**: jqw_com/BulidSSMStudy

## Basic Information

- **Project Name**: BulidSSMStudy
- **Description**: ssm整合学习笔记
- **Primary Language**: Java
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-01-30
- **Last Updated**: 2022-01-30

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 1. 配置pom.xml

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

    <groupId>com.wqj</groupId>
    <artifactId>ssmbuild</artifactId>
    <version>1.0-SNAPSHOT</version>

    <!--依赖 junit,数据库驱动，连接池，servlet，jsp，mybatis，mybatis-spring，spring-->

    <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.4</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-->
        <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-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.3.13</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.13</version>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.20</version>
        </dependency>
    </dependencies>

    <!--静态资源导出问题-->
    <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>

</project>
```

# 2. 配置MySQL驱动database.properties

```properties
# 以下是MySQL5.0+版本的
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root

# 注意：如果使用的MySQL8.0+，需要增加一个时区的配置；如下：

# 以下是MySQL8.0+版本的
jdbc.driver=com.mysql.jdbc.Driver
# 如果使用的MySQL8.0+，需要增加一个时区的配置&serverTimezone=Asia/Shanghai(这里配置的是亚洲上海)；
# useSSL=true&useUnicode=true&characterEncoding = utf8防止乱码
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=root
```



# 3. ssm底层整合实现步骤

1. 创建数据库

2. idea创建项目

3. idea连接数据库

4. 编写mybatis-config.xml配置文件、applicationContext.xml配置文件、数据库驱动database.properties配置文件

   ```xml
   <!--mybatis-config.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>
   
       <!--配置数据源，交给spring去做-->
       <typeAliases>
           <package name="com.wqj.pojo"/>
       </typeAliases>
   
       <mappers>
           <mapper class="com.wqj.dao.BookMapper"/>
       </mappers>
   </configuration>
   ```

   ```xml
   <!--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"
          xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans.xsd">
   
       <!--将两个整合的配置文件关联起来，如果不关连，在注入的时候回发生报错，没办法找到dao层-->
       <import resource="classpath:spring-dao.xml"/>
       <import resource="classpath:spring-service.xml"/>
       <import resource="classpath:spring-mvc.xml"/>
   </beans>
   ```

   

5. 编写数据库实体类Books

   ```java
   package com.wqj.pojo;
   
   import lombok.AllArgsConstructor;
           import lombok.Data;
           import lombok.NoArgsConstructor;
   
   @Data //除了有参构造没有之外都有了
   @AllArgsConstructor //加了它之后无参构造又没有了
   @NoArgsConstructor //添加无参构造
   public class Books{
       private int bookID;
       private String bookName;
       private int bookCounts;
       private String detail;
   }
   
   ```

   

6. 编写dao层数据库操作层BookMapper类和BookMapper.xml

   ```java
   package com.wqj.dao;
   
   import com.wqj.pojo.Books;
   import org.apache.ibatis.annotations.Param;
   
   import java.util.List;
   
   public interface BookMapper {
       //增加一本书
       int addBook(Books books);
   
       //删除一本书
       int deleteBookById(@Param("bookID") int id);
   
       //更新一本书
       int updateBook(Books books);
   
       //查询一本书
       Books queryBookById(@Param("bookID") int id);
   
       //查询全部的书
       List<Books> queryAllBook();
   
   }
   
   ```

   ```xml
   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE mapper
           PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
           "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   <mapper namespace="com.wqj.dao.BookMapper">
       <insert id="addBook" parameterType="Books">
           insert into books (bookName, bookCount, detail) values (#{bookName},#{bookCount},#{detail});
       </insert>
   
       <delete id="deleteBookById" parameterType="int">
           delete from books where bookID =#{bookID};
   
       </delete>
       <update id="updateBook" parameterType="Books">
           update books set bookName = #{bookName},bookCount=#{bookCount},detail = #{detail} = where bookID=#{bookID};
   
       </update>
       <select id="queryBookByIDd" resultType="Books">
           select * from books where bookID = #{bookID};
       </select>
   
       <select id="queryBook" resultType="Books">
           select * from books;
       </select>
   
       <!--写完之后将其绑定到mybatis-config.xml中，之后去写业务层service -->
   
   </mapper>
   ```

   

7. 编写service业务层BookService接口和BookServiceImpl实现类

   ```java
   package com.wqj.service;
   
   import com.wqj.pojo.Books;
   
   import java.util.List;
   
   public interface BookService {
       //增加一本书
       int addBook(Books books);
   
       //删除一本书
       int deleteBookById(int id);
   
       //更新一本书
       int updateBook(Books books);
   
       //查询一本书
       Books queryBookById(int id);
   
       //查询全部的书
       List<Books> queryAllBook();
   }
   
   ```

   ```java
   package com.wqj.service;
   
   import com.wqj.dao.BookMapper;
   import com.wqj.pojo.Books;
   import java.util.List;
   
   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 deleteBookById(int id) {
           return deleteBookById(id);
       }
   
       public int updateBook(Books books) {
           return updateBook(books);
       }
   
       public Books queryBookById(int id) {
           return bookMapper.queryBookById(id);
       }
   
       public List<Books> queryAllBook() {
           return bookMapper.queryAllBook();
       }
   }
   
   ```

   

8. 编写spring-dao.xml整合dao层

   - 关联数据库配置文件

     ```xml
     <context:property-placeholder location="classpath:database.properties"/>
     ```

     

   - 连接池

     ```xml
       <!--2. 连接池
         dbcp:半自动化操作，不能自动连接
         c3p0:自动化操作（自动化的加载配置文件，并且可以自动设置到对象中！)
         druid ; hikari(springBoot2,自带默认的数据源）
         -->
         <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>
     ```

     

   - sqlSessionFactory

     - 注册数据源

     - 绑定mybatis的配置文件

       ```xml
        <!--3. sqlSessionFactory-->
           <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
               <!--注册数据源-->
               <property name="dataSource" ref="dataSource"/>
               <!--绑定Mybatis的配置文件-->
               <property name="configLocation" value="classpath:mybatis-config.xml"/>
       
               <!--==============到这一步结束，mybatis和spring就整合完成====================-->
           </bean>
       ```

       

   - 配置dao接口扫描包，动态实现Dao接口可以注入到spring容器中。

     ```xml
     <!--4. 配置dao接口扫描包，动态的实现了Dao接口可以注入到Spring容器中-->
         <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
             <!--注入sqlSessionFactory-->
             <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
             <!--要扫描的dao包-->
             <property name="basePackage" value="com.wqj.dao"/>
         </bean>
     ```

9. 编写spring-service.xml整合service层

   - 扫描service下的包

     ```xml
     <context:component-scan base-package="com.wqj.service"/>
     ```

   - 将我们所有的业务类（service）注入到spring，可通过注解或配置的方式

     - 注解

       ```java
       import org.springframework.stereotype.Service;
       
       import java.util.List;
       @Service
       public class BookServiceImpl implements BookService {
       
           //service调dao层：组合dao
           @Autowired
           private BookMapper bookMapper;
           public void setBookMapper(BookMapper bookMapper) {
               this.bookMapper = bookMapper;
           }
       
       
           public int addBook(Books books) {
               return bookMapper.addBook(books);
           }
       
           public int deleteBookById(int id) {
               return deleteBookById(id);
           }
       
           public int updateBook(Books books) {
               return updateBook(books);
           }
       
           public Books queryBookById(int id) {
               return bookMapper.queryBookById(id);
           }
       
           public List<Books> queryAllBook() {
               return bookMapper.queryAllBook();
           }
       }
       
       ```

       

     - 配置方式

       ```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 https://www.springframework.org/schema/context/spring-context.xsd">
       
           <!--整合service-->
       
           <!--1. 扫描service下的包-->
           <context:component-scan base-package="com.wqj.service"/>
           <!--2. 将我们的所有业务类，注入到Spring，可以通过配置，或者注解(在BookServiceImpl类中添加@Service在private上面添加@Autowired实现-->
           <bean id="BookServiceImpl" class="com.wqj.service.BookServiceImpl">
               <property name="bookMapper" ref="bookMapper"/><!-- 此处必须和spring-dao.xml有关联不然将报错-->
           </bean>
       </beans>
       ```

   - 声明事务配置（ioc）

     ```xml
        <!--3. 声明式事务配置-->
         <bean id="transacationManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
             <!--注入数据源-->
             <property name="dataSource" ref="dataSource"/>
         </bean>
     ```

     

10. 添加web驱动

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