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

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

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. getMapper

Introduction

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

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

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

License:GNU General Public License

public static RichTextEditorSettings load() {

    RichTextEditorSettings lRichTextEditorSettings;

    mLog.debug("Start load()");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   w w w .j  a v  a2  s. co  m
        lRichTextEditorSettings = new RichTextEditorSettings();
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        // font
        Properties lProperties = lPropertiesMapper.selectByPrimaryKey("font");
        lRichTextEditorSettings.setFont(lProperties.getValue());

        // font size
        lProperties = lPropertiesMapper.selectByPrimaryKey("font-size");
        lRichTextEditorSettings.setSize(lProperties.getValue());

        // font size
        lProperties = lPropertiesMapper.selectByPrimaryKey("spellCheckEnabled");
        lRichTextEditorSettings.setSpellCheckEnabled(Boolean.valueOf(lProperties.getValue()));

    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End load()");

    return lRichTextEditorSettings;
}

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

License:GNU General Public License

public static void save(RichTextEditorSettings pRichTextEditorSettings) {

    mLog.debug("Start save()");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//ww  w . ja  v a 2 s  .co  m
        PropertiesMapper lPropertiesMapper = lSqlSession.getMapper(PropertiesMapper.class);

        // font
        Properties lProperties = new Properties();
        lProperties.setProperty("font");
        lProperties.setValue(pRichTextEditorSettings.getFont());
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        // font size
        lProperties = new Properties();
        lProperties.setProperty("font-size");
        lProperties.setValue(pRichTextEditorSettings.getSize());
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        // spell check enabled
        lProperties = new Properties();
        lProperties.setProperty("spellCheckEnabled");
        lProperties.setValue(String.valueOf(pRichTextEditorSettings.isSpellCheckEnabled()));
        lPropertiesMapper.updateByPrimaryKey(lProperties);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End save()");
}

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

License:GNU General Public License

private static SceneRevisionDTO load(SqlSession pSqlSession, Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start load(Integer)");

    // load scene
    ScenesMapper lScenesMapper = pSqlSession.getMapper(ScenesMapper.class);
    Scenes lScenes = lScenesMapper.selectByPrimaryKey(pIntIdScene.longValue());

    // load scene revision
    SceneRevisionsMapper lSceneRevisionsMapper = pSqlSession.getMapper(SceneRevisionsMapper.class);
    SceneRevisions lSceneRevisionsSelected = lSceneRevisionsMapper.getSelectedByIdScene(pIntIdScene);

    // populate SceneRevisionDTO
    lSceneRevisionDTO = new SceneRevisionDTO();
    lSceneRevisionDTO.setIdScene(pIntIdScene);
    lSceneRevisionDTO.setPosition(lScenes.getPosition());
    lSceneRevisionDTO.setTitle(lScenes.getDescription());
    lSceneRevisionDTO.setTaskStatus(TaskStatus.getTaskStatusFromValue(lScenes.getTaskStatus()));
    lSceneRevisionDTO.setText(lSceneRevisionsSelected.getScene());
    lSceneRevisionDTO.setIdRevision(lSceneRevisionsSelected.getIdSceneRevision().intValue());
    lSceneRevisionDTO.setRevision(lSceneRevisionsSelected.getRevisionNumber());
    lSceneRevisionDTO.setIdLocation(lSceneRevisionsSelected.getIdLocation());
    lSceneRevisionDTO.setPointOfView(lSceneRevisionsSelected.getPointOfView() != null
            ? PointOfView.getPointOfViewFromValue(lSceneRevisionsSelected.getPointOfView())
            : null);/*w w w. j  a v  a2  s .  c om*/
    lSceneRevisionDTO.setIdCharacterPointOfView(lSceneRevisionsSelected.getPointOfViewIdCharacter());
    lSceneRevisionDTO.setSceneDate(lSceneRevisionsSelected.getSceneDate());
    lSceneRevisionDTO.setWordCount(lSceneRevisionsSelected.getWords());
    lSceneRevisionDTO.setCharacterCount(lSceneRevisionsSelected.getCharacters());

    // load revisions
    SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
    lSceneRevisionsExample.createCriteria().andIdSceneEqualTo(pIntIdScene);
    lSceneRevisionsExample.setOrderByClause("revision_number desc");
    List<SceneRevisions> lSceneRevisionsList = lSceneRevisionsMapper.selectByExample(lSceneRevisionsExample);
    List<Integer> lListSceneRevision = new ArrayList<Integer>();
    for (SceneRevisions lSceneRevisions : lSceneRevisionsList) {
        lListSceneRevision.add(lSceneRevisions.getIdSceneRevision().intValue());
    }
    lSceneRevisionDTO.setRevisions(lListSceneRevision);

    // load characters
    List<Integer> lListCharacter = new ArrayList<Integer>();
    SceneRevisionCharactersExample lSceneRevisionCharactersExample = new SceneRevisionCharactersExample();
    lSceneRevisionCharactersExample.createCriteria()
            .andIdSceneRevisionEqualTo(lSceneRevisionsSelected.getIdSceneRevision().intValue());
    SceneRevisionCharactersMapper lSceneRevisionCharactersMapper = pSqlSession
            .getMapper(SceneRevisionCharactersMapper.class);
    List<SceneRevisionCharactersKey> lSceneRevisionCharactersKeyList = lSceneRevisionCharactersMapper
            .selectByExample(lSceneRevisionCharactersExample);
    if (lSceneRevisionCharactersKeyList != null && lSceneRevisionCharactersKeyList.size() > 0) {
        for (SceneRevisionCharactersKey lSceneRevisionCharactersKey : lSceneRevisionCharactersKeyList) {
            lListCharacter.add(lSceneRevisionCharactersKey.getIdCharacter());
        }
    }
    lSceneRevisionDTO.setCharacters(lListCharacter);

    // load strands
    List<Integer> lListStrand = new ArrayList<Integer>();
    SceneRevisionStrandsExample lSceneRevisionStrandsExample = new SceneRevisionStrandsExample();
    lSceneRevisionStrandsExample.createCriteria()
            .andIdSceneRevisionEqualTo(lSceneRevisionsSelected.getIdSceneRevision().intValue());
    SceneRevisionStrandsMapper lSceneRevisionStrandsMapper = pSqlSession
            .getMapper(SceneRevisionStrandsMapper.class);
    List<SceneRevisionStrandsKey> lSceneRevisionStrandsKeyList = lSceneRevisionStrandsMapper
            .selectByExample(lSceneRevisionStrandsExample);
    if (lSceneRevisionStrandsKeyList != null && lSceneRevisionStrandsKeyList.size() > 0) {
        for (SceneRevisionStrandsKey lSceneRevisionStrandsKey : lSceneRevisionStrandsKeyList) {
            lListStrand.add(lSceneRevisionStrandsKey.getIdStrand());
        }
    }
    lSceneRevisionDTO.setStrands(lListStrand);

    mLog.debug("End load(Integer)");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneRevisionDTO createRevisionFromScratch(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start createRevisionFromScratch(" + pIntIdScene, ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from ww  w. ja v  a 2  s .com

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);

        // deselect all revisions
        deselectAllRevisions(lSqlSession, pIntIdScene);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // insert new scene revision
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setIdScene(pIntIdScene);
        lSceneRevisions.setRevisionNumber(lIntMaxRevisionNumber + 1);
        lSceneRevisions.setSelected("Y");
        lSceneRevisions.setWords(0);
        lSceneRevisions.setCharacters(0);
        lSceneRevisionsMapper.insert(lSceneRevisions);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End createRevisionFromScratch(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneRevisionDTO createRevisionFromActual(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start createRevisionFromActual(" + pIntIdScene, ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//w  ww  .j a va 2  s  .  c o m

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);

        // get actual revision
        SceneRevisions lSceneRevisionsActual = lSceneRevisionsMapper.getSelectedByIdScene(pIntIdScene);

        // deselect all revisions
        deselectAllRevisions(lSqlSession, pIntIdScene);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // insert new scene revision
        lSceneRevisionsActual.setIdSceneRevision(null);
        lSceneRevisionsActual.setRevisionNumber(lIntMaxRevisionNumber + 1);
        lSceneRevisionsActual.setSelected("Y");
        lSceneRevisionsMapper.insert(lSceneRevisionsActual);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End createRevisionFromActual(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

private static void deselectAllRevisions(SqlSession pSqlSession, Integer pIntIdScene) {

    mLog.debug("Start deselectAllRevisions(SqlSession, Integer)");

    // deselect all revision scene
    SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
    lSceneRevisionsExample.createCriteria().andIdSceneEqualTo(pIntIdScene);

    SceneRevisions lSceneRevisions = new SceneRevisions();
    lSceneRevisions.setSelected("N");

    SceneRevisionsMapper lSceneRevisionsMapper = pSqlSession.getMapper(SceneRevisionsMapper.class);
    lSceneRevisionsMapper.updateByExampleSelective(lSceneRevisions, lSceneRevisionsExample);

    mLog.debug("End deselectAllRevisions(SqlSession, Integer)");
}

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

License:GNU General Public License

public static SceneRevisionDTO deleteActualRevision(Integer pIntIdScene) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start deleteActualRevision(" + pIntIdScene, ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//  w  ww  . j  a va 2s  . c o  m

        // load scene revision
        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        SceneRevisions lSceneRevisionsSelected = lSceneRevisionsMapper.getSelectedByIdScene(pIntIdScene);

        // get position of revision to delete
        Integer lIntPositionRevisionToDelete = lSceneRevisionsSelected.getRevisionNumber();

        // delete actual revision
        lSceneRevisionsMapper.deleteByPrimaryKey(lSceneRevisionsSelected.getIdSceneRevision());

        // shift down the revision number 
        lSceneRevisionsMapper.shiftDown(lIntPositionRevisionToDelete);

        // get actual max revision number
        Integer lIntMaxRevisionNumber = lSceneRevisionsMapper.selectNextRevisionNumber(pIntIdScene)
                .getRevisionNumber();

        // select revision with max revision number
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setSelected("Y");

        SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
        lSceneRevisionsExample.createCriteria().andIdSceneEqualTo(pIntIdScene)
                .andRevisionNumberEqualTo(lIntMaxRevisionNumber);

        lSceneRevisionsMapper.updateByExampleSelective(lSceneRevisions, lSceneRevisionsExample);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End deleteActualRevision(" + pIntIdScene, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static void delete(Integer pIntIdScene) {

    mLog.debug("Start delete(Integer)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from  w ww  . j a  v a2  s . c  om

        // load scene
        ScenesMapper lScenesMapper = lSqlSession.getMapper(ScenesMapper.class);
        Scenes lScenes = lScenesMapper.selectByPrimaryKey(pIntIdScene.longValue());

        // load all scene revisions
        SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
        lSceneRevisionsExample.createCriteria().andIdSceneEqualTo(lScenes.getIdScene().intValue());
        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        List<SceneRevisions> lListSceneRevisions = lSceneRevisionsMapper
                .selectByExample(lSceneRevisionsExample);

        // delete all scene revision characters and all scene revision strands
        SceneRevisionCharactersMapper lSceneRevisionCharactersMapper = lSqlSession
                .getMapper(SceneRevisionCharactersMapper.class);
        SceneRevisionStrandsMapper lSceneRevisionStrandsMapper = lSqlSession
                .getMapper(SceneRevisionStrandsMapper.class);
        for (SceneRevisions lSceneRevisions : lListSceneRevisions) {
            SceneRevisionCharactersExample lSceneRevisionCharactersExample = new SceneRevisionCharactersExample();
            lSceneRevisionCharactersExample.createCriteria()
                    .andIdSceneRevisionEqualTo(lSceneRevisions.getIdSceneRevision().intValue());
            lSceneRevisionCharactersMapper.deleteByExample(lSceneRevisionCharactersExample);

            SceneRevisionStrandsExample lSceneRevisionStrandsExample = new SceneRevisionStrandsExample();
            lSceneRevisionStrandsExample.createCriteria()
                    .andIdSceneRevisionEqualTo(lSceneRevisions.getIdSceneRevision().intValue());
            lSceneRevisionStrandsMapper.deleteByExample(lSceneRevisionStrandsExample);
        }

        // delete all scene revisions
        lSceneRevisionsMapper.deleteByExample(lSceneRevisionsExample);

        // delete scene
        lScenesMapper.deleteByPrimaryKey(lScenes.getIdScene());

        // shift down scenes
        lScenesMapper.shiftDown(lScenes.getPosition(), Integer.MAX_VALUE, lScenes.getIdChapter());

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End delete(Integer)");

}

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

License:GNU General Public License

public static SceneRevisionDTO changeRevision(Integer pIntIdScene, Integer pIntNewRevision) {

    SceneRevisionDTO lSceneRevisionDTO = null;

    mLog.debug("Start changeRevision(" + pIntIdScene, "," + pIntNewRevision, ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  www. j a v  a2  s .  c o m*/

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);

        // deselect all revisions
        deselectAllRevisions(lSqlSession, pIntIdScene);

        // select new revision
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setIdSceneRevision(pIntNewRevision.longValue());
        lSceneRevisions.setSelected("Y");
        lSceneRevisionsMapper.updateByPrimaryKeySelective(lSceneRevisions);

        // reload scene with new revision
        lSceneRevisionDTO = load(lSqlSession, pIntIdScene);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End changeRevision(" + pIntIdScene, "," + pIntNewRevision, ")");

    return lSceneRevisionDTO;
}

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

License:GNU General Public License

public static SceneDTO insert(SceneDTO pSceneDTO) {

    mLog.debug("Start insert(SceneDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*  w w  w . j  a va  2 s  .co m*/

        // Insert scene
        Scenes lScenes = new Scenes();
        lScenes.setIdChapter(pSceneDTO.getIdChapter());
        lScenes.setDescription(pSceneDTO.getDescription());
        lScenes.setPosition(pSceneDTO.getPosition());

        ScenesMapper lScenesMapper = lSqlSession.getMapper(ScenesMapper.class);
        lScenesMapper.insertSelective(lScenes);

        pSceneDTO.setIdScene(lScenes.getIdScene().intValue());
        pSceneDTO.setTaskStatus(TaskStatus.TODO);

        // insert scene revision
        SceneRevisions lSceneRevisions = new SceneRevisions();
        lSceneRevisions.setIdScene(lScenes.getIdScene().intValue());
        lSceneRevisions.setRevisionNumber(1);
        lSceneRevisions.setSelected("Y");
        lSceneRevisions.setWords(0);
        lSceneRevisions.setCharacters(0);

        SceneRevisionsMapper lSceneRevisionsMapper = lSqlSession.getMapper(SceneRevisionsMapper.class);
        lSceneRevisionsMapper.insert(lSceneRevisions);

        lSqlSession.commit();

    } catch (Throwable t) {
        mLog.error(t);
        lSqlSession.rollback();
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    mLog.debug("End insert(SceneRevisionDTO)");

    return pSceneDTO;
}