81,091
社区成员
发帖
与我相关
我的任务
分享
<typeAlias alias="yearStatModel" type="com.xx.ydjw.statistics.model.YearStatModel" />
<select id="queryYearStatCount" parameterClass="yearStatModel" resultClass="Integer">
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Area">
<!-- 映射对应实体 -->
<typeAlias alias="area" type="com.pojo.Area"/>
<!-- 配置实体属性 -->
<resultMap class="area" id="areafoResult">
<result property="area_id" column="AREA_ID" javaType="java.lang.Integer" jdbcType="int"/>
<result property="area_name" column="AREA_NAME" javaType="java.lang.String" jdbcType="nvarchar"/>
</resultMap>
<resultMap class="area" id="areafoResults">
<result property="area_id" column="AREA_ID" javaType="java.lang.Integer" jdbcType="int"/>
<result property="area_name" column="AREA_NAME" javaType="java.lang.String" jdbcType="nvarchar"/>
<result property="regions" column="AREA_ID" javaType="java.lang.String" jdbcType="nvarchar" select="Region.findRegionByAreaId"/>
</resultMap>
<!-- 查询全部 -->
<select id="findAreaAll" resultMap="areafoResult">
<![CDATA[SELECT * FROM POS_SN_AREA]]>
</select>
<!-- 查询全部数量 -->
<select id="findAreaCount" resultClass="java.lang.Object" parameterClass="java.lang.String">
<![CDATA[SELECT COUNT([AREA_ID]) FROM POS_SN_AREA WHERE 1=1 $value$]]>
</select>
<!-- 查询全部 -->
<select id="findAreaByCondition" resultMap="areafoResult" parameterClass="com.aisino.snpos.ben.util.PageBean">
<![CDATA[SELECT TOP $pageSize$ * FROM POS_SN_AREA WHERE [AREA_ID] NOT IN
(SELECT TOP (($currPage$-1)*$pageSize$) [AREA_ID] FROM POS_SN_AREA WHERE 1=1 $condition$)
$condition$]]>
</select>
<!-- 片区名称是否存在 -->
<select id="isExistsAreaName" resultClass="java.lang.Object" parameterClass="java.lang.String">
<![CDATA[SELECT COUNT(1) FROM POS_SN_AREA WHERE [AREA_NAME] = #value#]]>
</select>
<!-- 删除 -->
<delete id="deleteAreaById" parameterClass="java.lang.String">
<![CDATA[DELETE FROM POS_SN_AREA WHERE [AREA_ID]=#value#]]>
</delete>
<!-- 新增 -->
<statement id="addArea" parameterClass="com.aisino.snpos.ben.pojo.Area" resultClass="java.lang.Object">
<![CDATA[INSERT INTO POS_SN_AREA([AREA_NAME])
VALUES(#area_name#);SELECT @@IDENTITY;]]>
</statement>
<!-- 修改 -->
<update id="modifyAreaById" parameterClass="com.aisino.snpos.ben.pojo.Area">
<![CDATA[UPDATE POS_SN_AREA SET [AREA_NAME]=#area_name# WHERE [AREA_ID]=#area_id#]]>
</update>
<!-- 按ID查询 -->
<select id="findAreaByAreaId" resultMap="areafoResult" parameterClass="java.lang.String">
<![CDATA[SELECT * FROM POS_SN_AREA WHERE [AREA_ID] = #value#]]>
</select>
<!-- 删除 -->
<statement id="truncateArea">
<![CDATA[TRUNCATE TABLE [POS_SN_AREA]]]>
</statement>
<!-- 按AREA_NAME查询 -->
<select id="findAreaByAreaName" resultMap="areafoResult" parameterClass="java.lang.String">
<![CDATA[SELECT * FROM POS_SN_AREA WHERE [AREA_NAME] = #value#]]>
</select>
</sqlMap>