query.properties

java 编写的程序

                   PROJECT_ID=?, ACCESS_FLAGS=?, STATE=?, LOCKED_BY=?, \
                   LAUNCHER_TYPE=?, LAUNCHER_CLASSNAME=?, DATE_LASTMODIFIED=?, \
                   RESOURCE_LASTMODIFIED_BY=?, RESOURCE_SIZE=?, FILE_ID=?  \
                   WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET \
                   RESOURCE_TYPE=?, RESOURCE_FLAGS=?, USER_ID=?, GROUP_ID=?, \
                   PROJECT_ID=?, ACCESS_FLAGS=?, STATE=?, LOCKED_BY=?, \
                   LAUNCHER_TYPE=?, LAUNCHER_CLASSNAME=?, DATE_LASTMODIFIED=?, \
                   RESOURCE_LASTMODIFIED_BY=?, RESOURCE_SIZE=?, FILE_ID=?  \
                   WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_FILE=UPDATE CMS_RESOURCES SET \
                        RESOURCE_TYPE=?, RESOURCE_FLAGS=?, USER_ID=?, \
                        GROUP_ID=?, PROJECT_ID=?, ACCESS_FLAGS=?, STATE=?, LOCKED_BY=?, \
                        LAUNCHER_TYPE=?, LAUNCHER_CLASSNAME=?, DATE_LASTMODIFIED=?, \
                        RESOURCE_LASTMODIFIED_BY=?, RESOURCE_SIZE=?, FILE_ID=?  \
                        WHERE RESOURCE_ID=?
C_RESOURCES_UPDATE_FILE_ONLINE=UPDATE CMS_ONLINE_RESOURCES SET \
                               RESOURCE_TYPE=?, RESOURCE_FLAGS=?, USER_ID=?, \
                               GROUP_ID=?, PROJECT_ID=?, ACCESS_FLAGS=?, STATE=?, LOCKED_BY=?, \
                               LAUNCHER_TYPE=?, LAUNCHER_CLASSNAME=?, DATE_LASTMODIFIED=?, \
                               RESOURCE_LASTMODIFIED_BY=?, RESOURCE_SIZE=?, FILE_ID=?  \
                               WHERE RESOURCE_ID=?
C_RESOURCES_READ_ALL=SELECT CMS_RESOURCES.*, CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                     FROM CMS_RESOURCES WHERE RESOURCE_NAME=?
C_RESOURCES_READ_ALL_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                            FROM CMS_ONLINE_RESOURCES WHERE RESOURCE_NAME=?
C_RESOURCES_READ_ALL_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                            FROM CMS_BACKUP_RESOURCES WHERE RESOURCE_NAME=?  \
                            ORDER BY VERSION_ID
# read the resource with resource_name that exists in the project or in the online project
C_RESOURCES_READ=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 = ?  \
                     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_RESOURCES_READ_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                        FROM CMS_ONLINE_RESOURCES \
                        WHERE RESOURCE_NAME=?  \
                        AND PROJECT_ID = ?
C_RESOURCES_READ_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                        FROM CMS_BACKUP_RESOURCES \
                        WHERE RESOURCE_NAME=?  \
                        AND VERSION_ID = ?
# read the resource with resource_name that exists in the project
C_RESOURCES_READINPROJECT=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 = ?  \
                     AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%') \
                     AND CMS_PROJECTRESOURCES.PROJECT_ID = ?  \
                     ORDER BY CMS_PROJECTRESOURCES.PROJECT_ID DESC
C_RESOURCES_READINPROJECT_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                        FROM CMS_ONLINE_RESOURCES \
                        WHERE RESOURCE_NAME=?  \
                        AND PROJECT_ID = ?
C_RESOURCES_READINPROJECT_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                 FROM CMS_BACKUP_RESOURCES \
                                 WHERE RESOURCE_NAME=?  \
                                 AND PROJECT_ID = ?  \
                                 ORDER BY VERSION_ID DESC
C_RESOURCES_READBYID=SELECT CMS_RESOURCES.*, CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                     FROM CMS_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_READBYID_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                            FROM CMS_ONLINE_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_READBYID_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                            FROM CMS_BACKUP_RESOURCES WHERE RESOURCE_ID=?
C_RESOURCES_READBYPROJECT=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=?
C_RESOURCES_READBYPROJECT_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                 FROM CMS_ONLINE_RESOURCES WHERE PROJECT_ID=?
C_RESOURCES_READBYPROJECT_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                 FROM CMS_BACKUP_RESOURCES WHERE PROJECT_ID=?
C_RESOURCES_READFOLDERSBYPROJECT=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_PROJECTRESOURCES.PROJECT_ID=?  \
                                 AND CMS_RESOURCES.RESOURCE_TYPE=0 \
                                 AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%')
C_RESOURCES_READFOLDERSBYPROJECT_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_READFOLDERSBYPROJECT_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                        FROM CMS_BACKUP_RESOURCES \
                                        WHERE RESOURCE_TYPE=0 \
                                        AND PROJECT_ID = ?
C_RESOURCES_READFILESBYPROJECT=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_FILES.FILE_CONTENT, \
                                  CMS_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                               FROM CMS_RESOURCES, CMS_FILES, CMS_PROJECTRESOURCES \
                               WHERE CMS_PROJECTRESOURCES.PROJECT_ID=?  \
                               AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME, '%') \
                               AND CMS_RESOURCES.FILE_ID = CMS_FILES.FILE_ID \
                               AND CMS_RESOURCES.RESOURCE_TYPE <> 0
C_RESOURCES_READFILESBYPROJECT_ONLINE=SELECT CMS_ONLINE_RESOURCES.*, CMS_ONLINE_FILES.FILE_CONTENT, \
                                      CMS_ONLINE_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                      FROM CMS_ONLINE_RESOURCES, CMS_ONLINE_FILES \
                                      WHERE RESOURCE_TYPE <> 0 \
                                      AND CMS_ONLINE_RESOURCE.FILE_ID = CMS_ONLINE_FILES.FILE_ID \
                                      AND PROJECT_ID = ?
C_RESOURCES_READFILESBYPROJECT_BACKUP=SELECT CMS_BACKUP_RESOURCES.*, CMS_BACKUP_FILES.FILE_CONTENT, \
                                      CMS_BACKUP_RESOURCES.PROJECT_ID LOCKED_IN_PROJECT \
                                      FROM CMS_BACKUP_RESOURCES, CMS_BACKUP_FILES \
                                      WHERE RESOURCE_TYPE <> 0 \
                                      AND CMS_BACKUP_RESOURCES.FILE_ID = CMS_BACKUP_FILES.FILE_ID \
                                      AND PROJECT_ID = ?
C_RESOURCES_GET_FILESINFOLDER=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 = ?  \
                              ORDER BY CMS_RESOURCES.RESOURCE_NAME
C_RESOURCES_GET_FILESINFOLDER_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_SUBFOLDER=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, \