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.abcd.employeemaven.dao.impl.EmployeeDaoImpl.java

@Override
public List<Employee> getAll() {
    return jdbcTemplate.query(EmployeeSQL.GETALL, new RowMapper<Employee>() {

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

---

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

public static List<ColumnBean> getColumns(final TableBean tableBean) {
    return jdbcTemplate.query("select * from COLUMNS where table_schema = ? and table_name = ?",
            new Object[] { SCHEMA_NAME, tableBean.getTableName() }, new RowMapper<ColumnBean>() {

                @Override//from  w w w  .  j  a v a2 s.  co m
                public ColumnBean mapRow(ResultSet rs, int i) throws SQLException {
                    ColumnBean columnBean = new ColumnBean();
                    String columnName = rs.getString("column_name");
                    columnBean.setColumnName(columnName);
                    columnBean.setColumnNameNoDash(delDash(columnName));
                    columnBean
                            .setColumnNameCapitalized(StringUtils.capitalize(columnBean.getColumnNameNoDash()));
                    columnBean.setColumnComment(rs.getString("column_comment"));

                    String charLength = rs.getString("character_maximum_length");
                    if (StringUtils.isNoneBlank(charLength)) {
                        columnBean.setLength(Long.parseLong(charLength));
                    }

                    String columnType = rs.getString("column_type").toLowerCase();
                    if (columnType.startsWith("varchar") || columnType.startsWith("char")
                            || columnType.startsWith("clob") || ("text").equals(columnType)
                            || ("longtext").equals(columnType) || columnType.startsWith("enum")) {
                        columnBean.setColumnType("String");
                        columnBean.setColumnTypeRsGetter("getString");
                    } else if (columnType.startsWith("tinyint") || columnType.startsWith("smallint")
                            || columnType.startsWith("mediumint")) {
                        columnBean.setColumnType("Integer");
                        columnBean.setColumnTypeRsGetter("getInt");
                    } else if (columnType.startsWith("int") || columnType.startsWith("bigint")) {
                        columnBean.setColumnType("Long");
                        columnBean.setColumnTypeRsGetter("getLong");
                    } else if (("timestamp").equals(columnType) || ("datetime").equals(columnType)
                            || ("date").equals(columnType)) {
                        columnBean.setColumnType("Date");
                        columnBean.setColumnTypeRsGetter("getDate");
                        tableBean.setHasDateColumn(true);
                    } else if (columnType.startsWith("float")) {
                        columnBean.setColumnType("Float");
                        columnBean.setColumnTypeRsGetter("getFloat");
                    } else if (columnType.startsWith("double")) {
                        columnBean.setColumnType("Double");
                        columnBean.setColumnTypeRsGetter("getDouble");
                    } else if (columnType.startsWith("decimal")) {
                        columnBean.setColumnType("BigDecimal");
                        columnBean.setColumnTypeRsGetter("getBigDecimal");
                        tableBean.setHasBigDecimal(true);
                    } else {
                        throw new RuntimeException("Unsupported type: [" + columnType + "]!");
                    }

                    String dataType = rs.getString("data_type").toUpperCase();

                    if ("DATETIME".equals(dataType)) {
                        dataType = "TIMESTAMP";
                    } else if ("TEXT".equals(dataType)) {
                        dataType = "LONGVARCHAR";
                    }

                    columnBean.setColumnJdbcType(dataType);

                    return columnBean;
                }

            });
}

---

From source file:db.migration.V055__UpdateECTS.java

public void migrate(JdbcTemplate jdbcTemplate) throws Exception {
    LOG.info("migrate()...");

    // Get all organisaatiometadatas where there are strings to process
    List<Map> resultSet = jdbcTemplate.query(
            "SELECT id,hakutoimistoectsemail,hakutoimistoectsnimi,hakutoimistoectspuhelin,hakutoimistoectstehtavanimike FROM organisaatiometadata WHERE hakutoimistoectsemail<>'' OR hakutoimistoectsnimi<>'' OR hakutoimistoectspuhelin<>'' OR hakutoimistoectstehtavanimike<>''",
            new RowMapper<Map>() {
                @Override//  ww  w  .java2 s.co m
                public Map mapRow(ResultSet rs, int rowNum) throws SQLException {
                    Map r = new HashMap<String, Object>();

                    ResultSetMetaData metadata = rs.getMetaData();
                    for (int i = 1; i <= metadata.getColumnCount(); i++) {
                        String cname = metadata.getColumnName(i);
                        int ctype = metadata.getColumnType(i);

                        switch (ctype) {
                        case Types.VARCHAR: // hakutoimistoectsemail,hakutoimistoectsnimi,hakutoimistoectspuhelin,hakutoimistoectstehtavanimike
                            r.put(cname, rs.getString(cname));
                            break;

                        case Types.BIGINT: // id
                            r.put(cname, rs.getInt(cname));
                            break;

                        default:
                            break;
                        }
                    }

                    LOG.debug("  read from db : organisaatiometadata = {}", r);

                    return r;
                }
            });

    // Move strings to monikielinenteksti_values
    for (Map orgmd : resultSet) {

        handleOrganisaatiometadata(orgmd, jdbcTemplate);

    }

    LOG.info("migrate()... done.");
}

---

From source file:com.karki.spring.dao.impl.CourseDaoImpl.java

@Override
public Course getById(int id) throws ClassNotFoundException, SQLException {
    return jdbcTemplate.queryForObject(CourseSQL.GETBYID, new Object[] { id }, new RowMapper<Course>() {

        @Override/*  w  ww . j a v a2s. c o  m*/
        public Course mapRow(ResultSet rs, int i) throws SQLException {
            return mapData(rs);

        }
    });
}

---

From source file:example.java8.JdbcRepository.java

/**
 * Shows the usage of//  w w  w .j  av a  2 s .  c  o m
 * {@link JdbcTemplate#query(org.springframework.jdbc.core.PreparedStatementCreator, org.springframework.jdbc.core.RowCallbackHandler)}
 * using Java 8 Lambda expressions in contrast to the traditional style.
 */
public void executeQueryWithPreparedStatementAndRowMapper() {

    template.query("SELECT name, age FROM person WHERE dep = ?", ps -> ps.setString(1, "Sales"),
            (rs, rowNum) -> new Person(rs.getString(1), rs.getString(2)));

    // VS.

    template.query("SELECT name, age FROM person WHERE dep = ?", new PreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement ps) throws SQLException {
            ps.setString(1, "Sales");
        }
    }, new RowMapper<Person>() {
        @Override
        public Person mapRow(ResultSet rs, int i) throws SQLException {
            return new Person(rs.getString(1), rs.getString(2));
        }
    });
}

---

From source file:com.ethlo.kfka.mysql.TestCfg.java

@Bean
public KfkaMapStore<CustomKfkaMessage> mapStore(DataSource ds) {
    final RowMapper<CustomKfkaMessage> ROW_MAPPER = new RowMapper<CustomKfkaMessage>() {
        @Override/*from   w  w w  . j  a  v  a  2 s . c o  m*/
        public CustomKfkaMessage mapRow(ResultSet rs, int rowNum) throws SQLException {
            return new CustomKfkaMessageBuilder().userId(rs.getInt("userId")).payload(rs.getBytes("payload"))
                    .timestamp(rs.getLong("timestamp")).topic(rs.getString("topic")).type(rs.getString("type"))
                    .id(rs.getLong("id")).build();
        }
    };

    return new MysqlKfkaMapStore<CustomKfkaMessage>(ds, ROW_MAPPER);
}

---

From source file:co.jirm.spring.SpringJdbcSqlExecutor.java

@Override
protected <T> T doQueryForObject(String sql, final JdbcResultSetRowMapper<T> rowMapper, Object[] objects) {
    return jdbcTemplate.queryForObject(sql, new RowMapper<T>() {
        @Override//from   w w w  .  j  av  a2 s.  co m
        public T mapRow(ResultSet rs, int rowNum) throws SQLException {
            return rowMapper.mapRow(rs, rowNum);
        }
    }, objects);
}

---

From source file:org.cleverbus.admin.dao.MessageReportDaoJdbcImpl.java

@Override
public List<MessageReportDto> getMessageStateSummary(Date startDate, Date endDate) {

    String sql = "SELECT service, operation_name, source_system, state, COUNT(*) as state_count "
            + "FROM message m " + "     WHERE receive_timestamp >= ? AND receive_timestamp <= ? "
            + "GROUP BY service, operation_name, source_system, state "
            + "ORDER BY service, operation_name, source_system, state;";

    List<MessageReportDto> raw = jdbcTemplate.query(sql, new RowMapper<MessageReportDto>() {

        public MessageReportDto mapRow(ResultSet rs, int i) throws SQLException {
            MessageReportDto mdto = new MessageReportDto();
            mdto.setServiceName(rs.getString("service"));
            mdto.setOperationName(rs.getString("operation_name"));
            mdto.setSourceSystem(rs.getString("source_system"));
            mdto.setState(rs.getString("state"));
            mdto.setStateCount(rs.getInt("state_count"));
            return mdto;
        }/*from   w w w  . ja v a  2s .  c o  m*/
    }, startDate, endDate);

    return raw;
}

---

From source file:com.leapfrog.SpringMaven.DAOImpl.UserDAOImpl.java

@Override
public User getById(int id) throws SQLException, ClassNotFoundException {

    String query = "SELECT * from  tbl_user where user_id=?";
    return jdbcTemplate.queryForObject(query, new Object[] { id }, new RowMapper<User>() {

        @Override//  ww  w  .  j av  a  2 s. c  o  m
        public User mapRow(ResultSet rs, int i) throws SQLException {
            User user = new User();

            user.setId(rs.getInt("user_id"));
            user.setUserName(rs.getString("user_name"));
            user.setPassword(rs.getString("password"));
            user.setEmail(rs.getString("email"));
            user.setStatus(rs.getBoolean("status"));

            return user;

        }

    });
}

---

From source file:eionet.transfer.dao.MetadataServiceJdbc.java

@Override
public Upload getById(String id) {
    String query = "SELECT id, expires, filename, uploader, contenttype, filesize FROM uploads WHERE id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    Upload uploadRec = jdbcTemplate.queryForObject(query, new Object[] { id }, new RowMapper<Upload>() {

        @Override/*from   ww  w  .  j  a  v a 2s  .  com*/
        public Upload mapRow(ResultSet rs, int rowNum) throws SQLException {
            Upload uploadRec = new Upload();
            uploadRec.setId(rs.getString("id"));
            uploadRec.setFilename(rs.getString("filename"));
            uploadRec.setExpires(rs.getDate("expires"));
            uploadRec.setUploader(rs.getString("uploader"));
            uploadRec.setContentType(rs.getString("contenttype"));
            uploadRec.setSize(rs.getLong("filesize"));
            return uploadRec;
        }
    });

    return uploadRec;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »