뚱2's Story

    <!-- CLOB -->
    <resultmap id="selectChangeSeqCLOB" class="my.com.dao.helper.GMap">
        <result property="CONTENT" column="CONTENT" jdbctype="CLOB" javatype="java.lang.String">
    </result></resultmap>   

    <!-- CLOB -->
    <select id="selectLectureChangeListOnlyCLOB" parameterclass="Map" resultmap="selectChangeSeqCLOB">
    /* ProgramID=selectLectureChangeListOnlyCLOB */
    SELECT B.CONTENT
      FROM CHANGESEQ   B
    </select>  

    <update id="updateChangeSeqApprovalOnlyContent" parameterclass="Map">
    /* ProgramID=updateChangeSeqApprovalOnlyContent */
    UPDATE CHANGESEQ
       SET CONTENT     = #content:CLOB#
    </update>

<select name="test"></select>

// 추가
$("< OPTION >< /OPTION >")
  .attr("selected", "selected")
  .text("추가")
  .attr("value", "추가")
  .appendTo("select[name='test']");

// 선택
var value = $("select[name='test'] option:selected").val();
var name = $("select[name='test'] option:selected").text();

// 특정 삭제
$("select[name='test'] option[value='추가']").remove();
// 선택 삭제
$("select[name='test'] option:selected").remove();
// 모두 삭제
$("select[name='test'] option").remove();