9. 都什么时候了，你还不会框架SSM整合

???需求：

???使用ssm框架完成对 account 表格的增删改查操作。

???最后，框架建成后，阿红手写了一个完整的CRUD的demo，请看第9章节···

步骤分析

1. 准备数据库和表记录
2. 创建web项目
3. 编写mybatis在ssm可单独用于环境
4. 编写spring在ssm可单独用于环境
5. spring整合mybatis
6. 编写springMVC在ssm可单独用于环境
7. spring整合springMVC

CREATE TABLE `account` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) DEFAULT NULL, `money` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; insert  into `account`(`id`,`name`,`money`) values (1,'tom',1000), (2,'jerry',1000); 

   <packaging>war</packaging>     <dependencies>         <!--    数据库连接驱动-->         <dependency>             <groupId>mysql</groupId>             <artifactId>mysql-connector-java</artifactId>             <version>5.1.47</version&t;
        </dependency>
<!--        配置数据库连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.15</version>
        </dependency>
<!--        mybatis依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.4</version>
        </dependency>
<!--        junit依赖-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

public class Account { 
        
    private Integer id;
    private String name;
    private String money;
 //省略get和set方法 
}

    /** * 查询所有信息 * @return */
     List<Account> findAll();

<?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.weihong.dao.AccountDao">
    <select id="findAll" resultType="Account">
        select * from account
    </select>
</mapper>

jdbc.properties文件：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/smd
jdbc.username=root
jdbc.password=root

SqlMapConfig.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>
<!--    加载配置文件-->
    <properties resource="jdbc.properties" />
<!--    给实体重命名，方便在sql.xml配置简单-->
    <typeAliases>
        <package name="com.weihong.domain"/>
    </typeAliases>
<!--    配置数据量连接信息-->
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    
<!--    加载映射文件-->
    <mappers>
        <package name="com.weihong.dao"/>
    </mappers>
</configuration>

public class MyTest { 
        

    @Test
    public void findAccountInfo() throws IOException { 
        
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        AccountDao accountDao = sqlSession.getMapper(AccountDao.class);
        List<Account> listAccount = accountDao.findAll();
        for (Account account : listAccount) { 
        
            System.out.println(account);
        }
// 释放资源
        sqlSession.close();

    }
}

<!--        Spring依赖 start-->
<!--        spring版本-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>
<!--        spring切面-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.13</version>
        </dependency>
<!--        spring-jdbc对jdbc进行封装 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.6.RELEASE</version>
        </dependency>
<!--        spring-tx:提供事务的支持-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.2.15.RELEASE</version>
        </dependency>
<!--        spring测试-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>
<!--        spring依赖结束 end-->

public interface AccountService { 
        

     List<Account> findAccount();

}

@Service
public class AccountServiceImpl implements AccountService { 
        
    @Override
    public List<Account> findAccount() { 
        
        System.out.println("执行了业务方法！");
        return null;
    }
}

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" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">

    <!--注解组件扫描-->
    <context:component-scan base-package="com.weihong" />

</beans>

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:applicationContext.xml")
public class SpringTest { 
        

    @Autowired
    private AccountService accountService;

    @Test
    public void test1(){ 
        
        accountService.findAccount();
    }
}

将mybatis接口代理对象的创建权交给spring管理，我们就可以把dao的代理对象注入到service中，此时也就完成了spring与mybatis的整合了。

也就是摒弃这几行代码，通过代理对象注入到service中。

     <!--spring整合mybatis        -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>

注意：此时可以将mybatis主配置文件删除。

@Service
public class AccountServiceImpl implements AccountService { 
        
    @Autowired
    private AccountDao accountDao;
    @Override
    public List<Account> findAccount() { 
        
        System.out.println("开始查询数据库信息！");
        List<Account> list = accountDao.findAll();
        return list;
    }

}

访问到controller里面的方法查询所有账户，并跳转到list.jsp页面进行列表展示

        <!-- spring mvc 依赖 start-->
<!-- 引入spring MVC -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.1.5.RELEASE</version>
        </dependency>
<!-- 引入jsp依赖-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.2</version>
        </dependency>
<!-- 引入spring的el表达式-->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>