Add SQL annotations like in JDBI [DATAJDBC-116]

[spring-projects-issues]

Alex Rader opened DATAJDBC-116 and commented

In JDBI we can write

public interface UserDao {
    @SqlUpdate("CREATE TABLE user (id INTEGER PRIMARY KEY, name VARCHAR)")
    void createTable();

    @SqlUpdate("INSERT INTO user(id, name) VALUES (?, ?)")
    void insertPositional(int id, String name);

    @SqlUpdate("INSERT INTO user(id, name) VALUES (:id, :name)")
    void insertNamed(@Bind("id") int id, @Bind("name") String name);

    @SqlUpdate("INSERT INTO user(id, name) VALUES (:id, :name)")
    void insertBean(@BindBean User user);

    @SqlQuery("SELECT * FROM user ORDER BY name")
    @RegisterBeanMapper(User.class)
    List<User> listUsers();
}

http://jdbi.github.io/

it will be useful to able to do the same in Spring Data

---

Issue Links:

• DATAJDBC-82 annotation based spring-jdbc
  ("duplicates")

[spring-projects-issues]

Alex Rader commented

Please close as duplicate of https://jira.spring.io/browse/DATAJDBC-82