如何改表不用改？个数

Question

conn.prepareStatement("insert into MYTEST_COPY values(?,?,?,?,?)");

Answer 1

[code="java"]String tableName = "base_customer";
//getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
List columnNameList = new ArrayList();
ResultSet rs = conn.getMetaData().getColumns(null, null, tableName, "%");
while(rs.next()) {
columnNameList.add(rs.getString(4));
}

        StringBuilder s = new StringBuilder("insert into ");
        s.append("insert into ");
        s.append(tableName);
        s.append(" values(");
        for(int i = 0; i < columnNameList.size(); i++) {
            if(i > 0) {
                s.append(",");
            }
            s.append("?");
        }
        s.append(")");

        System.out.println(s.toString());[/code]