获取数据库的自增长序列
<!-- 获取站内信编号(日期+数列自增长) -->
<select id="selectSeqNo" resultType="string">
<![CDATA[
select to_char(sysdate,'YYYYMMDD')||SEQ_MESSAGETEXT_ID.NEXTVAL from dual
]]>
</select>
<!-- 查询机构开户申请流水号 -->
<select id="selectOrderId" resultType="string">
<![CDATA[
select to_char(SYSDATE, 'yyyymmdd') ||
lpad(to_char(SEQ_APPCORPACCT.nextval), 12, '0')
from dual
]]>
</select>
<!-- 新增反馈信息(登录用户) -->
<insert id="insertFeedBackMsgLogin" parameterType="com.bosera.iof.emp.beans.FeedbackMsgVO">
<![CDATA[
insert into feedbackmsg_login
(ID, MESSAGE, FUNDACCT, ADDTIME,IDTP,IDNO,DISTRIBUTORTYPE,NAME,OPID)
VALUES
(to_char(sysdate,'YYYYMMDD')||SEQ_FEEDBACKMSG_LOGIN.NEXTVAL, #{message}, #{fundAcct}, sysdate,#{idTp},#{idNo},#{distributorType},#{name},#{opId})
]]>
</insert>
create sequence SEQ_PINGAN
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;