模板_oracle_sql生成java代码 =======================还需要修改 需要把sql的执行结果放在这里

select rownum*3 as rk, '/** 注释*/' from dual connect by rownum<=7

union all

select rownum*3+2 as rk, null from dual connect by rownum<=7

union all

select rownum*3 as rk ,
    'public static final String '
    || replace(column_name,'_','') 
    || ' = "' 
    || lower(column_name) 
    || '";' 
from user_tab_columns 
where table_name='emp'
order by rk
;

select 'map.put('|| replace(column_name,'_','')||',rs.getLong('||rownum||'));'  
from user_tab_columns 
where table_name='emp'

--还可以添加类型
select 'map.put('|| replace(column_name,'_','')||',rs.get'
|| decode(DATA_TYPE,'NUMBER','Long','VARCHAR2','String')
||'('||rownum||'));'  
from user_tab_columns 
where table_name='emp'

 

参考地址：

https://mp.csdn.net/console/editor/html/108409288 （oracle 函数）