一、主方法:
str:需要转换的数据
tableName:需要转换的表名(使用as重命名了的表名)
public static void main(String[] args) {
//要生成的数据需和表名对应
String[] str = {
"id, gyyd_yqcf_code, gyyd_yqcf_name, total_area, street_name, community_name, idle_area, legal_name, legal_tel, shxydm, company_name, building_floor, type, detail_address, gps_ns, gps_we, gps_lk, gyyd_yqcf_type, create_time, update_time, create_by, update_by, status,",
"plant_state, plant_agent, plant_phone, plant_agent_person, plant_rent_nature, plant_price, plant_structure, plant_level, plant_room, plant_lift, plant_company_size, plant_nature, park_build_date, park_info, park_level, park_space_type, park_type, park_faclty_type, park_leading_industry, park_area, park_average_rent, park_rent_area, park_elec_fee, park_property_fee, park_water_fee"
};
String[] tableName ={"info","ext"};
for (int i = 0; i < tableName.length; i++) {
conversion(tableName[i],str[i]);
}
}
二、转换函数:
public static void conversion(String tableName,String str){
StringBuilder builder = new StringBuilder();
String[] strList = str.split(",");
for (int i = 0; i < strList.length; i++) {
//去掉下划线单词前空格
String strs = strList[i].trim();
//单词是否有下划线
if(strList[i].indexOf("_") > 0) {
String[] wordList = strList[i].split("_");
for (int i1 = 0; i1 < wordList.length; i1++) {
if (i1 > 0) {
//首字母转换为大写
String words = wordList[i1].substring(0, 1).toUpperCase().concat(wordList[i1].substring(1).toLowerCase());
builder.append(words);
} else {
builder.append(tableName+"."+ strs + " " +wordList[i1]);
}
}
builder.append(",");
}else{
builder.append(tableName +"."+ strs +",");
}
}
System.out.println(builder);
}
三、结果