public class DatabaseToInterfaceTest {
public static void main(String[] args) {
String str = " `out_id` varchar(32) NOT NULL COMMENT '进货出库流水号',\r\n"
+ " `in_id` varchar(32) NOT NULL COMMENT '进货入库流水号',\r\n" + " \r\n"
+ " `out_num` bigint(10) DEFAULT 0 COMMENT '领用数量',\r\n"
+ " `out_num_unit` varchar(10) DEFAULT '' COMMENT '领用数量单位',\r\n" + " \r\n"
+ " `company_id` varchar(32) NOT NULL COMMENT '企业编号',\r\n"
+ " `company_name` varchar(32) DEFAULT NULL COMMENT '企业名称',\r\n"
+ " `create_time` char(19) DEFAULT '' COMMENT '创建时间(yyyy-MM-dd HH:mm:ss)',\r\n"
+ " `update_time` char(19) DEFAULT '' COMMENT '更新时间(yyyy-MM-dd HH:mm:ss)',\r\n"
+ " `create_user_id` varchar(32) DEFAULT '' COMMENT '创建人员id',\r\n"
+ " `update_user_id` varchar(32) DEFAULT '' COMMENT '修改人员id',\r\n"
+ " `create_user_name` varchar(200) DEFAULT '' COMMENT '创建人员名称',\r\n"
+ " `update_user_name` varchar(200) DEFAULT '' COMMENT '修改人员名称',";
sayFiedAndComment(str);
}
public static void sayFiedAndComment(String str) {
String[] rowStr = str.split("\r\n");
StringBuffer sb = new StringBuffer();
for (String rowS : rowStr) {
sb.setLength(0);
rowS = rowS.trim().replace("`", "");
String[] fiedS = rowS.split(" ");
sb.append(fiedS[0] + "\t" + getTf(fiedS[0])).append("\t");
if (rowS.contains(" COMMENT ")) {
// System.out.println("rowS:" + rowS);
// System.out.println("rowS:" + rowS.length() + " " + (rowS.indexOf("COMMENT '")
// +" " + rowS.lastIndexOf("',")));
sb.append(rowS.substring(rowS.indexOf("COMMENT '") + 9, rowS.lastIndexOf("',")));
}
System.out.println(sb.toString());
}
}
/**
* 驼峰形式输出
*
* @param str
* @return
*/
public static String getTf(String str) {
if (str.trim().length() == 0) {
return "";
}
StringBuffer sb = new StringBuffer();
String[] strs = str.split("_");
for (int i = 0; i < strs.length; i++) {
if (i == 0) {
sb.append(strs[i]);
} else {
sb.append((strs[i].charAt(0) + "").toUpperCase() + strs[i].substring(1));
}
}
return sb.toString();
}
}
运行效果: