Discuss / Java / 根据fields个数来确定问号的个数

根据fields个数来确定问号的个数

Topic source

杨森-ys

#1 Created at ... [Delete] [Delete and Lock User]

static String buildInsertSql(String table, String[] fields) {

            StringBuilder sb = new StringBuilder();

    sb = sb.append("INSERT INTO employee () VALUES ()");

    for(int i = 0;i<fields.length;i++) {

        if(i==0) {

            sb.insert(sb.indexOf(")"), fields[i]);

            sb.insert(sb.indexOf(")", sb.indexOf(")")+1), "?");

        }else {

            sb.insert(sb.indexOf(")"), ", "+fields[i]);

            sb.insert(sb.indexOf(")", sb.indexOf(")")+1), ", ?");

        }

    }

            return sb.toString();

        }


  • 1

Reply