gistfile1.groovy

Class c = object.getClass();
Field fields[] = c.getFields();
StringBuilder query = new StringBuilder()
  .append("INSERT INTO ").append(c.getName())
  .append(" VALUE (");

for (int i = 0; i < fields.length; i++) query.append("?,");
query.deleteCharAt(query.length());
query.append(')');

PreparedStatement st = connection.prepareStatement(query.toString());

for (Field field : fields)
{
  if (!Modifier.isPublic(field.getModifiers()))
  {
    continue;
  }

  String name = field.getName();
  if (field.getType().equals("int"))
  {
    st.setInt(name, field.getInt(object));
  }
  else if (field.getType().equals("string"))
  {
    st.setString(name, field.get(object).toString());
  }
  // 必要に応じて追加
}