MyBatis---基本配置

[color=green]1、在applicationContext.xml做如下配置：[/color]

[color=green]a.引入数据源属性文件：[/color]

<!-- 引入数据源属性文件jdbc.properties -->
	<bean id="propertyConfigurer"  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">      
	    <property name="location" value="classpath:jdbc.properties"/>      
	</bean>

[color=green]属性文件中声明：[/color]
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=//数据库URL
jdbc.username=//
jdbc.password=//

[color=green]b.配置数据源连接池：[/color]

<!-- 配置数据源连接池 (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>

[color=green]3.MyBatis ：[/color]

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

[color=green]a.SqlMapConfig.xml[/color]

<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>

[color=green]b.mapper-shsjgl-place.xml[/color]

<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>