invoice.xml.svn-base

数据库系统教材中附录的课程设计accomodation宿舍管理系统源码

<?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="invoice" type="cn.kmp.accommodation.domain.Invoice"/>
	<typeAlias alias="hashmap" type="java.util.HashMap"/>
	<!-- 娣诲姞甯愬崟 -->
	<insert id="insertInvoice" parameterClass="invoice">
		INSERT INTO invoice(invoiceNum,leaseNum,semester,paymentDue,payDate,payMethod,firstSend,secondSend,isPay)
		VALUES(#invoiceNum#,#leaseNum#,#semester#,#paymentDue#,#payDate#,#payMethod#,#firstSend#,#secondSend#,#isPay#)
	</insert>
	<!-- 娣诲姞甯愬崟 -->
	<!-- 鍒犻櫎甯愬崟BY invoiceNum -->
	<delete id="deleteInvoiceByInvoiceNum" parameterClass="int">
		DELETE FROM invoice
		WHERE invoiceNum=#invoiceNum#
	</delete>
	<!-- 鍒犻櫎甯愬崟 BY invoiceNum-->
	<!-- 鍒犻櫎甯愬崟BY leaseNum -->
	<delete id="deleteInvoiceByLeaseNum" parameterClass="int">
		DELETE FROM invoice
		WHERE leaseNum=#leaseNum#
	</delete>
	<!-- 鍒犻櫎甯愬崟BY leaseNum -->
	
	<!-- 鏇存柊甯愬崟 -->
	<update id="updateInvoice" parameterClass="invoice">
		UPDATE invoice
		SET isPay=#isPay#,
		semester=#semester#,
		paymentDue=#paymentDue#,
		payDate=#payDate#,
		payMethod=#payMethod#,
		firstSend=#firstSend#,
		secondSend=#secondSend#,
		leaseNum=#leaseNum#
		WHERE invoiceNum=#invoiceNum#
	</update>
	<!-- 鏇存柊甯愬崟 -->
	
	<!-- 鍩虹