ibatis动态映射.txt

来自「Java大部分的基础知识,EJB3,EJB2,WEBSERVICE,SOAP,J」· 文本 代码 · 共 78 行

iBatis动态映射机制

<select id="getUsers" parameterClass="user" resultMap="user-result">
	select id,nam,sex form t_user
	<dynamic prepend="WHERE">
		<isNotEmpty prepend="AND" property="name">
			(name like #name#)
		</isNotEmpty>
		<isNotEmpty prepend="AND" property="address">
			(address like #address#)
		</isNotEmpty>
	</dynamic>
</select>

嵌套

	<dynamic prepend="WHERE">
		<isNotEmpty prepend="AND" property="name">
			(name like #name#
				<isNotEmpty prepend="AND" property="address">
					(address like #address#)
				</isNotEmpty>
		)
		</isNotEmpty>
	</dynamic>
---------------------------------------------------
ibatis中调用procedure(存储过程)
 <procedure id="getPage" resultMap="abatorgenerated_QuestionResult" parameterClass="ibatis.GetPage" >
    <!--
      调用存储过程获得分页数据：表名、主键名、页尺寸、页码
    -->
      {call UP_GetRecordByPage (#tableName:VARCHAR#,#primaryKeyName:VARCHAR#,#pageSize:INTEGER#,#pageNumber:INTEGER#)}
  </procedure>
=====================
public class GetPage 
{
	private String tableName;
	private String primaryKeyName;
	private Integer pageSize;
	private Integer pageNumber;
	public String getTableName() {
		return tableName;
	}
	public void setTableName(String tableName) {
		this.tableName = tableName;
	}
	public String getPrimaryKeyName() {
		return primaryKeyName;
	}
	public void setPrimaryKeyName(String primaryKeyName) {
		this.primaryKeyName = primaryKeyName;
	}
	public Integer getPageSize() {
		return pageSize;
	}
	public void setPageSize(Integer pageSize) {
		this.pageSize = pageSize;
	}
	public Integer getPageNumber() {
		return pageNumber;
	}
	public void setPageNumber(Integer pageNumber) {
		this.pageNumber = pageNumber;
	}
	public GetPage(String tableName, String primaryKeyName, Integer pageSize,
			Integer pageNumber) {
		super();
		this.tableName = tableName;
		this.primaryKeyName = primaryKeyName;
		this.pageSize = pageSize;
		this.pageNumber = pageNumber;
	}
	public GetPage() {
		super();
		// TODO Auto-generated constructor stub
	}
	
}