语法会随版本的变化而改变，但其核心流程几乎不变；

大部分的保存代码，少部分的解释，可以参照注解和注释。

SSM框架

Sql

  1. CREATE DATABASE `ssmbuild`;
  3. USE `ssmbuild`;
  5. DROP TABLE IF EXISTS `books`;
  7. CREATE TABLE `books` (
  8.   `bookID` int(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
  9.   `bookName` varchar(100) NOT NULL COMMENT '书名',
  10.   `bookCounts` int(11) NOT NULL COMMENT '数量',
  11.   `detail` varchar(200) NOT NULL COMMENT '描述',
  12.   PRIMARY KEY (`bookID`)
  13. ) ENGINE = InnoDB CHARACTER SET = utf8;
  15. INSERT INTO    `books` (`bookID`,`bookName`,`bookCounts`,`detail`)VALUES
  16. (1,'Java',1,'Java'),
  17. (2,'MySQL',10,'MySQL'),
  18. (3,'Linux',5,'Linux');

导入依赖

  2.     <!--依赖: junit, 数据库驱动，连接池，servlet, jsp, mybatis, mybattis-spring, spring, -->
  3.     <dependencies>
  4.         <!--Junit-->
  5.         <dependency>
  6.             <groupId>junit</groupId>
  7.             <artifactId>junit</artifactId>
  8.             <version>4.12</version>
  9.         </dependency>
  10.         <!--数据库驱动-->
  11.         <dependency>
  12.             <groupId>mysql</groupId>
  13.             <artifactId>mysql-connector-java</artifactId>
  14.             <version>5.1.47</version>
  15.         </dependency>
  16.         <!--数据库连接池: c3p0-->
  17.         <dependency>
  18.             <groupId>com.mchange</groupId>
  19.             <artifactId>c3p0</artifactId>
  20.             <version>0.9.5.2</version>
  21.         </dependency>
  22.         <!--Servlet - JSP -->
  23.         <dependency>
  24.             <groupId>javax.servlet</groupId>
  25.             <artifactId>servlet-api</artifactId>
  26.             <version>2.5</version>
  27.         </dependency>
  28.         <dependency>
  29.             <groupId>javax.servlet.jsp</groupId>
  30.             <artifactId>jsp-api</artifactId>
  31.             <version>2.2</version>
  32.         </dependency>
  33.         <dependency>
  34.             <groupId>javax.servlet</groupId>
  35.             <artifactId>jstl</artifactId>
  36.             <version>1.2</version>
  37.         </dependency>
  38.         <!--Mybatis-->
  39.         <dependency>
  40.             <groupId>org.mybatis</groupId>
  41.             <artifactId>mybatis</artifactId>
  42.             <version>3.5.2</version>
  43.         </dependency>
  44.         <dependency>
  45.             <groupId>org.mybatis</groupId>
  46.             <artifactId>mybatis-spring</artifactId>
  47.             <version>2.0.2</version>
  48.         </dependency>
  49.         <!--Spring-->
  50.         <dependency>
  51.             <groupId>org.springframework</groupId>
  52.             <artifactId>spring-webmvc</artifactId>
  53.             <version>5.1.9.RELEASE</version>
  54.         </dependency>
  55.         <dependency>
  56.             <groupId>org.springframework</groupId>
  57.             <artifactId>spring-jdbc</artifactId>
  58.             <version>5.1.9.RELEASE</version>
  59.         </dependency>
  60.     </dependencies>
  61.     <!--静态资源导出问题-->
  62.     <build>
  63.         <resources>
  64.             <resource>
  65.                 <directory>src/main/java</directory>
  66.                 <includes>
  67.                     <include>**/properties</include>
  68.                     <include>**/*.xml</include>
  69.                 </includes>
  70.                 <filtering>false</filtering>
  71.             </resource>
  72.             <resource>
  73.                 <directory>src/mainresources</directory>
  74.                 <includes>
  75.                     <include>**/properties</include>
  76.                     <include>**/.xml</include>
  77.                 </includes>
  78.                 <filtering>false</filtering>
  79.             </resource>
  80.         </resources>
  81.     </build>

建立基本结构和配置框架

SSM整合 - 图1

  • cn.dafran.pojo
  • cn.dafran.mapper
  • cn.dafran.service
  • cn.dafran.controller
  • mybatis-config.xml的头文件
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <!--mybatis-->
  6. <configuration>
  8. </configuration>
  • applicationContext.xml
  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  6.     <!--spring-->
  8. </beans>

持久层（Mybatis）：Dao层（mapper) 层编写

  1. 数据库配置文件 database.properties
  1. jdbc.driver=com.mysql.jdbc.Driver
  2. #如果使用的是MySQL8.0+,增加一个时区的配置;  &serverTimezone=Asia/Shanghai
  3. jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
  4. jdbc.username=root
  5. jdbc.password=123456
  1. 配置mybatis-config.xmlg.xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <!--mybatis-->
  6. <configuration>
  8.     <!--配置数据源,交给Spring去做-->
  10.     <typeAliases>
  11.         <package name="cn.dafran.pojo"/>
  12.     </typeAliases>
  13.     <!--在mybatis配置文件中注册-->
  14.     <mappers>
  15.         <mapper class="cn.dafran.mapper.BookMapper"/>
  16.     </mappers>
  18. </configuration>

Entity

  1. <!--Lombok-->
  2. <dependency>
  3.     <groupId>org.projectlombok</groupId>
  4.     <artifactId>lombok</artifactId>
  5.     <version>1.16.10</version>
  6. </dependency>
  1. @Data
  2. @AllArgsConstructor
  3. @NoArgsConstructor
  4. public class Books {
  5.     /**
  6.      * 书id
  7.      */
  8.     private Integer bookID;
  10.     /**
  11.      * 书名
  12.      */
  13.     private String bookName;
  15.     /**
  16.      * 数量
  17.      */
  18.     private Integer bookCounts;
  20.     /**
  21.      * 描述
  22.      */
  23.     private String detail;
  24. }

Dao

  1. public interface BookMapper {
  3.     //增加一本书
  4.     int addBook(Books books);
  6.     //删除一本书
  7.     int deleteBookById(@Param("bookId") int id);
  9.     //修改一本书
  10.     int updateBook(Books books);
  12.     //查找一本书
  13.     Books queryBooksById(@Param("bookId") int id);
  15.     //查询全部书
  16.     List<Books> queryAllBooks();
  18. }
  1. <mapper namespace="cn.dafran.mapper.BookMapper">
  3.     <insert id="addBook" parameterType="Books">
  4.         insert into ssmbuild.books (bookName, bookCounts, detail)
  5.         VALUES (#{bookName},#{bookCounts},#{detail});
  6.     </insert>
  8.     <delete id="deleteBookById" parameterType="int">
  9.         delete from ssmbuild.books
  10.         where bookID= #{bookId};
  11.     </delete>
  13.     <update id="updateBook" parameterType="Books">
  14.         update ssmbuild.books
  15.         set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
  16.         where bookID=#{bookID};
  17.     </update>
  19.     <select id="queryBooksById" resultType="Books">
  20.         select * from ssmbuild.books
  21.         where bookID=#{bookId};
  22.     </select>
  23.     <select id="queryAllBooks" resultType="Books">
  24.         select * from ssmbuild.books;
  25.     </select>
  27. </mapper>

Service

  1. public interface BookService {
  2.     //增加一本书
  3.     int addBook(Books books);
  5.     //删除一本书
  6.     int deleteBookById(int id);
  8.     //修改一本书
  9.     int updateBook(Books books);
  11.     //查找一本书
  12.     Books queryBooksById(int id);
  14.     //查询全部书
  15.     List<Books> queryAllBooks();
  17. }
  1. public class BookServiceImpl implements BookService {
  3.     //service调用dao层,组合Dao
  4.     private BookMapper bookMapper;
  6.     public void setBookMapper(BookMapper bookMapper) {
  7.         this.bookMapper = bookMapper;
  8.     }
  10.     @Override
  11.     public int addBook(Books books) {
  12.         return bookMapper.addBook(books);
  13.     }
  15.     @Override
  16.     public int deleteBookById(int id) {
  17.         return bookMapper.deleteBookById(id);
  18.     }
  20.     @Override
  21.     public int updateBook(Books books) {
  22.         return bookMapper.updateBook(books);
  23.     }
  25.     @Override
  26.     public Books queryBooksById(int id) {
  27.         return bookMapper.queryBooksById(id);
  28.     }
  30.     @Override
  31.     public List<Books> queryAllBooks() {
  32.         return bookMapper.queryAllBooks();
  33.     }
  34. }

Spring层

spring-dao.xml

  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  6.         http://www.springframework.org/schema/beans/spring-beans.xsd
  7.         http://www.springframework.org/schema/context
  8.         https://www.springframework.org/schema/context/spring-context.xsd">
  10.     <!--spring整合dao层-->
  12.     <!--1.关联数据库配置文件-->
  13.     <context:property-placeholder location="classpath:database.properties"/>
  15.     <!--2.连接池
  16.         dbcp: 半自动化操作，不能 自动连接
  17.         c3p0: 自动化操作(自动化的加载配置文件，并且可以自动设置到对象中! )
  18.         druid:
  19.         hikari:spring2.0 新增默认数据源
  20.     -->
  21.     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  22.         <property name="driverClass" value="${jdbc.driver}"/>
  23.         <property name="jdbcUrl" value="${jdbc.url}"/>
  24.         <property name="user" value="${jdbc.username}"/>
  25.         <property name="password" value="${jdbc.password}"/>
  27.         <!-- c3p0连接池的私有属性-->
  28.         <property name="maxPoolSize" value="30"/>
  29.         <property name="minPoolSize" value="10"/>
  30.         <!-- 关闭连接后不自动commit -->
  31.         <property name="autoCommitOnClose" value="false"/>
  32.         <!--获取连接超时时间-->
  33.         <property name="checkoutTimeout" value= "10000"/>
  34.         <!-- 当获取连接失败重试次数-->
  35.         <property name="acquireRetryAttempts" value="2"/>
  37.     </bean>
  39.     <!--3.sqlSessionFactory-->
  40.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  41.         <property name="dataSource" ref="dataSource"/>
  42.         <!--绑定Mybatis的配置文件-->
  43.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  44.     </bean>
  47.     <!--配置dao接口扫描包,动态的实现Dao接口可以注入到Spring容器中!-->
  48.    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  49.        <!--注入sqlSessionFactory-->
  50.        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  51.        <!--要扫描的dao包-->
  52.        <property name="basePackage" value="cn.dafran.mapper"/>
  53.    </bean>
  55. </beans>

spring-service.xml

  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:context="http://www.springframework.org/schema/context"
  5.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  6.         http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
  8.     <!--1.扫描service的包-->
  9.     <context:component-scan base-package="cn.dafran.service"/>
  11.     <!--2.将所有的业务注入到spring中-->
  12.     <bean id="BookServiceImpl" class="cn.dafran.service.impl.BookServiceImpl">
  13.         <property name="bookMapper" ref="bookMapper"/>
  14.     </bean>
  16.     <!--3.声明是事务层-->
  17.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  18.         <!--注入数据源-->
  19.         <property name="dataSource" ref="dataSource"/>
  20.     </bean>
  22.     <!--4.AOP事务支持-->
  23. </beans>

applicationContext.xml

  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  6.     <!--spring配置方法-->
  7.     <!--也可以在service层 中加@Service注解 @Autowired-->
  8.     <import resource="classpath:spring-dao.xml"/>
  9.     <import resource="classpath:spring-service.xml"/>
  10. </beans>

SpringMVC 层(controller)

添加web

web.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
  3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
  5.          version="4.0">
  7.     <!--DispatchServlet-->
  8.     <servlet>
  9.         <servlet-name>springmvc</servlet-name>
  10.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  11.         <init-param>
  12.             <param-name>contextConfigLocation</param-name>
  13.             <param-value>classpath:applicationContext.xml</param-value>
  14.         </init-param>
  15.         <load-on-startup>1</load-on-startup>
  16.     </servlet>
  17.     <servlet-mapping>
  18.         <servlet-name>springmvc</servlet-name>
  19.         <url-pattern>/</url-pattern>
  20.     </servlet-mapping>
  22.     <!--乱码过滤-->
  23.     <filter>
  24.         <filter-name>encodingFilter</filter-name>
  25.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  26.         <init-param>
  27.             <param-name>encoding</param-name>
  28.             <param-value>utf-8</param-value>
  29.         </init-param>
  30.     </filter>
  31.     <filter-mapping>
  32.         <filter-name>encodingFilter</filter-name>
  33.         <url-pattern>/*</url-pattern>
  34.     </filter-mapping>
  36.     <!--Session-->
  37.     <session-config>
  38.         <session-timeout>15</session-timeout>
  39.     </session-config>
  41. </web-app>

spring-mvc.xml

  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xmlns:mvc="http://www.springframework.org/schema/mvc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/mvc
  9.         http://www.springframework.org/schema/mvc/spring-cache.xsd
  10.         http://www.springframework.org/schema/context
  11.         https://www.springframework.org/schema/context/spring-context.xsd">
  13.     <!--1.注解驱动-->
  14.     <mvc:annotation-driven/>
  15.     <!--2.静态资源注入-->
  16.     <mvc:default-servlet-handler/>
  17.     <!--3.扫描包:controller-->
  18.     <context:component-scan base-package="cn.dafran.controller"/>
  19.     <!--4.视图解析器-->
  20.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  21.         <property name="prefix" value="/WEB-INF/jsp/"/>
  22.         <property name="suffix" value=".jsp"/>
  23.     </bean>
  25. </beans>

applicationContext.xml

  1. <?xml version="1.0" encoding ="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.         http://www.springframework.org/schema/beans/spring-beans.xsd">
  6.     <!--spring配置方法-->
  7.     <!--也可以在service层 中加@Service注解 @Autowired-->
  8.     <import resource="classpath:spring-dao.xml"/>
  9.     <import resource="classpath:spring-service.xml"/>
  10.     <import resource="classpath:spring-mvc.xml"/>
  11. </beans>