0290cd1f5b4d9a5656812a8b562d7592dd6f6ea3.svn-base
2.04 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.thinkgem.jeesite.modules.reg.dao.qjxt.BdcQlrxxDao">
<sql id="bdcQlrxxColumns">
a.id0 AS "id0",
a.zddm AS "zddm",
a.bdcdyh AS "bdcdyh",
a.qlrmc AS "qlrmc",
a.zjzl AS "zjzl",
a.zjh AS "zjh",
a.lxdh AS "lxdh",
a.qlrlx AS "qlrlx",
a.txdz AS "txdz",
a.bz AS "bz",
a.zt AS "zt"
</sql>
<sql id="bdcQlrxxJoins">
</sql>
<select id="get" resultType="BdcQlrxx">
SELECT
<include refid="bdcQlrxxColumns"/>
FROM bdc_qlrxx a
<include refid="bdcQlrxxJoins"/>
WHERE a.id = #{id}
</select>
<select id="findList" resultType="BdcQlrxx">
SELECT
<include refid="bdcQlrxxColumns"/>
FROM bdc_qlrxx a
<include refid="bdcQlrxxJoins"/>
<where>
</where>
<choose>
<when test="page !=null and page.orderBy != null and page.orderBy != ''">
ORDER BY ${page.orderBy}
</when>
<otherwise>
</otherwise>
</choose>
</select>
<select id="findAllList" resultType="BdcQlrxx">
SELECT
<include refid="bdcQlrxxColumns"/>
FROM bdc_qlrxx a
<include refid="bdcQlrxxJoins"/>
<where>
</where>
<choose>
<when test="page !=null and page.orderBy != null and page.orderBy != ''">
ORDER BY ${page.orderBy}
</when>
<otherwise>
</otherwise>
</choose>
</select>
<insert id="insert">
INSERT INTO bdc_qlrxx(
id0,
zddm,
bdcdyh,
qlrmc,
zjzl,
zjh,
lxdh,
qlrlx,
txdz,
bz,
zt
) VALUES (
#{id0},
#{zddm},
#{bdcdyh},
#{qlrmc},
#{zjzl},
#{zjh},
#{lxdh},
#{qlrlx},
#{txdz},
#{bz},
#{zt}
)
</insert>
<update id="update">
UPDATE bdc_qlrxx SET
id0 = #{id0},
zddm = #{zddm},
bdcdyh = #{bdcdyh},
qlrmc = #{qlrmc},
zjzl = #{zjzl},
zjh = #{zjh},
lxdh = #{lxdh},
qlrlx = #{qlrlx},
txdz = #{txdz},
bz = #{bz},
zt = #{zt}
WHERE id = #{id}
</update>
<update id="delete">
DELETE FROM bdc_qlrxx
WHERE id = #{id}
</update>
</mapper>