Example usage for org.apache.ibatis.session SqlSession commit

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession commit.

Prototype

void commit();

Source Link

Document

Flushes batch statements and commits database connection.

Usage

From source file:com.baomidou.mybatisplus.test.oracle.TestUserMapperTest.java

License:Apache License

/**
 *
 * RUN   MySql  //from   www .  j  av a 2 s  . c  om
 *
 */
public static void main(String[] args) {

    //?
    InputStream in = TestUserMapperTest.class.getClassLoader().getResourceAsStream("oracle-config.xml");

    /*
       *  MybatisSessionFactoryBuilder 
     * SqlSessionFactoryBaseMapper
     */
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();

    /** ? oracle */
    GlobalConfiguration gc = new GlobalConfiguration();
    gc.setDbType("oracle");
    mf.setGlobalConfig(gc);

    /*
     * 1??????
     * 2?????
     * 3?????
     *    ?? @TableId(value = "test_id") 
     */
    //mf.setDbColumnUnderline(true);

    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    TestUserMapper testUserMapper = session.getMapper(TestUserMapper.class);
    System.err.println(" debug run  test_user ??? ");
    session.delete("deleteAll");

    /**
     * ?
     */
    int rlt = testUserMapper.insert(new TestUser("10", "abc", 18, 1));
    System.err.println("\n--------------insert-------" + rlt);
    sleep();

    /**
     * ??
     */
    List<TestUser> ul = new ArrayList<>();
    ul.add(new TestUser("11", "1a", 11, 1));
    ul.add(new TestUser("12", "2a", 12, 2));
    ul.add(new TestUser("a", 1, 1));
    ul.add(new TestUser("b", 2, 2));
    ul.add(new TestUser("c", 3, 1));
    for (TestUser u : ul) {
        rlt = testUserMapper.insert(u);
    }
    System.err.println("\n--------------insertBatch-------" + rlt);
    sleep();

    /**
     * ?
     */
    List<TestUser> ul1 = new ArrayList<>();
    ul1.add(new TestUser("10", "update-0a", 11, 1));
    ul1.add(new TestUser("11", "update-1a", 11, 1));
    ul1.add(new TestUser("12", "update-2a", 12, 2));
    for (TestUser u : ul1) {
        rlt = testUserMapper.updateById(u);
    }
    System.err.println("\n--------------updateBatchById-------" + rlt);
    sleep();

    System.err.println(
            "\n------------------list  ---- testType = 1 ?--id--DESC--?--------");
    Page<TestUser> page = new Page<>(1, 2);
    EntityWrapper<TestUser> ew = new EntityWrapper<>(new TestUser(1), "TEST_ID DESC");
    List<TestUser> paginList = testUserMapper.selectPage(page, ew);
    page.setRecords(paginList);
    for (int i = 0; i < page.getRecords().size(); i++) {
        print(page.getRecords().get(i));
    }
    System.err.println(" " + page.toString());

    /* ?  */
    rlt = session.delete("deleteAll");
    System.err.println("?? rlt=" + rlt);

    /**
     * ??
     */
    session.commit();
}

From source file:com.beginner.core.dao.DaoSupport.java

License:Apache License

/** 
 * {@inheritDoc}/*from   www  .ja v a 2  s  .co  m*/
 */
@Override
public void batchSave(String str, List objs) throws Exception {
    SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();
    //?
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
    try {
        if (objs != null) {
            for (int i = 0, size = objs.size(); i < size; i++) {
                sqlSession.insert(str, objs.get(i));
            }
            sqlSession.flushStatements();
            sqlSession.commit();
            sqlSession.clearCache();
        }
    } finally {
        sqlSession.close();
    }
}

From source file:com.beginner.core.dao.DaoSupport.java

License:Apache License

/** 
 * {@inheritDoc}// w  w w  .j  a v  a  2s. c  o  m
 */
@Override
public void batchUpdate(String str, List objs) throws Exception {
    SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();
    //?
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
    try {
        if (objs != null) {
            for (int i = 0, size = objs.size(); i < size; i++) {
                sqlSession.update(str, objs.get(i));
            }
            sqlSession.flushStatements();
            sqlSession.commit();
            sqlSession.clearCache();
        }
    } finally {
        sqlSession.close();
    }
}

From source file:com.beginner.core.dao.DaoSupport.java

License:Apache License

/** 
 * {@inheritDoc}/* w ww  .j ava2 s  .com*/
 */
@Override
public void batchDelete(String str, List objs) throws Exception {
    SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();
    //?
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
    try {
        if (objs != null) {
            for (int i = 0, size = objs.size(); i < size; i++) {
                sqlSession.delete(str, objs.get(i));
            }
            sqlSession.flushStatements();
            sqlSession.commit();
            sqlSession.clearCache();
        }
    } finally {
        sqlSession.close();
    }
}

From source file:com.bibisco.manager.ArchitectureItemManager.java