/**
* InsertBuilder
* 请使用StringBuilder构造一个INSERT语句
*/
publicclassInsertBuilder {
publicstaticvoidmain(String[] args) {
String[] fields= { "name", "position", "salary" };
Stringtable="employee";
Stringinsert=buildInsertSql(table, fields);
System.out.println(insert);
Strings="INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)";
System.out.println(s.equals(insert) ?"测试成功":"测试失败");
}
staticStringbuildInsertSql(Stringtable, String[] fields) {
StringBuildersb=newStringBuilder();
Stringhead="INSERT INTO ";
sb.append(head);
sb.append(table);
sb.append(" (");
for (inti=0; i <fields.length; i++) {
sb.append(fields[i]);
if (i <fields.length-1) {
sb.append(", ");
sb.append(") VALUES (?, ?, ?)");
Stringbi=sb.toString();
return bi;
Sign in to make a reply
还没想好叫啥暂时先用这个
/**
* InsertBuilder
* 请使用StringBuilder构造一个INSERT语句
*/
publicclassInsertBuilder {
publicstaticvoidmain(String[] args) {
String[] fields= { "name", "position", "salary" };
Stringtable="employee";
Stringinsert=buildInsertSql(table, fields);
System.out.println(insert);
Strings="INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)";
System.out.println(s.equals(insert) ?"测试成功":"测试失败");
}
staticStringbuildInsertSql(Stringtable, String[] fields) {
StringBuildersb=newStringBuilder();
Stringhead="INSERT INTO ";
sb.append(head);
sb.append(table);
sb.append(" (");
for (inti=0; i <fields.length; i++) {
sb.append(fields[i]);
if (i <fields.length-1) {
sb.append(", ");
}
}
sb.append(") VALUES (?, ?, ?)");
Stringbi=sb.toString();
return bi;
}
}