java ibatis持久化框架配置

最新推荐文章于 2024-08-23 14:35:51 发布

原创最新推荐文章于 2024-08-23 14:35:51 发布 · 179 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ibatis 持久化框架

本文介绍了一个基于 Spring 的数据库配置案例，包括数据源、SqlMapClient 和事务管理的配置方式。通过 XML 文件详细展示了如何配置 MySQL 数据源、集成 MyBatis（IBatis）并实现事务控制。

[b][size=large][color=green]1. application*-db.xml[/color][/size][/b]

<?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:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xsi:schemaLocation="
           http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
	<!-- 数据源配置 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/empires" />
		<property name="username" value="root" />
		<property name="password" value="" />
	</bean>

	<!-- sqlMapClient 配置 -->
	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
		<property name="configLocation">
			<value>classpath:ibatis/sqlmap-config.xml</value>
		</property>
	</bean>

	<bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
		<property name="sqlMapClient">
			<ref bean="sqlMapClient" />
		</property>
	</bean>

	<!-- spring 事务配置 -->
	<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource">
			<ref bean="dataSource" />
		</property>
	</bean>

	<bean id="transactionTemplate"
class="org.springframework.transaction.support.TransactionTemplate">
		<property name="transactionManager">
			<ref bean="transactionManager" />
		</property>
	</bean>

	<!-- 开启事务，事务管理器不指定使用默认的transactionManager -->
	<tx:annotation-driven />
</beans>

[b][size=large][color=green]2. sqlmap-config.xml[/color][/size][/b]

<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" 
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
	<settings useStatementNamespaces="true" enhancementEnabled="true"
		lazyLoadingEnabled="true" />
	<sqlMap resource="ibatis/userInfo-sqlmap-mapping.xml" />
</sqlMapConfig>

[b][size=large][color=green]3. userInfo-sqlmap-mapping.xml[/color][/size][/b]

<sqlMap>
    <resultMap id="RM.UserInfo" class="com.empires.module.UserInfo">
     <result property="id" column="id" javaType="java.lang.String" jdbcType="VARCHAR"  />
     <result property="userName" column="user_name" javaType="java.lang.String" jdbcType="VARCHAR"  />
     <result property="userId" column="user_id" javaType="java.lang.String" jdbcType="VARCHAR"  />		
    </resultMap>

    <sql id="UserInfo.columns">
	id, user_name, user_id, login_name, password, phone, mobile, address
    </sql>

    <insert id="moaprod.UserInfo.insert">
	INSERT INTO user_info (
	  id ,user_name ,user_id ,login_name ,password ,phone ,mobile ,address 
	) VALUES (#id#,#userName#,#userId#,#loginName#,#password#,#phone#,#mobile#,#address#)
	<!--<selectKey resultClass="java.lang.String" type="post" keyProperty="id" >
            select last_insert_id()
    	</selectKey>        
	--></insert>
...