SqlSessionFactory build(InputStream inputStream)SqlSessionFactory build(InputStream inputStream, String environment)SqlSessionFactory build(InputStream inputStream, Properties properties)SqlSessionFactory build(InputStream inputStream, String env, Properties props)SqlSessionFactory build(Configuration config)

String resource = "mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(inputStream);

DataSource dataSource = BaseDataTest.createBlogDataSource();TransactionFactory transactionFactory = new JdbcTransactionFactory();Environment environment = new Environment("development", transactionFactory, dataSource);Configuration configuration = new Configuration(environment);configuration.setLazyLoadingEnabled(true);configuration.setEnhancementEnabled(true);configuration.getTypeAliasRegistry().registerAlias(Blog.class);configuration.getTypeAliasRegistry().registerAlias(Post.class);configuration.getTypeAliasRegistry().registerAlias(Author.class);configuration.addMapper(BoundBlogMapper.class);configuration.addMapper(BoundAuthorMapper.class);SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();SqlSessionFactory factory = builder.build(configuration);

SqlSession openSession()SqlSession openSession(boolean autoCommit)SqlSession openSession(Connection connection)SqlSession openSession(TransactionIsolationLevel level)SqlSession openSession(ExecutorType execType,TransactionIsolationLevel level)SqlSession openSession(ExecutorType execType)SqlSession openSession(ExecutorType execType, boolean autoCommit)SqlSession openSession(ExecutorType execType, Connection connection)Configuration getConfiguration();　　

     
       T selectOne(String statement, Object parameter)
      
        List
       
         selectList(String statement, Object parameter)
        
          Map
         
           selectMap(String statement, Object parameter, String mapKey)int insert(String statement, Object parameter)int update(String statement, Object parameter)int delete(String statement, Object parameter)　　
         
        
       
      
     

     
       T selectOne(String statement)
      
        List
       
         selectList(String statement)
        
          Map
         
           selectMap(String statement, String mapKey)int insert(String statement)int update(String statement)int delete(String statement)
         
        
       
      
     

// UserMapper.xml   select * from user where  id = #{id} // UserDao.javaUser u = session1.selectOne("selectUserById", 1);

     
       List
      
        selectList (String statement, Object parameter, RowBounds rowBounds)
       
         Map
        
          selectMap(String statement, Object parameter, String mapKey, RowBounds rowbounds)void select (String statement, Object parameter, ResultHandler
         
           handler)void select (String statement, Object parameter, RowBounds rowBounds, ResultHandler
          
            handler)
          
         
        
       
      
     

int offset = 100;int limit = 25;RowBounds rowBounds = new RowBounds(offset, limit);　　

UserMapper.xml   select * from user UserDao.javaList
     
       us = session1.selectList("selectUsers",null, new RowBounds(2, 1));
     

List
     
       flushStatements()
     

void commit()void commit(boolean force)void rollback()void rollback(boolean force)

void clearCache()

void close()

SqlSession session = sqlSessionFactory.openSession();try {    // following 3 lines pseudocod for "doing some work"    session.insert(...);    session.update(...);    session.delete(...);    session.commit();} finally {    session.close();}

try (SqlSession session = sqlSessionFactory.openSession()) {    // following 3 lines pseudocode for "doing some work"    session.insert(...);    session.update(...);    session.delete(...);    session.commit();}

Configuration getConfiguration()

     
       T getMapper(Class
      
        type)
      
     

public interface UserMapper {     User selectUsers();    User selectUserByName(String name);    int insertUser(User u);        int insertManyUser(List
     
       users);        User selectUserAndRole(int id);        Role selectRole(int id);    Role selectRoleAndUsers(int id);    List
      
        queryUser();}
      
     

@Select("select * from user where id=#{id}")    User selectOne(int id);

String sql = "SELECT P.ID, P.USERNAME, P.PASSWORD, P.FULL_NAME, ""P.LAST_NAME,P.CREATED_ON, P.UPDATED_ON " +"FROM PERSON P, ACCOUNT A " +"INNER JOIN DEPARTMENT D on D.ID = P.DEPARTMENT_ID " +"INNER JOIN COMPANY C on D.COMPANY_ID = C.ID " +"WHERE (P.ID = A.ID AND P.FIRST_NAME like ?) " +"OR (P.LAST_NAME like ?) " +"GROUP BY P.ID " +"HAVING (P.LAST_NAME like ?) " +"OR (P.FIRST_NAME like ?) " +"ORDER BY P.ID, P.FULL_NAME";

private String selectPersonSql() {  return new SQL() {
    {    SELECT("P.ID, P.USERNAME, P.PASSWORD, P.FULL_NAME");    SELECT("P.LAST_NAME, P.CREATED_ON, P.UPDATED_ON");    FROM("PERSON P");    FROM("ACCOUNT A");    INNER_JOIN("DEPARTMENT D on D.ID = P.DEPARTMENT_ID");    INNER_JOIN("COMPANY C on D.COMPANY_ID = C.ID");    WHERE("P.ID = A.ID");    WHERE("P.FIRST_NAME like ?");    OR();    WHERE("P.LAST_NAME like ?");    GROUP_BY("P.ID");    HAVING("P.LAST_NAME like ?");    OR();    HAVING("P.FIRST_NAME like ?");    ORDER_BY("P.ID");    ORDER_BY("P.FULL_NAME");  }}.toString();}

       
      
           ...    
           ...