query.properties

java 编写的程序

C_PROPERTYDEF_MAXID_ONLINE=SELECT MAX(PROPERTYDEF_ID) FROM CMS_ONLINE_PROPERTYDEF
C_PROPERTYDEF_MAXID_BACKUP=SELECT MAX(PROPERTYDEF_ID) FROM CMS_BACKUP_PROPERTYDEF
C_PROPERTYDEF_READ=SELECT * FROM CMS_PROPERTYDEF \
                   WHERE PROPERTYDEF_NAME=?  \
                   AND RESOURCE_TYPE=?
C_PROPERTYDEF_READ_ONLINE=SELECT * FROM CMS_ONLINE_PROPERTYDEF \
                          WHERE PROPERTYDEF_NAME=?  \
                          AND RESOURCE_TYPE=?
C_PROPERTYDEF_READ_BACKUP=SELECT * FROM CMS_BACKUP_PROPERTYDEF \
                          WHERE PROPERTYDEF_NAME=?  \
                          AND RESOURCE_TYPE=?
C_PROPERTYDEF_READALL=SELECT * FROM CMS_PROPERTYDEF WHERE RESOURCE_TYPE=?
C_PROPERTYDEF_READALL_ONLINE=SELECT * FROM CMS_ONLINE_PROPERTYDEF WHERE RESOURCE_TYPE=?
C_PROPERTYDEF_READALL_BACKUP=SELECT * FROM CMS_BACKUP_PROPERTYDEF WHERE RESOURCE_TYPE=?
C_PROPERTYDEF_CREATE=INSERT INTO CMS_PROPERTYDEF VALUES(?,?,?)
C_PROPERTYDEF_CREATE_ONLINE=INSERT INTO CMS_ONLINE_PROPERTYDEF VALUES(?,?,?)
C_PROPERTYDEF_CREATE_BACKUP=INSERT INTO CMS_BACKUP_PROPERTYDEF VALUES(?,?,?)
C_PROPERTYDEF_DELETE=DELETE FROM CMS_PROPERTYDEF WHERE PROPERTYDEF_ID=?
C_PROPERTYDEF_DELETE_ONLINE=DELETE FROM CMS_ONLINE_PROPERTYDEF WHERE PROPERTYDEF_ID=?
C_PROPERTYDEF_DELETE_BACKUP=DELETE FROM CMS_BACKUP_PROPERTYDEF WHERE PROPERTYDEF_ID=?
C_PROPERTYDEF_UPDATE=UPDATE CMS_PROPERTYDEF SET PROPERTYDEF_NAME=?  WHERE PROPERTYDEF_ID=?
C_PROPERTYDEF_UPDATE_ONLINE=UPDATE CMS_ONLINE_PROPERTYDEF SET PROPERTYDEF_NAME=?  WHERE PROPERTYDEF_ID=?
C_PROPERTYDEF_UPDATE_BACKUP=UPDATE CMS_BACKUP_PROPERTYDEF SET PROPERTYDEF_NAME=?  WHERE PROPERTYDEF_ID=?
#
# Properties
#
C_PROPERTY_VALUE=PROPERTY_VALUE
C_PROPERTY_RESOURCE_ID=RESOURCE_ID
# Statements
C_PROPERTIES_MAXID=SELECT MAX(PROPERTY_ID) FROM CMS_PROPERTIES
C_PROPERTIES_MAXID_ONLINE=SELECT MAX(PROPERTY_ID) FROM CMS_ONLINE_PROPERTIES
C_PROPERTIES_MAXID_BACKUP=SELECT MAX(PROPERTY_ID) FROM CMS_BACKUP_PROPERTIES
C_PROPERTIES_READALL_COUNT=SELECT count(*) FROM CMS_PROPERTIES WHERE PROPERTYDEF_ID=?
C_PROPERTIES_READALL_COUNT_ONLINE=SELECT count(*) FROM CMS_ONLINE_PROPERTIES WHERE PROPERTYDEF_ID=?
C_PROPERTIES_READALL_COUNT_BACKUP=SELECT count(*) FROM CMS_BACKUP_PROPERTIES WHERE PROPERTYDEF_ID=?
C_PROPERTIES_READ=SELECT CMS_PROPERTIES.PROPERTY_VALUE FROM CMS_PROPERTIES, CMS_PROPERTYDEF \
                  WHERE CMS_PROPERTIES.PROPERTYDEF_ID=CMS_PROPERTYDEF.PROPERTYDEF_ID \
                  AND CMS_PROPERTIES.RESOURCE_ID=?  \
                  AND CMS_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                  AND CMS_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_READ_ONLINE=SELECT CMS_ONLINE_PROPERTIES.PROPERTY_VALUE FROM CMS_ONLINE_PROPERTIES, CMS_ONLINE_PROPERTYDEF \
                         WHERE CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID=CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_ID \
                         AND CMS_ONLINE_PROPERTIES.RESOURCE_ID=?  \
                         AND CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                         AND CMS_ONLINE_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_READ_BACKUP=SELECT CMS_BACKUP_PROPERTIES.PROPERTY_VALUE FROM CMS_BACKUP_PROPERTIES, CMS_BACKUP_PROPERTYDEF \
                         WHERE CMS_BACKUP_PROPERTIES.PROPERTYDEF_ID=CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_ID \
                         AND CMS_BACKUP_PROPERTIES.RESOURCE_ID=?  \
                         AND CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_NAME=?  \
                         AND CMS_BACKUP_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_UPDATE=UPDATE CMS_PROPERTIES SET PROPERTY_VALUE=?  \
                    WHERE RESOURCE_ID=?  \
                    AND PROPERTYDEF_ID=?
C_PROPERTIES_UPDATE_ONLINE=UPDATE CMS_ONLINE_PROPERTIES SET PROPERTY_VALUE=?  \
                           WHERE RESOURCE_ID=?  \
                           AND PROPERTYDEF_ID=?
C_PROPERTIES_UPDATE_BACKUP=UPDATE CMS_BACKUP_PROPERTIES SET PROPERTY_VALUE=?  \
                           WHERE RESOURCE_ID=?  \
                           AND PROPERTYDEF_ID=?
C_PROPERTIES_CREATE=INSERT INTO CMS_PROPERTIES VALUES(?,?,?,?)
C_PROPERTIES_CREATE_ONLINE=INSERT INTO CMS_ONLINE_PROPERTIES VALUES(?,?,?,?)
C_PROPERTIES_CREATE_BACKUP=INSERT INTO CMS_BACKUP_PROPERTIES VALUES(?,?,?,?)
C_PROPERTIES_READALL=SELECT CMS_PROPERTYDEF.PROPERTYDEF_NAME, CMS_PROPERTIES.PROPERTY_VALUE \
                     FROM CMS_PROPERTIES, CMS_PROPERTYDEF \
                     WHERE CMS_PROPERTIES.PROPERTYDEF_ID=CMS_PROPERTYDEF.PROPERTYDEF_ID \
                     AND CMS_PROPERTIES.RESOURCE_ID=?  \
                     AND CMS_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_READALL_ONLINE=SELECT CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_NAME, CMS_ONLINE_PROPERTIES.PROPERTY_VALUE \
                            FROM CMS_ONLINE_PROPERTIES, CMS_ONLINE_PROPERTYDEF \
                            WHERE CMS_ONLINE_PROPERTIES.PROPERTYDEF_ID=CMS_ONLINE_PROPERTYDEF.PROPERTYDEF_ID \
                            AND CMS_ONLINE_PROPERTIES.RESOURCE_ID=?  \
                            AND CMS_ONLINE_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_READALL_BACKUP=SELECT CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_NAME, CMS_BACKUP_PROPERTIES.PROPERTY_VALUE \
                            FROM CMS_BACKUP_PROPERTIES, CMS_BACKUP_PROPERTYDEF \
                            WHERE CMS_BACKUP_PROPERTIES.PROPERTYDEF_ID=CMS_BACKUP_PROPERTYDEF.PROPERTYDEF_ID \
                            AND CMS_BACKUP_PROPERTIES.RESOURCE_ID=?  \
                            AND CMS_BACKUP_PROPERTYDEF.RESOURCE_TYPE=?
C_PROPERTIES_DELETEALL=DELETE FROM CMS_PROPERTIES WHERE RESOURCE_ID=?
C_PROPERTIES_DELETEALL_ONLINE=DELETE FROM CMS_ONLINE_PROPERTIES WHERE RESOURCE_ID=?
C_PROPERTIES_DELETEALL_BACKUP=DELETE FROM CMS_BACKUP_PROPERTIES WHERE RESOURCE_ID=?
C_PROPERTIES_DELETE=DELETE FROM CMS_PROPERTIES \
                    WHERE PROPERTYDEF_ID=?  \
                    AND RESOURCE_ID=?
C_PROPERTIES_DELETE_ONLINE=DELETE FROM CMS_ONLINE_PROPERTIES \
                           WHERE PROPERTYDEF_ID=?  \
                           AND RESOURCE_ID=?
C_PROPERTIES_DELETE_BACKUP=DELETE FROM CMS_BACKUP_PROPERTIES \
                           WHERE PROPERTYDEF_ID=?  \
                           AND RESOURCE_ID=?
C_PROPERTIES_DELETEALLPROP=DELETE FROM CMS_PROPERTIES \
                           WHERE RESOURCE_ID IN \
                           (SELECT RESOURCE_ID FROM CMS_RESOURCES, CMS_PROJECTRESOURCES \
                           WHERE CMS_PROJECTRESOURCES.PROJECT_ID=?  \
                           AND CMS_RESOURCES.RESOURCE_NAME LIKE CONCAT(CMS_PROJECTRESOURCES.RESOURCE_NAME,'%'))
C_PROPERTIES_DELETEALLPROP_ONLINE=DELETE FROM CMS_ONLINE_PROPERTIES
C_PROPERTIES_DELETEALLPROP_BACKUP=DELETE FROM CMS_BACKUP_PROPERTIES
#
# Groups
#
C_GROUPS_GROUP_ID=GROUP_ID
C_GROUPS_PARENT_GROUP_ID=PARENT_GROUP_ID
C_GROUPS_GROUP_NAME=GROUP_NAME
C_GROUPS_GROUP_DESCRIPTION=GROUP_DESCRIPTION
C_GROUPS_GROUP_FLAGS=GROUP_FLAGS
C_GROUPS_MAXID=SELECT MAX(GROUP_ID) FROM CMS_GROUPS
C_GROUPS_READGROUP=SELECT * FROM CMS_GROUPS WHERE GROUP_NAME=?
C_GROUPS_READGROUP2=SELECT * FROM CMS_GROUPS WHERE GROUP_ID=?
C_GROUPS_CREATEGROUP=INSERT INTO CMS_GROUPS VALUES(?,?,?,?,?)
C_GROUPS_WRITEGROUP=UPDATE CMS_GROUPS SET \
                    GROUP_DESCRIPTION=?, GROUP_FLAGS=?, PARENT_GROUP_ID=?  \
                    WHERE GROUP_ID=?
C_GROUPS_DELETEGROUP=DELETE FROM CMS_GROUPS WHERE GROUP_NAME=?
C_GROUPS_GETGROUPS=SELECT * FROM CMS_GROUPS ORDER BY GROUP_NAME
C_GROUPS_GETCHILD=SELECT * FROM CMS_GROUPS WHERE PARENT_GROUP_ID=?
C_GROUPS_GETPARENT=SELECT * FROM CMS_GROUPS WHERE GROUP_ID=?
C_GROUPS_GETGROUPSOFUSER=SELECT * FROM CMS_GROUPS G, CMS_USERS U, CMS_GROUPUSERS GU \
                         WHERE U.USER_NAME=?  \
                         AND U.USER_ID=GU.USER_ID \
                         AND GU.GROUP_ID=G.GROUP_ID
C_GROUPS_ADDUSERTOGROUP=INSERT INTO CMS_GROUPUSERS VALUES(?,?,?)
C_GROUPS_USERINGROUP=SELECT * FROM CMS_GROUPUSERS WHERE GROUP_ID=?  AND USER_ID=?
C_GROUPS_GETUSERSOFGROUP=SELECT U.USER_INFO, U.USER_ID, U.USER_NAME, U.USER_PASSWORD, U.USER_RECOVERY_PASSWORD, \
                         U.USER_DESCRIPTION, U.USER_FIRSTNAME, U.USER_LASTNAME, U.USER_EMAIL, \
                         U.USER_LASTLOGIN, U.USER_LASTUSED, U.USER_FLAGS, U.USER_DEFAULT_GROUP_ID, DG.PARENT_GROUP_ID, \
                         DG.GROUP_NAME, DG.GROUP_DESCRIPTION, DG.GROUP_FLAGS, U.USER_ADDRESS, U.USER_SECTION, U.USER_TYPE \
                         FROM CMS_GROUPS G, CMS_USERS U, CMS_GROUPUSERS GU, CMS_GROUPS  DG \
                         WHERE G.GROUP_NAME=?  \
                         AND U.USER_ID=GU.USER_ID \
                         AND GU.GROUP_ID=G.GROUP_ID \
                         AND U.USER_DEFAULT_GROUP_ID=DG.GROUP_ID \
                         AND U.USER_TYPE IN (?, 2)  \
                         ORDER BY USER_NAME
C_GROUPS_REMOVEUSERFROMGROUP=DELETE FROM CMS_GROUPUSERS WHERE GROUP_ID=?  AND USER_ID=?
#
# Users
#
C_USERS_USER_ID=USER_ID
C_USERS_USER_NAME=USER_NAME
C_USERS_USER_PASSWORD=USER_PASSWORD
C_USERS_USER_RECOVERY_PASSWORD=USER_RECOVERY_PASSWORD
C_USERS_USER_DESCRIPTION=USER_DESCRIPTION
C_USERS_USER_FIRSTNAME=USER_FIRSTNAME
C_USERS_USER_LASTNAME=USER_LASTNAME
C_USERS_USER_LASTLOGIN=USER_LASTLOGIN
C_USERS_USER_LASTUSED=USER_LASTUSED
C_USERS_USER_FLAGS=USER_FLAGS
C_USERS_USER_INFO=USER_INFO
C_USERS_USER_DEFAULT_GROUP_ID=USER_DEFAULT_GROUP_ID
C_USERS_USER_ADDRESS=USER_ADDRESS
C_USERS_USER_SECTION=USER_SECTION
C_USERS_USER_TYPE=USER_TYPE
C_USERS_USER_EMAIL=USER_EMAIL
C_USERS_MAXID=SELECT MAX(USER_ID) FROM CMS_USERS
C_USERS_ADD=INSERT INTO CMS_USERS (USER_ID, USER_NAME, USER_PASSWORD, USER_RECOVERY_PASSWORD, \
USER_DESCRIPTION, USER_FIRSTNAME, USER_LASTNAME, USER_EMAIL, USER_LASTLOGIN, USER_LASTUSED, USER_FLAGS, \
USER_INFO, USER_DEFAULT_GROUP_ID, USER_ADDRESS, USER_SECTION, USER_TYPE) \
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
C_USERS_READ=SELECT USER_INFO,USER_ID,USER_NAME,USER_PASSWORD,USER_RECOVERY_PASSWORD,USER_DESCRIPTION, \
             USER_FIRSTNAME,USER_LASTNAME,USER_EMAIL,USER_LASTLOGIN,USER_LASTUSED,USER_FLAGS, \
             GROUP_ID,PARENT_GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_FLAGS, \
             USER_ADDRESS,USER_SECTION,USER_TYPE \
             FROM CMS_USERS, CMS_GROUPS \
             WHERE USER_NAME=?  \
             AND USER_TYPE IN (?, 2)  \
             AND USER_DEFAULT_GROUP_ID=GROUP_ID
C_USERS_READID=SELECT USER_INFO,USER_ID,USER_NAME,USER_PASSWORD,USER_RECOVERY_PASSWORD,USER_DESCRIPTION, \
             USER_FIRSTNAME,USER_LASTNAME,USER_EMAIL,USER_LASTLOGIN,USER_LASTUSED,USER_FLAGS, \
             GROUP_ID,PARENT_GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_FLAGS, \
             USER_ADDRESS,USER_SECTION,USER_TYPE \
             FROM CMS_USERS, CMS_GROUPS \
               WHERE USER_ID=?  \
               AND USER_DEFAULT_GROUP_ID=GROUP_ID
C_USERS_READPW=SELECT USER_INFO,USER_ID,USER_NAME,USER_PASSWORD,USER_RECOVERY_PASSWORD,USER_DESCRIPTION, \
             USER_FIRSTNAME,USER_LASTNAME,USER_EMAIL,USER_LASTLOGIN,USER_LASTUSED,USER_FLAGS, \
             GROUP_ID,PARENT_GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_FLAGS, \
             USER_ADDRESS,USER_SECTION,USER_TYPE \
             FROM CMS_USERS, CMS_GROUPS \
               WHERE USER_NAME=?  \
               AND USER_PASSWORD=?  \
               AND USER_TYPE IN (?, 2)  \
               AN