XinYu_RZMES/.svn/pristine/47/47b663251a0d4382a319fa99e1684c97786d2227.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="UID020050-MyTest">
	<query id="mytest.select1" desc="无条件查询">
        <![CDATA[
			SELECT * FROM MYTEST
        ]]>
    </query>
	<query id="mytest.select2" desc="有条件查询">
        <![CDATA[
			 SELECT * FROM MYTEST WHERE ID =:1
        ]]>
    </query>
    <query id="mytest.insert" desc="插入数据">
        <![CDATA[
			 INSERT INTO MYTEST VALUES(?,?,to_date(?,'yyyy-mm-dd'),?,?,?)
        ]]>
    </query>
    <query id="mytest.update" desc="修改数据">
        <![CDATA[
			 UPDATE MYTEST SET ID=?,NAME=?,BIRTHDAY=to_date(?,'yyyy-mm-dd'),ADDRESS=?,PHONE=?,EMAIL=? WHERE ID=?
        ]]>
    </query>
 
    <query id="mytest.delete" desc="删除数据">
        <![CDATA[
			DELETE FROM MYTEST WHERE ID=:1
        ]]>
    </query>
</queryMap>