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

List of usage examples for org.apache.ibatis.session SqlSession commit

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. 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.inform.project.dao.MyBatisGetSellsImpl.java

@Override
public void updSells(UserSellsModel sell) {
    SqlSession session = null;
    try {/* w  w w.  j a va 2  s . c  o  m*/
        session = MyBatisSession.getInst().getSession().openSession();
        session.update("GetUsersSellsMapper.updateOne", sell);
        session.commit();
    } catch (IOException ex) {
        Logger.getLogger(MyBatisAdminImpl.class.getName()).log(Level.SEVERE, null, ex);
    } finally {
        if (session != null) {
            session.close();
        }
    }
}

From source file:com.mroza.dao.ProgramDaoTests.ProgramDaoUpdateProgramTest.java

License:Open Source License

@Test
public void updateProgramTest() {
    SqlSession sqlSession = databaseUtils.getSqlSession();
    ProgramsDao programsDao = new ProgramsDao();
    ReflectionWrapper.setPrivateField(programsDao, "sqlSession", sqlSession);

    programsDao.updateProgram(this.program);
    sqlSession.commit();

    Program changedProgram = programsDao.selectProgramById(this.program.getId());

    Assert.assertEquals("Updated program's name should have been changed", this.program.getName(),
            changedProgram.getName());//w ww .j ava2s . c o m
    Assert.assertEquals("Updated program's symbol should have been changed", this.program.getSymbol(),
            changedProgram.getSymbol());
    Assert.assertEquals("Updated program's description should have been changed", this.program.getDescription(),
            changedProgram.getDescription());
}

From source file:com.mroza.dao.ProgramDaoTests.ProgramDaoUpdateProgramTest.java

License:Open Source License

@Test
public void updateAssignedProgramTest() {
    SqlSession sqlSession = databaseUtils.getSqlSession();
    ProgramsDao programsDao = new ProgramsDao();
    ReflectionWrapper.setPrivateField(programsDao, "sqlSession", sqlSession);

    Program assignedProgram = databaseUtils.setUpAssignedProgram(this.kid, this.program);
    programsDao.updateProgram(this.program);
    sqlSession.commit();

    Program changedProgram = programsDao.selectProgramById(assignedProgram.getId());

    Assert.assertEquals("Updated program's assigned to kid program's name should have been changed",
            this.program.getName(), changedProgram.getName());
    Assert.assertEquals("Updated program's assigned to kid program's symbol should have been changed",
            this.program.getSymbol(), changedProgram.getSymbol());
    Assert.assertEquals("Updated program's assigned to kid program's description should have been changed",
            this.program.getDescription(), changedProgram.getDescription());
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void initWithBasicKids(List<Kid> exampleKids) {
    exampleKids.add(new Kid());
    exampleKids.add(new Kid());
    exampleKids.get(0).setCode("Jacek");
    exampleKids.get(1).setCode("Julia");
    initUtilsDaos();/*from  w ww  .j a v  a  2  s .  c o  m*/
    SqlSession sqlSession = getSqlSession();
    exampleKids.stream().forEach(kidsDao::insertKid);
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void initWithBasicKidWithCode(List<Kid> exampleKids, List<String> codes) {
    for (String code : codes) {
        Kid newKid = new Kid();
        newKid.setCode(code);/*from   w ww  .jav a2 s . co m*/
        exampleKids.add(newKid);
    }
    initUtilsDaos();
    SqlSession sqlSession = getSqlSession();
    exampleKids.stream().forEach(kidsDao::insertKid);
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void initWithBasicPrograms(List<Program> exampleProgram) {
    exampleProgram.add(new Program("ABC"));
    exampleProgram.add(new Program("QWR"));
    exampleProgram.add(new Program("RFG"));

    initUtilsDaos();/*www  .  ja va2s  .  c om*/
    SqlSession sqlSession = getSqlSession();
    programsDao.insertProgram(exampleProgram.get(0));
    programsDao.insertProgram(exampleProgram.get(1));
    programsDao.insertProgram(exampleProgram.get(2));
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void initWithMultiPrograms(List<Program> exampleProgram) {
    exampleProgram.add(new Program("ABC"));
    exampleProgram.add(new Program("ABC"));
    exampleProgram.add(new Program("ABC"));
    exampleProgram.add(new Program("QWR"));
    exampleProgram.add(new Program("QWR"));
    exampleProgram.add(new Program("RFG"));

    initUtilsDaos();/* w w w  .  j a v  a2  s  . com*/
    SqlSession sqlSession = getSqlSession();
    programsDao.insertProgram(exampleProgram.get(0));
    programsDao.insertProgram(exampleProgram.get(1));
    programsDao.insertProgram(exampleProgram.get(2));
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void initKidDeeply(List<Kid> exampleKids, String programsSymbolPrefix) {
    List<Period> kidPeriods = new ArrayList<>();
    kidPeriods.add(/* ww w .j  a  va  2  s  . c o m*/
            new Period(-1, strToDate("5-11-2014"), strToDate("10-11-2014"), null, null, new ArrayList<>()));
    kidPeriods.add(
            new Period(-1, strToDate("5-11-2014"), strToDate("10-11-2014"), null, null, new ArrayList<>()));

    List<Table> program1Tables = new ArrayList<>();
    program1Tables.add(new Table("Prog 1 - krok 1"));
    program1Tables.get(0).addTableRow("Wiersz z nazw 1", 3, 2);
    program1Tables.get(0).addTableRow("Wiersz z nazw 2");
    program1Tables.get(0).addTableRow("Wiersz z nazw 3");
    program1Tables.add(new Table("Prog 1 - krok 2"));
    program1Tables.get(1).addTableRow("Wiersz dla kroku 2 - nr 1", 3, 0);
    program1Tables.get(1).addTableRow("Wiersz dla kroku 2 - nr 2");
    List<Table> program2Tables = new ArrayList<>();
    program2Tables.add(new Table("Prog 2 - krok 1", LocalDate.of(2014, 11, 15)));
    program2Tables.get(0).addTableRow("Wiersz dla programu 2, krok 1 - nr 1", 2, 5);
    program2Tables.get(0).addTableRow("Wiersz dla programu 2, krok 1 - nr 2");
    program2Tables.get(0).addTableRow("Wiersz dla programu 2, krok 1 - nr 3");
    program2Tables.get(0).addTableRow("Wiersz dla programu 2, krok 1 - nr 4");

    List<Program> kidPrograms = new ArrayList<>();
    kidPrograms.add(new Program(-1, programsSymbolPrefix + ".RT.1", "Program 1", "Opis programu 1", false, -1,
            program1Tables));
    kidPrograms.add(new Program(-1, programsSymbolPrefix + ".RT.2", "Program 2", "Opis programu 2", false, -1,
            program2Tables));
    kidPrograms.add(new Program(-1, programsSymbolPrefix + ".RT.3", "Program 3", "Opis programu 3", false, -1,
            new ArrayList<>()));

    program1Tables.get(0).setProgram(kidPrograms.get(0));
    program1Tables.get(1).setProgram(kidPrograms.get(0));
    program2Tables.get(0).setProgram(kidPrograms.get(1));

    List<KidTable> kidTablesForPeriod_1 = new ArrayList<>();
    kidTablesForPeriod_1.add(new KidTable(true, true, program1Tables.get(0), kidPeriods.get(0)));
    kidTablesForPeriod_1.get(0).setNote("Notatka");
    kidTablesForPeriod_1.get(0).getResolvedFields().get(0).setValue("OK");
    kidTablesForPeriod_1.get(0).getResolvedFields().get(0).setValue("NOK");

    kidTablesForPeriod_1.add(new KidTable(false, true, program2Tables.get(0), kidPeriods.get(0)));
    kidTablesForPeriod_1.get(1).setFinishedLearning(true);
    kidTablesForPeriod_1.get(1).setNote("Notatka 2");
    kidPeriods.get(0).setKidTables(kidTablesForPeriod_1);

    program1Tables.get(0).getKidTables().add(kidTablesForPeriod_1.get(0));
    program1Tables.get(1).getKidTables().add(kidTablesForPeriod_1.get(1));

    Kid exampleKid = new Kid(-1, "Jarek", false, kidPrograms, kidPeriods);
    exampleKids.add(exampleKid);

    SqlSession sqlSession = getSqlSession();
    initUtilsDaos();
    insertKidDeeply(exampleKid);
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void kidsInitializedTearDown(List<Kid> exampleKids) {
    SqlSession sqlSession = getSqlSession();
    kidsDao.deleteKids(exampleKids);// w ww  .j a  v a  2s .co  m
    clearDeleteHistory();
    sqlSession.commit();
}

From source file:com.mroza.utils.Utils.java

License:Open Source License

public static void programsInitializedTearDown(List<Program> examplePrograms) {
    SqlSession sqlSession = getSqlSession();
    examplePrograms.stream().forEach(programsDao::deleteProgram);
    clearDeleteHistory();/*from  w  w w  .  j av a  2 s.  com*/
    sqlSession.commit();
}