java对MySQL建表语句解析_根据javabean转换为mysql建表语句

com.util;importjava.io.IOException;importjava.lang.reflect.Field;/*** Created by Jeff on 2018/12/5.*/

public classCreateTableUtil {/***@paramargs

*@throwsIOException*/

public static void main(String[] args) throwsIOException {

createTable(com.entity.SharingFile.class, null);

}public static void createTable(Class obj,String tableName) throwsIOException{

Field[] fields= null;

fields=obj.getDeclaredFields();

String param= null;

String column= null;

StringBuilder sb= null;

sb= new StringBuilder(50);if(tableName==null||tableName.equals("")){//未传表明则默认用类名

tableName =obj.getName();

tableName= tableName.substring(tableName.lastIndexOf(".")+1);

}

sb.append("drop table if exists ").append(tableName).append(";\r\n");

sb.append("create table ").append(tableName).append(" ( \r\n");boolean firstId = true;for(Field f : fields){

column=f.getName();for(int i = 0; i < column.length(); i++)if(Character.isUpperCase(column.charAt(i)))

column= column.substring(0, i) + ‘_‘ + column.substring(i, i+1).toLowerCase() + column.substring(i+1, column.length());

sb.append(column).append(" ");

param=f.getType().getTypeName();if(param.equals("java.lang.Integer")){

sb.append("INTEGER");

}else{

sb.append("VARCHAR(20)");//根据需要自行修改

}if(firstId){//类型转换

sb.append(" PRIMARY KEY AUTO_INCREMENT");

firstId= false;

}

sb.append(",\n");

}

String sql= null;

sql=sb.toString();

sql= sb.substring(0, sql.length()-2)+"\n)ENGINE = INNODB DEFAULT CHARSET= utf8 AUTO_INCREMENT=1;\r\n";

System.out.println(sql);

}

}

根据javabean转换为mysql建表语句

标签：cep   void   pre   end   substr   \n   arch   table   append

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/Jeffscnblog/p/10072483.html