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.tech.auju.util.ProduksiService.java

@Override
public void updateJumlahBahan(int amount, int id) {
    SqlSession sqlSession = new MyBatisSqlSessionFactory().openSession();
    try {/*  w  w w  . j a v  a 2 s.  c  om*/
        ProduksiMapper produksiMapper = sqlSession.getMapper(ProduksiMapper.class);
        produksiMapper.updateJumlahBahan(amount, id);
        sqlSession.commit();
    } finally {
        sqlSession.close();
    }
}

From source file:com.tianjunwei.selectKey.SelectKeyMain.java

License:Apache License

public static void main(String[] args) {
    //mybatis?//from  w  ww  . j  a  v a2s  . co m
    String resource = "learn/mybatis-config.xml";
    InputStream is = SelectKeyMain.class.getClassLoader().getResourceAsStream(resource);
    //sqlSession
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
    SqlSession session = sessionFactory.openSession();
    User user = new User();
    user.setAge(10);
    user.setNames("yao");
    session.insert("com.tianjunwei.selectKey.entity.User.add", user);
    session.commit();
    System.err.println(user.getId());
    session.insert("com.tianjunwei.selectKey.entity.User.insert", user);
    session.commit();
    System.err.println(user.getId());
}

From source file:edu.eci.pdsw.samples.services.client.MyBatisExample.java

License:Open Source License

/**
 * Programa principal de ejempo de uso de MyBATIS
 * @param args//from ww  w .j  a v  a2  s .c  o  m
 * @throws SQLException 
 */
public static void main(String args[]) throws SQLException {
    SqlSessionFactory sessionfact = getSqlSessionFactory();

    SqlSession sqlss = sessionfact.openSession();

    //Crear el mapper y usarlo: 

    //cm...
    ClienteMapper cm = sqlss.getMapper(ClienteMapper.class);
    System.out.println(cm.consultarCliente(1026585664));
    ItemMapper cm1 = sqlss.getMapper(ItemMapper.class);
    System.out.println(cm1.consultarItem(5));

    sqlss.commit();

    sqlss.close();

}

From source file:edu.eci.pdsw.samples.tests.PersistenceMapperTest.java

License:Open Source License

@Test
public void OneTest() {
    SqlSessionFactory sessionfact = getSqlSessionFactory();
    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pmap = sqlss.getMapper(PacienteMapper.class);
    Assert.assertEquals(pmap.loadPacienteById(1, "cc"), null);
    sqlss.commit();
    sqlss.close();//from w w  w. ja va2  s.  c  om
}

From source file:edu.eci.pdsw.samples.tests.PersistenceMapperTest.java

License:Open Source License

@Test
public void TwoTest() {
    int numero = 1221946830;
    SqlSessionFactory sessionfact = getSqlSessionFactory();
    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pmap = sqlss.getMapper(PacienteMapper.class);
    Date date = java.sql.Date.valueOf("1998-06-19");
    Paciente jhordy = new Paciente(numero, "cc", "Jhordy Salinis", date);
    pmap.insertPaciente(jhordy);//from w w w.j  a  va  2 s .  c  o m

    Assert.assertEquals(jhordy.toString(), pmap.loadPacienteById(numero, "cc").toString());
    sqlss.commit();
    sqlss.close();
}

From source file:edu.eci.pdsw.samples.tests.PersistenceMapperTest.java

License:Open Source License

@Test
public void ThreeTest() {
    int numero = 1221946839;
    SqlSessionFactory sessionfact = getSqlSessionFactory();
    SqlSession sqlss = sessionfact.openSession();
    PacienteMapper pmap = sqlss.getMapper(PacienteMapper.class);
    Date date = java.sql.Date.valueOf("1998-06-19");
    Paciente jhordy = new Paciente(numero, "cc", "Jhordy Salinis", date);
    pmap.insertPaciente(jhordy);/*  w w  w.j  av a  2s  .c o  m*/
    Consulta consulta = new Consulta(java.sql.Date.valueOf("2000-01-02"), "hola como estas?");
    pmap.insertConsulta(consulta, jhordy.getId(), jhordy.getTipo_id());
    Set<Consulta> set = jhordy.getConsultas();
    set.add(consulta);
    jhordy.setConsultas(set);
    System.out.println("hola");
    System.out.println(jhordy.toString());
    System.out.println(pmap.loadPacienteById(numero, "cc").toString());
    Assert.assertEquals(jhordy.toString(), pmap.loadPacienteById(numero, "cc").toString());
    sqlss.commit();
    sqlss.close();
}

From source file:edu.eci.pdsw.samples.textview.MyBatisExample.java

License:Open Source License

/**
 * Programa principal de ejempo de uso de MyBATIS
 * @param args/*from w w  w .  j  a v  a  2 s  .  c  om*/
 * @throws SQLException 
 */
public static void main(String args[]) throws SQLException {
    SqlSessionFactory sessionfact = getSqlSessionFactory();

    SqlSession sqlss = sessionfact.openSession();

    PacienteMapper pmap = sqlss.getMapper(PacienteMapper.class);
    Date d = new java.sql.Date(1994 - 01 - 29);
    Consulta c = new Consulta(java.sql.Date.valueOf("2016-04-01"), "Esta muy gordo");

    pmap.insertConsulta(c, 12, "CC");
    System.out.println(pmap.loadPacienteById(12, "CC"));

    System.out.println(pmap.loadPacienteById(105, "CC"));

    sqlss.commit();

    sqlss.close();

}

From source file:fr.cph.stock.dao.AccountDaoImpl.java

License:Apache License

@Override
public final void insert(final Account account) {
    SqlSession session = getSqlSessionFactory();
    try {//  ww  w. java2s .  co m
        session.insert("AccountDao.insertOneAccount", account);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:fr.cph.stock.dao.AccountDaoImpl.java

License:Apache License

@Override
public final void update(final Account account) {
    SqlSession session = getSqlSessionFactory();
    try {/*  w  w w.j a  va  2  s  .  c om*/
        session.update("AccountDao.updateOneAccount", account);
        session.commit();
    } finally {
        session.close();
    }

}

From source file:fr.cph.stock.dao.AccountDaoImpl.java

License:Apache License

@Override
public final void delete(final Account account) {
    SqlSession session = getSqlSessionFactory();
    try {/*from  w w w  .  ja  va 2  s  . co  m*/
        session.delete("AccountDao.deleteOneAccount", account);
        session.commit();
    } finally {
        session.close();
    }
}