static String buildInsertSql(String table, String[] fields) {
var sb=new StringBuilder(1024);
sb.append("INSERT INTO ")
.append(table)
.append(" (")
.append(String.join(", ",fields))
.append(") ")
.append("VALUES (?, ?, ?)");
return sb.toString();
}
这应该是最优的写法了,赞!!!
Sign in to make a reply
高谦05
static String buildInsertSql(String table, String[] fields) {
var sb=new StringBuilder(1024);
sb.append("INSERT INTO ")
.append(table)
.append(" (")
.append(String.join(", ",fields))
.append(") ")
.append("VALUES (?, ?, ?)");
return sb.toString();
}