String ss = "INSERT INTO %s (%s, %s, %s) VALUES (?, ?, ?)";return String.format(ss, table, fields[0], fields[1], fields[2]);
"INSERT INTO " + table + " (" + fields[0] + ", " + fields[1] + ", " + fields[2] + ") VALUES (?, ?, ?)"
如果大量拼接StringBuilder性能肯定更好
因为大家想的是实践,实际情况是fields的个数可能不是3个,所以(?, ?, ?)也不会是3个‘?’,写死了可用性就差了。
Sign in to make a reply
Joker.fu_95