1   package org.unitedfront2.dao.jdbc;
2   
3   import org.springframework.dao.DataAccessException;
4   import org.springframework.stereotype.Repository;
5   import org.unitedfront2.dao.SampleDomainDao;
6   import org.unitedfront2.domain.SampleDomain;
7   
8   @Repository(value = "sampleDomainDao")
9   public class SampleDomainDaoImpl extends SimpleDaoSupport<SampleDomain>
10      implements SampleDomainDao {
11  
12      @Override
13      protected Class<SampleDomain> getDomainClass() {
14          return SampleDomain.class;
15      }
16  
17      @Override
18      public SampleDomain findByCode(String code) {
19          try {
20              return getSimpleJdbcTemplate().queryForObject(
21                      "SELECT * FROM SampleDomain WHERE Code = ?",
22                      createRowMapper(), code);
23          } catch (DataAccessException e) {
24              if (logger.isInfoEnabled()) {
25                  logger.info(e.getMessage());
26              }
27              return null;
28          }
29      }
30  
31      @Override
32      public int count() {
33          return getSimpleJdbcTemplate().queryForInt(
34                  "SELECT COUNT(*) FROM SampleDomain");
35      }
36  }