MyBatis--基本構成

1、アプリケーションContext.xmlは次のように構成されています.
a.データソース属性ファイルを導入する:

<!--  jdbc.properties -->
	<bean id="propertyConfigurer"  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">      
	    <property name="location" value="classpath:jdbc.properties"/>      
	</bean>

プロパティ・ファイルで宣言:
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=//データベースURL
jdbc.username=//
jdbc.password=//
b.データソース接続プールの構成:

<!--   (jotm) -->
	<bean id="oracleDS" class="org.enhydra.jdbc.pool.StandardXAPoolDataSource" destroy-method="shutdown">
		<property name="dataSource">
			<bean class="org.enhydra.jdbc.standard.StandardXADataSource" destroy-method="shutdown">
				<property name="transactionManager" ref="jotm" />
				<property name="driverName" value="${jdbc.driverClassName}" />
				<property name="url" value="${jdbc.url}" />
			</bean>
		</property>
		<property name="user" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>

3.MyBatis :

<!--  mybatis  -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="oracleDS" />
		<property name="configLocation" value="classpath:SqlMapConfig.xml" />
	</bean>

a.SqlMapConfig.xml

<configuration>
	<typeAliases>
		<!--  -->
		<typeAlias alias="DlssVo" type="com.sinosoft.perfect.shsjgl.facilities.vo.DlssVo" />
	</typeAliases>
	<mappers>
		<!--  -->	
		<mapper resource="com/sinosoft/perfect/shsjgl/place/mapper-shsjgl-place.xml"/>
	</mappers>
</configuration>

b.mapper-shsjgl-place.xml

<mapper>
<!-- type  -->
<!-- id  -->
<resultMap type="GhVO" id="GhVORMap">
	<result column="ID" property="id" jdbcType="VARCHAR" />
</resultMap>
<!--   -->
<!-- parameterType:  -->
<!-- resultMap:  -->
<select id="selectTShsjglGh" parameterType="GhVO" resultMap="GhVORMap">
SELECT ID, HBM, ZBM, SSZID, DYH, LCH, FH, HX, ZT, FZLX, FZXM, FZSFZH,FZLXFS, DZ, BZ
FROM T_SHSJGL_GH
<where>
	<if test="id != null and id != ''">
	ID=#{id}
	</if>
</where>
</select>
<!--   -->
<!-- #{id:VARCHAR}:  -->
<insert id="insertTShsjglGh" parameterType="GhVO">
INSERT INTO T_SHSJGL_GH (ID, HBM, ZBM,SSZID, DYH, LCH, FH, HX, ZT,FZLX, FZXM, FZSFZH,FZLXFS, DZ, BZ) 
VALUES ( #{id:VARCHAR},#{hbm:VARCHAR	},#{zbm:VARCHAR},#{sszid:VARCHAR},#{dyh:INTEGER},#{lch:INTEGER},#{fh:VARCHAR},#{hx:VARCHAR},#{zt:VARCHAR},#{fzlx:VARCHAR},#{fzxm:INTEGER},#{fzsfzh:VARCHAR},#{fzlxfs:VARCHAR},#{dz:VARCHAR},#{bz:VARCHAR} )
</insert>
<!--   -->
<update id="updateTShsjglGh" parameterType="GhVO">
UPDATE T_SHSJGL_GH
<set>
	<if test="hbm != null">
		HBM = #{hbm},
	</if>

</set>
<where>
	ID=#{id}
</where>
</update>
<!--   -->
<delete id="deleteTShsjglGh" parameterType="GhVO">
DELETE FROM T_SHSJGL_GH
<where>
	<if test="id != null and id != ''">
	ID = #{id}
	</if>
</where>
</delete>
</mapper>