Spring2.0+Ibatis的组合
<?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"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">
<!-- 数据库配置 -->
<bean id="dataSource"
ref="dataSource"></property>
<property name="sqlMapClient" ref="sqlMapClient"></property>
</bean>
<!-- 用户DAO -->
<bean id="UserDao" parent="BaseDao">
</bean>
</beans>
<!--Ibatis配置 -->
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMap resource="com/lf/drp/sqlmapping/xml/T_User.xml"/>
<sqlMap resource="com/lf/drp/sqlmapping/xml/T_Area.xml"/>
</sqlMapConfig>
<!--T_User的配置 -->
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
<!--对象类型 参数设定 方便下面 增删改查 调用 -->
<typeAlias alias="userInfo" type="com.lf.drp.entity.T_User" />
<!--查询全部 -->
<select id="selectAllUser" resultparameterparameterproperty="loginName">
loginName like '%$loginName$%'
</isNotEmpty>
</isNotNull>
</isPropertyAvailable>
<!-- 筛选条件2 -->
<isNotNull property="contect_Tel">
<isNotEmpty prepend="and " property="contect_Tel">
contect_Tel=#contect_Tel#
</isNotEmpty>
</isNotNull>
<!-- 筛选条件3-->
<isNotNull property="start_Date">
<isNotNull property="end_Date">
<isNotEmpty property="start_Date">
<isNotEmpty prepend="and" property="end_Date">
create_Date between #start_Date# and #end_Date#
</isNotEmpty>
</isNotEmpty>
</isNotNull>
</isNotNull>
</dynamic>
</select>
<!--用户登录-->
<select id="login" parameterresultparameterparameterClass="userInfo">
update T_User set loginName = #loginName# ,contect_Tel =
#contect_Tel# ,email =#email# WHERE user_no=#user_no#
</update>
</sqlMap>
