oracle 逆向生成实体,oracle查询自动生成实体entity

select 'private ' || (case

when col.DATA_TYPE = 'VARCHAR2' then

'String'

when col.DATA_TYPE = 'NUMBER' then

'BigDecimal'

when col.DATA_TYPE = 'DATE' then

'Date'

end) DATA_TYPE1

,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||

substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2)

,LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||

substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2) || ';'

,'dto.set' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '(xxx);'

,'dto.get' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '()'

,'dto.set' || REPLACE(INITCAP(col.COLUMN_NAME), '_', '') || '(' ||

'rs.get' || (case

when col.DATA_TYPE = 'VARCHAR2' then

'String'

when col.DATA_TYPE = 'NUMBER' then

'BigDecimal'

when col.DATA_TYPE = 'DATE' then

'Date'

end) || '("' ||

LOWER(substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 1, 1)) ||

substr(REPLACE(INITCAP(col.COLUMN_NAME), '_', ''), 2) || '")' || ');'

,CONCAT('//', com.comments)

from user_tab_columns col

inner join user_col_comments com

on col.TABLE_NAME = UPPER('SCORE_MERGE_SETTING')

and col.TABLE_NAME = com.TABLE_NAME

and col.COLUMN_NAME = com.COLUMN_NAME

order by col.COLUMN_ID;