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'orderby 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'orderby a.column_id;
生成insert
select'insert into '||a.table_name||' ('||
listagg(column_name,',')withingroup(orderby column_id)||') values ('||
listagg('?',',')withingroup(orderby column_id)||');'from user_tab_columns a where a.table_name='DINGDAN'groupby a.table_name;
可以按照数据库字段的顺序排序select 'private String '|| lower(substr(a.column_name,1,1)) || substr(REPLACE(INITCAP(a.column_name),'_',''),2) ||'; // '|| b.commentsfrom user_tab_columns a join user_col_comments b on b.column_name=a.column_name and a.table_name=b.ta