请教!!有一个需求
{
“total”:4,
“fieldNum”:3,
“data”: [
{ “ID”:“1” , “NAME”:“Gates”, “AGE”:18},
{ “ID”:“2” , "NAME:“Bill”, " AGE ":17},
{ “ID”:“3” , “NAME”:“Sam”, " AGE ":17},
{ “ID”:“4” , “NAME”:“Bob”, “AGE”:18}
]
}
这个是用户传过来的数据格式,要求在自动建表的时候根据数据类型自定义字段类型
比如 AGE=18 要求根据18这个值设定AGE的类型为int
public void createTable(Connection connection, String tableName, String[] columns) {
if (tableName == null || "".equals(tableName) || columns.length == 0) {
return;
}
String sql = "CREATE TABLE " + tableName;
StringBuilder columnSql = new StringBuilder("(gp_uuid varchar(128) PRIMARY KEY, gp_timestamp timestamp(8),");
for (String column : columns) {
columnSql.append(column).append(" varchar(255),");
}
columnSql.deleteCharAt(columnSql.length() - 1);
columnSql.append(")");
sql += columnSql.toString();
try {
Statement st = connection.createStatement();
boolean success = st.execute(sql);
} catch (SQLException e) {
e.printStackTrace();
}
} `
这个是建表的方法 有什么办法吗 大佬们????