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.DAO.VehicleDAOImpl.java

@Override
public Integer registerVehicle(Vehicle vehicle) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w ww  .ja  v  a 2s  . c o m
        Integer vehicleID = session.insert("Vehicle.insert", vehicle);
        log.info("Vehicle registration ID is : " + vehicle.getVehicleId());
        session.commit();
        if (vehicleID > 0)
            return vehicle.getVehicleId();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        session.close();
    }
    return Integer.MIN_VALUE;
}

From source file:com.eincs.athens.olympus.service.CheckService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final String accessTokenString = request.getHeaders().get(HeaderNames.ACCESS_TOKEN);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();

    try {/*  w  w  w.j  a  va 2s .com*/
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final JSONToken accessToken = tokenFactory.fromBytes(accessTokenString.getBytes());

        if (!Tokens.verifyToken(accessToken)) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = accessToken.getContent().getString(TokenNames.EMAIL);
        String sessionUuid = accessToken.getContent().getString(TokenNames.SESSION_UUID);

        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        Session userSession = mapper.getSessionByUUID(Session.create(sessionUuid));
        if (userSession == null) {
            String responseString = DataUtils.toResponseString(false);
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }
        session.commit();

        String responseString = DataUtils.toResponseString(true);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.ConfirmService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {

    final String tokenString = request.getParams().getParam("token", String.class);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();
    try {/*from  w  ww . jav  a2  s  .  com*/
        if (tokenString == null) {
            String responseString = DataUtils.toResponseStringError("invalid access");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        JSONToken registrationToken = tokenFactory.fromBytes(tokenString.getBytes());
        if (!Tokens.verifyToken(registrationToken)) {
            String responseString = DataUtils.toResponseStringError("invalid token");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = registrationToken.getContent().getString(TokenNames.EMAIL);
        String nickname = registrationToken.getContent().getString(TokenNames.NICKNAME);
        String sessionUuid = registrationToken.getContent().getString(TokenNames.SESSION_UUID);
        String sessionTag = registrationToken.getContent().getString(TokenNames.SESSION_TAG);

        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            mapper.insertUser(User.create(email, nickname));
            user = mapper.getUserByEmail(User.createByEmail(email));
        }
        mapper.insertSession(Session.create(user.getId(), sessionUuid, sessionTag));
        session.commit();

        String responseString = DataUtils.toResponseString(true);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
        return;

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.PostDeleteService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final Integer postId = request.getParams().getParam("id", Integer.class);
    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();

    try {// w w  w.  ja  v a  2 s .  c  o m
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final int result = mapper.deletePost(Post.create(postId));
        session.commit();

        final String responseString = DataUtils.toResponseString(result > 0);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eincs.athens.olympus.service.PostWriteService.java

License:Apache License

@Override
public void doServe(PanteonRequest request, PanteonResponse response) throws Exception {
    final String content = request.getParams().getParam("content", String.class);
    final String accessTokenString = request.getHeaders().get(HeaderNames.ACCESS_TOKEN);

    final DBManager dbm = DBManager.getInstance();
    final SqlSession session = dbm.openSession();
    final JSONTokenFactory tokenFactory = new JSONTokenFactory();

    try {/*w  ww .  jav a2 s. c o  m*/
        final OlympusMapper mapper = session.getMapper(OlympusMapper.class);
        final JSONToken accessToken = tokenFactory.fromBytes(accessTokenString.getBytes());

        if (!Tokens.verifyToken(accessToken)) {
            String responseString = DataUtils.toResponseStringError("permission denied. invalid token.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        String email = accessToken.getContent().getString(TokenNames.EMAIL);
        String sessionUuid = accessToken.getContent().getString(TokenNames.SESSION_UUID);

        User user = mapper.getUserByEmail(User.createByEmail(email));
        if (user == null) {
            String responseString = DataUtils.toResponseStringError("permission denied. no such user.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }
        Session userSession = mapper.getSessionByUUID(Session.create(sessionUuid));
        if (userSession == null) {
            String responseString = DataUtils.toResponseStringError("permission denied. no such session.");
            response.setContentType(PanteonContentType.TEXT_PLAIN);
            response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));
            return;
        }

        final int result = mapper.insertPost(Post.create(user.getId(), content));
        session.commit();

        final String responseString = DataUtils.toResponseString(result > 0);
        response.setContentType(PanteonContentType.TEXT_PLAIN);
        response.setContents(ChannelBuffers.copiedBuffer(responseString, CharsetUtil.UTF_8));

    } finally {
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisContainerDao.java

License:Open Source License

@Override
public void save(Container container) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from   w  w w.j  a v  a 2  s.com
        DateTime current = DateTime.now(DateTimeZone.UTC);
        container.setModifiedDate(current);
        for (CssClass cssClass : container.getCssClassList()) {
            cssClassDao.save(cssClass);
        }
        if (container.getId() > 0) {
            containerMapper.update(container);
        } else {
            container.setCreatedDate(current);
            containerMapper.insert(container);
        }
        for (CssClass cssClass : container.getCssClassList()) {
            cssClassDao.saveContainerRel(cssClass, container);
        }

    } catch (Exception ex) {
        logger.error("Error saving container", ex);
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisContainerDao.java

License:Open Source License

@Override
public void delete(Container container) {
    SqlSession session = sqlSessionFactory.openSession();
    try {/*from  w w  w  .  j  av a2  s.c  om*/
        containerMapper.delete(container.getId());
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisCssClassDao.java

License:Open Source License

public void save(CssClass cssClass) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from  www .  j a  v a  2s. c  om
        DateTime current = DateTime.now(DateTimeZone.UTC);
        cssClass.setModifiedDate(current);
        if (cssClass.getId() > 0) {
            cssClassMapper.update(cssClass);
        } else {
            cssClass.setCreatedDate(current);
            cssClassMapper.insert(cssClass);
        }
    } catch (Exception ex) {
        logger.error("Error saving css class", ex);
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisCssClassDao.java

License:Open Source License

public void saveContainerRel(CssClass cssClass, Container container) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//from ww w. ja v a  2  s.co m
        cssClassMapper.insertContainerClasses(container.getId(), cssClass.getId());
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.eldar.daos.mybatis.MyBatisCssClassDao.java

License:Open Source License

public void delete(CssClass cssClass) {
    SqlSession session = sqlSessionFactory.openSession();
    try {//  ww  w  .j  a  v a  2 s .c  om
        cssClassMapper.delete(cssClass.getId());
    } finally {
        session.commit();
        session.close();
    }
}