cms河南移动内容管理系统
1。下面的一个例子显示了两个要点
a.对oracle大对象blob对象的处理
b.对oracle日期对象的处理（oracle日期对象为timestamp）
?
/**
??? ?* 保存新增的对象.
??? ?*/
??? public void saveTiewithBlob(final BbsTie vo)throws DataAccessException{
??? ??? getJdbcTemplate().execute(
??? ??? ??? ??? "INSERT INTO BBS_TIE (TIE_ID,TIE_NAME,TIE_DESC, CREATE_USERID,CREATE_DATE,CREATE_USERNAME,SUBJECT_ID) VALUES (SQ_bbs_TIE_PRIMARY_ID.nextval,?,?,?,?,?,?)",
??? ??? ??? ??? new AbstractLobCreatingPreparedStatementCallback(this.lobHandler) {
??? ??? ??? ??? ??? protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
??? ??? ??? ??? ??? ??? ps.setString(1, vo.getTieName());
??? ??? ??? ??? ??? ??? try {
??? ??? ??? ??? ??? ??? ??? lobCreator.setBlobAsBinaryStream(ps, 2, IOUtils.toInputStream(vo.getTieDesc()), IOUtils.toInputStream(vo.getTieDesc()).available());
??? ??? ??? ??? ??? ??? } catch (IOException e) {
??? ??? ??? ??? ??? ??? ??? e.printStackTrace();
??? ??? ??? ??? ??? ??? }
??? ??? ??? ??? ??? ??? ps.setString(3, vo.getCreateUserid());
??? ??? ??? ??? ??? ??? ps.setTimestamp(4, new java.sql.Timestamp(vo.getCreateDate().getTime()));
??? ??? ??? ??? ??? ??? ps.setString(5, vo.getCreateUsername());
??? ??? ??? ??? ??? ??? ps.setString(6, vo.getSubjectId());
??? ??? ??? ??? ??? }
??? ??? ??? ??? }
??? ??? );
??? }
?
?
2。
alter table TB_SV_ACTIVECOSTINFO modify ACTIVE_ID VARCHAR2(100);//修改表字段
truncate table tb_sv_activecostinfo;//清空表
3.
if(flg){//正在进行中的活动
??? ??? ??? sqlEntity.append(" and to_char(t.UNEFFECT_DATE,'yyyy-mm-dd') >= ? ",new java.sql.Date(date.getTime()));
??? ??? } else {//历史活动
??? ??? ??? sqlEntity.append(" and to_char(t.UNEFFECT_DATE,'yyyy-mm-dd') < ? ",new java.sql.Date(date.getTime()));
??? ??? }
