query.properties

java 编写的程序

#
# Tablenames
#
C_TABLE_RESOURCES=CMS_RESOURCES
C_TABLE_RESOURCES_ONLINE=CMS_ONLINE_RESOURCES
C_TABLE_RESOURCES_BACKUP=CMS_BACKUP_RESOURCES
C_TABLE_FILES=CMS_FILES
C_TABLE_FILES_ONLINE=CMS_ONLINE_FILES
C_TABLE_FILES_BACKUP=CMS_BACKUP_FILES
C_TABLE_PROPERTIES=CMS_PROPERTIES
C_TABLE_PROPERTIES_ONLINE=CMS_ONLINE_PROPERTIES
C_TABLE_PROPERTIES_BACKUP=CMS_BACKUP_PROPERTIES
C_TABLE_PROPERTYDEF=CMS_PROPERTYDEF
C_TABLE_PROPERTYDEF_ONLINE=CMS_ONLINE_PROPERTYDEF
C_TABLE_PROPERTYDEF_BACKUP=CMS_BACKUP_PROPERTYDEF
C_TABLE_EXPORT_LINKS=CMS_EXPORT_LINKS
C_TABLE_EXPORT_DEPENDENCIES=CMS_EXPORT_DEPENDENCIES
#
# Projects
#
C_PROJECTS_PROJECT_ID=PROJECT_ID
C_PROJECTS_USER_ID=USER_ID
C_PROJECTS_GROUP_ID=GROUP_ID
C_PROJECTS_MANAGERGROUP_ID=MANAGERGROUP_ID
C_PROJECTS_TASK_ID=TASK_ID
C_PROJECTS_PROJECT_NAME=PROJECT_NAME
C_PROJECTS_PROJECT_DESCRIPTION=PROJECT_DESCRIPTION
C_PROJECTS_PROJECT_FLAGS=PROJECT_FLAGS
C_PROJECTS_PROJECT_CREATEDATE=PROJECT_CREATEDATE
C_PROJECTS_PROJECT_TYPE=PROJECT_TYPE
C_PROJECTS_RECORD=PROJECT_ID, USER_ID, GROUP_ID, MANAGERGROUP_ID, TASK_ID, PROJECT_NAME, \
                  PROJECT_DESCRIPTION, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                  PROJECT_TYPE
C_PROJECTS_MAXID=SELECT MAX(PROJECT_ID) FROM CMS_PROJECTS
C_PROJECTS_CREATE=INSERT INTO CMS_PROJECTS \
                  (PROJECT_ID, USER_ID, GROUP_ID, MANAGERGROUP_ID, TASK_ID, PROJECT_NAME, \
                   PROJECT_DESCRIPTION, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                   PROJECT_TYPE) VALUES (?,?,?,?,?,?,?,?,?,?)
C_PROJECTS_READ=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                PROJECT_TYPE FROM CMS_PROJECTS \
                WHERE PROJECT_ID=?  ORDER BY PROJECT_NAME
C_PROJECTS_READ_BYTASK=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                       USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                       PROJECT_TYPE FROM CMS_PROJECTS \
                       WHERE TASK_ID=?  ORDER BY PROJECT_NAME
C_PROJECTS_READ_BYUSER=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                       USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                       PROJECT_TYPE FROM CMS_PROJECTS \
                       WHERE USER_ID=?  \
                       AND PROJECT_FLAGS=0 \
                       ORDER BY PROJECT_NAME
C_PROJECTS_READ_BYGROUP=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                        USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                        PROJECT_TYPE FROM CMS_PROJECTS \
                        WHERE (GROUP_ID=?  OR MANAGERGROUP_ID=?) \
                        AND PROJECT_FLAGS=0 \
                        ORDER BY PROJECT_NAME
C_PROJECTS_READ_BYFLAG=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                       USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                       PROJECT_TYPE \
                       FROM CMS_PROJECTS \
                       WHERE PROJECT_FLAGS=?  \
                       ORDER BY PROJECT_NAME
C_PROJECTS_READ_BYMANAGER=SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,  \
                          USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS, PROJECT_CREATEDATE, \
                          PROJECT_TYPE FROM CMS_PROJECTS \
                          WHERE MANAGERGROUP_ID=?  \
                          AND PROJECT_FLAGS=0 \
                          ORDER BY PROJECT_NAME
C_PROJECTS_DELETE=DELETE FROM CMS_PROJECTS WHERE PROJECT_ID=?
C_PROJECTS_WRITE=UPDATE CMS_PROJECTS SET USER_ID=?, GROUP_ID=?, MANAGERGROUP_ID=?, PROJECT_FLAGS=?, \
                 WHERE PROJECT_ID=?
C_PROJECTS_NEWFILES=SELECT * FROM CMS_RESOURCES WHERE PROJECT_ID = ?  \
                    AND STATE = ?  \
                    AND RESOURCE_TYPE != ?
C_PROJECTS_NEWFOLDERS=SELECT * FROM CMS_RESOURCES WHERE PROJECT_ID = ?  \
                    AND STATE = ?  \
                    AND RESOURCE_TYPE = ?  \
                    ORDER BY RESOURCE_NAME DESC
#
# Projecthistory
#
C_PROJECTS_CREATE_BACKUP=INSERT INTO CMS_BACKUP_PROJECTS \
                         (VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_PUBLISHDATE, PROJECT_PUBLISHED_BY, \
                         PROJECT_PUBLISHED_BY_NAME, USER_ID, USER_NAME, GROUP_ID, GROUP_NAME, \
                         MANAGERGROUP_ID, MANAGERGROUP_NAME, PROJECT_DESCRIPTION, PROJECT_CREATEDATE, \
                         PROJECT_TYPE, TASK_ID) \
                         VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
C_PROJECTS_READBYVERSION_BACKUP=SELECT VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_PUBLISHDATE, PROJECT_PUBLISHED_BY, \
                                PROJECT_PUBLISHED_BY_NAME, USER_ID, USER_NAME, GROUP_ID, GROUP_NAME, \
                                MANAGERGROUP_ID, MANAGERGROUP_NAME, PROJECT_DESCRIPTION, PROJECT_CREATEDATE, \
                                PROJECT_TYPE, TASK_ID \
                                FROM CMS_BACKUP_PROJECTS \
                                WHERE VERSION_ID = ?
C_PROJECTS_READBYPROJECTID_BACKUP=SELECT VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_PUBLISHDATE, PROJECT_PUBLISHED_BY, \
                                PROJECT_PUBLISHED_BY_NAME, USER_ID, USER_NAME, GROUP_ID, GROUP_NAME, \
                                MANAGERGROUP_ID, MANAGERGROUP_NAME, PROJECT_DESCRIPTION, PROJECT_CREATEDATE, \
                                PROJECT_TYPE, TASK_ID \
                                FROM CMS_BACKUP_PROJECTS \
                                WHERE PROJECT_ID = ?  \
                                ORDER BY VERSION_ID
C_PROJECTS_READALL_BACKUP=SELECT VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_PUBLISHDATE, PROJECT_PUBLISHED_BY, \
                         PROJECT_PUBLISHED_BY_NAME, USER_ID, USER_NAME, GROUP_ID, GROUP_NAME, \
                         MANAGERGROUP_ID, MANAGERGROUP_NAME, PROJECT_DESCRIPTION, PROJECT_CREATEDATE, \
                         PROJECT_TYPE, TASK_ID \
                         FROM CMS_BACKUP_PROJECTS \
                         ORDER BY VERSION_ID DESC
C_PROJECTS_READLAST_BACKUP=SELECT * FROM (SELECT VERSION_ID, PROJECT_ID, PROJECT_NAME, PROJECT_PUBLISHDATE, PROJECT_PUBLISHED_BY, \
                         PROJECT_PUBLISHED_BY_NAME, PROJECT_DESCRIPTION, TASK_ID, USER_ID, USER_NAME, GROUP_ID, GROUP_NAME, \
                         MANAGERGROUP_ID, MANAGERGROUP_NAME, PROJECT_CREATEDATE, PROJECT_TYPE \
                         FROM CMS_BACKUP_PROJECTS \
                         ORDER BY VERSION_ID DESC) \
                         WHERE ROWNUM <= ?
C_PROJECTRESOURCES_CREATE_BACKUP=INSERT INTO CMS_BACKUP_PROJECTRESOURCES \
                                 (VERSION_ID, PROJECT_ID, RESOURCE_NAME) VALUES (?,?,?)
C_PROJECTRESOURCES_READ_BACKUP=SELECT RESOURCE_NAME \
                               FROM CMS_BACKUP_PROJECTRESOURCES \
                               WHERE VERSION_ID = ?
#
# Projectresources
#
C_PROJECTRESOURCES_CREATE=INSERT INTO CMS_PROJECTRESOURCES (PROJECT_ID, RESOURCE_NAME) \
                          VALUES (?, ?)
C_PROJECTRESOURCES_WRITE=UPDATE CMS_PROJECTRESOURCES SET RESOURCE_NAME = ?  \
                         WHERE PROJECT_ID = ?  AND RESOURCE_NAME = ?
C_PROJECTRESOURCES_DELETE=DELETE FROM CMS_PROJECTRESOURCES \
                          WHERE PROJECT_ID = ?  AND RESOURCE_NAME = ?
C_PROJECTRESOURCES_DELETEALL=DELETE FROM CMS_PROJECTRESOURCES \
                             WHERE PROJECT_ID = ?
C_PROJECTRESOURCES_READ=SELECT RESOURCE_NAME FROM CMS_PROJECTRESOURCES \
                        WHERE PROJECT_ID = ?  AND RESOURCE_NAME = ?
C_PROJECTRESOURCES_READALL=SELECT RESOURCE_NAME FROM CMS_PROJECTRESOURCES \
                           WHERE PROJECT_ID = ?
#
# Resources
#
C_RESOURCES_RESOURCE_ID=RESOURCE_ID
C_RESOURCES_VERSION_ID=VERSION_ID
C_RESOURCES_PARENT_ID=PARENT_ID
C_RESOURCES_RESOURCE_TYPE=RESOURCE_TYPE
C_RESOURCES_RESOURCE_FLAGS=RESOURCE_FLAGS
C_RESOURCES_FILE_ID=FILE_ID
C_RESOURCES_RESOURCE_NAME=RESOURCE_NAME
C_RESOURCES_USER_ID=USER_ID
C_RESOURCES_USER_NAME=USER_NAME
C_RESOURCES_GROUP_ID=GROUP_ID
C_RESOURCES_GROUP_NAME=GROUP_NAME
C_RESOURCES_PROJECT_ID=PROJECT_ID
C_PROJECT_ID_RESOURCES=CMS_RESOURCES.PROJECT_ID
C_RESOURCE_FLAGS=RESOURCE_FLAGS
C_RESOURCES_ACCESS_FLAGS=ACCESS_FLAGS
C_RESOURCES_STATE=STATE
C_RESOURCES_LOCKED_BY=LOCKED_BY
C_RESOURCES_LAUNCHER_TYPE=LAUNCHER_TYPE
C_RESOURCES_LAUNCHER_CLASSNAME=LAUNCHER_CLASSNAME
C_RESOURCES_DATE_CREATED=DATE_CREATED
C_RESOURCES_DATE_LASTMODIFIED=DATE_LASTMODIFIED
C_RESOURCES_SIZE=RESOURCE_SIZE
C_RESOURCES_LASTMODIFIED_BY=RESOURCE_LASTMODIFIED_BY
C_RESOURCES_LASTMODIFIED_BY_NAME=RESOURCE_LASTMODIFIED_BY_NAME
C_RESOURCES_FILE_CONTENT=FILE_CONTENT
# Statements
C_RESOURCES_MAXID=SELECT MAX(RESOURCE_ID) FROM CMS_RESOURCES
C_RESOURCES_MAXID_ONLINE=SELECT MAX(RESOURCE_ID) FROM CMS_ONLINE_RESOURCES
C_RESOURCES_COUNT_SUBRESOURCES=SELECT COUNT(*) FROM CMS_RESOURCES \
                               WHERE PARENT_ID = ?
C_RESOURCES_WRITE=INSERT INTO CMS_RESOURCES VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
C_RESOURCES_WRITE_ONLINE=INSERT INTO CMS_ONLINE_RESOURCES \
                         (RESOURCE_ID, PARENT_ID, RESOURCE_NAME, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                          GROUP_ID, PROJECT_ID, FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                          LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_SIZE, \
                          RESOURCE_LASTMODIFIED_BY) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
C_RESOURCES_WRITE_BACKUP=INSERT INTO CMS_BACKUP_RESOURCES \
                         (RESOURCE_ID, PARENT_ID, RESOURCE_NAME, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                          USER_NAME, GROUP_ID, GROUP_NAME, PROJECT_ID, FILE_ID, ACCESS_FLAGS, STATE, LAUNCHER_TYPE, \
                          LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_SIZE, \
                          RESOURCE_LASTMODIFIED_BY, RESOURCE_LASTMODIFIED_BY_NAME, VERSION_ID) \
                          VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
C_RESOURCES_UPDATE=UPDATE CMS_RESOURCES SET \
                   RESOURCE_TYPE=?, RESOURCE_FLAGS=?, USER_ID=?, GROUP_ID=?, \