Mybatis----整合Spring ---配置

1,spring整合mybatis的意思是原有的mybatis中的配置内容,合并到spring中。:如,连接数据库等。

 2,spring整合mybatis的步骤

     (1) 原来mybatis中提供sqlsession对象的一个工具:sqlsessionFactory

               在spring 中 sqlsessionFactoryBean

    在spring配置文件里头配置一个
    <!--配置工厂bean-->

    <bean id="sesiionFactroy" class="org.mybatis.spring.SqlSessionFactoryBean">

      <property name="dataSource" ref="dataSource"></property>

       <property name="configLocation" value="classpath:mybatis-config.xml"></property>
    </bean>
(2)映射文件mapper.xml

    dao 层的配置,因为dao层没有实现类,但是我们有dao层的xml文件。使用
    MapperScannerConfigurer类 去扫描 dao' 层xml文件。

          在sprng中配置如下:

   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
     <property name="basePackage" value="cn.happy.spring16ssm.dao"></property>
     <property name="sqlSessionFactoryBeanName" value="sesiionFactroy"></property>
    </bean>
3,案列:添加图书的功能(来了解spring整合mybatis的步骤)
  (1)数据库
     

        

          


(2)实体层
    

      

package cn.happy.spring16ssm.entity;

public class Book {
    private Integer bookid;
    private String bookname;
    private Integer bookprice;

    public Integer getBookid() {
        return bookid;
    }

    public void setBookid(Integer bookid) {
        this.bookid = bookid;
    }

    public String getBookname() {
        return bookname;
    }

    public void setBookname(String bookname) {
        this.bookname = bookname;
    }

    public Integer getBookprice() {
        return bookprice;
    }

    public void setBookprice(Integer bookprice) {
        this.bookprice = bookprice;
    }
}
  (3)dao层
    

      IBookDAO接口

package cn.happy.spring16ssm.dao;

import cn.happy.spring16ssm.entity.Book;

public interface IBookDAO {
    public int addbook(Book book);
}

      IBookDAO.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">
<!--映射文件的根节点
  namespace
-->
<mapper namespace="cn.happy.spring16ssm.dao.IBookDAO">
    <insert id="addbook">
        INSERT INTO book(bookname,bookprice) VALUES (#{bookname},#{bookprice})
    </insert>
</mapper>
   
  (4)service层
    

      IBookService

package cn.happy.spring16ssm.service;

import cn.happy.spring16ssm.entity.Book;

public interface IBookService {
    public int addbook(Book book);
}

    IBookServiceImpl

    

import cn.happy.spring16ssm.entity.Book;
import cn.happy.spring16ssm.service.IBookService;

public class IBookServiceImpl implements IBookService {
    //植入dao层
    IBookDAO dao;
    public int addbook(Book book) {
        return dao.addbook(book);
    }

    public IBookDAO getDao() {
        return dao;
    }

    public void setDao(IBookDAO dao) {
        this.dao = dao;
    }
}
    
  (5)spring配置文件applicationContest.xml文件
    
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
      http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
       http://www.springframework.org/schema/aop
      http://www.springframework.org/schema/aop/spring-aop.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
">

   <!--使用propertyPlaceholder-->
   <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
      <property name="location" value="classpath:jdbc.properties"/>
   </bean>
   <!--bncp的驱动-->
   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="url" value="${jdbc.url}"></property>
      <property name="driverClassName" value="${jdbc.driverClassName}"></property>
      <property name="username" value="${jdbc.username}"></property>
      <property name="password" value="${jdbc.password}"></property>
   </bean>
   <!--配置工厂bean-->
   <bean id="sesiionFactroy" class="org.mybatis.spring.SqlSessionFactoryBean">
      <property name="dataSource" ref="dataSource"></property>
      <property name="configLocation" value="classpath:mybatis-config.xml"></property>
   </bean>
   <!--dao-->
   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
      <property name="basePackage" value="cn.happy.spring16ssm.dao"></property>
      <property name="sqlSessionFactoryBeanName" value="sesiionFactroy"></property>
   </bean>
   <!--service-->
   <bean id="bookService" class="cn.happy.spring16ssm.service.impl.IBookServiceImpl">
      <property name="dao" ref="IBookDAO"></property>
   </bean>
   <!--平台事务管理器-->
   <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
      <!--注入什么东西 事务对象的来源,一定是Connection -->
      <property name="dataSource" ref="dataSource"></property>
   </bean>
   <!--事务方式2:使用AspectJaop 实现事务-->
   <tx:advice id="txAdvice" transaction-manager="transactionManager">
      <tx:attributes>
         <tx:method name="addbook" isolation="DEFAULT" propagation="REQUIRED"/>
      </tx:attributes>
   </tx:advice>
   <aop:config>
      <!--设置切点point-->
      <aop:pointcut id="mypoint" expression="execution(* *..spring16ssm.service.*.*(..))"/>
      <!--设置顾问-->
      <aop:advisor advice-ref="txAdvice" pointcut-ref="mypoint"></aop:advisor>
   </aop:config>
</beans>
 
 
  (6)mybatis配置文件 mybatis-cinfig.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="jdbc1.properties"></properties>-->
    <typeAliases>
        <package name="cn.happy.spring16ssm.entity"></package>
    </typeAliases>
<!--下面的papper配置节点可以省略-->
    <mappers>
        <package name="cn.happy.spring16ssm.dao"></package>
    </mappers>
</configuration>
    
  (7)jdbc.properties文件
    
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///mynews?characterEncoding=UTF-8
jdbc.username=root
jdbc.password=
 
 

  


  (8)pom.xml 依赖文件
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <parent>
        <artifactId>MyBatis01</artifactId>
        <groupId>cn.happy</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>spring01</artifactId>
    <packaging>war</packaging>
    <name>spring01 Maven Webapp</name>
    <url>http://maven.apache.org</url>
    <dependencies>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>3.8.1</version>
            <scope>test</scope>
        </dependency>
        <!--引入beans节点-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-beans</artifactId>
            <version>4.2.3.RELEASE</version>
        </dependency>
        <!--context-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.2.2.RELEASE</version>
        </dependency>
        <!--后加的依赖-->
        <dependency>
            <groupId> org.aspectj</groupId >
            <artifactId> aspectjweaver</artifactId >
            <version> 1.8.7</version >
        </dependency>


        <!--spring JDBC-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.2.0.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>org.wisdom-framework</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.34_1</version>
        </dependency>


        <!--dbcp 数据源-->
        <!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.4</version>
        </dependency>
        <!--c3p0-->
        <!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
        <!-- https://mvnrepository.com/artifact/c3p0/c3p0 -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>

        <!--alibaba datasource-->
        <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.18</version>
        </dependency>

        <!--Mybatis+Spring整合-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.2.0</version>
        </dependency>

        <!--mybatis jar包-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.2</version>
        </dependency>

        <!--javaee的jar包-->
        <dependency>
            <groupId>javaee</groupId>
            <artifactId>javaee-api</artifactId>
            <version>5</version>
        </dependency>

        <!--jsp进行循环迭代数据,使用jstl-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
            <scope>runtime</scope>
        </dependency>

        <!-- Spring整合JavaWeb的包 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>4.3.9.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.junit.jupiter</groupId>
            <artifactId>junit-jupiter-api</artifactId>
            <version>RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.18</version>
        </dependency>

    </dependencies>
    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
            </resource>
        </resources>
    </build>
</project>
 
 

  (9)不要忘了pom.xml文件里头的 build 节点的配置和 mybatis-spring 的依赖

                

  <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.*</include>
                </includes>
            </resource>
        </resources>
    </build>

      依赖:

    <!--Mybatis+Spring整合-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.2.0</version>
        </dependency>
(10)测试

    

package cn.happy.SpringMybatis;

import cn.happy.spring16ssm.entity.Book;
import cn.happy.spring16ssm.service.IBookService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {
    // Spring 事务测试
    @org.junit.Test
    public void test04() {
        ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContextSpring15mybatis.xml");
        IBookService service = (IBookService) ctx.getBean("bookService");
        Book book=new Book();
        book.setBookname("狼图腾");
        book.setBookprice(78);
        service.addbook(book);
    }

    }

  (11)测试结果

                

 

          

 

 







转载于:https://www.cnblogs.com/bb1008/p/7704671.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值