augustoccesar / querybuilder-mapper Goto Github PK

When the project is using JPA, it already has a @Column annotation on models, so, need to create a way to verify following the rules:

• If model contains QueryBuilder @Column annotation, work as it is now.
• If model contains JPA @Column, get the data from it and build as the previous.
• If model don't contains @Column, get the fields and consider it column name as the attribute name in snake case.

As it is now, you can only create a new instance when mapping the result of a query

User user = new Mapper<User>("u").map(rs, User.class);

need to create a way to map to an existing instance

User user = new User();
new Mapper<User>("u").map(rs, user);

Create a way to reduce the boilerplate code produced every time that is going to run a query

try (PreparedStatement stmt = this.connection.prepareStatement(sql)) {
    try (ResultSet rs = stmt.executeQuery()) {
        while (rs.next()) {
            // Do stuff with each result
        }
    }
}

Looking for a way to do it simpler, like

SomeClass.executeQuery(sql, connection, (rs) -> {
    // Do stuff with each result
});

If query contains ? than, be able to pass the parameters

SomeClass.executeQuery(sql, connection, param1, param2, param3, (rs) -> {
    // Do stuff with each result
});
// or
ArrayList<Object> params = new ArrayList<>();
SomeClass.executeQuery(connection, params, (rs) -> {
    // Do stuff with each result
});

When the resultset contains a null date, the BeanUtils throw an exception.