vote_a.xml.svn-base

一个实用的CMS管理

<?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 namespace="Vote_a"> 
<typeAlias alias="vote_a" type="com.suncms.domain.Vote_a"/> 

<resultMap id="vote_aInfoResult"  class="Vote_a"> 
<result property="row_id" column="ROW_ID"/> 
<result property="vote_item" column="VOTE_ITEM"/> 
<result property="vote_id" column="VOTE_ID"/> 
<result property="polled" column="POLLED"/> 
 </resultMap> 
<insert id="insertVote_a" parameterClass="vote_a"> 
INSERT INTO 
Vote_a (
ROW_ID,
VOTE_ITEM,
VOTE_ID,
POLLED
)
 values(
#row_id#,
#vote_item#,
#vote_id#,
#polled#
) 
</insert> 
<select id="getVoteaByVoteID" resultMap="vote_aInfoResult" parameterClass="java.lang.String">
      select * from Vote_a where VOTE_ID=#vote_id#
</select>
<update id="updateVoteaPolled" parameterClass="java.lang.String">
      update vote_a set polled=polled+1 where row_id=#row_id#
</update>
</sqlMap>