mysql表（全是varchar）的一行允许的最大长度_建表测试脚本

hhajhh

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class Test {

public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub

String ip = "127.0.0.1";
String port = "3306";
String db = "rcp_data_db?characterEncoding=UTF-8";
String name = "root";
String pass = "root";
// 1.加驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.建连接
String url = "jdbc:mysql://" + ip + ":" + port + "/" + db;
Connection conn = DriverManager.getConnection(url, name, pass);

Statement ps = conn.createStatement();

String lineStr = "";
StringBuffer s = new StringBuffer();
int count = 21;
for (int i = 0; i < count; i++) {
s.append("a" + i);
if (i != count - 1)
s.append("^");
}
lineStr = s.toString();
System.out.println(lineStr + "=======================");
String[] strArray = lineStr.split("\\^", -1);
StringBuffer createTableSql = new StringBuffer();
createTableSql.append("CREATE TABLE test"
+ " (");
createTableSql
.append("_ID_ varchar(255) NOT NULL DEFAULT '',");
for (String col : strArray) {
createTableSql.append(col
+ " varchar(1000)  DEFAULT NULL,");
//+ " text ,"); // text类型貌似没有限制
}
createTableSql
.append("_CREATE_TIME_ datetime NOT NULL,");
createTableSql.append("PRIMARY KEY (_ID_)");
createTableSql.append(")");
System.out.println(createTableSql.toString() + "======createTableSql.toString()=================");
ps.executeUpdate(createTableSql.toString());


ps.close();
conn.close();
}
}