Oracle 数据库插入时间字段

后台类

public void doSave(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Date date = new Date();
		SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
		String finalDate = sdf.format(date);
		
		ParameterSet pset = parseRequest(request);
        Csff bean = new Csff();
        super.parser.parsePramSetToBean(pset, bean);
        boolean sucess = false;
        String idstr = request.getParameter("id");
        System.out.println("更改状态是："+bean.getStatus());
        if (StatusBean.STATUS_NEW.equals(bean.getStatus())) {
            if (StringUtils.isEmpty(idstr)) {
                //bean.setId(HHStringUtils.getUUID32());
            	int num = csffDomain.getId();
            	System.out.println(num);
            	bean.setId(num+1);
            	bean.setFbsj(finalDate);
            }
            sucess = this.csffDomain.insert(bean) == 1;
        } else if (StatusBean.STATUS_UPDATE.equals(bean.getStatus())) {
            sucess = this.csffDomain.update(bean) == 1;
        }
        if (sucess) {
            this.writeAsJson(response, ScreenUtil.mkReturnMap(ScreenUtil.SUCCESS, ScreenUtil.NOMSG, bean));
        } else {
        	if (log.isErrorEnabled()) {
                log.error("保存时出错了！");
            }
            throw new HHBusinessException("保存时出错了！");
        }
    }

创建了date对象为String类型，在SQL中需要转换为DATE类型，使用to_date()方法

<insert id="insert">
		INSERT INTO ZHSZ_SXJK_TZJKCSFF
		(
		ID, TCXMID, CSMD, CDQC, CSFF, ZYSX, SFFB, FBSJ, CJR, BZ
		)
		VALUES
		(
		#{id, jdbcType=INTEGER},
		#{tcxmid, jdbcType=INTEGER},
		#{csmd, jdbcType=VARCHAR},
		#{cdqc, jdbcType=VARCHAR},
		#{csff, jdbcType=VARCHAR},
		#{zysx, jdbcType=VARCHAR},
		#{sffb, jdbcType=INTEGER},
		to_date(#{fbsj, jdbcType=VARCHAR},'yyyy-mm-dd'),
		#{cjr, jdbcType=INTEGER},
		#{bz, jdbcType=VARCHAR}
		)
	</insert>