mybatis spring配置SqlSessionTemplate使用

最新推荐文章于 2025-04-04 09:42:24 发布

艾伦蓝

最新推荐文章于 2025-04-04 09:42:24 发布

阅读量340

点赞数

CC 4.0 BY-SA版权

分类专栏： Mybatis 文章标签： java 数据库

本文链接：https://blog.youkuaiyun.com/lan12334321234/article/details/84653370

Mybatis 专栏收录该内容

12 篇文章

订阅专栏

本文详细介绍如何在Spring框架中整合MyBatis，包括application.xml配置、MyBatisDAO实现及具体的DAO配置等核心内容。文章还展示了如何通过Spring管理数据源及MyBatis会话工厂，并提供了一个具体的数据访问对象示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[size=large][color=red]1.application.xml配置[/color][/size]


<?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:tx="http://www.springframework.org/schema/tx" 
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:dwr="http://www.directwebremoting.org/schema/spring-dwr"
	xmlns:lang="http://www.springframework.org/schema/lang"
	xmlns:top="http://www.comtop.org/schema/spring-top"
	xsi:schemaLocation="
		     http://www.springframework.org/schema/beans
		     http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		     http://www.springframework.org/schema/tx
		     http://www.springframework.org/schema/tx/spring-tx-3.2.xsd
		     http://www.springframework.org/schema/aop
		     http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
		     http://www.springframework.org/schema/context
		     http://www.springframework.org/schema/context/spring-context-3.2.xsd
		     http://www.directwebremoting.org/schema/spring-dwr
        	 http://www.directwebremoting.org/schema/spring-dwr-3.0.xsd
        	 http://www.springframework.org/schema/lang
        	 http://www.springframework.org/schema/lang/spring-lang-3.2.xsd
        	 http://www.comtop.org/schema/spring-top
        	 http://www.comtop.org/schema/top/spring-top.xsd">

	<!-- spring 注解 -->  
    <context:component-scan base-package="com.dwr"/>

    <!-- 这句的作用是表示允许DWR访问Spring的Context -->  
	<dwr:annotation-config  id="dwr_as"/>  
    <!-- 扫描加了注解@RemoteProxy & @RemoteMethod 的对象 -->  
    <dwr:annotation-scan scanRemoteProxy="false" base-package="com.dwr" />  
    <!-- dwr初始化配置 -->
    <dwr:configuration></dwr:configuration>

    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  
       destroy-method="close">
       <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />  
       <property name="url" value="jdbc:oracle:thin:@10.10.15.29:1521:xxxx" />  
       <property name="username" value="edmp" />  
       <property name="password" value="edmp" />  
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
        <property name="dataSource" ref="dataSource" />
		<property name="mapperLocations" value="classpath:com/mybatis/*.xml" /> 
    </bean>
    <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<property name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>

	<import resource="RESTful.xml" />

</beans>

[color=red][size=large]2.MyBatisDAO ：[/size][/color]


package com.dwr;

import java.util.List;

import javax.annotation.Resource;

import org.apache.ibatis.session.RowBounds;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.stereotype.Repository;

@Repository
public class MyBatisDAO{

	@Resource
    private SqlSessionTemplate sqlSessionTemplate;  

    public MyBatisDAO() {  
    }  

    public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {  
        this.sqlSessionTemplate = sqlSessionTemplate;  
    }  

    public void delete(String statementId, Object deleteObject) {  
        try {  
            this.sqlSessionTemplate.delete(statementId, deleteObject);  
        } catch (Exception e) {  
        }  
    }  

    public void insert(String statementId, Object insertObject) {  
        try {  
            this.sqlSessionTemplate.insert(statementId, insertObject);  
        } catch (Exception e) {  
        }  
    }  


    public void update(String statementId, Object updateObject) {  
        try {  
            this.sqlSessionTemplate.update(statementId, updateObject);  
        } catch (Exception e) {  
        }  
    }  


    public Object getObject(String statementId, Object selectParamObject) {  
        return this.sqlSessionTemplate  
                .selectOne(statementId, selectParamObject);  
    }  

    @SuppressWarnings("all")
    public List queryList(String statementId, Object queryParamObject) {  
        return this.sqlSessionTemplate  
                .selectList(statementId, queryParamObject);  
    }
    @SuppressWarnings("all")
    public List queryList(String statementId, Object queryParamObject,  
            int pageNo, int pageSize) {  
        RowBounds objRowBounds;  
        int iOffset = (pageNo - 1) * pageSize;  
        objRowBounds = new RowBounds(iOffset, pageSize);  
        return this.sqlSessionTemplate.selectList(statementId,  
                queryParamObject, objRowBounds);  
    }  
}

[size=large][color=red]3.mybatis配置文件[/color][/size]


<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
    PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
    "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="Test">

	<select id="queryDataCount"
		parameterType="com.mybatis.Test"
		resultType="int">
		SELECT COUNT(1) FROM INF_CONSUMER T WHERE T.UUID = #{uuid}
	</select>

</mapper>

[size=large][color=red]4.具体DAO配置[/color][/size]


package com.dwr;

import org.springframework.stereotype.Repository;

import com.mybatis.Test;

@Repository
public class TestDAO extends MyBatisDAO {

	public int getCount(Test test) {
		return (Integer) this.getObject("Test.queryDataCount", test);
	}
}