Spring与MyBatis的整合（一）

最新推荐文章于 2019-02-18 12:37:35 发布

高风言

最新推荐文章于 2019-02-18 12:37:35 发布

阅读量122

点赞数

分类专栏： java框架文章标签： idea spring mybatis

本文链接：https://blog.csdn.net/gaofengyan/article/details/83476848

版权

java框架专栏收录该内容

18 篇文章 0 订阅

订阅专栏

学习idea用maven管理spring与mybatis框架的整合，整合的方式有很多种，今天先用一种，其他不多说，直接上货，给自己留后用，喜欢的朋友可以参考，使用的时候要根据个人的工作调整（微调）
简单看下目录：
在这里插入图片描述
pom.xml配置文件：

<?xml version="1.0" encoding="UTF-8"?>

<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/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.big3</groupId>
    <artifactId>springandmybatis</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>springandmybatis Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.7</maven.compiler.source>
        <maven.compiler.target>1.7</maven.compiler.target>
    </properties>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.11</version>
            <scope>test</scope>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>4.3.10.RELEASE</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver -->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.12</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>4.3.14.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>4.3.18.RELEASE</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.mchange/mchange-commons-java -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>mchange-commons-java</artifactId>
            <version>0.2.11</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>

        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>3.1.0</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.5</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>


    </dependencies>

    <build>
        <finalName>springandmybatis</finalName>
        <!--<pluginManagement>&lt;!&ndash; lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) &ndash;&gt;-->
        <plugins>
            <plugin>
                <artifactId>maven-clean-plugin</artifactId>
                <version>3.0.0</version>
            </plugin>
            <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
            <plugin>
                <artifactId>maven-resources-plugin</artifactId>
                <version>3.0.2</version>
            </plugin>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.7.0</version>
            </plugin>
            <plugin>
                <artifactId>maven-surefire-plugin</artifactId>
                <version>2.20.1</version>
            </plugin>
            <plugin>
                <artifactId>maven-war-plugin</artifactId>
                <version>3.2.0</version>
            </plugin>
            <plugin>
                <artifactId>maven-install-plugin</artifactId>
                <version>2.5.2</version>
            </plugin>
            <plugin>
                <artifactId>maven-deploy-plugin</artifactId>
                <version>2.8.2</version>
            </plugin>
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.5</version>
                <executions>
                    <execution>
                        <id>Generate MyBatis Files</id>
                        <goals>
                            <goal>generate</goal>
                        </goals>

                        <configuration>
                            <verbose>true</verbose>
                            <overwrite>true</overwrite>
                        </configuration>
                    </execution>
                </executions>
            </plugin>
        </plugins>
        <!--</pluginManagement>-->
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
            </resource>
        </resources>
    </build>
</project>

spring-mybatis.xml配置文件，将原来的mybatis的数据源配置引入到spring中，这其中的方式有很多种，包括DBCP，c3p0等方式，我这里用的是c3p0方式，并且刚开始是用database.properties配置文件引入，但是测试的时候除了错误，错误标明是连接问题，后来直接在xml文件中配置数据源就OK了，问题还是要解决，先跑通再说吧。

<?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"
       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">

    <!--引入database.properties配置文件-->
    <!--<context:property-placeholder location="database.properties"/>-->
    <!--引入数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/spring_day03?useUnicode=true&amp;characterEncoding=utf-8"/>
        <property name="user" value="root"/>
        <property name="password" value="123456"/>
    </bean>

    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!-- 自动扫描mapping.xml文件，**表示迭代查找,也可在sqlMapConfig.xml中单独指定xml文件-->
        <property name="mapperLocations" value="classpath:com/kgc/mappers/*.xml"/>
    </bean>
    <bean class="com.kgc.service.UserService" id="userService"/>
    <!-- DAO接口所在包名，Spring会自动查找其下的类 ,包下的类需要使用@MapperScan注解,否则容器注入会失败 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.kgc.dao"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!--开起注解-->
    <context:component-scan base-package="com.kgc.service"/>
</beans>

数据库的表user表
在这里插入图片描述
pojo----->user.java类

package com.kgc.pojo;

import org.springframework.stereotype.Component;

@Component
public class User {
    private String username;
    private String password;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

接口，UserDao.java

package com.kgc.dao;

import com.kgc.pojo.User;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.stereotype.Component;


@Component
public interface UserDao {
  /*  //查询总条数
    public void getCount();*/
    //查询用户信息
    public int getUserInfo();
}

我这里的接口没有实现类，在service层做了实现
IUserService.java接口

package com.kgc.service;

import com.kgc.pojo.User;

public interface IUserService {
  /*  //查询总条数
    public void getCount();*/
    //查询用户信息
    public int getUserInfo();
}

接口实现类UserService.java

package com.kgc.service;

import com.kgc.dao.UserDao;
import com.kgc.pojo.User;
import org.springframework.stereotype.Component;

import javax.annotation.Resource;


public class UserService implements IUserService {
    @Resource(name="userDao")
    private UserDao userDao;

   /* public void setUserDao(UserDao iUser) {
        this.userDao = userDao;
    }*/

 /*   @Override
    public void getCount() {

    }*/

    @Override
    public int getUserInfo() {
        return userDao.getUserInfo();
    }
}

UserMapper.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">
<!-- 为这个mapper指定一个唯一的namespace，namespace的值习惯上设置成包名+sql映射文件名，这样就能够保证namespace的值是唯一的-->
<!--在select标签中编写查询的SQL语句， 设置select标签的id属性为getUserInfo，id属性值必须是唯一的，不能够重复,
　　使用parameterType属性指明查询时使用的参数类型，resultType属性指明查询返回的结果集类型
　　resultType="com.hua.saf.User"就表示将查询结果封装成一个User类的对象返回,User类就是user表所对应的实体类-->
<!-- 根据id查询得到一个user对象-->
<mapper namespace="com.kgc.dao.UserDao">

    <select id="getUserInfo"  resultType="java.lang.Integer">SELECT COUNT(1) FROM USER</select>
</mapper>

测试TestSpringAndMybatis.java

package com.kgc.test;

import com.kgc.dao.UserDao;
import com.kgc.service.IUserService;
import com.kgc.service.UserService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class TestSpringAndMybatis {
    @Test
    public void test1(){
        ApplicationContext context= new ClassPathXmlApplicationContext("spring-mybatis.xml");
        IUserService userService= (UserService) context.getBean("userService");
        System.out.println(userService.getUserInfo());
    }
}

我这里只测试了一个，跑通了，先可以做其他学习操作了。

高风言

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Spring与MyBatis的整合（一）

学习idea用maven管理spring与mybatis框架的整合，整合的方式有很多种，今天先用一种，其他不多说，直接上货，给自己留后用，喜欢的朋友可以参考，使用的时候要根据个人的工作调整（微调）简单看下目录：pom.xml配置文件：&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&amp;gt;&amp;lt;project xmlns=&
复制链接

扫一扫

专栏目录