Archives: Annotations

Java – JDBC 4 – Update Annotation Example

JDBC 4 Annotation Example using Update Query

The Update annotation is used to decorate a Query interface method to update one or more records in a database table.
An Update annotation must include a sql annotation type element.



Java – JDBC 4 – Select Annotation Example

JDBC 4 Annotation Example using Select Query

Here’s an example of Select annotation to get all the active loans from the loan database:

The sql annotation allows I/O parameters as well (a parameter marker is represented with a question mark followed by an integer). Here’s an example of a parameterized sql query.