SSM整合过程(详细)

待我称王封你为后i 2023-07-20 12:11 54阅读 0赞

### SSM整合过程 ###

#### 1.基本环境搭建 ####

1.新建一个Maven项目

2.导入相关的pom依赖

<dependencies>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.11</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.2.4.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.2.4.RELEASE</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
    
            
            <dependency>
                <groupId>javax.annotation</groupId>
                <artifactId>jsr250-api</artifactId>
                <version>1.0</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.9.5</version>
            </dependency>
    
            
            <dependency>
                <groupId>log4j</groupId>
                <artifactId>log4j</artifactId>
                <version>1.2.17</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.12</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.3</version>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>2.5</version>
                <scope>provided</scope>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet.jsp</groupId>
                <artifactId>jsp-api</artifactId>
                <version>2.2</version>
                <scope>provided</scope>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
        </dependencies>

3.Maven资源过滤

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

4.建立基本结构和配置框架

*  com.superman.pojo
 *  com.superman.dao
 *  com.superman.service
 *  com.superman.controller
 *  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>
            
        
        </configuration>
 *  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 ">
        
        </beans>

#### 2.Mybatis层编写 ####

1.数据库配置文件database.properties(交给spring处理)

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

2.idea关联数据库

3.编写mybatis核心配置文件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>
        
        <typeAliases>
            <package name="com.superman.pojo"/>
        </typeAliases>
    
        <mappers>
            <mapper class="com.superman.dao.*"/>
        </mappers>
    
    </configuration>

4.编写数据库对应的实体类com.superman.pojo.Books

使用lombok插件

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

5.编写Dao层的Mapper接口

package com.superman.dao;
    import com.superman.pojo.Books;
    import java.util.List;
    
    public interface BookMapper { 
    
        int addBook(Books book);
    
        int deleteBook(int id);
    
        int updateBook(Books books);
    
        Books queryBook(int id);
    
        List<Books> queryAllBooks();
    }

6.编写接口对应的Mapper.xml , 需要导入mybatis的包

<?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.superman.dao.BookMapper">
    
        <insert id="addBook" parameterType="books">
            insert into ssmbuild.books(bookID,bookName,bookCounts,detail)
            values (#{bookID},#{bookName},#{bookCounts},#{detail})
        </insert>
    
        <delete id="deleteBook" parameterType="int">
            delete from ssmbuild.books where bookID=#{bookID}
        </delete>
    
        <update id="updateBook" parameterType="books">
            update ssmbuild.books
            set bookNmae=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
            where bookID=#{bookID}
        </update>
    
        <select id="queryBook" parameterType="int">
            select * from ssmbuild.books where bookID=#{bookID}
        </select>
    
        <select id="queryAllBooks" resultType="books">
            select * from ssmbuild.books
        </select>
    
    </mapper>

7.编写service层的接口

package com.superman.service;
    
    import com.superman.pojo.Books;
    
    import java.util.List;
    
    public interface BookeService { 
        int addBook(Books book);
    
        int deleteBook(int id);
    
        int updateBook(Books books);
    
        Books queryBook(int id);
    
        List<Books> queryAllBooks();
    }

8.编写service层接口的实现类

package com.superman.service;
    
    import com.superman.dao.BookMapper;
    import com.superman.pojo.Books;
    
    import java.util.List;
    
    /** * @ClassName BookServiceImpl * @Description TODO * @Author 蔡吉 * @Date 2020-3-31 9:39 * @Version 1.0 **/
    public class BookServiceImpl implements BookeService { 
    
        /** * service层调用dao层 */
        private BookMapper bookMapper;
    
        public void setBookMapper(BookMapper bookMapper) { 
            this.bookMapper = bookMapper;
        }
    
        public int addBook(Books books) { 
            return bookMapper.addBook(books);
        }
    
        public int deleteBook(int id) { 
            return bookMapper.deleteBook(id);
        }
    
        public int updateBook(Books books) { 
            return bookMapper.updateBook(books);
        }
    
        public Books queryBook(int id) { 
            return bookMapper.queryBook(id);
        }
    
        public List<Books> queryAllBooks() { 
            return queryAllBooks();
        }
    }

#### 3.spring层 ####

1.配置spring整合mybatis,使用c3p0连接池

2.编写spring整合mybatis的相关配置文件

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/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:db.properties"/>
    
        
        <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}"/>
            
            <property name="maxPoolSize" value="30"/>
            <property name="minPoolSize" value="10"/>
            
            <property name="autoCommitOnClose" value="false"/>
            
            <property name="checkoutTimeout" value="10000"/>
            
            <property name="acquireRetryAttempts" value="2"/>
        </bean>
    
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
            
            <property name="configLocation" value="classpath:mybatis-config.xml"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
            
            <property name="basePackage" value="com.superman.dao"/>
        </bean>
    
    </beans>

spring-service.xml

#### 4.spring-mvc层 ####

1.web.xml

<?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">
        
        <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-config>
            <session-timeout>15</session-timeout>
        </session-config>
    </web-app>

2.spring-mvc.xml

3.spring配置整合文件,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 ">
    
        <import resource="classpath:spring-service.xml"/>
        <import resource="classpath:spring-dao.xml"/>
        <import resource="classpath:spring-mvc.xml"/>
    </beans>