ibatis与spring的集成

最新推荐文章于 2021-01-30 19:40:57 发布

oklinsong

最新推荐文章于 2021-01-30 19:40:57 发布

阅读量485

点赞数

分类专栏： ibatis 文章标签： spring ibatis bean class encoding mysql

本文链接：https://blog.csdn.net/oklinsong/article/details/6572339

版权

ibatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1. 把需要的jar包加入到classpath，不再赘述

2 配置jdbc.properties,我用的是mysql数据库

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306
jdbc.username=root
jdbc.password=

3 配置spring的配置文件applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
            "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>jdbc.properties</value>
            </list>
        </property>
    </bean>
    <bean id="dataSource"
        class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
    </bean>
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation">
            <value>sql-map-config.xml</value>
        </property>
        <property name="dataSource">
            <ref bean="dataSource" />
        </property>
    </bean>
    <bean id="sqlMapClientTemplate"
        class="org.springframework.orm.ibatis.SqlMapClientTemplate">
        <property name="sqlMapClient">
            <ref bean="sqlMapClient" />
        </property>
    </bean>
    <bean id="gadgetDao" class="dao.GadgetCategoryDao">
        <property name="sqlmap">
            <ref bean="sqlMapClientTemplate" />
        </property>
    </bean>
</beans>

4 配置sql-map-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMap resource="dao/gadgetCategory.xml" />
</sqlMapConfig>

5 配置gadgetCategory.xml，具体的sql语句在此