其他数据库操作方法

MappingSqlQuery(表操作):

public ActorMappingQuery(DataSource ds) {
  super(ds, "select id, first_name, last_name from t_actor where id = ?");
  super.declareParameter(new SqlParameter("id", Types.INTEGER));
  compile();
}
@Override
protected Actor mapRow(ResultSet rs, int rowNumber) throws SQLException {
  Actor actor = new Actor();
  actor.setId(rs.getLong("id"));
  actor.setFirstName(rs.getString("first_name"));
  actor.setLastName(rs.getString("last_name"));
  return actor;
}

SqlUpdate(表操作):

public UpdateCreditRating(DataSource ds) {
  setDataSource(ds);
  setSql("update customer set credit_rating = ? where id = ?");
  declareParameter(new SqlParameter("creditRating", Types.NUMERIC));
  declareParameter(new SqlParameter("id", Types.NUMERIC));
  compile();
}
public int execute(int id, int rating) {
  return update(rating, id);
}

StoredProcedure(存储过程)

private static final String SPROC_NAME = "AllTitlesAndGenres";
public TitlesAndGenresStoredProcedure(DataSource dataSource) {
  super(dataSource, SPROC_NAME);
  declareParameter(new SqlOutParameter("titles", OracleTypes.CURSOR, new TitleMapper()));
  declareParameter(new SqlOutParameter("genres", OracleTypes.CURSOR, new GenreMapper()));
  compile();
}
public Map<String, Object> execute() {
  return super.execute(new HashMap<String, Object>());
}