• Spring和MyBatis环境整合


    开篇简介:

      Spring:

    Spring是一个轻量级的控制反转(IoC)和面向切面(AOP)的容器框架。

    两个重要模块:Spring 面向方面编程(AOP)和控制反转 (IOC) 容器。

    控制反转模式(也称作依赖性介入)的基本概念是:不创建对象,但是描述创建它们的方式。在代码中不直接与对象和服务连接,但在配置文件中描述哪一个组件需要哪一项服务。

    容器 (在 Spring 框架中是 IOC 容器) 负责将这些联系在一起。在典型的 IOC 场景中,容器创建了所有对象,并设置必要的属性将它们连接在一起,决定什么时间调用方法。

       MyBatis:

        

    MyBatis 是支持普通 SQL查询,存储过程和高级映射的优秀持久层框架。MyBatis 消除了几乎所有的JDBC代码和参数的手工设置以及
    结果集的检索。
     
    MyBatis 使用简单的 XML或注解用于配置和原始映射,将接口和 Java 的POJOs(Plain Old Java Objects,普通的 Java
    对象)映射成数据库中的记录。

       开始整合Spring和MyBatis:

    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>01MyBatis</artifactId>
            <groupId>cn.happy</groupId>
            <version>1.0-SNAPSHOT</version>
        </parent>
        <modelVersion>4.0.0</modelVersion>
        <artifactId>SpringSSM</artifactId>
        <packaging>war</packaging>
        <name>SpringSSM Maven Webapp</name>
        <url>http://maven.apache.org</url>
        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.0</version>
                <scope>test</scope>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>4.2.3.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>4.2.2.RELEASE</version>
            </dependency>
    
            <!--spring JDBCTemplate-->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>4.2.0.RELEASE</version>
            </dependency>
    
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.7</version>
            </dependency>
    
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.38</version>
            </dependency>
    
            <dependency>
                <groupId>commons-dbcp</groupId>
                <artifactId>commons-dbcp</artifactId>
                <version>1.4</version>
            </dependency>
    
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
    
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.0.18</version>
            </dependency>
    
            <!--mybatis jar-->
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.2</version>
            </dependency>
    
            <!--spring整合mybatis-->
            <!--Mybatis+Spring整合-->
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.2.0</version>
            </dependency>
    
        </dependencies>
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.xml</include>
                    </includes>
                </resource>
            </resources>
        </build>
    
    </project>

       步骤一:定义Bookr实体类

    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;
        }
    }

        步骤二:定义接口类IBookDAO

    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.dao.IBookDAO">
        <insert id="addBook">
            INSERT INTO book(bookname,bookprice) VALUES (#{bookname},#{bookprice})
        </insert>
    </mapper>

        步骤四:定义Service的接口

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

        步骤五:定义Service的实现类

    import cn.happy.bean.Book;
    import cn.happy.dao.IBookDAO;
    import cn.happy.service.IBookService;
    public class BookServiceImpl implements IBookService {
        private IBookDAO dao;
        public int addBook(Book book) {
            return dao.addBook(book);
        }
        public IBookDAO getDao() {
            return dao;
        }
        public void setDao(IBookDAO dao) {
            this.dao = dao;
        }
    }

        步骤六:定义jdbc.properties

    jdbc.url=jdbc:mysql:///t14
    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.username=root
    jdbc.password=1234

         步骤七:配置Mybatis-config.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>
        <!--别名的设置-->
        <typeAliases>
            <package name="cn.happy.bean"></package>
        </typeAliases>
        <!--管理小配置-->
        <mappers>
            <package name="cn.happy.dao"></package>
        </mappers>
    </configuration>

          步骤八:配置Spring的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:aop="http://www.springframework.org/schema/aop"
           xmlns:context="http://www.springframework.org/schema/context"
           xmlns:tx="http://www.springframework.org/schema/tx"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans.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">
    
        <context:property-placeholder location="classpath:jdbc.properties"/>
        <!--阿里数据源 不想进入阿里的程序员,不是好厨师-->
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <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>
    
        <!--1.将MyBatis SqlSessionFactory 配置一下-->
        <bean class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"></property>
            <property name="configLocation" value="classpath:mybatis-config.xml"></property>
        </bean>
    
        <!--bookDAO  根据工厂去生成session-->
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="cn.happy.dao"></property>
        </bean>
    
        <!--4.service  去绑定内存中看不见的dao对象-->
        <bean id="bookService" class="cn.happy.service.impl.BookServiceImpl">
            <property name="dao" ref="IBookDAO"></property>
        </bean>
    
        <!--平台事务管理器-->
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <!--注入什么东西 事务对象的来源,一定是Connection -->
            <property name="dataSource" ref="dataSource"></property>
        </bean>
    
        <!--方式三:AspectJ AOP 方式管理事务-->
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="addBook" isolation="DEFAULT" propagation="REQUIRED"/>
            </tx:attributes>
        </tx:advice>
    
        <aop:config>
            <!--1.切点:建议配置的越详细越好,如果像是execution(* *..*.*(..))的话会报很长的错-->
            <aop:pointcut id="mypointcut" expression="execution(* *..*..service.*(..))"></aop:pointcut>
            <!--2.顾问-->
            <aop:advisor advice-ref="txAdvice" pointcut-ref="mypointcut"></aop:advisor>
            <!--3.切面-->
        </aop:config>
    Error creating bean with name 'dataSource':
    Bean with name 'dataSource' has been injected into other beans [transactionManager] in its raw version as part of a circular reference,
    but has eventually been wrapped. This means that said other beans do not use the final version of the bean.
    This is often the result of over-eager type matching - consider using 'getBeanNamesOfType' with the 'allowEagerInit' flag turned off, for example.
    名为“dataSource”的Bean已经以其原始版本作为循环引用的一部分注入到其他bean [transactionManager]中,但最终已被包装。
    即它有可能会寻址到其他的module的Book里的类

    </beans>

           步骤九:测试类

    @Test
        public void Test() {
            ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
            IBookService service = (IBookService) ctx.getBean("bookService");
            Book book = new Book();
            book.setBookname("艾丝凡");
            book.setBookprice(3);
            service.addBook(book);
        }
  • 相关阅读:
    caml library
    DIV+CSS 最常用知识
    Jquery(Ajax) 调用 SharePoint 2013 Search Rest API 并使用Josn反回结果并简单显示
    SharePoint 使用Jquery
    SharePoint 报表
    在SharePoint 平台上发布一个Power BI 报表
    Sharepoint前端
    .net 高并发 多消费者模式处理订单
    ERP 系统数据库设计规范
    ListView 点击加载更多
  • 原文地址:https://www.cnblogs.com/Chenghao-He/p/7704829.html
Copyright © 2020-2023  润新知