Discuss / Java / 作业

作业

Topic source

WXinghui

#1 Created at ... [Delete] [Delete and Lock User]
public class stringbuildertest {    public static void main(String[] args) {        String[] fields = { "name", "position", "salary" };        String table = "employee";        String insert = buildInsertSql(table, fields);        System.out.println(insert);        String s = "INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)";        System.out.println(s.equals(insert) ? "测试成功" : "测试失败");    }    static String buildInsertSql(String table, String[] fields) {        // TODO:        StringBuilder strbuilder = new StringBuilder(1024);        strbuilder.append("INSERT INTO "+table+" (");        for(int i=0;i<fields.length;i++){            strbuilder.append(fields[i]+", ");        }        strbuilder.delete(strbuilder.length()-2,strbuilder.length());        strbuilder.append(") VALUES (?, ?, ?)");        return strbuilder.toString();    }}

  • 1

Reply