query.properties

java 编写的程序

                          CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                          FROM CMS_RESOURCES, CMS_PROJECTRESOURCES \
                          WHERE CMS_RESOURCES.PARENT_ID=?  \
                          AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                          AND CMS_RESOURCES.RESOURCE_TYPE=0 \
                          AND CMS_PROJECTRESOURCES.PROJECT_ID = ?  \
                          ORDER BY CMS_RESOURCES.RESOURCE_NAME
C_RESOURCES_GET_SUBFOLDER_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                 FROM CMS_ONLINE_RESOURCES \
                                 WHERE PARENT_ID= ?  \
                                 AND RESOURCE_TYPE=0 \
                                 AND PROJECT_ID = ?  \
                                 ORDER BY RESOURCE_NAME
C_RESOURCES_GET_FOLDERS_IN_FOLDER=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.PARENT_ID=?  \
                                  AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                                  AND CMS_RESOURCES.RESOURCE_TYPE = 0 \
                                  AND CMS_PROJECTRESOURCES.PROJECT_ID IN (?, 1) \
                                  ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_GET_FOLDERS_IN_FOLDER_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                         FROM CMS_ONLINE_RESOURCES \
                                         WHERE PARENT_ID=?  \
                                         AND RESOURCE_TYPE=0 \
                                         AND PROJECT_ID = ?  \
                                         ORDER BY RESOURCE_NAME
C_RESOURCES_GET_RESOURCES_IN_FOLDER=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.PARENT_ID=?  \
                                    AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                                    AND CMS_RESOURCES.RESOURCE_TYPE <> 0 \
                                    AND CMS_PROJECTRESOURCES.PROJECT_ID IN (?, 1) \
                                    ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_GET_RESOURCES_IN_FOLDER_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                           FROM CMS_ONLINE_RESOURCES \
                                           WHERE PARENT_ID=?  \
                                           AND RESOURCE_TYPE <> 0 \
                                           AND PROJECT_ID = ?  \
                                           ORDER BY RESOURCE_NAME
C_RESOURCES_GET_FOLDERTREE=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 CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                           AND (CMS_PROJECTRESOURCES.PROJECT_ID = ?  or CMS_PROJECTRESOURCES.PROJECT_ID = 1) \
                           AND CMS_RESOURCES.RESOURCE_TYPE = 0
C_RESOURCES_GET_FOLDERTREE_ADD1=AND CMS_RESOURCES.RESOURCE_NAME LIKE '
C_RESOURCES_GET_FOLDERTREE_ADD2=%' ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_GET_FOLDERTREE_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                  FROM CMS_ONLINE_RESOURCES \
                                  WHERE RESOURCE_TYPE=0 \
                                  AND PROJECT_ID=?
C_RESOURCES_GET_FOLDERTREE_ONLINE_ADD1=AND RESOURCE_NAME LIKE '
C_RESOURCES_GET_FOLDERTREE_ONLINE_ADD2=%' ORDER BY RESOURCE_NAME
C_RESOURCES_GET_FILES_WITH_PROPERTY=SELECT CMS_RESOURCES.RESOURCE_NAME \
                                    FROM CMS_RESOURCES, CMS_PROPERTYDEF, \
                                    CMS_PROPERTIES, CMS_PROJECTRESOURCES \
                                    WHERE CMS_PROJECTRESOURCES.PROJECT_ID=?  \
                                    AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                                    AND CMS_PROPERTIES.PROPERTY_VALUE=?  \
                                    AND CMS_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                    AND CMS_RESOURCES.RESOURCE_ID=CMS_PROPERTIES.RESOURCE_ID \
                                    AND CMS_PROPERTIES.PROPERTYDEF_ID=CMS_PROPERTYDEF.PROPERTYDEF_ID
C_RESOURCES_GET_FILES_WITH_PROPERTY_ONLINE=SELECT CMS_ONLINE_RESOURCES.RESOURCE_NAME \
                                           FROM CMS_ONLINE_RESOURCES, CMS_ONLINE_PROPERTYDEF, \
                                           CMS_ONLINE_PROPERTIES \
                                           WHERE CMS_ONLINE_RESOURCES.PROJECT_ID=?  \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTY_VALUE=?  \
                                           AND CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                           AND CMS_ONLINE_RESOURCES.RESOURCE_ID=CMS_ONLINE_PROPERTIES.RESOURCE_ID \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID=CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_ID
C_RESOURCES_GET_FILES_WITH_PROPERTY_BACKUP=SELECT CMS_BACKUP_RESOURCES.RESOURCE_NAME \
                                    FROM CMS_BACKUP_RESOURCES, CMS_BACKUP_PROPERTYDEF, \
                                    CMS_BACKUP_PROPERTIES \
                                    WHERE CMS_BACKUP_RESOURCES.PROJECT_ID=?  \
                                    AND CMS_BACKUP_PROPERTIES.PROPERTY_VALUE=?  \
                                    AND CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                    AND CMS_BACKUP_RESOURCES.RESOURCE_ID=CMS_BACKUP_PROPERTIES.RESOURCE_ID \
                                    AND CMS_BACKUP_PROPERTIES.PROPERTYDEF_ID=CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_ID
C_RESOURCES_GET_RESOURCE_WITH_PROPERTY=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_PROPERTYDEF, \
                                       CMS_PROPERTIES, CMS_PROJECTRESOURCES \
                                       WHERE (CMS_PROJECTRESOURCES.PROJECT_ID = ?  or CMS_PROJECTRESOURCES.PROJECT_ID = 1)  \
                                       AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                                       AND CMS_PROPERTIES.PROPERTY_VALUE=?  \
                                       AND CMS_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                       AND CMS_PROPERTYDEF.RESOURCE_TYPE=?  \
                                       AND CMS_RESOURCES.RESOURCE_ID=CMS_PROPERTIES.RESOURCE_ID \
                                       AND CMS_PROPERTIES.PROPERTYDEF_ID=CMS_PROPERTYDEF.PROPERTYDEF_ID \
                                       ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_GET_RESOURCE_WITH_PROPERTY_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, \
                                           CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                           FROM CMS_ONLINE_RESOURCES, CMS_ONLINE_PROPERTYDEF, \
                                           CMS_ONLINE_PROPERTIES \
                                           WHERE CMS_ONLINE_RESOURCES.PROJECT_ID=?  \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTY_VALUE=?  \
                                           AND CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                           AND CMS_ONLINE_PROPERTYDEF.RESOURCE_TYPE=?  \
                                           AND CMS_ONLINE_RESOURCES.RESOURCE_ID=CMS_ONLINE_PROPERTIES.RESOURCE_ID \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID=CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_ID \
                                           ORDER BY CMS_ONLINE_RESOURCES.RESOURCE_NAME
C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF=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_PROPERTYDEF, \
                                          CMS_PROPERTIES, CMS_PROJECTRESOURCES \
                                          WHERE (CMS_PROJECTRESOURCES.PROJECT_ID = ?  or CMS_PROJECTRESOURCES.PROJECT_ID = 1)  \
                                          AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                                          AND CMS_PROPERTIES.PROPERTY_VALUE IS NOT NULL  \
                                          AND CMS_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                          AND CMS_RESOURCES.RESOURCE_ID=CMS_PROPERTIES.RESOURCE_ID \
                                          AND CMS_PROPERTIES.PROPERTYDEF_ID=CMS_PROPERTYDEF.PROPERTYDEF_ID \
                                          ORDER BY CMS_RESOURCES.RESOURCE_NAME, CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_GET_RESOURCE_WITH_PROPERTYDEF_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, \
                                           CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                           FROM CMS_ONLINE_RESOURCES, CMS_ONLINE_PROPERTYDEF, \
                                           CMS_ONLINE_PROPERTIES \
                                           WHERE CMS_ONLINE_RESOURCES.PROJECT_ID=?  \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTY_VALUE IS NOT NULL  \
                                           AND CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                                           AND CMS_ONLINE_RESOURCES.RESOURCE_ID=CMS_ONLINE_PROPERTIES.RESOURCE_ID \
                                           AND CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID=CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_ID \
                                           ORDER BY CMS_ONLINE_RESOURCES.RESOURCE_NAME
C_RESOURCES_RENAMERESOURCE=UPDATE CMS_RESOURCES SET RESOURCE_NAME=?, RESOURCE_LASTMODIFIED_BY=?  \
                           WHERE RESOURCE_ID=?
C_RESOURCES_RENAMERESOURCE_ONLINE=UPDATE CMS_ONLINE_RESOURCES \
                                  SET RESOURCE_NAME=?, RESOURCE_LASTMODIFIED_BY=?  \
                                  WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_LOCK=UPDATE CMS_RESOURCES SET LOCKED_BY=?, PROJECT_ID=?  WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_LOCK_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET LOCKED_BY=?, PROJECT_ID=?  \
                               WHERE RESOURCE_ID=?
C_RESOURCES_UNLOCK=UPDATE CMS_RESOURCES SET LOCKED_BY=-1 \
                   WHERE PROJECT_ID=?
C_RESOURCES_UNLOCK_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET LOCKED_BY=-1 WHERE PROJECT_ID=?
                                  WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_STATE=UPDATE CMS_RESOURCES SET STATE=?  WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_STATE_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET STATE=?  WHERE RESOURCE_ID=?
C_RESOURCES_COUNTLOCKED=SELECT COUNT(CMS_RESOURCES.RESOURCE_ID) \
                               FROM CMS_RESOURCES \
                               WHERE CMS_RESOURCES.LOCKED_BY <> -1 \