jdbc连接中间库mysql。插入数据

public void addHousefeedbackcount(HouseFeedbackCount houseFeedbackCount){
    Connection conn = null;
    String url = System.getProperty("yuncai.jdbcurl");
    try {
        Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动
        System.out.println("成功加载MySQL驱动程序");
        conn = DriverManager.getConnection(url);
        if (houseFeedbackCount!=null){
            PreparedStatement ps = null;
            String sql = "   insert into dc_house_feedback_count(failedcount,successcount,biz_name,count,create_date ) VALUES (?,?,?,?,?)";
            ps = conn.prepareStatement(sql,
                    PreparedStatement.RETURN_GENERATED_KEYS);
            ps.setInt(1, houseFeedbackCount.getFailedcount());
            SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            String datestring=sdf.format(new Date());
            Date date=sdf.parse(datestring);
            ps.setInt(2, houseFeedbackCount.getSuccesscount());
            ps.setString(3, houseFeedbackCount.getBizname());
            ps.setInt(4, houseFeedbackCount.getCount());
            ps.setTimestamp(5, new java.sql.Timestamp(date.getTime()));

            int i = ps.executeUpdate();
            if (i>0){
                System.out.println("定时生成任务记录表成功，dc_house_feedback_count");
                log.debug("定时生成任务表成功，dc_house_feedback_count");
            }
        }else{
            System.out.println("定时生成任务记录表失败，dc_house_feedback_count！");
            log.debug("定时生成任务记录表失败，dc_house_feedback_count！");
        }
        conn.close();
    } catch (ClassNotFoundException e) {
        log.debug("mysql驱动加载失败，找不到驱动类");
        e.printStackTrace();
    } catch (SQLException e) {
        log.debug("mysql连接失败");
        e.printStackTrace();
    } catch (ParseException e) {
        log.debug("时间转换失败");
        e.printStackTrace();
    }
}