@Override
public PreparedStatement buildPreparedInsertStatement(Table table) throws Exception {
List<Field> fields = table.getFields();
StringBuffer query = new StringBuffer("INSERT INTO ");
StringBuffer values = new StringBuffer("VALUES(");
query.append(buildTableName(table));
query.append(" (");
for (int i = 0, l = fields.size(); i < l; i++) {
Field field = fields.get(i);
query.append("[");
query.append(field.getName());
query.append("]");
values.append("?");
if (i < l - 1) {
query.append(",");
values.append(",");
}
}
query.append(") ");
values.append(")");
query.append(values);
return createPreparedStatement(query.toString());
}
