倒是没看到有人这样

Discuss / Java / 倒是没看到有人这样

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

String ss = "INSERT INTO %s (%s, %s, %s) VALUES (?, ?, ?)";return String.format(ss, table, fields[0], fields[1], fields[2]);

#2 Created at ... [Delete] [Delete and Lock User]

"INSERT INTO " + table + " (" + fields[0] + ", " + fields[1] + ", " + fields[2] + ") VALUES (?, ?, ?)"

#3 Created at ... [Delete] [Delete and Lock User]

如果大量拼接StringBuilder性能肯定更好

#4 Created at ... [Delete] [Delete and Lock User]

因为大家想的是实践，实际情况是fields的个数可能不是3个，所以(?, ?, ?)也不会是3个‘?’，写死了可用性就差了。