Mysql vo 만들기

1. vo 만들기

SELECT
    #CONCAT(COL,',')AS ''
    CONCAT('private ', CASE WHEN DATA_TYPE = 'timestamp' THEN 'Timestamp ' ELSE 'String ' END, GENERATOR_COL,';'  , '    //' , IFNULL(COLUMN_COMMENT, ''))AS ''
    #CONCAT('#{', GENERATOR_COL,'},')AS ''
FROM
(
    SELECT COL,
             CASE WHEN COL1 ='' THEN '_id'
             ELSE CONCAT(LOWER(COL1),UPPER(SUBSTR(COL2, 1, 1)),LOWER(SUBSTR(COL2, 2)),UPPER(SUBSTR(COL3, 1, 1)),LOWER(SUBSTR(COL3, 2)),UPPER(SUBSTR(COL4, 1, 1)),LOWER(SUBSTR(COL4, 2)))
             END GENERATOR_COL, COLUMN_COMMENT, DATA_TYPE
    FROM       
    (
        SELECT replace(substring(substring_index(COL,'_', 1), length(substring_index(COL,'_', 1 - 1)) + 1),'_','')AS COL1,
                 replace(substring(substring_index(COL,'_', 2), length(substring_index(COL,'_', 2 - 1)) + 1),'_','')AS COL2,
                 replace(substring(substring_index(COL,'_', 3), length(substring_index(COL,'_', 3 - 1)) + 1),'_','')AS COL3,
                 replace(substring(substring_index(COL,'_', 4), length(substring_index(COL,'_', 4 - 1)) + 1),'_','')AS COL4,
                 COL, COLUMN_COMMENT, DATA_TYPE
        FROM
        (
            SELECT column_name AS COL, COLUMN_COMMENT, DATA_TYPE
            FROM   information_schema.columns
            WHERE  table_name ='ST_COM_MESSAGE'
        )AS X
    )AS Y
)AS Z;