a87de8e63b13_ClientMapper1.java

@Mapper
public interface ClientMapper {

    @Select("SELECT id as id, first_name as firstName, last_name as lastName FROM spring_demo.clients WHERE id = #{id}")
    Client selectOne(long id);

    @Select("SELECT id as id, first_name as firstName, last_name as lastName FROM spring_demo.clients")
    List<Client> findAll();

    @Insert("INSERT INTO spring_demo.clients (id, first_name, last_name) VALUES (#{id}, #{firstName}, #{lastName})")
    // Sets the object id to the id generated in database
    @Options(useGeneratedKeys = true, keyColumn = "id", keyProperty = "id")
    void insertClient(Client client);
}