public List<PromoterRowGateway> findAll() {
   List result = new ArrayList();
   List promoters = jdbcTemplate.queryForList(findAllStatement);
   for (int i = 0; i < promoters.size(); i++)
     result.add(PromoterRowGateway.load(dataSource, (Map) promoters.get(i)));
   return result;
 }
 public PromoterRowGateway find(int code) {
   List promoters = jdbcTemplate.queryForList(findStatement, code);
   PromoterRowGateway promoter = PromoterRowGateway.load(dataSource, (Map) promoters.get(0));
   return promoter;
 }
 public PromoterRowGateway create() {
   return PromoterRowGateway.load(dataSource, null);
 }