query.properties

java 编写的程序

                               AND CMS_RESOURCES.PROJECT_ID=?
C_RESOURCES_COUNTLOCKED_ONLINE=SELECT COUNT(RESOURCE_ID) FROM CMS_ONLINE_RESOURCES \
                               WHERE LOCKED_BY <> -1 \
                               AND PROJECT_ID=?
C_RESOURCES_ID_DELETE=DELETE FROM CMS_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_ID_DELETE_ONLINE=DELETE FROM CMS_ONLINE_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_DELETE=DELETE FROM CMS_RESOURCES \
                   WHERE RESOURCE_NAME=?
C_RESOURCES_DELETE_ONLINE=DELETE FROM CMS_ONLINE_RESOURCES \
                          WHERE RESOURCE_NAME=?
C_RESOURCES_DELETE_PROJECT=DELETE FROM CMS_RESOURCES WHERE PROJECT_ID=?
C_RESOURCES_REMOVE=UPDATE CMS_RESOURCES SET STATE=?, LOCKED_BY=?  \
                   WHERE RESOURCE_NAME=?
C_RESOURCES_REMOVE_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET STATE=?, LOCKED_BY=?  \
                          WHERE RESOURCE_NAME=?
C_RESOURCES_DELETEBYID=DELETE FROM CMS_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_DELETEBYID_ONLINE=DELETE FROM CMS_ONLINE_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_GET_LOST_ID=SELECT FILE_ID FROM CMS_FILES \
                        WHERE FILE_ID NOT IN (SELECT FILE_ID FROM CMS_RESOURCES)
C_RESOURCES_GET_LOST_ID_ONLINE=SELECT FILE_ID FROM CMS_ONLINE_FILES \
                               WHERE FILE_ID NOT IN (SELECT FILE_ID FROM CMS_ONLINE_RESOURCES)
C_RESOURCES_DELETE_LOST_ID=DELETE FROM CMS_FILES \
                           WHERE FILE_ID NOT IN (SELECT FILE_ID FROM CMS_RESOURCES)
C_RESOURCES_DELETE_LOST_ID_ONLINE=DELETE FROM CMS_ONLINE_FILES \
                                  WHERE FILE_ID NOT IN (SELECT FILE_ID FROM CMS_ONLINE_RESOURCES)
C_RESOURCES_PUBLISH_MARKED=SELECT CMS_ONLINE_RESOURCES.*, CMS_RESOURCES.* \
                           FROM CMS_ONLINE_RESOURCES, CMS_RESOURCES, CMS_PROJECTRESOURCES \
                           WHERE CMS_PROJECTRESOURCES.PROJECT_ID=?  \
                           AND CMS_ONLINE_RESOURCES.PROJECT_ID=?  \
                           AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                           AND CMS_RESOURCES.RESOURCE_NAME=CMS_ONLINE_RESOURCES.RESOURCE_NAME \
                           AND CMS_RESOURCES.STATE=?  \
                           ORDER BY CMS_RESOURCES.RESOURCE_NAME
C_RESOURCES_PUBLISH_PROJECT_READFILE=SELECT CMS_RESOURCES.RESOURCE_NAME, RESOURCE_ID,PARENT_ID, \
                                            FILE_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                                            GROUP_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                                            LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, \
                                            RESOURCE_LASTMODIFIED_BY, RESOURCE_SIZE \
                                            FROM CMS_RESOURCES \
                                            WHERE CMS_RESOURCES.PROJECT_ID=?  \
                                            AND CMS_RESOURCES.RESOURCE_TYPE <> 0
C_RESOURCES_PUBLISH_PROJECT_READFOLDER=SELECT CMS_RESOURCES.RESOURCE_NAME, RESOURCE_ID, PARENT_ID, \
                                              FILE_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                                              GROUP_ID, ACCESS_FLAGS, STATE, LOCKED_BY, \
                                              LAUNCHER_TYPE, LAUNCHER_CLASSNAME, DATE_CREATED, \
                                              DATE_LASTMODIFIED, RESOURCE_LASTMODIFIED_BY, \
                                              RESOURCE_SIZE FROM CMS_RESOURCES \
                                              WHERE CMS_RESOURCES.PROJECT_ID=?  \
                                              AND CMS_RESOURCES.RESOURCE_TYPE <> 0
C_RESOURCES_BACKUP_MAXVER=SELECT MAX(VERSION_ID) FROM CMS_BACKUP_PROJECTS
C_RESOURCES_BACKUP_MAXVER_RESOURCE=SELECT MAX(VERSION_ID) FROM CMS_BACKUP_RESOURCES
C_RESOURCES_UPDATE_PROJECTID=UPDATE CMS_RESOURCES SET PROJECT_ID = ?  \
                             WHERE RESOURCE_NAME = ?
C_RESOURCES_PROJECTVIEW=SELECT CMS_RESOURCES.*, PROJECT_ID LOCKED_IN_PROJECT \
                        FROM CMS_RESOURCES \
                        WHERE PROJECT_ID = ?
C_RESOURCES_GETTEMPFILES=SELECT RESOURCE_ID, FILE_ID FROM CMS_RESOURCES WHERE RESOURCE_NAME LIKE ?
C_RESOURCES_DELETETEMPFILES=DELETE FROM CMS_RESOURCES WHERE RESOURCE_NAME LIKE ?

C_RESOURCES_READ_LIKENAME_1=SELECT CMS_RESOURCES.RESOURCE_ID, CMS_RESOURCES.PARENT_ID, \
                     CMS_RESOURCES.RESOURCE_NAME, CMS_RESOURCES.RESOURCE_TYPE, \
                     CMS_RESOURCES.RESOURCE_FLAGS, CMS_RESOURCES.USER_ID, \
                     CMS_RESOURCES.GROUP_ID, CMS_PROJECTRESOURCES.PROJECT_ID, \
                     CMS_RESOURCES.FILE_ID, CMS_RESOURCES.ACCESS_FLAGS, CMS_RESOURCES.STATE, \
                     CMS_RESOURCES.LOCKED_BY, CMS_RESOURCES.LAUNCHER_TYPE, \
                     CMS_RESOURCES.LAUNCHER_CLASSNAME, CMS_RESOURCES.DATE_CREATED, \
                     CMS_RESOURCES.DATE_LASTMODIFIED, CMS_RESOURCES.RESOURCE_SIZE, \
                     CMS_RESOURCES.RESOURCE_LASTMODIFIED_BY, \
                     CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                     FROM CMS_RESOURCES, CMS_PROJECTRESOURCES \
                     WHERE CMS_RESOURCES.RESOURCE_NAME LIKE '%
C_RESOURCES_READ_LIKENAME_2= %' AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                     AND CMS_PROJECTRESOURCES.PROJECT_ID IN (?, 1) \
                     ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_READ_LIKENAME_1_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                        FROM CMS_ONLINE_RESOURCES \
                        WHERE RESOURCE_NAME LIKE '%
C_RESOURCES_READ_LIKENAME_2_ONLINE=%' AND PROJECT_ID = ?

C_RESOURCES_READ_FILESBYTYPE=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_NAME, RESOURCE_TYPE, \
                   RESOURCE_FLAGS, USER_ID, GROUP_ID, PROJECT_ID, \
                   CMS_RESOURCES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_SIZE, \
                   RESOURCE_LASTMODIFIED_BY, CMS_FILES.FILE_CONTENT, PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_RESOURCES, CMS_FILES \
                   WHERE CMS_RESOURCES.FILE_ID=CMS_FILES.FILE_ID \
                   AND RESOURCE_TYPE=?  \
                   ORDER BY RESOURCE_NAME
C_RESOURCES_READ_FILESBYTYPE_ONLINE=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_NAME, RESOURCE_TYPE, \
                   RESOURCE_FLAGS, USER_ID, GROUP_ID, PROJECT_ID, \
                   CMS_ONLINE_RESOURCES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_SIZE, \
                   RESOURCE_LASTMODIFIED_BY, CMS_ONLINE_FILES.FILE_CONTENT, PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_ONLINE_RESOURCES, CMS_ONLINE_FILES \
                   WHERE CMS_ONLINE_RESOURCES.FILE_ID=CMS_ONLINE_FILES.FILE_ID \
                   AND RESOURCE_TYPE=?  \
                   ORDER BY RESOURCE_NAME
#
# Files
#
C_FILE_ID=FILE_ID
C_FILE_CONTENT=FILE_CONTENT
C_FILES_MAXID=SELECT MAX(FILE_ID) FROM CMS_FILES
C_FILES_MAXID_ONLINE=SELECT MAX(FILE_ID) FROM CMS_ONLINE_FILES
C_FILES_WRITE=INSERT INTO CMS_FILES VALUES(?,?)
C_FILES_WRITE_ONLINE=INSERT INTO CMS_ONLINE_FILES VALUES(?,?)
C_FILES_WRITE_BACKUP=INSERT INTO CMS_BACKUP_FILES VALUES(?,?)
C_FILES_UPDATE=UPDATE CMS_FILES SET FILE_CONTENT=?  WHERE FILE_ID=?
C_FILES_UPDATE_ONLINE=UPDATE CMS_ONLINE_FILES SET FILE_CONTENT=?  WHERE FILE_ID=?
C_FILES_READ=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   GROUP_ID,CMS_FILES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_LASTMODIFIED_BY, \
                   RESOURCE_SIZE, CMS_FILES.FILE_CONTENT, CMS_PROJECTRESOURCES.PROJECT_ID, \
                   CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_RESOURCES, CMS_FILES, CMS_PROJECTRESOURCES \
                   WHERE CMS_RESOURCES.FILE_ID=CMS_FILES.FILE_ID \
                   AND CMS_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                   AND CMS_PROJECTRESOURCES.PROJECT_ID IN (?, 1) \
                   ORDER BY CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_FILES_READ_ONLINE=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   GROUP_ID,CMS_ONLINE_FILES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_LASTMODIFIED_BY, \
                   RESOURCE_SIZE, CMS_ONLINE_FILES.FILE_CONTENT, PROJECT_ID, \
                   PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES \
                   WHERE CMS_ONLINE_RESOURCES.FILE_ID=CMS_ONLINE_FILES.FILE_ID \
                   AND CMS_ONLINE_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_ONLINE_RESOURCES.PROJECT_ID=?
C_FILES_READ_BACKUP=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   USER_NAME, GROUP_ID, GROUP_NAME, CMS_BACKUP_FILES.FILE_ID, ACCESS_FLAGS, \
                   STATE, LAUNCHER_TYPE, LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, \
                   RESOURCE_LASTMODIFIED_BY, RESOURCE_LASTMODIFIED_BY_NAME, \
                   RESOURCE_SIZE, CMS_BACKUP_FILES.FILE_CONTENT, PROJECT_ID, \
                   PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_BACKUP_RESOURCES,CMS_BACKUP_FILES \
                   WHERE CMS_BACKUP_RESOURCES.FILE_ID=CMS_BACKUP_FILES.FILE_ID \
                   AND CMS_BACKUP_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_BACKUP_RESOURCES.VERSION_ID=?
C_FILES_READINPROJECT=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   GROUP_ID,CMS_FILES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_LASTMODIFIED_BY, \
                   RESOURCE_SIZE, CMS_FILES.FILE_CONTENT, \
                   PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_RESOURCES, CMS_FILES, CMS_PROJECTRESOURCES \
                   WHERE CMS_RESOURCES.FILE_ID=CMS_FILES.FILE_ID \
                   AND CMS_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                   AND CMS_PROJECTRESOURCES.PROJECT_ID = ?
C_FILES_READINPROJECT_ONLINE=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   GROUP_ID,CMS_ONLINE_FILES.FILE_ID, ACCESS_FLAGS, STATE, LOCKED_BY, LAUNCHER_TYPE, \
                   LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, RESOURCE_LASTMODIFIED_BY, \
                   RESOURCE_SIZE, CMS_ONLINE_FILES.FILE_CONTENT, \
                   PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES \
                   WHERE CMS_ONLINE_RESOURCES.FILE_ID=CMS_ONLINE_FILES.FILE_ID \
                   AND CMS_ONLINE_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_ONLINE_RESOURCES.PROJECT_ID=?
C_FILES_READINPROJECT_BACKUP=SELECT RESOURCE_ID, PARENT_ID, RESOURCE_TYPE, RESOURCE_FLAGS, USER_ID, \
                   USER_NAME, GROUP_ID, GROUP_NAME, CMS_BACKUP_FILES.FILE_ID, ACCESS_FLAGS, \
                   STATE, LAUNCHER_TYPE, LAUNCHER_CLASSNAME, DATE_CREATED, DATE_LASTMODIFIED, \
                   RESOURCE_LASTMODIFIED_BY, RESOURCE_LASTMODIFIED_BY_NAME \
                   RESOURCE_SIZE, CMS_BACKUP_FILES.FILE_CONTENT, PROJECT_ID, \
                   PROJECT_ID LOCKED_IN_PROJECT \
                   FROM CMS_BACKUP_RESOURCES,CMS_BACKUP_FILES \
                   WHERE CMS_BACKUP_RESOURCES.FILE_ID=CMS_BACKUP_FILES.FILE_ID \
                   AND CMS_BACKUP_RESOURCES.RESOURCE_NAME=?  \
                   AND CMS_BACKUP_RESOURCES.PROJECT_ID=?
C_FILE_DELETE=DELETE FROM CMS_FILES WHERE FILE_ID=?
C_FILE_DELETE_ONLINE=DELETE FROM CMS_ONLINE_FILES WHERE FILE_ID=?
C_FILE_READ=SELECT FILE_CONTENT FROM CMS_FILES WHERE FILE_ID=?
C_FILE_READ_ONLINE=SELECT FILE_CONTENT FROM CMS_ONLINE_FILES WHERE FILE_ID=?
C_FILE_READ_BACKUP=SELECT FILE_CONTENT FROM CMS_BACKUP_FILES WHERE FILE_ID=?

#
# Propertydefinitions
#
C_PROPERTYDEF_ID=PROPERTYDEF_ID
C_PROPERTYDEF_NAME=PROPERTYDEF_NAME
C_PROPERTYDEF_RESOURCE_TYPE=RESOURCE_TYPE
C_PROPERTYDEF_MAXID=SELECT MAX(PROPERTYDEF_ID) FROM CMS_PROPERTYDEF