📄 family.xml.svn-base
字号:
<?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>
<typeAlias alias="family" type="cn.kmp.accommodation.domain.Family"/>
<!-- 鏍规嵁familyNum鏉ヨ幏寰梖amily -->
<select id="getFamilyByFamilyNum" parameterClass="int" resultClass="family">
SELECT *
FROM family
WHERE familyNum=#familyNum#
</select>
<!-- 鏍规嵁familyNum鏉ヨ幏寰梖amily -->
<!-- 鏍规嵁瀛︾敓鍙疯幏寰梖amily -->
<select id="getFamilyByStudentNum" parameterClass="int" resultClass="family">
SELECT *
FROM family
WHERE studentNum=#studentNum#
</select>
<!-- 鏍规嵁瀛﹀彿鑾峰緱family -->
<!-- 娣诲姞family-->
<insert id="insertFamily" parameterClass="family">
INSERT INTO family
VALUES(#familyNum#,#studentNum#,#name#,#relationship#,#phoneNumber#,#street#,#city#,#postcode#)
</insert>
<!-- 娣诲姞family -->
<!-- 鏍规嵁familyNum鍒犻櫎family -->
<delete id="deleteFamilyByFamilyNum" parameterClass="int">
DELETE FROM family
WHERE familyNum=#familyNum#
</delete>
<!-- 鏍规嵁familyNum鍒犻櫎family -->
<!-- 鏍规嵁studentNum鍒犻櫎family -->
<delete id="deleteFamilyByStudentNum" parameterClass="int">
DELETE FROM family
WHERE studentNum=#studentNum#
</delete>
<!-- 鏍规嵁studentNum鍒犻櫎family -->
<!--鏇存柊familyBYFamilyNum-->
<update id="updateFamilyByFamilyNum" parameterClass="family">
UPDATE family
SET studentNum=#studentNum#,
name=#name#,
relationship=#relationship#,
phoneNumber=#phoneNumber#,
street=#street#,
city=#city#,
postcode=#postcode#
WHERE familyNum=#familyNum#
</update>
<!-- 鏇存柊familyBYFamilyNum -->
<!-- 鏇存柊familyBYstudentNum -->
<update id="updateFamilyByStudentNum" parameterClass="int">
UPDATE family
SET familyNum=#familyNum#,
name=#name#,
relationship=#relationship#,
phoneNumber=#phoneNumber#,
street=#street#,
city=#city#,
postcode=#postcode#
WHERE studentNum=#studentNum#
</update>
<!-- 鏇存柊familyBYstudentNum -->
</sqlMap>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -