Interface SqlSession

All Superinterfaces:
AutoCloseable, Closeable
All Known Implementing Classes:
DefaultSqlSession, SqlSessionManager

public interface SqlSession extends Closeable
The primary Java interface for working with MyBatis. Through this interface you can execute commands, get mappers and manage transactions.
Author:
Clinton Begin
  • Method Summary

    Modifier and Type
    Method
    Description
    void
    Clears local session cache.
    void
    Closes the session.
    void
    Flushes batch statements and commits database connection.
    void
    commit(boolean force)
    Flushes batch statements and commits database connection.
    int
    delete(String statement)
    Execute a delete statement.
    int
    delete(String statement, Object parameter)
    Execute a delete statement.
    Flushes batch statements.
    Retrieves current configuration.
    Retrieves inner database connection.
    <T> T
    getMapper(Class<T> type)
    Retrieves a mapper.
    int
    insert(String statement)
    Execute an insert statement.
    int
    insert(String statement, Object parameter)
    Execute an insert statement with the given parameter object.
    void
    Discards pending batch statements and rolls database connection back.
    void
    rollback(boolean force)
    Discards pending batch statements and rolls database connection back.
    void
    select(String statement, Object parameter, ResultHandler handler)
    Retrieve a single row mapped from the statement key and parameter using a ResultHandler.
    void
    select(String statement, Object parameter, RowBounds rowBounds, ResultHandler handler)
    Retrieve a single row mapped from the statement key and parameter using a ResultHandler and RowBounds.
    void
    select(String statement, ResultHandler handler)
    Retrieve a single row mapped from the statement using a ResultHandler.
    <T> Cursor<T>
    selectCursor(String statement)
    A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
    <T> Cursor<T>
    selectCursor(String statement, Object parameter)
    A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
    <T> Cursor<T>
    selectCursor(String statement, Object parameter, RowBounds rowBounds)
    A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
    <E> List<E>
    selectList(String statement)
    Retrieve a list of mapped objects from the statement key.
    <E> List<E>
    selectList(String statement, Object parameter)
    Retrieve a list of mapped objects from the statement key and parameter.
    <E> List<E>
    selectList(String statement, Object parameter, RowBounds rowBounds)
    Retrieve a list of mapped objects from the statement key and parameter, within the specified row bounds.
    <K, V> Map<K,V>
    selectMap(String statement, Object parameter, String mapKey)
    The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
    <K, V> Map<K,V>
    selectMap(String statement, Object parameter, String mapKey, RowBounds rowBounds)
    The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
    <K, V> Map<K,V>
    selectMap(String statement, String mapKey)
    The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
    <T> T
    selectOne(String statement)
    Retrieve a single row mapped from the statement key.
    <T> T
    selectOne(String statement, Object parameter)
    Retrieve a single row mapped from the statement key and parameter.
    int
    update(String statement)
    Execute an update statement.
    int
    update(String statement, Object parameter)
    Execute an update statement.
  • Method Details

    • selectOne

      <T> T selectOne(String statement)
      Retrieve a single row mapped from the statement key.
      Type Parameters:
      T - the returned object type
      Parameters:
      statement - the statement
      Returns:
      Mapped object
    • selectOne

      <T> T selectOne(String statement, Object parameter)
      Retrieve a single row mapped from the statement key and parameter.
      Type Parameters:
      T - the returned object type
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      Returns:
      Mapped object
    • selectList

      <E> List<E> selectList(String statement)
      Retrieve a list of mapped objects from the statement key.
      Type Parameters:
      E - the returned list element type
      Parameters:
      statement - Unique identifier matching the statement to use.
      Returns:
      List of mapped object
    • selectList

      <E> List<E> selectList(String statement, Object parameter)
      Retrieve a list of mapped objects from the statement key and parameter.
      Type Parameters:
      E - the returned list element type
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      Returns:
      List of mapped object
    • selectList

      <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds)
      Retrieve a list of mapped objects from the statement key and parameter, within the specified row bounds.
      Type Parameters:
      E - the returned list element type
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      rowBounds - Bounds to limit object retrieval
      Returns:
      List of mapped object
    • selectMap

      <K, V> Map<K,V> selectMap(String statement, String mapKey)
      The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects. Eg. Return a of Map[Integer,Author] for selectMap("selectAuthors","id")
      Type Parameters:
      K - the returned Map keys type
      V - the returned Map values type
      Parameters:
      statement - Unique identifier matching the statement to use.
      mapKey - The property to use as key for each value in the list.
      Returns:
      Map containing key pair data.
    • selectMap

      <K, V> Map<K,V> selectMap(String statement, Object parameter, String mapKey)
      The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
      Type Parameters:
      K - the returned Map keys type
      V - the returned Map values type
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      mapKey - The property to use as key for each value in the list.
      Returns:
      Map containing key pair data.
    • selectMap

      <K, V> Map<K,V> selectMap(String statement, Object parameter, String mapKey, RowBounds rowBounds)
      The selectMap is a special case in that it is designed to convert a list of results into a Map based on one of the properties in the resulting objects.
      Type Parameters:
      K - the returned Map keys type
      V - the returned Map values type
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      mapKey - The property to use as key for each value in the list.
      rowBounds - Bounds to limit object retrieval
      Returns:
      Map containing key pair data.
    • selectCursor

      <T> Cursor<T> selectCursor(String statement)
      A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
      Type Parameters:
      T - the returned cursor element type.
      Parameters:
      statement - Unique identifier matching the statement to use.
      Returns:
      Cursor of mapped objects
    • selectCursor

      <T> Cursor<T> selectCursor(String statement, Object parameter)
      A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
      Type Parameters:
      T - the returned cursor element type.
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      Returns:
      Cursor of mapped objects
    • selectCursor

      <T> Cursor<T> selectCursor(String statement, Object parameter, RowBounds rowBounds)
      A Cursor offers the same results as a List, except it fetches data lazily using an Iterator.
      Type Parameters:
      T - the returned cursor element type.
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      rowBounds - Bounds to limit object retrieval
      Returns:
      Cursor of mapped objects
    • select

      void select(String statement, Object parameter, ResultHandler handler)
      Retrieve a single row mapped from the statement key and parameter using a ResultHandler.
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - A parameter object to pass to the statement.
      handler - ResultHandler that will handle each retrieved row
    • select

      void select(String statement, ResultHandler handler)
      Retrieve a single row mapped from the statement using a ResultHandler.
      Parameters:
      statement - Unique identifier matching the statement to use.
      handler - ResultHandler that will handle each retrieved row
    • select

      void select(String statement, Object parameter, RowBounds rowBounds, ResultHandler handler)
      Retrieve a single row mapped from the statement key and parameter using a ResultHandler and RowBounds.
      Parameters:
      statement - Unique identifier matching the statement to use.
      parameter - the parameter
      rowBounds - RowBound instance to limit the query results
      handler - ResultHandler that will handle each retrieved row
    • insert

      int insert(String statement)
      Execute an insert statement.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      Returns:
      int The number of rows affected by the insert.
    • insert

      int insert(String statement, Object parameter)
      Execute an insert statement with the given parameter object. Any generated autoincrement values or selectKey entries will modify the given parameter object properties. Only the number of rows affected will be returned.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      parameter - A parameter object to pass to the statement.
      Returns:
      int The number of rows affected by the insert.
    • update

      int update(String statement)
      Execute an update statement. The number of rows affected will be returned.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      Returns:
      int The number of rows affected by the update.
    • update

      int update(String statement, Object parameter)
      Execute an update statement. The number of rows affected will be returned.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      parameter - A parameter object to pass to the statement.
      Returns:
      int The number of rows affected by the update.
    • delete

      int delete(String statement)
      Execute a delete statement. The number of rows affected will be returned.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      Returns:
      int The number of rows affected by the delete.
    • delete

      int delete(String statement, Object parameter)
      Execute a delete statement. The number of rows affected will be returned.
      Parameters:
      statement - Unique identifier matching the statement to execute.
      parameter - A parameter object to pass to the statement.
      Returns:
      int The number of rows affected by the delete.
    • commit

      void commit()
      Flushes batch statements and commits database connection. Note that database connection will not be committed if no updates/deletes/inserts were called. To force the commit call commit(boolean)
    • commit

      void commit(boolean force)
      Flushes batch statements and commits database connection.
      Parameters:
      force - forces connection commit
    • rollback

      void rollback()
      Discards pending batch statements and rolls database connection back. Note that database connection will not be rolled back if no updates/deletes/inserts were called. To force the rollback call rollback(boolean)
    • rollback

      void rollback(boolean force)
      Discards pending batch statements and rolls database connection back. Note that database connection will not be rolled back if no updates/deletes/inserts were called.
      Parameters:
      force - forces connection rollback
    • flushStatements

      List<BatchResult> flushStatements()
      Flushes batch statements.
      Returns:
      BatchResult list of updated records
      Since:
      3.0.6
    • close

      void close()
      Closes the session.
      Specified by:
      close in interface AutoCloseable
      Specified by:
      close in interface Closeable
    • clearCache

      void clearCache()
      Clears local session cache.
    • getConfiguration

      Configuration getConfiguration()
      Retrieves current configuration.
      Returns:
      Configuration
    • getMapper

      <T> T getMapper(Class<T> type)
      Retrieves a mapper.
      Type Parameters:
      T - the mapper type
      Parameters:
      type - Mapper interface class
      Returns:
      a mapper bound to this SqlSession
    • getConnection

      Connection getConnection()
      Retrieves inner database connection.
      Returns:
      Connection