Update annotation : JDBC Annotation « Database « Java Tutorial

1. Java Tutorial
2. Database
3. JDBC Annotation

The Update annotation is used to decorate a method specifying an SQL update statement.

The method's return value can be an int or void.

Only if the return value type is int will the update count be returned.

import java.sql.BaseQuery;
import java.sql.DataSet;
import java.sql.Select;
public interface UserQueries extends BaseQuery {


    // Delete user
    @Update ("DELETE Users WHERE firstName={firstName}" +
             "AND lastName={lastName}")
    int deleteUser (String firstName, String lastName);
}