When you generate an annotated-method interface from a SELECT statement, the interface contains one method. This method has an @Select annotation. The content of the annotation is the original SELECT statement. The method return type is an Iterator of <BeanName>.
The default name of the method is get<Name-of-bean>. You can change this name when you specify the information for generating the interface.
@Select(sql="Select * from name-of-table where col1 = ?")
Iterator<Name-of-bean> getName-of-bean(int param1);
If you specify the name of a custom RowHandler, an @Handler annotation is included.
@Select(sql="Select * from name-of-table where col1 = ?")
@Handler(rowHandler="Name-of-handler")
Iterator<Name-of-bean> getName-of-bean(int param1);
When you generate an annotated-method interface from an UPDATE, INSERT, or DELETE statement, the interface contains a method that has an @Update annotation. The content of the annotation is the original UPDATE, INSERT, or DELETE statement. The method return type is an integer.
When you generate an annotated-method interface from a CALL statement, the interface contains a method that has an @Call annotation. The content of the annotation is the original CALL statement.
The method return type is StoredProcedureResult . You can access the JDBC ResultSet from the StoredProcedureResult type.
If you specify the name of a custom CallHandlerWithParameters class, an @Handler annotation is included.