SSM集成（demo版）

1 SSM集成

1.1 导包

1.2 配置spring的黑心配置文件

1.2.1 jdbc.properties

jdbc.username=root
jdbc.password=root
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///ssm

1.2.2 DataSource

配置applicationContext.xml

<!--引入数据连接四大参数-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
       <!--连接池-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="driverClassName" value="${jdbc.driver}"/>
    </bean>

1.2.3 SqlSessionPactory

<!--创建SessionFactory-->
    <bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--配置DataSource-->
        <property name="dataSource" ref="dataSource"/>
        <!--加载mapper文件-->
        <property name="mapperLocations" value="classpath:com/cl/ssm/mapper/*.xml"/>
        <!--定义公共的基础包-->
        <property name="typeAliasesPackage">
            <value>
                com.cl.ssm.query
                com.cl.ssm.domain
            </value>
        </property>
    </bean>

1.2.4 mapper

创建mapper接口

package com.cl.ssm.mapper;

import com.cl.ssm.domain.Book;

import java.util.List;

public interface BookMapper {

	List<Book> selectAllBooks();
}

创建mapper.xml

<?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.cl.ssm.mapper.BookMapper">
  <resultMap id="BaseResultMap" type="com.cl.ssm.domain.Book">
    <id column="book_id" jdbcType="BIGINT" property="bookId" />
    <result column="name" jdbcType="VARCHAR" property="name" />
    <result column="number" jdbcType="INTEGER" property="number" />
  </resultMap>
  <sql id="Base_Column_List">
    book_id, name, number
  </sql>
  <!-- ****************************************************** -->
  <select id="selectAllBooks" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from book
  </select>
  <!-- ****************************************************** -->
</mapper>

配置

<!--mapper扫描器的配置-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--只要扫描到该包下所有的接口，我都使用代理模式进行实现-->
        <property name="basePackage" value="com.cl.ssm.mapper"/>
    </bean>

1.2.5 service

 <!--扫描service-->
    <context:component-scan base-package="com.cl.ssm.service"/>

1.2.6 事务

<!--配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!--开启注解支持-->
    <tx:annotation-driven/>

1.3 controller

package com.cl.ssm.web.controller;

import java.util.List;

import com.cl.ssm.domain.Book;
import com.cl.ssm.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

/**
 * @description:
 * @author: chengLi
 * @createTime: 2019年11月27日 下午8:52:04
 * @history:
 * @version: v1.0
 */
@Controller
@RequestMapping("/book")
public class BookController {
	@Autowired
	private BookService bookService;

	@RequestMapping("/index")
	public ModelAndView index(ModelAndView modelAndView) {
		List<Book> books = bookService.queryAllBooks();
		modelAndView.setViewName("/book/book");
		modelAndView.addObject("books", books);
		return modelAndView;
	}

	
}

1.4 springMVC的核心配置文件

配置applicationContext-mvc.xml

1.4.1 扫描包

<!--包扫描-->
    <context:component-scan base-package="com.cl.ssm.web.controller"/>

1.4.2 静态资源放行

<!--静态资源放行-->
    <mvc:default-servlet-handler/>

1.4.3 开启springMVC注解

<!--注解支持-->
    <mvc:annotation-driven/>

1.4.4 视图解析器

<!--视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

1.5 web.xml

1.5.1 启动spring容器

<!--启动spring-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

1.5.2 启动SpringMVC容器

 <!--启动springmvc-->
    <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-mvc.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>

1.5.3 配置字符集过滤器

<!--字符集过滤器-->
    <filter>
        <filter-name>CharacterEncodingFilter</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>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

1.6 jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
${books}
</body>
</html>