配置hessian:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 对在此配置文件下的所有cache 进行全局性开/关设置 true,false -->
<setting name="cacheEnabled" value="true" />
<!-- 全局性设置懒加载。如果设为‘false’，则所有相关联的都会被初始化加载 true,false -->
<setting name="lazyLoadingEnabled" value="true" />
<!-- 当设置为‘true’的时候，懒加载的对象可能被任何懒属性全部加载。否则，每个属性都按需加载 true,false -->
<setting name="aggressiveLazyLoading" value="true" />
<!-- 允许和不允许单条语句返回多个数据集（取决于驱动需求），默认true -->
<setting name="multipleResultSetsEnabled" value="true" />
<!-- 使用列标签代替列名称。不同的驱动器有不同的作法。参考一下驱动器文档，或者用这两个不同的选项进行测试一下 true,false -->
<setting name="useColumnLabel" value="true" />
<!-- 允许JDBC 生成主键。需要驱动器支持。如果设为了true，这个设置将强制使用被生成的主键，有一些驱动器不兼容不过仍然可以执行 true,false -->
<setting name="useGeneratedKeys" value="false" />
<!-- 指定MyBatis 是否并且如何来自动映射数据表字段与对象的属性。PARTIAL将只自动映射简单的，没有嵌套的结果。FULL将自动映射所有复杂的结果
NONE,PARTIAL,FULL -->
<setting name="autoMappingBehavior" value="PARTIAL" />
<!-- 配置和设定执行器，SIMPLE执行器执行其它语句。REUSE执行器可能重复使用prepared statements语句，BATCH执行器可以重复执行语句和批量更新
SIMPLE,REUSE,BATCH -->
<setting name="defaultExecutorType" value="REUSE" />
<!-- 设置一个时限，以决定让驱动器等待数据库回应的多长时间为超时 -->
<setting name="defaultStatementTimeout" value="25000" />
</settings>
<!-- 引入Model 对象 -->
<typeAliases>
<typeAlias alias="HwgActivityInfo" type="com.j1.hwg.model.HwgActivityInfo" />
<typeAlias alias="HwgSelectGoods" type="com.j1.hwg.model.HwgSelectGoods" />
<typeAlias alias="HwgHotBrand" type="com.j1.hwg.model.HwgHotBrand" />
<typeAlias alias="HwgCategoryImage" type="com.j1.hwg.model.HwgCategoryImage" />
<typeAlias alias="HwgCategoryProduct" type="com.j1.hwg.model.HwgProduct" />
<typeAlias alias="HwgKeyword" type="com.j1.hwg.model.HwgKeyword" />
<typeAlias alias="HwgProductEvaluation" type="com.j1.hwg.model.HwgProductEvaluation" />
<typeAlias alias="HwgProductSaleLimit" type="com.j1.hwg.model.HwgProductSaleLimit" />
<typeAlias alias="HwgCatalogBrand" type="com.j1.hwg.model.HwgCatalogBrand" />
</typeAliases>
</configuration>
或者是Model的全路径:
" ?>
-mapper.dtd" >
<mapper namespace="com.j1.soa.resource.hwg.dao.oracle.HwgCatalogBrandMapper">
<resultMap id="HwgCatalogBrandMap" type="HwgCatalogBrand">
<result column="CATALOG_BRAND_ID" property="catalogBrandId" />
<result column="PRO_CATALOG_ID" property="proCatalogId" />
<result column="PRODUCT_BRAND_NAME" property="productBrandName" />
<result column="PRODUCT_BRAND_IMG" property="productBrandImg" />
<result column="PRODUCT_BRAND_URL" property="productBrandUrl" />
<result column="PRO_CATALOG_NAME" property="proCatalogName" />
<result column="CATALOG_BRAND_ORDER" property="catalogBrandOrder" />
</resultMap>
<resultMap id="hwgCategoryMap" type="com.j1.hwg.model.HwgCategory">
<result column="PRO_CATALOG_ID" property="categoryId"/>
<result column="PRO_CATALOG_NAME" property="categoryName"/>
</resultMap>
<!-- 用于分页查询的头部 -->
<sql id="be_fy">
select *
from (select row_.*, rownum rownum_
from (
</sql>
<!-- 用于分页的尾部 -->
<sql id="ed_fy">
) row_
<if test="endRow != null">
<![CDATA[
and rownum <= #{endRow}
]]>
</if>
)
<if test="startRow != null">
<![CDATA[
and rownum_ >= #{startRow}
]]>
</if>
</sql>
<!-- 查询 -->
<select id="queryHwgCatalogBrandPages" resultMap="HwgCatalogBrandMap" parameterType="HwgCatalogBrand">
<include refid="be_fy" />
select
t.catalog_brand_id,
t.pro_catalog_id,
t.product_brand_name,
t.product_brand_img,
t.product_brand_url,
l.pro_catalog_name,
t.catalog_brand_order
from hwg_catalog_brand t inner join product_catalog l on l.pro_catalog_id =t.pro_catalog_id
<where>
t.is_delete = 'N'
<if test="productBrandName != null and productBrandName != ''">
and t.PRODUCT_BRAND_NAME like '%'||#{productBrandName}||'%'
</if>
">
and t.PRO_CATALOG_ID =#{proCatalogId}
</if>
</where>
order by t.ADD_TIME desc
<include refid="ed_fy" />
</select>
<!-- 查询总数量 -->
<select id="getHwgCatalogBrandCount" resultType="java.lang.Integer" parameterType="HwgCatalogBrand">
) from hwg_catalog_brand t
<where>
t.is_delete = 'N'
<if test="productBrandName != null and productBrandName != ''">
and t.PRODUCT_BRAND_NAME like '%'||#{productBrandName}||'%'
</if>
">
and t.PRO_CATALOG_ID =#{proCatalogId}
</if>
</where>
</select>
<!-- 根据主键查询 -->
<select id="getHwgCatalogBrandById" resultMap="HwgCatalogBrandMap" parameterType="java.lang.Long">
select t.catalog_brand_id,
t.pro_catalog_id,
t.product_brand_name,
t.product_brand_img,
t.product_brand_url,
t.catalog_brand_order
from hwg_catalog_brand t where t.catalog_brand_id = #{catalogBrandId}
</select>
<!-- 根据分类ID查询 -->
<select id="getHwgCatalogBrandByCatalogId" resultMap="HwgCatalogBrandMap" parameterType="java.lang.Long">
select t.catalog_brand_id,
t.pro_catalog_id,
t.product_brand_name,
t.product_brand_img,
t.product_brand_url,
t.catalog_brand_order
from hwg_catalog_brand t where t.PRO_CATALOG_ID = #{proCatalogId} AND t.is_delete='N'
ORDER BY t.CATALOG_BRAND_ORDER
</select>
<!-- 保存 -->
<insert id="save" parameterType="HwgCatalogBrand">
<selectKey resultType="java.lang.Long" keyProperty="catalogBrandId" order="BEFORE">
SELECT HWG_CATALOG_BRAND_ID_SEQ.nextval from dual
</selectKey>
insert into HWG_CATALOG_BRAND
<trim prefix="(" suffix=")" suffixOverrides=",">
CATALOG_BRAND_ID,
<if test="proCatalogId != null">
PRO_CATALOG_ID,
</if>
<if test="productBrandName != null">
PRODUCT_BRAND_NAME,
</if>
<if test="productBrandImg != null">
PRODUCT_BRAND_IMG,
</if>
<if test="productBrandUrl != null">
PRODUCT_BRAND_URL,
</if>
<if test="catalogBrandOrder != null">
catalog_brand_order,
</if>
<if test="addUserId != null">
ADD_USER_ID,
</if>
<if test="editTime != null">
EDIT_TIME,
</if>
<if test="addTime != null">
ADD_TIME,
</if>
<if test="editUserId != null">
EDIT_USER_ID,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
#{catalogBrandId,jdbcType=NUMERIC},
<if test="proCatalogId != null">
#{proCatalogId,jdbcType=NUMERIC},
</if>
<if test="productBrandName != null">
#{productBrandName,jdbcType=VARCHAR},
</if>
<if test="productBrandImg != null">
#{productBrandImg,jdbcType=VARCHAR},
</if>
<if test="productBrandUrl != null">
#{productBrandUrl,jdbcType=VARCHAR},
</if>
<if test="catalogBrandOrder != null">
#{catalogBrandOrder,jdbcType=NUMERIC},
</if>
<if test="addUserId != null">
#{addUserId,jdbcType=NUMERIC},
</if>
<if test="editTime != null">
#{editTime,jdbcType=VARCHAR},
</if>
<if test="addTime != null">
#{addTime,jdbcType=VARCHAR},
</if>
<if test="editUserId != null">
#{editUserId,jdbcType=NUMERIC},
</if>
</trim>
</insert>
<!-- 修改 -->
<update id="update" parameterType="HwgCatalogBrand">
update HWG_CATALOG_BRAND
<set>
<if test="proCatalogId != null and proCatalogId != ''">
PRO_CATALOG_ID =#{proCatalogId,jdbcType=NUMERIC},
</if>
<if test="productBrandName != null and productBrandName != ''">
PRODUCT_BRAND_NAME = #{productBrandName,jdbcType=VARCHAR},
</if>
<if test="productBrandImg != null and productBrandImg != ''">
PRODUCT_BRAND_IMG = #{productBrandImg,jdbcType=VARCHAR},
</if>
<if test="productBrandUrl != null and productBrandUrl != ''">
PRODUCT_BRAND_URL = #{productBrandUrl,jdbcType=VARCHAR},
</if>
<if test="catalogBrandOrder != null and catalogBrandOrder != ''">
CATALOG_BRAND_ORDER = #{catalogBrandOrder,jdbcType=NUMERIC},
</if>
<if test="addUserId != null and addUserId != ''">
ADD_USER_ID = #{addUserId,jdbcType=NUMERIC},
</if>
<if test="addTime != null and addTime != ''">
ADD_TIME = #{addTime,jdbcType=VARCHAR},
</if>
<if test="editUserId != null and editUserId != ''">
EDIT_USER_ID = #{editUserId,jdbcType=NUMERIC},
</if>
<if test="editTime != null and editTime != ''">
EDIT_TIME = #{editTime,jdbcType=VARCHAR},
</if>
<if test="isDelete != null and isDelete != ''">
IS_DELETE = #{isDelete,jdbcType=VARCHAR}
</if>
</set>
where catalog_brand_id = #{catalogBrandId,jdbcType=NUMERIC}
</update>
<!-- 删除 -->
<update id="delete" parameterType="java.util.List">
update HWG_CATALOG_BRAND set IS_DELETE='Y' where catalog_brand_id
in
<foreach item="item" collection="list" separator="," open="(" close=")">
#{item, jdbcType=NUMERIC}
</foreach>
</update>
<select id="queryCatalog" resultMap="hwgCategoryMap" parameterType="java.lang.String">
select c.PRO_CATALOG_ID ,c.PRO_CATALOG_NAME
from PRODUCT_CATALOG c
where c.PRO_PARENT_CATALOG IN
(select c.PRO_CATALOG_ID
from PRODUCT_CATALOG c,PRODUCT_CATALOG_AUTH a
where a.PRO_CATALOG_ID=c.PRO_CATALOG_ID
and a.AUTH_TYPE=#{value})
</select>
<!-- 查询所有楼层 -->
<select id="getAbroadCategoryInfo" resultType="com.j1.hwg.webmodel.AbroadCategoryInfo" >
select
hc.category_id as categoryId, hc.category_name as categoryName
from
hwg_category hc
where
hc.is_delete='N'
order by
hc.category_order
</select>
</mapper>