oracle查询自动生成实体entity

最新推荐文章于 2020-09-25 14:39:09 发布

vernonchen163

最新推荐文章于 2020-09-25 14:39:09 发布

阅读量332

点赞数

分类专栏： oracle java web后端+框架文章标签：数据库 java

本文链接：https://blog.csdn.net/vernonchen163/article/details/84511630

版权

java web后端+框架同时被 2 个专栏收录

56 篇文章 1 订阅

订阅专栏

oracle

39 篇文章 0 订阅

订阅专栏

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;