Example usage for org.springframework.jdbc.core RowMapper RowMapper

Introduction

In this page you can find the example usage for org.springframework.jdbc.core RowMapper RowMapper.

Prototype

RowMapper

Source Link

Usage

From source file:com.github.binarywang.demo.spring.dao.AppointmentDao.java

public long count() {
    return jdbcTemplate.queryForObject("select count(id) from appointment", new RowMapper<Long>() {
        @Override/*from  w  w w.  ja v  a2s  . c  o  m*/
        public Long mapRow(ResultSet resultSet, int i) throws SQLException {
            return resultSet.getLong(1);
        }
    });
}

From source file:com.xinferin.dao.DAOProviderImpl.java

@Override
public List<Provider> list() {
    String sql = "SELECT * FROM provider";
    List<Provider> list = jdbcTemplate.query(sql, new RowMapper<Provider>() {
        @Override/*from  w  w  w. j av a2 s  .  c o m*/
        public Provider mapRow(ResultSet rs, int rowNum) throws SQLException {
            Provider aProvider = new Provider();

            aProvider.setId(rs.getInt("id"));
            aProvider.setName(rs.getString("name"));

            return aProvider;
        }
    });
    return list;
}

From source file:tianci.pinao.dts.tasks.dao.impl.ConfigDaoImpl.java

@Override
public Map<Integer, Config> getConfigs() {
    final Map<Integer, Config> configs = new HashMap<Integer, Config>();
    getJdbcTemplate().query("select id, type, value, lastmod_time, lastmod_userid from "
            + SqlConstants.TABLE_CONFIG + " where isdel = ?", new Object[] { 0 }, new RowMapper<Config>() {

                @Override/*ww w  .  jav a  2 s. c  om*/
                public Config mapRow(ResultSet rs, int index) throws SQLException {
                    Config config = new Config();

                    config.setId(rs.getInt("id"));
                    config.setType(rs.getInt("type"));
                    config.setValue(rs.getLong("value"));
                    Timestamp ts = rs.getTimestamp("lastmod_time");
                    if (ts != null)
                        config.setLastModTime(new Date(ts.getTime()));
                    config.setLastModUserid(rs.getInt("lastmod_userid"));

                    configs.put(config.getType(), config);

                    return config;
                }

            });

    return configs;
}

From source file:com.company.dao.impl.StudentDAOImpl.java

@Override
public List<Student> getAll() throws SQLException {
    String sql = "SELECT * FROM tbl_students";
    return jdbcTemplate.query(sql, new RowMapper<Student>() {

        @Override/*w  ww. ja  v a 2 s .  c  o  m*/
        public Student mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);
        }
    });
}

From source file:com.butler.service.ProductDao.java

public List<Product> getAllProducts() {
    String sql = "select name,display_name,market_price,selling_price,size,type,booking_only from product where visible=1 order by display_position,booking_only";
    return this.getJdbcTemplate().query(sql, new RowMapper() {

        @Override/*from   w  w w. jav a 2s.  c o  m*/
        public Object mapRow(ResultSet rs, int i) throws SQLException {
            Product product = new Product();
            product.setName(rs.getString("name"));
            product.setDisplayName(rs.getString("display_name"));
            product.setSellingPrice(rs.getFloat("selling_price"));
            product.setMarketPrice(rs.getFloat("market_price"));
            product.setSizeSpecification(rs.getString("size"));
            product.setType(rs.getString("type"));
            product.setBookingOnly(rs.getBoolean("booking_only"));
            return product;
        }
    });
}

From source file:com.butler.service.UserDao.java

public String getName(String number) {

    try {/*from  w w  w  .  j  ava2 s .c  om*/
        List<String> names = this.getJdbcTemplate().query("select name from user where number=?",
                new String[] { number }, new RowMapper() {

                    @Override
                    public Object mapRow(ResultSet rs, int i) throws SQLException {
                        return rs.getString("name");
                    }
                });
        return names.isEmpty() ? "UNKNOWN" : names.get(0);
        // return this.getSimpleJdbcTemplate().queryForObject("select name from user where number=?", String.class, number);
    } catch (Throwable e) {
        return "UNKNOWN";
    }
}

From source file:com.javacodegags.waterflooding.model.ResultImplemented.java

@Override
public List<Result> getAll() {
    String sql = "SELECT * FROM results";
    List<Result> listCaption = jdbcTemplate.query(sql, new RowMapper<Result>() {
        @Override/* ww  w .  ja  v  a2 s  . com*/
        public Result mapRow(ResultSet rs, int rowNum) throws SQLException {
            Result result = new Result();
            result.setId(rs.getInt("id"));
            result.setMinimum(rs.getDouble("minimum"));
            result.setAverage(rs.getDouble("average"));
            return result;
        }
    });
    return listCaption;
}

From source file:com.handany.base.generator.Generator.java

public static List<TableBean> getTables() {
    Properties p = new Properties();
    try {//  w  ww. j a  v  a 2 s .  com
        p.load(new FileInputStream(new File("src/main/java/com/handany/base/generator/generator.properties")));
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    List<TableBean> tableBeanList = jdbcTemplate.query("select * from TABLES where table_schema = ?",
            new Object[] { SCHEMA_NAME }, new RowMapper<TableBean>() {
                @Override
                public TableBean mapRow(ResultSet rs, int i) throws SQLException {
                    TableBean bean = new TableBean();
                    String tableName = rs.getString("table_name");
                    bean.setTableName(tableName);
                    bean.setTableNameNoDash(delDash(tableName));
                    bean.setTableNameCapitalized(StringUtils.capitalize(bean.getTableNameNoDash()));
                    bean.setTableComment(rs.getString("table_comment"));
                    return bean;
                }
            });

    for (TableBean tableBean : tableBeanList) {
        tableBean.setColumnBeanList(getColumns(tableBean));
    }

    return tableBeanList;
}

From source file:com.leapfrog.sms.dao.impl.CourseDAOImpl.java

@Override
public List<Course> getAll() {
    return jdbcTemplate.query(SqlConstant.COURSE_GETALL, new RowMapper<Course>() {

        @Override/*from w w  w.  j a  va 2 s. co  m*/
        public Course mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);
        }
    });

}

From source file:com.ewcms.component.online.dao.CitizenDAO.java

public Citizen get(int id) {

    String sql = "Select * From content_citizen Where id=?";

    List<Citizen> list = jdbcTemplate.query(sql, new Object[] { id }, new RowMapper<Citizen>() {

        @Override//from w  w w .  j a va2 s .c  om
        public Citizen mapRow(ResultSet rs, int rowNum) throws SQLException {
            return citizenMapRow(rs);
        }
    });

    return list.isEmpty() ? null : list.get(0);
}