Mybatis与Spring整合

TWOFOUR_

于 2019-11-05 14:31:22 发布

阅读量58

点赞数

分类专栏： Ide 文章标签： Mybatis与Spring整合

本文链接：https://blog.csdn.net/qq_43868329/article/details/102914403

版权

Ide 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

通过超简单实例了解Mubatis与Spring整合

实例1

采用注解的方式进行查询
创建实体类

public class Person {
        private Integer id;
    private String name;
    private Integer sex;
    private String headUrl;
    private String profession;
    private String introduce;
    @Override
    public String toString() {
        return "Person{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", sex=" + sex +
                ", headUrl='" + headUrl + '\'' +
                ", profession='" + profession + '\'' +
                ", introduce='" + introduce + '\'' +
                '}';
    }
    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 Integer getSex() {
        return sex;
    }
    public void setSex(Integer sex) {
        this.sex = sex;
    }

    public String getHeadUrl() {
        return headUrl;
    }

    public void setHeadUrl(String headUrl) {
        this.headUrl = headUrl;
    }

    public String getProfession() {
        return profession;
    }

    public void setProfession(String profession) {
        this.profession = profession;
    }

    public String getIntroduce() {
        return introduce;
    }

    public void setIntroduce(String introduce) {
        this.introduce = introduce;
    }
}

导入getset方法
创建Dao接口

public interface PersonDao {
    public List<Person> getAll();
}

创建Dao实现类

import java.util.List;
@Repository//用与标注Dao类
public class PersonDaoImpl implements PersonDao {
    @Override
    public List<Person> getAll() {
        return null;
    }
}

创建Service接口

public interface PerviceService {
    public List<Person> getAll();
}

创建Service实现类必须导入set方法

//表示Setvice类
@Service("perviceServiceImpl")
public class PerviceServiceImpl implements PerviceService {
	//默认ByName式，如果name确实默认按照ByType式注入，
    @Resource
    private PersonDao personDao;
    @Override
    public List<Person> getAll() {
        return personDao.getAll();
    }

    public PersonDao getPersonDao() {
        return personDao;
    }

    public void setPersonDao(PersonDao personDao) {
        this.personDao = personDao;
    }
}

编写database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///account
jdbc.username=root
jdbc.password=root

编写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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!--导入database.properties文件-->
    <context:property-placeholder location="database.properties"/>
    <context:component-scan base-package="com.SpringAndMybatis"/>
    <!--导入数据源-->
    <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="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <!--配置mybatis核心对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="typeAliasesPackage" value="com.SpringAndMybatis.entity"></property>
        <property name="mapperLocations" value="classpath*:mapper/*.xml"></property>
    </bean>
    <!--Mybatis的dao接口扫描器（借助dao接口生成动态代理）-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--指向dao姐接口-->
        <property name="basePackage" value="com.SpringAndMybatis.dao"></property>
    </bean>
</beans>

编写PersonDao.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="com.SpringAndMybatis.dao.PersonDao">
    <select id="getAll" resultType="Person">
        select * from person
    </select>
</mapper>

结果

Person{id=1, name='1', sex=1, headUrl='1', profession='1', introduce='1'}
Person{id=2, name='2', sex=2, headUrl='2', profession='2', introduce='2'}
Person{id=3, name='3', sex=3, headUrl='3', profession='3', introduce='3'}

Process finished with exit code 0

非注解方式

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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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/aop
       http://www.springframework.org/schema/aop/spring-aop.xsd
       http://www.springframework.org/schema/tx
       http://www.springframework.org/schema/tx/spring-tx.xsd">
    <!--导入database.properties文件-->
    <context:property-placeholder location="database.properties"/>
    <context:component-scan base-package="com.SpringAndMybatis"></context:component-scan>
    <!--导入数据源-->
    <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="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
    <!--配置mybatis核心对象-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="typeAliasesPackage" value="com.SpringAndMybatis.entity"></property>
        <property name="mapperLocations" value="classpath*:mapper/*.xml"></property>
    </bean>
    <!--Mybatis的dao接口扫描器（借助dao接口生成动态代理）-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--指向dao姐接口-->
        <property name="basePackage" value="com.SpringAndMybatis.dao"></property>
    </bean>
    <!--将service实现类生成到spring容器中-->
    <!--spring隐式注入bytype-->
   <bean id="perviceService" class="com.SpringAndMybatis.Service.impl.PerviceServiceImpl" autowire="byType"/>
    <!--&lt;!&ndash;完成事务配置&ndash;&gt;-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <tx:advice transaction-manager="transactionManager" id="txAdivce">
        <tx:attributes>
            <tx:method name="getAll" isolation="READ_COMMITTED" propagation="REQUIRED"/>
        </tx:attributes>
    </tx:advice>
    <aop:config>
        <aop:advisor advice-ref="txAdivce" pointcut="execution(* com.SpringAndMybatis.Service.*.*(..))"/>
    </aop:config>

</beans>

然后吧Service中的@Resource和@Service注释
吧Dao实现类中的@Repository注释就行了
通过注解的方式在Service实现类中不需要set方法

TWOFOUR_

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Mybatis与Spring整合

通过超简单实例了解Mubatis与Spring整合实例1采用注解的方式进行查询创建实体类public class Person { private Integer id; private String name; private Integer sex; private String headUrl; private String profe...
复制链接

扫一扫