Indo

An elegant interface between Java and SQL

List results by passing in a result object type and bind parameters as variable arguments.

SqlRunner runner = new SqlRunner(dataSource);

List<Employee> employees1 =
        runner.list(" SELECT                  " +
                    "   e.employeeId,         " +
                    "   e.firstName,          " +
                    "   e.lastName            " +
                    " FROM  employee e        " +
                    " WHERE e.salary > ?      " +
                    " AND   e.lastName LIKE ? ",
                Employee.class,
                BigDecimal.valueOf(75000.00),
                "Lancaster");

List results and map them directly from the ResultSet using the ResultSets static helper.

SqlRunner runner = new SqlRunner(dataSource);

List<Employee> employees2 =
        runner.list(" SELECT                  " +
                    "   e.employeeId,         " +
                    "   e.firstName,          " +
                    "   e.lastName            " +
                    " FROM  employee e        " +
                    " WHERE e.salary > ?      " +
                    " AND   e.lastName LIKE ? ",
                rs -> new Employee(
                        getLong(rs, "employeeId"),
                        getString(rs, "firstName"),
                        getString(rs, "lastName")
                ),
                BigDecimal.valueOf(75000.00),
                "Lancaster");

List results by binding named parameters from a Map.

SqlRunner runner = new SqlRunner(dataSource);

List<Employee> employees3 =
        runner.list(" SELECT                          " +
                    "   e.employeeId,                 " +
                    "   e.firstName,                  " +
                    "   e.lastName                    " +
                    " FROM  employee e                " +
                    " WHERE e.salary > :salary        " +
                    " AND   e.lastName LIKE :lastName ",
                Employee.class,
                Maps.newHashMap(
                        "salary", BigDecimal.valueOf(75000.00),
                        "lastName", "Lancaster"
                ));

List results by binding named parameters from a custom SqlParameterProvider, in this case a POJO.

SqlRunner runner = new SqlRunner(dataSource);

Employee employeeLike = new Employee();
employeeLike.setLastName("Lancaster");
employeeLike.setSalary(BigDecimal.valueOf(75000.00));

List<Employee> employees4 =
        runner.list(" SELECT                          " +
                    "   e.employeeId,                 " +
                    "   e.firstName,                  " +
                    "   e.lastName                    " +
                    " FROM  Employee e                " +
                    " WHERE e.salary > :salary        " +
                    " AND   e.lastName LIKE :lastName ",
                Employee.class,
                SqlParameters.from(employeeLike));
}