ssm整合

环境搭建

数据库创建

导包

db.properties

pojo类
setter and getter
constructor

dao层

接口

mapper.xml
(绑定namespace,编写SQL)

<?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.liu.dao.BookDao">

    <insert id="addBook" parameterType="Books">
        insert into books( bookName, bookCounts, detail) values(#{bookName},#{bookCounts},#{detail})
    </insert>
    <delete id="deleteBookByID" parameterType="int">
        delete from books where bookID= #{bookId}
    </delete>

    <update id="updateBook" parameterType="books">
        update books
        set  bookName=#{bookName},
             bookCounts= #{bookCounts},
             detail=#{detail}
        where bookID=#{bookID};
    </update>
    <select id="queryBookById" parameterType="int" resultType="books">
        select *
        from books
        where bookID= #{bookId};
    </select>

    <select id="queryAllBooks" resultType="Books">
        select *
        from books;
    </select>

</mapper>

mybatis-config.xml

业务层service

service接口

service实现类

public class BookServiceImpl implements BookService{
    //调dao 层
    private BookDao bookDao;

    //set方法，让spring来托管
    public void setBookDao(BookDao bookDao) {
        this.bookDao = bookDao;
    }

    @Override
    public int addBook(Books books) {
        return bookDao.addBook(books);
    }

    @Override
    public int deleteBookById(int id) {
        return bookDao.deleteBookById(id);
    }

    @Override
    public int updateBook(Books books) {
        return bookDao.updateBook(books);
    }

    @Override
    public Books queryBookById(int id) {
        return bookDao.queryBookById(id);
    }

    @Override
    public List<Books> queryAllBooks() {
        return bookDao.queryAllBooks();
    }

Spring

applicationContext.xml
spring-dao.xml
(连接数据库，数据库连接池配置，sqlSessionFactory,dao扫描注入)

    <!-- 1.关联数据库文件 -->
    <context:property-placeholder location="classpath:db.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-config.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接口包 动态的实现了将dao接口注入到容器中-->
        <property name="basePackage" value="com.liu.dao"/>   <!--不用写impl-->
    </bean>

spring-service.xml
(扫描service层注入，创建serviceImpl对象，配置事务)

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

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

Spring MVC层
(注解驱动，静态资源过滤，扫描controller层，视图解析器)

    <!--1.注解驱动-->
    <mvc:annotation-driven/>
    <!--2.静态资源过滤-->
    <mvc:default-servlet-handler/>

    <!--3.扫描包：controller-->
    <context:component-scan base-package="com.liu.controller"/>
    <!--4.视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/jsp/"/>
        <property name="suffix" value=".jsp"/>
    </bean>

Controller层

(设置url,返回model&view)

@Controller
@RequestMapping("/book")
public class BookController {
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;
    @RequestMapping("/allBook")
    public String allBook(Model model){
        List<Books> books = bookService.queryAllBooks();
        model.addAttribute("books",books);
        return "allBook";
    }