Discuss / Java / 作业

作业

Topic source
public class Hello {    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) {        StringBuilder sb = new StringBuilder(1024);        sb.append("INSERT INTO ").append(table).append(" ");        for(var i = 0; i<fields.length;i++){            if(i == 0){                sb.append("(");            }            sb.append(fields[i]);            if(i != fields.length -1){                sb.append(", ");            }else{                sb.append(")");            }        }        sb.append(" VALUES (?, ?, ?)");        return sb.toString();    }};

  • 1

Reply