/** * @see org.opencms.db.I_CmsProjectDriver#writeProject(org.opencms.db.CmsDbContext, org.opencms.file.CmsProject) */ public void writeProject(CmsDbContext dbc, CmsProject project) throws CmsDataAccessException { if (CmsStringUtil.isEmptyOrWhitespaceOnly(project.getDescription())) { project.setDescription(" "); } Connection conn = null; PreparedStatement stmt = null; try { // get a JDBC connection from the OpenCms standard pools conn = m_sqlManager.getConnection(dbc); stmt = m_sqlManager.getPreparedStatement(conn, "C_PROJECTS_WRITE_6"); stmt.setString(1, project.getDescription()); stmt.setString(2, project.getGroupId().toString()); stmt.setString(3, project.getManagerGroupId().toString()); stmt.setInt(4, project.getFlags()); stmt.setInt(5, project.getType().getMode()); stmt.setString(6, project.getUuid().toString()); stmt.executeUpdate(); } catch (SQLException e) { throw new CmsDbSqlException( Messages.get().container(Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)), e); } finally { m_sqlManager.closeAll(dbc, conn, stmt, null); } }
/** * @see org.opencms.db.I_CmsProjectDriver#writeProject(org.opencms.db.CmsDbContext, org.opencms.file.CmsProject) */ public void writeProject(CmsDbContext dbc, CmsProject project) throws CmsDataAccessException { if (CmsStringUtil.isEmptyOrWhitespaceOnly(project.getDescription())) { project.setDescription(" "); } Connection conn = null; PreparedStatement stmt = null; try { // get a JDBC connection from the OpenCms standard pools conn = m_sqlManager.getConnection(dbc); stmt = m_sqlManager.getPreparedStatement(conn, "C_PROJECTS_WRITE_6"); stmt.setString(1, project.getDescription()); stmt.setString(2, project.getGroupId().toString()); stmt.setString(3, project.getManagerGroupId().toString()); stmt.setInt(4, project.getFlags()); stmt.setInt(5, project.getType().getMode()); stmt.setString(6, project.getUuid().toString()); stmt.executeUpdate(); } catch (SQLException e) { throw new CmsDbSqlException(Messages.get().container( Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)), e); } finally { m_sqlManager.closeAll(dbc, conn, stmt, null); } }
/** * Saves an existing project.<p> */ private void saveProject() { CmsObject cms = A_CmsUI.getCmsObject(); try { m_project.setDescription(m_fieldDescription.getValue()); m_project.setGroupId(cms.readGroup(m_fieldUser.getValue()).getId()); m_project.setManagerGroupId(cms.readGroup(m_fieldManager.getValue()).getId()); m_project.setDeleteAfterPublishing(m_fieldDeleteAfterPublish.getValue().booleanValue()); cms.writeProject(m_project); updateProjectResources(); } catch (Throwable t) { CmsErrorDialog.showErrorDialog(t); } }
/** * @see org.opencms.db.I_CmsProjectDriver#writeProject(org.opencms.db.CmsDbContext, org.opencms.file.CmsProject) */ public void writeProject(CmsDbContext dbc, CmsProject project) throws CmsDataAccessException { if (CmsStringUtil.isEmptyOrWhitespaceOnly(project.getDescription())) { project.setDescription(" "); } try { Query q = m_sqlManager.createQuery(dbc, C_PROJECTS_WRITE_6); q.setParameter(1, project.getUuid().toString()); List<CmsDAOProjects> res = q.getResultList(); for (CmsDAOProjects pr : res) { pr.setProjectDescription(project.getDescription()); pr.setGroupId(project.getGroupId().toString()); pr.setManagerGroupId(project.getManagerGroupId().toString()); pr.setProjectFlags(project.getFlags()); pr.setProjectType(project.getType().getMode()); } } catch (PersistenceException e) { throw new CmsDataAccessException(Messages.get().container(Messages.ERR_JPA_PERSITENCE_1, e), e); } }