1.1 原始方式整合
1. 准备工作
创建数据表
CREATE DATABASE ssm;CREATE TABLE account(id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(100),money DOUBLE(7,2))
2. 创建Maven工程
new module下一步，配置模块信息project structureFacets 👉 + 👉 web选择对应文件修改目录完善项目目录3. 导入Maven坐标
<dependencies><!--spring相关--><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.0.5.RELEASE</version></dependency><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.8.7</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.0.5.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.0.5.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>5.0.5.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.0.5.RELEASE</version></dependency><!--servlet和jsp--><dependency><groupId>javax.servlet</groupId><artifactId>servlet-api</artifactId><version>2.5</version></dependency><dependency><groupId>javax.servlet.jsp</groupId><artifactId>jsp-api</artifactId><version>2.0</version></dependency><!--mybatis相关--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.5</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.1</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.22</version></dependency><dependency><groupId>c3p0</groupId><artifactId>c3p0</artifactId><version>0.9.1.2</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><dependency><groupId>jstl</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency></dependencies>
4. 编写实体类
package com.itheima.domain;public class Account {private Integer id;private String name;private Double money;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public Double getMoney() {return money;}public void setMoney(Double money) {this.money = money;}@Overridepublic String toString() {return "Account{" +"id=" + id +", name='" + name + '\'' +", money=" + money +'}';}}
5. 编写Mapper接口
package com.itheima.mapper;import com.itheima.domain.Account;import java.util.List;public interface AccountMapper {// 保存账户信息public void save(Account account);// 查询账户信息public List<Account> findAll();}
6. 编写Service接口
package com.itheima.service;import com.itheima.domain.Account;import java.io.IOException;import java.util.List;public interface AccountService {// 保存账户数据public void save(Account account) throws IOException;// 查询账户数据public List<Account> findAll();}
7. 编写Service接口实现
@Service("accountService")public class AccountServiceImpl implements AccountService {public void save(Account account) {SqlSession sqlSession = MyBatisUtils.openSession();AccountMapper accountMapper = sqlSession.getMapper(AccountMapper.class);accountMapper.save(account);mit();sqlSession.close();}public List<Account> findAll() {SqlSession sqlSession = MyBatisUtils.openSession();AccountMapper accountMapper = sqlSession.getMapper(AccountMapper.class);return accountMapper.findAll();}}
8. 编写Controller
@Controllerpublic class AccountController {@Autowiredprivate AccountService accountService;@RequestMapping("/save")@ResponseBodypublic String save(Account account){accountService.save(account);return "save success";}@RequestMapping("/findAll")public ModelAndView findAll(){ModelAndView modelAndView = new ModelAndView();modelAndView.setViewName("accountList");modelAndView.addObject("accountList",accountService.findAll());return modelAndView;}}
9. 编写添加页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><title>Title</title></head><body><h1>保存账户信息表单</h1><form action="${pageContext.request.contextPath}/save.action" method="post">用户名称<input type="text" name="name"><br/>账户金额<input type="text" name="money"><br/><input type="submit" value="保存"><br/></form></body></html>
10. 编写列表页面
<table border="1"><tr><th>账户id</th><th>账户名称</th><th>账户金额</th></tr><c:forEach items="${accountList}" var="account"><tr><td>${account.id}</td><td>${account.name}</td><td>${account.money}</td></tr></c:forEach></table>
11. 编写相应配置文件(文件参考目录：素材/配置文件)
Spring配置文件：applicationContext.xmlSprngMVC配置文件：spring-mvc.xmlMyBatis映射文件：AccountMapper.xmlMyBatis核心文件：sqlMapConfig.xml数据库连接信息文件：jdbc.propertiesWeb.xml文件：web.xml日志文件：log4j.propertiesjdbc.properties：存储数据库连接信息
jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true & characterEncoding=UTF-8 & serverTimezone=Asia/Shanghaijdbc.username=rootjdbc.password=131415
log4j.properties：日志记录
### direct log messages to stdout ###log4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.Target=System.errlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n### direct messages to file mylog.log ###log4j.appender.file=org.apache.log4j.FileAppenderlog4j.appender.file.File=c:/mylog.loglog4j.appender.file.layout=org.apache.log4j.PatternLayoutlog4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n### set log levels - for more verbose logging change 'info' to 'debug' ###log4j.rootLogger=debug, stdout
web.xml
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns="/xml/ns/javaee"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/javaee /xml/ns/javaee/web-app_4_0.xsd"version="4.0"><!--Spring监听器：Spring与Web结合--><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><!--SpringMVC前端控制器：SpringMVC与Web结合--><servlet><servlet-name>DispatcherServlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring-mvc.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>DispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping><!--乱码过滤器--><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></filter><filter-mapping><filter-name>CharacterEncodingFilter</filter-name><url-pattern>/*</url-pattern></filter-mapping></web-app>
① Spring监听器：Spring与Web结合
② SpringMVC前端控制器：SpringMVC与Web结合
③ 乱码过滤器
applicationContext.xml：Spring配置文件
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:aop="/schema/aop"xmlns:tx="/schema/tx"xmlns:context="/schema/context"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd/schema/aop /schema/aop/spring-aop.xsd/schema/tx /schema/tx/spring-tx.xsd/schema/context /schema/context/spring-context.xsd"><!--组件扫描 扫描service和mapper--><context:component-scan base-package="com.itheima"><!--排除controller的扫描--><context:exclude-filter type="annotation"expression="org.springframework.stereotype.Controller"/></context:component-scan><!--加载propeties文件--><context:property-placeholder location="classpath:jdbc.properties"/><!--配置数据源信息--><bean id="dataSource" class="com.mchange.boPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/></bean><!--配置sessionFactory--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><!--加载mybatis核心文件--><property name="configLocation" value="classpath:sqlMapConfig-spring.xml"/></bean><!--扫描mapper所在的包 为mapper创建实现类--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.itheima.mapper"/></bean><!--声明式事务控制--><!--平台事务管理器--><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><!--配置事务增强--><tx:advice id="txAdvice"><tx:attributes><tx:method name="*"/></tx:attributes></tx:advice><!--事务的aop织入--><aop:config><aop:advisor advice-ref="txAdvice" pointcut="execution(* com.itheima.service.impl.*.*(..))"/></aop:config></beans>
组件扫描，主要是扫描service和mapper。要排除掉controller，因为controller主要是springMVC来控制扫描。
spring-mvc.xml：SprngMVC配置文件
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:mvc="/schema/mvc"xmlns:context="/schema/context"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans /schema/beans/spring-beans.xsd/schema/mvc /schema/mvc/spring-mvc.xsd/schema/context /schema/context/spring-context.xsd"><!--组件扫描 主要扫描controller--><context:component-scan base-package="com.itheima.controller"/><!--配置mvc注解驱动--><mvc:annotation-driven/><!--内部资源视图解析器--><bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/WEB-INF/pages/"/><property name="suffix" value=".jsp"/></bean><!--开发静态资源访问权限--><mvc:default-servlet-handler/></beans>
① 组件扫描——扫描controller
② 配置MVC注解驱动
③ 配置内部资源视图解析器，设置资源前后缀
④ 开放静态资源访问权限
AccountMapper.xml：MyBatis映射文件
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-////DTD Mapper 3.0//EN" "/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.itheima.mapper.AccountMapper"><insert id="save" parameterType="account">insert into accountvalues (#{id}, #{name}, #{money})</insert><select id="findAll" resultType="account">select *from account</select></mapper>
sqlMapConfig.xml：MyBatis核心文件
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-////DTD Config 3.0//EN" "/dtd/mybatis-3-config.dtd"><configuration><!--加载properties文件--><properties resource="jdbc.properties"/><!--定义别名--><typeAliases><!--<typeAlias type="com.itheima.domain.Account" alias="account"></typeAlias>--><package name="com.itheima.domain"/></typeAliases><!--环境--><environments default="developement"><environment id="developement"><transactionManager type="JDBC"/><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><!--<mapper resource="com/itheima/mapper/AccountMapper.xml"></mapper>--><package name="com.itheima.mapper"/></mappers></configuration>
12. 测试添加账户
13. 测试账户列表
1.2 Spring整合MyBatis
1. 整合思路
2. 将SqlSessionFactory配置到Spring容器中
<!--加载jdbc.properties--><context:property-placeholder location="classpath:jdbc.properties"/><!--配置数据源--><bean id="dataSource" class="com.mchange.boPooledDataSource"><property name="driverClass" value="${jdbc.driver}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/></bean><!--配置MyBatis的SqlSessionFactory--><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource"/><property name="configLocation" value="classpath:sqlMapConfig.xml"/></bean>
3. 扫描Mapper，让Spring容器产生Mapper实现类
<!--配置Mapper扫描--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.itheima.mapper"/></bean>
4. 配置声明式事务控制
<!--配置声明式事务控制--><bean id="transacionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><tx:advice id="txAdvice" transaction-manager="transacionManager"><tx:attributes><tx:method name="*"/></tx:attributes></tx:advice><aop:config><aop:pointcut id="txPointcut" expression="execution(* com.itheima.service.impl.*.*(..))"/><aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/></aop:config>
5. 修改Service实现类代码
@Service("accountService")public class AccountServiceImpl implements AccountService {@Autowiredprivate AccountMapper accountMapper;public void save(Account account) {accountMapper.save(account);}public List<Account> findAll() {return accountMapper.findAll();}}
