/* * (non-Javadoc) * @see * FormsOnlineDAO#createInstance(com.silverpeas.formsonline.model * .FormInstance) */ public FormInstance createInstance(FormInstance instance) throws FormsOnlineDatabaseException { Connection con = getConnection(); try (PreparedStatement stmt = con.prepareStatement(QUERY_INSERT_FORMINSTANCE)) { int id = DBUtil.getNextId(FORMS_INSTANCES_TABLENAME, "id"); stmt.setInt(1, id); stmt.setInt(2, instance.getFormId()); stmt.setInt(3, instance.getState()); stmt.setString(4, instance.getCreatorId()); prepareDateStatement(stmt, 5, instance.getCreationDate()); stmt.setString(6, instance.getValidatorId()); prepareDateStatement(stmt, 7, instance.getValidationDate()); stmt.setString(8, instance.getComments()); stmt.setString(9, instance.getComponentInstanceId()); stmt.executeUpdate(); instance.setId(id); return instance; } catch (SQLException se) { throw new FormsOnlineDatabaseException( "FormsOnlineDAOJdbc.createInstance()", SilverpeasException.ERROR, "formsOnline.INSERTING_FORMINSTANCE_FAILED", se); } finally { freeConnection(con); } }
private FormInstance fetchFormInstance(ResultSet rs) throws SQLException { FormInstance formInstance = new FormInstance(); formInstance.setId(rs.getInt("id")); formInstance.setFormId(rs.getInt("formId")); formInstance.setState(rs.getInt("state")); formInstance.setCreatorId(rs.getString("creatorId")); formInstance.setCreationDate(rs.getTimestamp("creationDate")); formInstance.setValidatorId(rs.getString("validatorId")); formInstance.setValidationDate(rs.getTimestamp("validationDate")); formInstance.setComments(rs.getString("comments")); formInstance.setInstanceId(rs.getString("instanceId")); return formInstance; }