spring+springmvc+ibatis整合注解方式实例

SpringMVC+Spring+Hibernate框架整合原理,作⽤及使⽤⽅法SSM框架是spring MVC ，spring和mybatis框架的整合，是标准的MVC模式，将整个系统划分为表现层，controller层，service层，DAO层四层使⽤spring MVC负责请求的转发和视图管理spring实现业务对象管理，mybatis作为数据对象的持久化引擎原理：SpringMVC：1.客户端发送请求到DispacherServlet（分发器）2.由DispacherServlet控制器查询HanderMapping，找到处理请求的Controller3.Controller调⽤业务逻辑处理后，返回ModelAndView4.DispacherSerclet查询视图解析器，找到ModelAndView指定的视图5.视图负责将结果显⽰到客户端Spring：我们平时开发接触最多的估计就是IOC容器，它可以装载bean（也就是我们中的类，当然也包括service dao⾥⾯的），有了这个机制，我们就不⽤在每次使⽤这个类的时候为它初始化，很少看到关键字new。

另外spring的aop，事务管理等等都是我们经常⽤到的。

Mybatis：mybatis是对jdbc的封装，它让数据库底层操作变的透明。

mybatis的操作都是围绕⼀个sqlSessionFactory实例展开的。

mybatis通过配置⽂件关联到各实体类的Mapper⽂件，Mapper⽂件中配置了每个类对数据库所需进⾏的sql语句映射。

在每次与数据库交互时，通过sqlSessionFactory拿到⼀个sqlSession，再执⾏sql命令。

使⽤⽅法：要完成⼀个功能：1. 先写实体类entity，定义对象的属性，（可以参照数据库中表的字段来设置，数据库的设计应该在所有编码开始之前）。

2. 写Mapper.xml（Mybatis），其中定义你的功能，对应要对数据库进⾏的那些操作，⽐如 insert、selectAll、selectByKey、delete、update等。

springmvc+spring+mybatis整合首先在整合这个框架的时候，想想其一般的步骤是怎样的，先有个步骤之后，不至于在后面的搞混了，这样在整合的时候也比较清晰些。

然后我们就细细的一步一步来整合。

1 创建一个Web项目。

2 导入Mybatis3、Spring4、SpringMVC4、连接数据库（我使用的数据库是mysql）的jar包。

我所用的包：spring-websocket-4.2.0.RELEASE.jar3 创建Mybatis3、Spring4、SpringMVC4、连接数据库的配置文件。

4 配置web.xml1<?xml version="1.0" encoding="UTF-8"?>2<web-app version="2.5"3xmlns="/xml/ns/javaee"4xmlns:xsi="/2001/XMLSchema-instance" 5xsi:schemaLocation="/xml/ns/javaee6/xml/ns/javaee/web-app_2_5.xsd">78<!-- 告知javaEE容器，有哪些内容需要添加到上下文中去--> 9<context-param>10<param-name>contextConfigLocation</param-name> 11<param-value>12/WEB-INF/classes/applicationContext.xml,13<!-- /WEB-INF/classes/mvc-servlet.xml -->14</param-value>15</context-param>161718<!-- 加载LOG4J -->19<context-param>20<param-name>log4jConfigLocation</param-name> 21<param-value>/WEB-INF/log4j.xml</param-value>22</context-param>2324<context-param>25<param-name>log4jRefreshInterval</param-name> 26<param-value>60000</param-value>27</context-param>2829<!-- 动态设置项目的运行路径-->30<context-param>31<param-name>webAppRootKey</param-name>32<param-value>ssm.root</param-value>33</context-param>3435<!-- 配置静态资源-->36<servlet-mapping>37<servlet-name>default</servlet-name>38<url-pattern>/static/*</url-pattern>39</servlet-mapping>404142<!-- 配置springmvc的前端控制器-->43<servlet>44<servlet-name>mvc</servlet-name>45<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>46<!-- 默认情况下：DispatcherServlet会寻找WEB-INF下，命名规范为[servlet-name]-servlet.xml文件。

Spring和MyBatis整合（注解版）1.导⼊所需要的依赖<!--MyBatis和Spring的整合包由MyBatis提供--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.0</version></dependency><!--MyBatis的核⼼jar⽂件--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.1</version></dependency>View Code2.entity实体类3.dao层接⼝4.service接⼝5.serviceimpl实现类6.Dao.xml配置7.jdbc.properties配置8.applicationContext.xml⼤配置⽂件<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:aop="/schema/aop"xmlns:context="/schema/context" xmlns:tx="/schema/tx"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans.xsd/schema/aop/schema/aop/spring-aop.xsd /schema/context /schema/context/spring-context.xsd /schema/tx http://www.springf <context:component-scan base-package="com.spring"/><!-- 配置数据源 spring内置的数据源--><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="${jdbc.driver}"></property><property name="url" value="${jdbc.url}"></property><property name="username" value="${ername}"></property><property name="password" value="${jdbc.password}"></property></bean><!-- 引⼊属性⽂件 --><context:property-placeholder location="jdbc.properties.properties"/><!-- &lt;!&ndash;注册DAO层:mapper的代理对象&ndash;&gt;<bean id="personDao"class="org.mybatis.spring.mapper.MapperFactoryBean"><property name="mapperInterface" value="com.spring.dao.PersonDao"></property><property name="sqlSessionFactory"ref="sqlSessionFactory"></property></bean>&lt;!&ndash;配置service层对象&ndash;&gt;<bean id="personService"class="com.spring.service.PersonServiceImpl"><property name="dao"ref="personDao"></property></bean>--><!-- sqlSessionFactory 创建SqlSession对象的⼯⼚ --><bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource"ref="dataSource"></property><!-- Mybatis的⼤配置⽂件 --><property name="typeAliasesPackage" value="com.spring.entity"></property><!-- 扫描sql配置⽂件:mapper需要的xml⽂件 --><property name="mapperLocations" value="classpath*:mapper/*.xml"/></bean><!-- MapperScannerConfigurer 扫描mapper⽂件扫描器 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.spring.dao"></property></bean><!-- transactionManager 事务管理器--><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource"ref="dataSource"></property></bean><!-- 事务通知--><tx:advice transaction-manager="transactionManager" id="txAdvice"><tx:attributes><!--get系列⽅法设置事务的隔离级别和传播⾏为--><tx:method name="get*" isolation="READ_COMMITTED" propagation="REQUIRED"/></tx:attributes></tx:advice></beans>View Code9.测试类结果:。

spring+springmvc+mybatis组合总结springmvc+spring+mybatis整合：1. 拷贝所需jar2. 创建spring配置⽂件(beans.xml)3. 配置数据源<bean id="dataSource" class="mons.dbcp.BasicDataSource"><property name="driverClassName" value="com.mysql.jdbc.Driver"></property><property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property><property name="username" value="root"></property><property name="password" value=""></property></bean>4.创建SqlSessionFactory实例：<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 指定数据源 --><property name="dataSource" ref="dataSource"/><!-- 指定mybatis的配置⽂件 --><property name="configLocation" value="classpath:mybatis-config.xml"/></bean><!--映射接⼝扫描mapper包下的所有xml⽂件 mapper是个包名应该是在main测试的时候才使⽤--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.liu.mapper"></property></bean>5. 配置事务<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean>6. 配置事务的传播特性<tx:advice id="txAdvice" transaction-manager="transactionManager"><tx:attributes><tx:method name="find*" read-only="true"/><tx:method name="get*" read-only="true"/><tx:method name="query*" read-only="true"/><tx:method name="add*" propagation="REQUIRED"/><tx:method name="update*" propagation="REQUIRED"/><tx:method name="del*" propagation="REQUIRED"/></tx:attributes></tx:advice>7. 配置AOP<!-- 配置AOP --><aop:config><!--配置切⾯必须要有空格 *空格 ssmy 否则会报错--><aop:config><aop:pointcut expression="execcution(*空格 ssmy.service.impl.*.*(..))" id="pointcut"/><aop:advisor advice-ref="txadvice" pointcut-ref="pointcut"/></aop:config>9. 配置DispatcherServlet<!-- 配置Spring核⼼控制器 --><servlet><servlet-name>springmvc</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class></servlet><servlet-mapping><servlet-name>springmvc</servlet-name><url-pattern>*.do</url-pattern></servlet-mapping>10. 创建springmvc-servlet.xml配置⽂件：<!-- 注解扫描器 --><context:component-scan base-package="com.liu"/><!-- 配置试图解析器 --><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"><property name="prefix" value="/"></property> <property name="suffix" value=".jsp"></property> </bean><import resource="classpath:beans.xml"/>。

主要介绍三大框架的整合，至于环境的搭建以及项目的创建可以参考其他资料。

这次整合主要用到两个配置文件：spring-mybatis.xm，包含spring和mybatis的配置文件，还有个是spring-mvc.xml的配置文件，此外有两个资源文件：jdbc.propertis和log4j.properties。

完整的目录结构如下图：本框架中用到的所有jar包都在源码中。

本测试项目中用到的是sqlserver数据库，MyEclipse 8.6和apache-tomcat-7.0.41下来逐一介绍配置文件：1、spring-mybatis.xml这个文件就是用来完成spring和mybatis的整合的。

这里面也没多少行配置，主要的就是自动扫描，自动注入，配置数据库，注释也很详细<?xml version="1.0"encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:p="/schema/p"xmlns:context="/schema/context"xmlns:mvc="/schema/mvc"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-3.1.xsd/schema/context/schema/context/spring-context-3.1.xsd/schema/mvc/schema/mvc/spring-mvc-4.0.xsd"><!-- 自动扫描 --><context:component-scan base-package="com.myProcess.study"/><!-- 引入配置文件 --><bean id="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location"value="classpath:jdbc.properties"/> </bean><bean id="dataSource"class="mons.dbcp.BasicDataSource"destroy-method="close"><property name="driverClassName"value="${driver}"/><property name="url"value="${url}"/><property name="username"value="${username}"/><property name="password"value="${password}"/><!-- 初始化连接大小 --><property name="initialSize"value="${initialSize}"></property><!-- 连接池最大数量 --><property name="maxActive"value="${maxActive}"></property><!-- 连接池最大空闲 --><property name="maxIdle"value="${maxIdle}"></property><!-- 连接池最小空闲 --><property name="minIdle"value="${minIdle}"></property><!-- 获取连接最大等待时间 --><property name="maxWait"value="${maxWait}"></property></bean><!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 --><bean id="sqlSessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource"ref="dataSource"/><!-- 自动扫描mapping.xml文件 --><property name="mapperLocations"value="classpath:com/myProcess/study/mapping/*.xml"></property></bean><!-- DAO接口所在包名，Spring会自动查找其下的类 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage"value=".hnust.dao"/><property name="sqlSessionFactoryBeanName"value="sqlSessionFactory"></property></bean><!-- (事务管理)transaction manager, use JtaTransactionManager for global tx --> <bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"ref="dataSource"/></bean></beans>2、log4j.propertieslog4j.rootLogger=INFO,Console,File#定义日志输出目的地为控制台log4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.Target=System.out#可以灵活地指定日志输出格式，下面一行是指定具体的格式yout = org.apache.log4j.PatternLayoutyout.ConversionPattern=[%c]-%m%n#文件大小到达指定尺寸的时候产生一个新的文件log4j.appender.File = org.apache.log4j.RollingFileAppender#指定输出目录log4j.appender.File.File = logs/ssm.log#定义文件最大大小log4j.appender.File.MaxFileSize = 10MB# 输出所以日志，如果换成DEBUG表示输出DEBUG以上级别日志log4j.appender.File.Threshold = ALLyout = org.apache.log4j.PatternLayoutyout.ConversionPattern =[%p][%d{yyyy-MM-ddHH\:mm\:ss}][%c]%m%n3、spring-mvc.xml主要是自动扫描控制器，视图模式，注解的启动这三个<?xml version="1.0"encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance"xmlns:p="/schema/p"xmlns:context="/schema/context"xmlns:mvc="/schema/mvc"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-3.1.xsd/schema/context/schema/context/spring-context-3.1.xsd/schema/mvc/schema/mvc/spring-mvc-4.0.xsd"><!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 --><context:component-scan base-package="com.myProcess.study.web"/><!--避免IE执行AJAX时，返回JSON出现下载文件 --><bean id="mappingJacksonHttpMessageConverter"class="org.springframework.http.converter.json.MappingJacksonHttpMessageConvert er"><property name="supportedMediaTypes"><list><value>text/html;charset=UTF-8</value></list></property></bean><!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 --><beanclass="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAd apter"><property name="messageConverters"><list><ref bean="mappingJacksonHttpMessageConverter"/><!-- JSON转换器 --></list></property></bean><!-- 定义跳转的文件的前后缀，视图模式配置--><beanclass="org.springframework.web.servlet.view.InternalResourceViewResolver"> <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个可用的url地址 --><property name="prefix"value="/WEB-INF/jsp/"/><property name="suffix"value=".jsp"/></bean><!-- 配置文件上传，如果没有使用文件上传可以不用配置，当然如果不配，那么配置文件中也不必引入上传组件包 --><bean id="multipartResolver"class="monsMultipartResolver"> <!-- 默认编码 --><property name="defaultEncoding"value="utf-8"/><!-- 文件大小最大值 --><property name="maxUploadSize"value="10485760000"/><!-- 内存中的最大值 --><property name="maxInMemorySize"value="40960"/></bean></beans>4、web.xml这里面对spring-mybatis.xml的引入以及配置的spring-mvc的Servlet就是为了完成SSM整合，之前2框架整合不需要在此处进行任何配置。

spring与ibatis框架整合问题：spring与ibatis框架整合回答：Spring和Ibatis框架整合的思路与spring和hibernate框架的整合思路基本一致。

步骤一：新建立一个项目。

步骤二：为该项目添加spring的应用环境。

步骤三：导入Ibatis的必须JAR包以及数据库JAR包。

步骤四：新建实体Bean。

如下：package cn.test.entity;import java.io.Serializable;/*** @author Administrator**学生实体Bean**/public class Student implements Serializable/****/private static final long serialVersionUID = 1L; private Integer id;private String studentname;private Integer studentage;private String studentaddress;public Integer getId()return id;public void setId(Integer id)this.id = id;public String getStudentname()return studentname;public void setStudentname(String studentname) this.studentname = studentname;public Integer getStudentage()return studentage;public void setStudentage(Integer studentage) this.studentage = studentage;public String getStudentaddress()return studentaddress;public void setStudentaddress(String studentaddress)this.studentaddress = studentaddress;步骤五：新建相应的Bean的配置文件。

本文主要介绍使用注解方式配置的spring mvc，包括数据访问层的实现web.xml配置：<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="/2001/XMLSchema-instance" xmlns="http:// /xml/ns/javaee" xmlns:web="/xml/ns/javaee/web-ap p_2_5.xsd" xsi:schemaLocation="/xml/ns/javaee http://java.su /xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5"><display-name>s3h3</display-name><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:applicationContext*.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</l istener-class></listener><servlet><servlet-name>spring</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servle t-class><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>spring</servlet-name> <!-- 这里在配成spring,下边也要写一个名为spring-servlet.xml的文件，主要用来配置它的controller --><url-pattern>*.do</url-pattern></servlet-mapping><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list></web-app>spring-servlet,主要配置controller的信息<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance" xmlns:p="http:// /schema/p"xmlns:context="/schema/context"xsi:schemaLocation="/schema/beans http://www. /schema/beans/spring-beans-3.0.xsd/schema/aop http://www.springframework.o rg/schema/aop/spring-aop-3.0.xsd/schema/tx http://www.springframework.or g/schema/tx/spring-tx-3.0.xsd/schema/context http://www.springframewo /schema/context/spring-context-3.0.xsd"><context:annotation-config /><!-- 把标记了@Controller注解的类转换为bean --><context:component-scan base-package="com.mvc.controller"/> <!-- 启动Spring MVC的注解功能，完成请求和注解POJO的映射 --><bean class="org.springframework.web.servlet.mvc.annotation.AnnotationM ethodHandlerAdapter"/><!-- 对模型视图名称的解析，即在模型视图名称添加前后缀 --><bean class="org.springframework.web.servlet.view.InternalResourceView Resolver"p:prefix="/WEB-INF/view/" p:suffix=".jsp"/><bean id="multipartResolver"class="monsMultipartRe solver"p:defaultEncoding="utf-8"/></beans>applicationContext.xml代码<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:aop="/schema/aop" xmlns:context="http:// /schema/context"xmlns:p="/schema/p" xmlns:tx="http://www.sprin /schema/tx"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/schema/beans http://www.springframewo /schema/beans/spring-beans-3.0.xsd/schema/context http://www.springframework.o rg/schema/context/spring-context-3.0.xsd/schema/aop /s chema/aop/spring-aop-3.0.xsd/schema/tx /sc hema/tx/spring-tx-3.0.xsd"><context:annotation-config /><context:component-scan base-package="com.mvc"/><!-- 自动扫描所有注解该路径 --><context:property-placeholder location="classpath:/hibernate.properties "/><bean id="sessionFactory"class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFacto ryBean"><property name="dataSource" ref="dataSource"/><property name="hibernateProperties"><props><prop key="hibernate.dialect">${dataSource.dialect}</prop><prop key="hibernate.hbm2ddl.auto">${dataSource.hbm2ddl.auto}</prop><prop key="hibernate.hbm2ddl.auto">update</prop></props></property><property name="packagesToScan"><list><value>com.mvc.entity</value><!-- 扫描实体类，也就是平时所说的model --></list></property></bean><bean id="transactionManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory"/><property name="dataSource" ref="dataSource"/></bean><bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName" value="${dataSource.driverClassName} "/><property name="url" value="${dataSource.url}"/><property name="username" value="${ername}"/><property name="password" value="${dataSource.password}"/></bean><!-- Dao的实现 --><bean id="entityDao" class="com.mvc.dao.EntityDaoImpl"><property name="sessionFactory" ref="sessionFactory"/></bean><tx:annotation-driven transaction-manager="transactionManager"/><tx:annotation-driven mode="aspectj"/><aop:aspectj-autoproxy/></beans>hibernate.properties数据库连接配置dataSource.password=123ername=rootdataSource.databaseName=testdataSource.driverClassName=com.mysql.jdbc.DriverdataSource.dialect=org.hibernate.dialect.MySQL5DialectdataSource.serverName=localhost:3306dataSource.url=jdbc:mysql://localhost:3306/testdataSource.properties=user=${ername};databaseName=${dataSource.d atabaseName};serverName=${dataSource.serverName};password=${dataSource.passwor d}dataSource.hbm2ddl.auto=update配置已经完成，下面开始例子先在数据库建表，例子用的是mysql数据库CREATE TABLE `test`.`student` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(45) NOT NULL,`psw` varchar(45) NOT NULL,PRIMARY KEY (`id`))建好表后，生成实体类package com.mvc.entity;import java.io.Serializable;import javax.persistence.Basic;import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.GenerationType;import javax.persistence.Id;import javax.persistence.Table;@Entity@Table(name = "student")public class Student implements Serializable {private static final long serialVersionUID = 1L;@Id@Basic(optional = false)@GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id", nullable = false)private Integer id;@Column(name = "name")private String user;@Column(name = "psw")private String psw;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUser() {return user;}public void setUser(String user) {er = user;}public String getPsw() {return psw;}public void setPsw(String psw) {this.psw = psw;}}Dao层实现package com.mvc.dao;import java.util.List;public interface EntityDao {public List<Object> createQuery(final String queryString);public Object save(final Object model);public void update(final Object model);public void delete(final Object model);}package com.mvc.dao;import java.util.List;import org.hibernate.Query;import org.springframework.orm.hibernate3.HibernateCallback;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;public class EntityDaoImpl extends HibernateDaoSupport implements EntityDao {public List<Object> createQuery(final String queryString) { return (List<Object>) getHibernateTemplate().execute(new HibernateCallback<Object>() {public Object doInHibernate(org.hibernate.Session sessio n)throws org.hibernate.HibernateException {Query query = session.createQuery(queryString);List<Object> rows = query.list();return rows;}});}public Object save(final Object model) {return getHibernateTemplate().execute(new HibernateCallback<Object>() {public Object doInHibernate(org.hibernate.Session sessio n)throws org.hibernate.HibernateException {session.save(model);return null;}});}public void update(final Object model) {getHibernateTemplate().execute(new HibernateCallback<Object>() { public Object doInHibernate(org.hibernate.Session session)throws org.hibernate.HibernateException {session.update(model);return null;}});}public void delete(final Object model) {getHibernateTemplate().execute(new HibernateCallback<Object>() { public Object doInHibernate(org.hibernate.Session session)throws org.hibernate.HibernateException {session.delete(model);return null;}});}}Dao在applicationContext.xml注入<bean id="entityDao" class="com.mvc.dao.EntityDaoImpl"><property name="sessionFactory" ref="sessionFactory"/></bean>Dao只有一个类的实现，直接供其它service层调用，如果你想更换为其它的Dao实现，也只需修改这里的配置就行了。

SpringBoot整合mybatis使⽤注解实现动态Sql、参数传递等常⽤操作（实现⽅法）前⾯介绍了Spring Boot 整合mybatis 使⽤注解的⽅式实现数据库操作，介绍了如何⾃动⽣成注解版的mapper 和pojo类。

接下来介绍使⽤mybatis 常⽤注解以及如何传参数等数据库操作中的常⽤操作。

其实，mybatis 注解⽅式和 XML配置⽅式两者的使⽤基本上相同，只有在构建 SQL 脚本有所区别，所以这⾥重点介绍两者之间的差异，以及增删改查，参数传递等注解的常⽤操作。

注解介绍mybatis 注解⽅式的最⼤特点就是取消了Mapper的XML配置，具体的 SQL 脚本直接写在 Mapper 类或是 SQLProvider 中的⽅法动态⽣成。

mybatis 提供的常⽤注解有：@Insert 、@Update 、@Select、 @Delete等标签，这些注解其实就是 MyBatis 提供的来取代其XML配置⽂件的。

1、@Select 注解@Select，主要在查询的时候使⽤，查询类的注解，⼀般简单的查询可以使⽤这个注解。

@Select({"select","id, company_id, username, password, nickname, age, sex, job, face_image, province, ","city, district, address, auth_salt, last_login_ip, last_login_time, is_delete, ","regist_time","from sys_user","where id = #{id,jdbcType=VARCHAR}"})@Results({@Result(column="id", property="id", jdbcType=JdbcType.VARCHAR, id=true),@Result(column="company_id", property="companyId", jdbcType=JdbcType.VARCHAR),@Result(column="face_image", property="faceImage", jdbcType=JdbcType.VARCHAR),@Result(column="auth_salt", property="authSalt", jdbcType=JdbcType.VARCHAR),@Result(column="last_login_ip", property="lastLoginIp", jdbcType=JdbcType.VARCHAR),@Result(column="last_login_time", property="lastLoginTime", jdbcType=JdbcType.TIMESTAMP),@Result(column="is_delete", property="isDelete", jdbcType=JdbcType.INTEGER),@Result(column="regist_time", property="registTime", jdbcType=JdbcType.TIMESTAMP)})User selectByPrimaryKey(String id);注意：如果是多个参数，需要将 #后⾯的参数和传⼊的变量名保持⼀致。

Spring整合MyBatis-纯注解形式（最简）Spring整合MyBatis-纯注解形式(最简)前提: 整合MyBatis使⽤Idea创建Maven⼯程, 下图为⼯程⽬录结构1. 导⼊Maven⼯程相关的坐标 - pom.xml<?xml version="1.0" encoding="UTF-8"?><project xmlns="/POM/4.0.0"xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/POM/4.0.0 /xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.xxx</groupId><artifactId>spring-mybatis02-zh</artifactId><version>1.0</version><!--指定java1.8版本--><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><piler.source>1.8</piler.source><piler.target>1.8</piler.target></properties><dependencies><!--MyBatis坐标--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.5.3</version></dependency><!--Mybatis-spring整合坐标--><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.3.0</version></dependency><!--druid连接池--><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.1.16</version></dependency><!--MySQL连接坐标--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.47</version></dependency><!--spring坐标--><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.1.9.RELEASE</version></dependency><!--Spring-jdbc--><dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>5.1.9.RELEASE</version></dependency><!--Junit-单元测试坐标--><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version></dependency><!--Junit-spring的test--><dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>5.1.9.RELEASE</version></dependency></dependencies></project>View Code2. 创建jdbc的配置⽂件 - jdbc.propertiesjdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/spring_dbername=rootjdbc.password=rootView Code3. config - SpringConfig.javapackage com.xxx.config;import ponentScan;import org.springframework.context.annotation.Configuration;import org.springframework.context.annotation.Import;import org.springframework.context.annotation.PropertySource;/*** @author : longChuanJiang* @date : Created in 2020/8/24 14:07*/@Configuration@ComponentScan(value = "com.xxx")@PropertySource("classpath:jdbc.properties")@Import({JdbcConfig.class, MyBatisConfig.class})public class SpringConfig {/*###########-Spring核⼼配置类详解-###########1. 开启Spring注解扫描器, 扫描Spring可识别的注解@ComponentScan(value = "com.xxx")2. 加载jdbc配置⽂件@PropertySource("classpath:jdbc.properties")3. 导⼊JdbcConfig和MyBatisConfig的配置类@Import({JdbcConfig.class, MyBatisConfig.class})*/}View Code4. config - JdbcConfig.javapackage com.xxx.config;import com.alibaba.druid.pool.DruidDataSource;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import javax.sql.DataSource;/*** @author : longChuanJiang* @date : Created in 2020/8/24 14:06*/public class JdbcConfig {@Value("${jdbc.driver}")private String driver;@Value("${jdbc.url}")private String url;@Value("${ername}")private String username;@Value("${jdbc.password}")private String password;@Beanpublic DataSource getDataSource() {DruidDataSource ds = new DruidDataSource();ds.setDriverClassName(driver);ds.setUrl(url);ds.setUsername(username);ds.setPassword(password);return ds;}}View Code5. config - MyBatisConfig.javapackage com.xxx.config;import org.mybatis.spring.SqlSessionFactoryBean;import org.mybatis.spring.mapper.MapperScannerConfigurer;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Value;import org.springframework.context.annotation.Bean;import ponent;import javax.sql.DataSource;/*** @author : longChuanJiang* @date : Created in 2020/8/24 14:07*/public class MyBatisConfig {/*** 获取数据源** @param dataSource 数据源* @return数据源*/@Beanpublic SqlSessionFactoryBean getSqlSessionFactoryBean(@Autowired DataSource dataSource) { SqlSessionFactoryBean ssfb = new SqlSessionFactoryBean();ssfb.setDataSource(dataSource);// 设置实体类的别名路径ssfb.setTypeAliasesPackage("com.xxx.domain");return ssfb;}/*** 注册扫描器: 扫描包下⾯的mapper接⼝*/@Beanpublic MapperScannerConfigurer getMapperScannerConfigurer() {MapperScannerConfigurer msc = new MapperScannerConfigurer();// 设置MyBatis的Mapper接⼝路径msc.setBasePackage("com.xxx.dao");return msc;}}View Code6. dao - AccountDao.java(接⼝)package com.xxx.dao;import com.xxx.domain.Account;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import ponent;import java.util.List;/*** @author longChuanJiang*/@Componentpublic interface AccountDao {@Insert("insert into account(name,money)values(#{name},#{money})")void save(Account account);@Delete("delete from account where id = #{id} ")void delete(Integer id);@Update("update account set name = #{name} , money = #{money} where id = #{id} ") void update(Account account);@Select("select * from account")List<Account> findAll();@Select("select * from account where id = #{id} ")Account findById(Integer id);}View Code7. doamin - Account.javapackage com.xxx.domain;import java.io.Serializable;public class Account implements Serializable {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) { = 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 +'}';}}View Code8. service - AccountService.java(接⼝)package com.xxx.service;import com.xxx.domain.Account;import java.util.List;public interface AccountService {void save(Account account);void delete(Integer id);void update(Account account);List<Account> findAll();Account findById(Integer id);}View Code9. service.impl - AccountServiceImpl.javapackage com.xxx.service.impl;import com.xxx.dao.AccountDao;import com.xxx.domain.Account;import com.xxx.service.AccountService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.annotation.Bean;import org.springframework.stereotype.Service;import java.util.List;/*** @author longChuanJiang*/@Service("accountService")public class AccountServiceImpl implements AccountService {@Autowiredprivate AccountDao accountDao;@Overridepublic void save(Account account) {accountDao.save(account);}@Overridepublic void update(Account account) {accountDao.update(account);}@Overridepublic void delete(Integer id) {accountDao.delete(id);}@Overridepublic Account findById(Integer id) {return accountDao.findById(id);}@Overridepublic List<Account> findAll() {return accountDao.findAll();}}View Code10. 数据库源码 - spring-db.sql/*Navicat Premium Data TransferSource Server : localMySQLSource Server Type : MySQLSource Server Version : 50729Source Host : localhost:3306Source Schema : spring_dbTarget Server Type : MySQLTarget Server Version : 50729File Encoding : 65001Date: 24/08/2020 17:30:33*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS =0;-- ------------------------------ Table structure for account-- ----------------------------DROP TABLE IF EXISTS `account`;CREATE TABLE `account` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`money` double(255, 30) NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT =5CHARACTER SET= utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ------------------------------ Records of account-- ----------------------------INSERT INTO `account` VALUES (1, '张三', 24.990000000000000000000000000000);INSERT INTO `account` VALUES (2, '赵四', 26.120000000000000000000000000000);INSERT INTO `account` VALUES (3, '王五', 19555.555000000000000000000000000000);INSERT INTO `account` VALUES (4, 'jock', 193.222000000000000000000000000000);SET FOREIGN_KEY_CHECKS =1;View Code11. 测试源码 - AccountServiceTest.javapackage com.xxx.service;import com.xxx.config.SpringConfig;import com.xxx.domain.Account;import com.xxx.service.AccountService;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import java.util.List;/*** @author : longChuanJiang* @date : Created in 2020/8/24 14:43*/@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(classes = SpringConfig.class)public class AccountServiceTest {@Autowiredprivate AccountService accountService;@Testpublic void findAllTest(){List<Account> all = accountService.findAll();System.out.println("all = " + all);}@Testpublic void findByIdTest(){Account ac = accountService.findById(4);System.out.println("ac = " + ac);}@Testpublic void saveTest(){Account account = new Account();account.setName("jock");account.setMoney(193.222);accountService.save(account);findAllTest();}}View Code。

Ibatis,Spring整合（注解⽅式注⼊）${原来姹紫嫣红开遍，似这般都付与扣钉⼋哥}<?xml version="1.0" encoding="UTF-8"?><beans xmlns="/schema/beans"xmlns:xsi="/2001/XMLSchema-instance" xmlns:p="/schema/p"xmlns:context="/schema/context"xmlns:aop="/schema/aop" xmlns:tx="/schema/tx"xsi:schemaLocation="/schema/beans/schema/beans/spring-beans-2.5.xsd/schema/tx/schema/tx/spring-tx-2.5.xsd/schema/aop/schema/aop/spring-aop-2.5.xsd/schema/context/schema/context/spring-context-2.5.xsd"><!-- ⾃动扫描Bean --><context:component-scan base-package="com.tq365"/><!-- 强制使⽤CGLIB代理 --><aop:aspectj-autoproxy proxy-target-class="true"/><!-- DataSource数据源 --><bean id="dataSource" class="mons.dbcp.BasicDataSource"destroy-method="close"><property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property><property name="url"><value>jdbc:mysql://localhost:3306/ibatisorm</value></property><property name="username"><value>root</value></property><property name="password"><value>root</value></property></bean><!-- Spring iBatis SqlMapClient --><bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"><property name="configLocation" value="WEB-INF/sqlmap-config.xml"/><property name="dataSource" ref="dataSource"/></bean><!--事务管理DataSourceTransactionManager--><bean id="txManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><!--启动spring注解功能--><tx:annotation-driven transaction-manager="txManager" /> <aop:config> <aop:pointcut id="baseServiceMethods" expression="execution(* com.tq365.samples.ibatis.dao.*.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="baseServiceMethods" /> </aop:config><aop:aspectj-autoproxy /> <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="select*" read-only="true" propagation="REQUIRED" /> <tx:method name="find*" read-only="true" propagation="REQUIRED" /> <tx:methodname="save*" propagation="REQUIRED" isolation="REPEATABLE_READ" /> <tx:method name="update*" propagation="REQUIRED" isolation="REPEATABLE_READ" /> <!-- <tx:method name="add*" propagation="REQUIRED" isolation="REPEATABLE_READ" /> --> <tx:method name="delete*" propagation="REQUIRED" isolation="REPEATABLE_READ" /> </tx:attributes> </tx:advice></beans><?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMapConfig PUBLIC "-////DTD SQL Map Config 2.0//EN" "/dtd/sql-map-config-2.dtd"><sqlMapConfig><sqlMap resource="com/tq365/sqlMap/User.xml"/></sqlMapConfig>User.xml<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap PUBLIC "-////DTD SQL Map 2.0//EN" "/dtd/sql-map-2.dtd"> <sqlMap namespace="User"><typeAlias alias="User" type="er"/><resultMap id="UserResult" class="User"><result property="id" column="id"/><result property="username" column="username"/><result property="address" column="address"/><result property="userpwd" column="userpwd"/></resultMap><insert id="addUser">insert user(username,userpwd,address)values(#username#,#userpwd#,#address#)</insert><select id="findUser" resultMap="UserResult">select * from user WHERE username=#username# and userpwd=#userpwd#</select><select id="findUserById" resultMap="UserResult">select * from user WHERE id=#id#</select><!-- User表内记录总条数 --><select id="getTotalCount" resultClass="int">select count(*) from user</select><select id="findAllPageUser" resultMap="UserResult">select * from user limit #start#,5</select></sqlMap>UserDAO.java接⼝package com.tq365.samples.ibatis.dao;import org.springframework.stereotype.Repository;import er;import com.tq365.sqmples.util.Pages;/*** UserDAO 接⼝*/@Repositorypublic interface UserDAO {/*** 通过ID查询* @param id* @return*/public User findUserById(int id);/*** 通过ID删除* @param id*/public void deleteUserById(int id);public void addUser(User user);/*** 查询指定的User对象* @param user* @return*/public User findUser(User user);/*** 通过⽤户名分页查询* @param username* @return*/public Pages<User> findUsersByUsername(String username,int pageNo);/*** 所有User对象分页* @param pageNo* @return*/public Pages<User> findAllPageUser(int pageNo);}BaseDao.javapackage com.tq365.samples.ibatis.dao;import javax.annotation.PostConstruct;import javax.annotation.Resource;import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;import com.ibatis.sqlmap.client.SqlMapClient;/*** BaseDao,Dao需继承此Dao* @author archie2010* since 2011-3-3 下午02:52:36*/public class BaseDao extends SqlMapClientDaoSupport{@Resource(name = "sqlMapClient")private SqlMapClient sqlMapClient;@PostConstructpublic void initSqlMapClient(){super.setSqlMapClient(sqlMapClient);}}@PostConstruct注解在⽅法上加上注解@PostConstruct，这个⽅法就会在Bean初始化之后被Spring容器执⾏（注：Bean初始化包括，实例化Bean，并装配Bean的属性（依赖注⼊））。