oracle java sql

生成field

select 'private String '
|| 
lower(substr(a.column_name,1,1)) || substr(REPLACE(INITCAP(a.column_name),'_',''),2) 
||
'; // '
|| b.comments
from user_tab_columns a join user_col_comments b on b.column_name=a.column_name and a.table_name=b.table_name  where a.table_name='DINGDAN'
order by a.column_id;

生成RowMapper

select 'o.set'
|| 
REPLACE(INITCAP(a.column_name),'_','')
||
'(rs.getString("'
|| a.column_name
|| '"));'
from user_tab_columns a  where a.table_name='DINGDAN'
order by a.column_id;

生成insert

select 'insert into '
||a.table_name||' ('||
listagg(column_name,',') within group(order by column_id)
||') values ('||
listagg('?',',')within group(order by column_id)
||');'
from user_tab_columns a  where a.table_name='DINGDAN'
group by a.table_name;