vote_q.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_q"> 
<typeAlias alias="vote_q" type="com.suncms.domain.Vote_q"/> 

<resultMap id="vote_qInfoResult"  class="Vote_q"> 
<result property="row_id" column="ROW_ID"/> 
<result property="vote_title" column="VOTE_TITLE"/> 
<result property="vote_type" column="VOTE_TYPE"/> 
<result property="vote_status" column="VOTE_STATUS"/> 
<result property="vote_createtime" column="VOTE_CREATETIME"/>
<result property="vote_content" column="VOTE_CONTENT"/>
<result property="votealist" column="row_id" select="getVoteaByVoteID" /> 
</resultMap> 
<insert id="insertVote_q" parameterClass="vote_q"> 
INSERT INTO 
Vote_q (
ROW_ID,
VOTE_TITLE,
VOTE_TYPE,
VOTE_STATUS,
VOTE_CREATETIME,
VOTE_CONTENT
)
 values(
#row_id#,
#vote_title#,
#vote_type#,
#vote_status#,
#vote_createtime#,
#vote_content#
) 
</insert> 
<select id="getAllVoteq" resultMap="vote_qInfoResult" >
      select * from Vote_q
</select>
<select id="getVoteqByF" resultMap="vote_qInfoResult" >
      select * from Vote_q where VOTE_STATUS='V'
</select>
<select id="getVoteqById" resultMap="vote_qInfoResult" parameterClass="java.lang.String">
      select * from Vote_q where ROW_ID=#row_id#
</select>
<update id="updateVoteF" >
      update Vote_q set VOTE_STATUS='F'
</update>
</sqlMap>