Hint

This article is generated by AI translation.

@Delete Annotation

Marks an interface method and accepts a string or string array that represents a DELETE statement.

info

If you pass a string array, the elements are concatenated with a single space between them.
This makes it easy to manage SQL in a readable way.

Example: delete a user by id

@SimpleMapper
public interface UserMapper {
    @Delete({"delete from users ",    // 1. SQL definition
             "where id = #{userId}"}) //
    int deleteUserById(               // 2. userId argument
            @Param("userId") int userId
    );
}

Properties

Property	Description
value	必选 SQL to execute.
statementType	可选 Determines which JDBC statement type to use. Default is PREPARED. - STATEMENT → java.sql.Statement - PREPARED → java.sql.PreparedStatement - CALLABLE → java.sql.CallableStatement
timeout	可选 If set to a value greater than 0, the value is applied to java.sql.Statement.setQueryTimeout(int) to enforce a timeout in seconds. Default is -1.