mybatis整合spring-有Mapper实现类

最新推荐文章于 2023-05-03 16:05:55 发布

天使彦

最新推荐文章于 2023-05-03 16:05:55 发布

阅读量2.8k

点赞数 3

CC 4.0 BY-SA版权

分类专栏： ssm 文章标签： ssm

本文链接：https://blog.youkuaiyun.com/qq_38217747/article/details/90269843

ssm 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何将MyBatis与Spring框架进行整合，包括导入必要的包、编写Mapper实现类、配置applicationContext.xml以及进行测试的过程。通过具体代码示例，展示了使用MyBatis与Spring结合进行数据库操作的方法。

1. 导入必须的包

2.编写mapper实现类

UserMapperImpl.xml
在这里插入图片描述

package Dao.DaoImpl;

import Dao.UserMapper;
import org.apache.ibatis.session.SqlSession;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import po.User;

/**
 * @description:
 * @Author: gpc
 * @CreateDate: 2019/5/16$ 14:14$
 */
public class UserMapperImpl extends SqlSessionDaoSupport implements UserMapper {
    @Override
    public void saveUser(User user) {
        SqlSession sqlSession = this.getSqlSession();
        sqlSession.insert("saveUser",user);
    }
    //这里不需要事务提交
}

3.编写applicationContext.xml

dbcp连接池 jar包
在这里插入图片描述
删除mybatis-config.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">
    <!-- 读取jdbc.properties -->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!-- 创建DataSource -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="url" value="${jdbc.url}"/>
        <property name="driverClassName" value="${jdbc.driverClass}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="maxActive" value="10"/>
        <property name="maxIdle" value="5"/>
    </bean>
    <!-- 创建SqlSessionFactory对象 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 关联连接池 -->
        <property name="dataSource" ref="dataSource"/>
        <!-- 加载sql映射文件 -->
        <property name="mapperLocations" value="classpath:mapper/*.xml"/>
    </bean>

    <!-- 创建CustomerMapperImpl对象，注入SqlSessionFactory -->
    <bean id="userMapper" class="Dao.DaoImpl.UserMapperImpl">
        <!-- 关联sqlSessionFactory -->
        <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
    </bean>
</beans>

4.测试类

test.class

package test01;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import Dao.UserMapper;
import po.User;

import java.util.Date;

/**
 * @description:
 * @Author: gpc
 * @CreateDate: 2019/5/16$ 19:36$
 */
public class mybatisSpringTest {
    public void test02() {
        //1.加载spring配置
        ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");

        //2.获取对象
        UserMapper userMapper = (UserMapper) ac.getBean("userMapper");
        Date date = new Date();
        User user = new User("管理员1","男",date,"萍乡1");
        userMapper.saveUser(user);
        //3.调用方法
    }

    public static void main(String[] args) {
        mybatisSpringTest mybatisSpringTest = new mybatisSpringTest();
        mybatisSpringTest.test02();
    }
}