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:action.reviseProfile.java

public String revise() throws IOException {

    String resource = "orm/configuration.xml";
    Reader reader = Resources.getResourceAsReader(resource);
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
    SqlSession session = sessionFactory.openSession();

    try {// w  w  w . jav a  2 s  .c om
        email = ActionContext.getContext().getSession().get("email").toString();

        //validate driverlicense
        String checkdl = "[0-9]{8}";
        Pattern regex = Pattern.compile(checkdl);
        java.util.regex.Matcher matcher = regex.matcher(driverlicense);
        boolean isMatched = matcher.matches();

        //check whether the email address is valid

        if (name.equals("") || sex.equals("") || dob.equals("")) {

            JOptionPane.showMessageDialog(null, "Please fill required information!", "Message",
                    JOptionPane.WARNING_MESSAGE);
            return "fail";

        } else if (!driverlicense.equals("")) {
            if (!isMatched) {
                JOptionPane.showMessageDialog(null, "Driver License should only be 8 numeric numbers!",
                        "Message", JOptionPane.ERROR_MESSAGE);
                return "fail";
            }

            else {
                //update user info
                u = new user();
                u.setEmail(email);
                u.setName(name);
                u.setDob(dob);
                u.setDriverlicense(driverlicense);
                u.setSex(sex);
                session.update("updateuserinfo", u);
                session.commit();
                JOptionPane.showMessageDialog(null, "Updated Successfully!", "Message",
                        JOptionPane.INFORMATION_MESSAGE);
                return "updatedsuccessfully";
            }
        }

        else {
            //update user's info
            System.out.println("email in revise=" + email);
            System.out.println("name in revise=" + name);
            System.out.println("dob in revise=" + dob);
            System.out.println("driverlicense in revise=" + driverlicense);

            u = new user();
            u.setEmail(email);
            u.setName(name);
            u.setDob(dob);
            u.setDriverlicense(driverlicense);
            u.setSex(sex);
            session.update("updateuserinfo", u);
            session.commit();
            JOptionPane.showMessageDialog(null, "Updated Successfully!", "Message",
                    JOptionPane.INFORMATION_MESSAGE);
            return SUCCESS;
        }

    } finally {
        session.close();
    }

}

From source file:adl.RecordActivitySpeechlet.java

License:Open Source License

public void writeAction(String intent) {

    SqlSession session = null;
    try {/*from  w  w w.java  2  s  . c  o  m*/
        session = SqlSessionHelper.getSessionFactory().openSession();
        ActionMapper mapper = session.getMapper(ActionMapper.class);

        ActionBean actionBean = new ActionBean();
        actionBean.setName(camelToUtterance(intent));//+
        actionBean.setTime(new Timestamp(System.currentTimeMillis()));
        mapper.addActionBean(actionBean);

        session.commit();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
}

From source file:cern.c2mon.server.history.dao.LoggerDAO.java

License:Open Source License

/**
 * Inserts into the database a set of rows containing the data coming in
 * several IFallback objects//from  w ww.  j ava  2s.  c  o m
 *
 * @param data
 *          List of IFallback object whose data has to be inserted in the DB
 * @throws IDBPersistenceException
 *           An exception is thrown in case an error occurs during the data
 *           insertion. The exception provides also the number of already
 *           committed objects
 */
@SuppressWarnings("unchecked")
// add generics to persistence manager
public final void storeData(final List data) throws IDBPersistenceException {
    SqlSession session = null;
    int size = data.size();
    int commited = 0;
    T tag;

    try {
        // We use batch set of statements to improve performance
        session = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
        if (LOGGER.isDebugEnabled()) {
            LOGGER.debug("Obtained batch transacted SQL session (session: " + session.toString() + ")");
        }
        LoggerMapper<T> persistenceMapper = session.getMapper(mapperInterface);

        // Iterate through the list of DataTagCacheObjects to insert
        // them one by one
        for (int i = 0; i != size; i++) {
            if ((0 == i % RECORDS_PER_BATCH) && i > 0) {
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("storeData([Collection]) : Commiting rows for i=" + i);
                }
                session.commit();
                commited = i;
            }

            if (data.get(i) != null) {
                tag = (T) data.get(i);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Logging object with ID: " + tag.getId());
                }
                persistenceMapper.insertLog(tag);
            }
        }
        // Commit the transaction
        session.commit();
        commited = size;
    } catch (PersistenceException e) {
        LOGGER.error("storeData([Collection]) : Error executing/closing prepared statement for " + data.size()
                + " dataTags", e);
        try {
            if (session != null) {
                session.rollback();
            }
        } catch (Exception sql) {
            LOGGER.error("storeData([Collection]) : Error rolling back transaction.", sql);
        }
        throw new IDBPersistenceException(e.getMessage(), commited);
    } finally {
        try {
            if (session != null) {
                session.close();
            }
        } catch (Exception e) {
            LOGGER.error("storeData([Collection]) : Error closing session.", e);
        }
    }
}

From source file:cern.c2mon.server.history.dao.LoggerDAO.java

License:Open Source License

@Override
public void storeData(IFallback object) throws IDBPersistenceException {
    SqlSession session = null;
    try {/*from   w  w  w. ja  v  a  2  s.  c  om*/
        session = sqlSessionFactory.openSession();
        LoggerMapper<T> loggerMapper = session.getMapper(mapperInterface);
        loggerMapper.insertLog((T) object);
        session.commit();
    } catch (PersistenceException ex1) {
        String message = "Exception caught while persisting an object to the history";
        LOGGER.error(message, ex1);
        if (session != null)
            session.rollback();
        throw new IDBPersistenceException(message, ex1);
    } finally {
        if (session != null)
            session.close();
    }
}

From source file:cl.beans.ContactoBean.java

public String guardar() {
    //Asignar un id por defecto
    contacto.setId(-1);// si es -1 es autoincrementable
    SqlSession session = new MyBatisUtil().getSession();
    if (session != null) {
        try {//from w  w w. j av  a 2  s .  c  o  m
            session.insert("Contacto.guardarContacto", contacto); //el nombre del namespace
            session.commit();
        } finally {
            session.close();
        }
    } else {
        System.out.println("Error");
    }
    FacesContext.getCurrentInstance().addMessage(null,
            new FacesMessage(FacesMessage.SEVERITY_INFO, "Aviso", "Contacto Creado"));
    return "index";
}

From source file:cn.cuizuoli.appranking.service.AppRankingService.java

License:Apache License

/**
 * batchAdd//  w  w  w  .j  a  v  a  2s.  c o m
 * @param appRankingList
 */
@Transactional
public void batchAdd(List<AppRanking> appRankingList) {
    SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH, false);
    AppRankingRepository batchAppRankingRepository = sqlSession.getMapper(AppRankingRepository.class);
    int i = 1;
    for (AppRanking appRanking : appRankingList) {
        appRanking.setId(appRankingIncrementer.nextStringValue());
        appRanking.setDateHour(DateTime.now().toString("yyyyMMddHH"));
        batchAppRankingRepository.insert(appRanking);
        if (i % 100 == 0) {
            sqlSession.commit();
        }
        i++;
    }
    sqlSession.commit();
    sqlSession.close();
}

From source file:com.baomidou.mybatisplus.test.GlobalConfigurationTest.java

License:Apache License

/**
 * ?//ww  w. j a v a 2  s  .  c  o  m
 */
@SuppressWarnings("unchecked")
public static void main(String[] args) {
    GlobalConfiguration global = GlobalConfiguration.defaults();
    global.setAutoSetDbType(true);
    // FieldStrategy.Empty
    global.setFieldStrategy(2);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://127.0.0.1:3306/mybatis-plus?characterEncoding=UTF-8");
    dataSource.setUsername("root");
    dataSource.setPassword("521");
    dataSource.setMaxTotal(1000);
    GlobalConfiguration.setMetaData(dataSource, global);
    // ?
    InputStream inputStream = GlobalConfigurationTest.class.getClassLoader()
            .getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder factoryBuilder = new MybatisSessionFactoryBuilder();
    factoryBuilder.setGlobalConfig(global);
    SqlSessionFactory sessionFactory = factoryBuilder.build(inputStream);
    SqlSession session = sessionFactory.openSession(false);
    TestMapper testMapper = session.getMapper(TestMapper.class);
    /*Wrapper type = Condition.instance().eq("id",1).or().in("type", new Object[]{1, 2, 3, 4, 5, 6});
    List list = testMapper.selectList(type);
    System.out.println(list.toString());*/
    Test test = new Test();
    test.setCreateTime(new Date());
    // ?
    test.setType("");
    testMapper.insert(test);

    SqlSession sqlSession = sessionFactory.openSession(false);
    NotPKMapper pkMapper = sqlSession.getMapper(NotPKMapper.class);
    NotPK notPK = new NotPK();
    notPK.setUuid(UUID.randomUUID().toString());
    int num = pkMapper.insert(notPK);
    Assert.assertTrue(num > 0);
    NotPK notPK1 = pkMapper.selectOne(notPK);
    Assert.assertNotNull(notPK1);
    pkMapper.selectPage(RowBounds.DEFAULT, Condition.create().eq("type", 12121212));
    NotPK notPK2 = null;
    try {
        notPK2 = pkMapper.selectById("1");
    } catch (Exception e) {
        System.out.println(",");
    }
    Assert.assertNull(notPK2);
    int count = pkMapper.selectCount(Condition.EMPTY);
    Assert.assertTrue(count > 0);
    int deleteCount = pkMapper.delete(null);
    Assert.assertTrue(deleteCount > 0);
    session.rollback();
    sqlSession.commit();
}

From source file:com.baomidou.mybatisplus.test.MybatisMapperRefreshTest.java

License:Apache License

/**
 *  Mybatis XML //from w w w  .  j a va2  s. c o m
 */
public static void main(String[] args) throws IOException, InterruptedException {
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    mf.setGlobalConfig(new GlobalConfiguration(new MySqlInjector()));
    Resource[] resource = new ClassPathResource[] { new ClassPathResource("mysql/UserMapper.xml") };
    SqlSessionFactory sessionFactory = mf.build(in);
    new MybatisMapperRefresh(resource, sessionFactory, 0, 5, true);
    boolean isReturn = false;
    SqlSession session = null;
    while (!isReturn) {
        try {
            session = sessionFactory.openSession();
            UserMapper userMapper = session.getMapper(UserMapper.class);
            userMapper.selectListRow(new Pagination(1, 10));
            resource[0].getFile().setLastModified(SystemClock.now());
            session.commit();
            session.close();
            Thread.sleep(5000);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (session != null) {
                session.close();
            }
            Thread.sleep(5000);
        }
    }
    System.exit(0);
}

From source file:com.baomidou.mybatisplus.test.mysql.UserMapperTest.java

License:Apache License

/**
 * RUN //  w  ww  .  ja v a 2  s.  co  m
 * <p>
 * <p>
 * MybatisPlus  SQL ?
 * </p>
 * 1?XMLSQL<br>
 * 2?sqlProviderSQL<br>
 * 3?xmlSql  sqlProvider???SQL<br>
 * <br>
 * ?SQLxmlSql > sqlProvider > crudSql <br>
 */
public static void main(String[] args) {

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

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

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

    /**
     *  SQL 
     */
    GlobalConfiguration gc = new GlobalConfiguration(new MySqlInjector());
    /**
     *  
     */
    gc.setMetaObjectHandler(new MyMetaObjectHandler());
    // gc.setCapitalMode(true);
    gc.setDbColumnUnderline(true);
    mf.setGlobalConfig(gc);

    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    UserMapper userMapper = session.getMapper(UserMapper.class);
    System.err.println(" debug run  user ??? ");
    userMapper.deleteAll();

    /**
     * sjy @TableFieldel
     */
    Role role = new Role();
    role.setId(IdWorker.getId());
    role.setName("admin");

    User userA = new User();
    userA.setId(IdWorker.getId());
    userA.setName("junyu_shi");
    userA.setAge(1);
    userA.setDesc("");
    userA.setTestType(1);
    userA.setRole(role);

    int rlt = userMapper.insert(userA);
    User whereUser = userMapper.selectOne(userA);
    print(whereUser);

    userA.setAge(18);
    userMapper.updateById(userA);
    userMapper.delete(new EntityWrapper<>(userA));
    System.err.println("--------- @TableField el() --------- " + rlt);

    /**
     * ?
     */
    rlt = userMapper.insertInjector(new User(1L, "1", 1, 1));
    System.err.println("--------- insertInjector --------- " + rlt);

    /**
     * ehcache 
     */
    User cacheUser = userMapper.selectOne(new User(1L, 1));
    print(cacheUser);
    cacheUser = userMapper.selectOne(new User(1L, 1));
    print(cacheUser);

    /**
     * ?
     */
    long id = IdWorker.getId();
    rlt = userMapper.insert(new User(id, "abc", 18, 1));
    System.err.println("\n--------------insert-------" + rlt);
    sleep();

    rlt = userMapper.insert(new User(18));
    System.err.println("\n---------- name ?----insert-------" + rlt);
    sleep();

    List<User> ul = new ArrayList<>();

    /*  ID */
    ul.add(new User(11L, "1", 1, 0));
    ul.add(new User(12L, "2", 2, 1));
    ul.add(new User(13L, "3", 3, 1));
    ul.add(new User(14L, "delname", 4, 0));
    ul.add(new User(15L, "5", 5, 1));
    ul.add(new User(16L, "6", 6, 0));

    /*  name test_type  */
    ul.add(new User(17L, 7));
    ul.add(new User(18L, 8));
    ul.add(new User(19L, 9));
    ul.add(new User(7));
    ul.add(new User(20L, "deleteByMap", 7, 0));

    /*  ID_WORKER ? ID */
    ul.add(new User("8", 8, 1));
    ul.add(new User("9", 9, 1));
    for (User u : ul) {
        rlt = userMapper.insert(u);
    }
    System.err.println("\n--------------insertBatch----------------" + rlt + "\n\n");

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

    /*
     * 
     */
    rlt = userMapper.deleteById(id);
    System.err.println("---------deleteById------- delete id=" + id + " ,result=" + rlt + "\n\n");
    sleep();

    Map<String, Object> columnMap = new HashMap<>();
    columnMap.put("name", "deleteByMap");
    columnMap.put("age", null);
    rlt = userMapper.deleteByMap(columnMap);
    System.err.println("---------deleteByMap------- result=" + rlt + "\n\n");
    sleep();

    List<Long> il = new ArrayList<>();
    il.add(16L);
    il.add(17L);
    rlt = userMapper.deleteBatchIds(il);
    System.err.println("---------deleteBatchIds------- delete id=" + id + " ,result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.delete(new EntityWrapper<>(new User(14L, "delname")));
    System.err.println("--------------delete------------------ result=" + rlt + "\n\n");
    sleep();

    /*
     * <p>  </p>
     *
     * updateById  BaseMapper ?UserMapper.xmlsql
     */
    rlt = userMapper.updateById(new User(12L, "MybatisPlus"));
    System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.updateById(new User(12L, "update all column", 12, 12));
    System.err.println("------------------updateById---------------------- result=" + rlt + "\n\n");
    sleep();

    rlt = userMapper.update(new User("55", 55, 5), new EntityWrapper<>(new User(15L, "5")));
    System.err.println("------------------update---------------------- result=" + rlt + "\n\n");
    sleep();

    EntityWrapper<User> ew1 = new EntityWrapper<>();
    ew1.addFilter("test_id={0} AND name={1}", 15L, "55");
    rlt = userMapper.update(new User("00"), ew1);
    System.err.println("------------------update---------------------- result=" + rlt + "\n\n");
    sleep();

    /* ? */
    // userMapper.update(new User("11"), null);

    List<User> userList = new ArrayList<>();
    userList.add(new User(11L, "updateBatchById-1", 1, 1));
    userList.add(new User(12L, "updateBatchById-2", 2, 1));
    userList.add(new User(13L, "updateBatchById-3", 3, 1));
    for (User u : userList) {
        rlt = userMapper.updateById(u);
    }
    System.err.println("------------------updateBatchById---------------------- result=" + rlt + "\n\n");
    sleep();

    /*
     * <p>  </p>
     */
    System.err.println("\n------------------selectById----------------------");
    User user = userMapper.selectById(12L);
    print(user);

    System.err.println("\n------------------selectBatchIds----------------------");
    List<Long> idList = new ArrayList<>();
    idList.add(11L);
    idList.add(12L);
    List<User> ul0 = userMapper.selectBatchIds(idList);
    for (User anUl0 : ul0) {
        print(anUl0);
    }

    System.err.println("\n------------------selectByMap----- map ??----");
    Map<String, Object> cm = new HashMap<>();
    cm.put("test_type", 1);
    cm.put("1", 1);
    List<User> ul1 = userMapper.selectByMap(cm);
    for (User anUl1 : ul1) {
        print(anUl1);
    }

    System.err.println("\n------------------selectOne----------------------");
    User userOne = userMapper.selectOne(new User("abc"));
    print(userOne);

    System.err.println("\n------------------selectCount----------------------");
    System.err.println(
            " type=1 " + userMapper.selectCount(new EntityWrapper<>(new User(1))));
    System.err.println("" + userMapper.selectCount(null));

    System.err.println("\n------------------selectList-----?----id--DESC--?----");
    List<User> ul2 = userMapper.selectList(new EntityWrapper<User>(null, "age,name"));
    for (User anUl2 : ul2) {
        print(anUl2);
    }

    System.err.println(
            "\n------------------list  ---- testType = 1 ?--id--DESC--?--------");
    Page<User> page = new Page<>(1, 2);
    EntityWrapper<User> ew = new EntityWrapper<>(new User(1));

    /*
     * 
     */
    ew.setSqlSelect("age,name");

    /*
     * ?SQL (?SQL?????)
     */
    ew.where("name like {0}", "'%dateBatch%'").and("age={0}", 3).orderBy("age,name", true);
    List<User> paginList = userMapper.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());

    System.err.println(
            "\n---------------xml---selectListRow ?? count ----?--------------");
    // TODO  Page ??
    List<User> rowList = userMapper.selectListRow(new Pagination(0, 2, false));
    for (User aRowList : rowList) {
        print(aRowList);
    }

    /*
     * 
     */
    System.err.println(" selectList EntityWrapper == null \n");
    paginList = userMapper.selectList(null);
    for (User aPaginList : paginList) {
        print(aPaginList);
    }

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

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

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

License:Apache License

/**
 *
 * Test Oracle Sequence//  ww  w . j  a  v a  2s  .c o  m
 *
 */
public static void main(String[] args) {

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

    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();

    /** ? oracle */
    GlobalConfiguration gc = new GlobalConfiguration();
    gc.setDbType("oracle");
    gc.setDbColumnUnderline(true);
    mf.setGlobalConfig(gc);
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    TestSequserMapper testSequserMapper = session.getMapper(TestSequserMapper.class);
    /**
     * ?
     */
    TestSequser one = new TestSequser("abc", 18, 1);
    int rlt = testSequserMapper.insert(one);
    System.err.println("\n one.id-------:" + one.getId());
    sleep();

    /**
     * ??
     */
    List<TestSequser> ul = new ArrayList<>();
    ul.add(new TestSequser("abc2", 18, 2));
    ul.add(new TestSequser("abc3", 18, 3));
    ul.add(new TestSequser("abc4", 18, 4));
    ul.add(new TestSequser("abc5", 18, 5));
    ul.add(new TestSequser("abc6", 18, 6));
    for (TestSequser u : ul) {
        rlt = testSequserMapper.insert(u);
    }
    for (TestSequser u : ul) {
        System.err.println("\n one.id-------:" + u.getId());
    }

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