package com.itranswarp.learnjava;


/**
 * Learn Java from https://www.liaoxuefeng.com/
 * 
 * @author liaoxuefeng
 */
public class Main {


public static void main(String[] args) {
String[] fields = { "name", "position", "salary" };
String table = "employee";
String insert = buildInsertSql(table, fields);
System.out.println(insert);
System.out.println(
"INSERT INTO employee (name, position, salary) VALUES (?, ?, ?)".equals(insert) ? "测试成功" : "测试失败");
}


static String buildInsertSql(String table, String[] fields) {
// TODO:
StringBuilder params = new StringBuilder(1024); 
StringBuilder postion = new StringBuilder(1024);
for(String s: fields) {
params.append(s+", "); 
postion.append("?, ") ;
}

String s1 = params.toString();
String s2 = postion.toString();
s1 = s1.substring(0, s1.length()-2);
s2 = s2.substring(0, s2.length()-2);

String insertSql = "INSERT INTO %s (%s) VALUES (%s)".formatted(table,s1, s2);

return insertSql;


}


}