Model配置

最新推荐文章于 2025-09-06 09:33:29 发布

转载最新推荐文章于 2025-09-06 09:33:29 发布 · 182 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/erik168/archive/2006/11/16/562263.html

文章标签：

#数据库

Class.xml

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="Class" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SqlMap.xsd">

<alias>
<typeAlias alias="Class" type="WebApplication1.Class,WebApplication1" />
</alias>

<resultMaps>
<resultMap id="Class" class="Class">
  <result property="ClassId" column="ClassId" />
  <result property="ClassName" column="ClassName" />
</resultMap>
<resultMap id="SimpleClass" class="Class">
  <result property="ClassName" column="ClassName" />
</resultMap>
</resultMaps>

<parameterMaps>
<parameterMap id="QueryClassName">
<parameter property="ClassName" column="" />
</parameterMap>
</parameterMaps>

<statements>
<select id="SelectClass" parameterClass="int" resultMap="SimpleClass">
select
ClassId,ClassName
from [Class]
  <dynamic prepend="WHERE">
   <isParameterPresent>
    ClassId = #value#
   </isParameterPresent>
  </dynamic>
</select>

<procedure id="GetClassByName" parameterMap="QueryClassName" resultMap="Class">
QueryClassByName
</procedure>

<insert id="InsertClass" parameterClass="Class" resultClass="int">
insert into Class
(ClassName)
values
(#ClassName#)
</insert>

<update id="UpdateClass" parameterClass="Class" resultClass="int">
update Class set
ClassName=#ClassName#
where ClassId = #ClassId#
</update>

<delete id="DeleteClass" parameterClass="Class" resultClass="int">
delete from Class
where ClassId = #ClassId#
</delete>
</statements>
</sqlMap>

GoodsType.xml

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="GoodsType" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="SqlMap.xsd">
<alias>
<typeAlias alias="GoodsType" type="WebApplication1.GoodsType,WebApplication1" />
</alias>
<resultMaps>
<resultMap id="GoodsTypeList" class="GoodsType">
  <result property="GoodsTypeId" column="GoodsTypeId" />
  <result property="GoodsTypeName" column="GoodsTypeName" />
  <result property="Class" resultMapping="Class.SimpleClass" />
</resultMap>
</resultMaps>

<statements>
<select id="ListGoodsType" resultMap="GoodsTypeList">
select GoodsTypeId,GoodsTypeName,GoodsType.ClassId,ClassName from [GoodsType],[Class]
where Class.ClassId=GoodsType.ClassId
</select>
</statements>
</sqlMap>

转载于:https://www.cnblogs.com/erik168/archive/2006/11/16/562263.html