org.simpleflatmapper.jdbc.README.md Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sfm-jdbc Show documentation

Java library to map flat record - ResultSet, csv - to java object with minimum configuration and low footprint.

There is a newer version: 9.0.2

JdbcMapper
---------

```java

public class MyDao {
    private final JdbcMapper parameterGetterMap =
        JdbcMapperFactory.newInstance().newMapper(MyObject.class);
    public void printAllLambda(Writer writer, Connection conn) throws SQLException {
        try (PreparedStatement ps =
                conn.prepareStatement("select id, email, my_property from MyTable");
                ResultSet rs = ps.executeQuery()) {
            parameterGetterMap.forEach(rs, (o) -> writer.append(o.toString()).append("\n"));
        }
    }
    public void printAll(Writer writer, Connection conn) throws SQLException {
        try (PreparedStatement ps =
                conn.prepareStatement("select id, email, my_property from MyTable");
                ResultSet rs = ps.executeQuery()) {
            parameterGetterMap.forEach(rs, new CheckedConsumer{
                public void handle(MyObject o) throws IOException {
                    writer.append(o.toString()).append("\n");
                }
            });
        }
    }
}
```