下面写了几条根据数据库表，获取domain中要用的数据字段sql语句。

selectconcat(concat(column_name,concat('=',concat(concat('#{',column_name),'}'))),',')from information_schema.`COLUMNS` where table_schema='saas-export' and table_name='ss_company';

以上sql语句获得的结果如id=#{id},

selectconcat(column_name,concat('=',concat(concat('#{',concat(column_name,'}')),',')))from information_schema.`COLUMNS` where table_schema='saas-export' and table_name='ss_company'

以上sql语句获得的结果如id=#{id},

select column_name,data_type,column_comment from information_schema.COLUMNS where table_schema='saas-export' and table_name='ss_company'