public void updateInfoById(String table, int id, Info info) throws Exception {
jdbcTemplate.update(
"UPDATE "
+ table
+ " SET "
+ info.getUpdateKeys()
+ " WHERE "
+ BaseColumn.KEY_SPIDER_ID
+ "="
+ id,
info.getUpdateParams());
}
public void saveInfo(String table, Info info) throws Exception {
jdbcTemplate.update(
"INSERT INTO " + table + "(" + info.getKeys() + ") values(" + info.getQuestions() + ")",
info.getParams());
}