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.LocationManager.java

License:GNU General Public License

public static LocationDTO load(Integer pIntIdLocation) {

    LocationDTO lLocationDTO = null;/*from   w  w  w.j ava 2s. co  m*/

    mLog.debug("Start load(Integer)");
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {

        LocationsMapper lLocationsMapper = lSqlSession.getMapper(LocationsMapper.class);
        Locations lLocations = lLocationsMapper.selectByPrimaryKey(pIntIdLocation.longValue());
        lLocationDTO = createLocationDTOFromLocations(lLocations);

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

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

    return lLocationDTO;
}

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

License:GNU General Public License

public static void save(LocationDTO pLocationDTO) {

    mLog.debug("Start update(LocationDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from   w  w  w . j  a va  2  s  .  c o m
        Locations lLocations = new Locations();
        lLocations.setIdLocation(pLocationDTO.getIdLocation().longValue());
        lLocations.setName(pLocationDTO.getName());
        lLocations.setNation(pLocationDTO.getNation());
        lLocations.setState(pLocationDTO.getState());
        lLocations.setCity(pLocationDTO.getCity());
        lLocations.setDescription(pLocationDTO.getDescription());
        if (pLocationDTO.getTaskStatus() != null) {
            lLocations.setTaskStatus(pLocationDTO.getTaskStatus().getValue());
        }

        LocationsMapper lLocationsMapper = lSqlSession.getMapper(LocationsMapper.class);
        lLocationsMapper.updateByPrimaryKeySelective(lLocations);

        lSqlSession.commit();

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

    mLog.debug("End insert(LocationDTO)");
}

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

License:GNU General Public License

private static boolean checkIfReferenced(Integer pIntIdLocation, SqlSession pSqlSession) {

    boolean lBlnResult = false;

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

    SceneRevisionsExample lSceneRevisionsExample = new SceneRevisionsExample();
    lSceneRevisionsExample.createCriteria().andIdLocationEqualTo(pIntIdLocation);
    SceneRevisionsMapper lSceneRevisionsMapper = pSqlSession.getMapper(SceneRevisionsMapper.class);
    List<SceneRevisions> lSceneRevisionList = lSceneRevisionsMapper.selectByExample(lSceneRevisionsExample);

    if (lSceneRevisionList != null && lSceneRevisionList.size() > 0) {
        lBlnResult = true;//from  w w w  .j  a  va 2  s. co  m
    } else {
        lBlnResult = false;
    }

    mLog.debug("End checkIfReferenced(Integer, SqlSession): return " + lBlnResult);

    return lBlnResult;
}

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

License:GNU General Public License

public static ProjectFromSceneChapterDTO loadChapterByIdScene(Integer pIntIdScene) {

    ProjectFromSceneChapterDTO lProjectFromSceneChapterDTO;

    mLog.debug("Start loadChapterByIdScene(" + pIntIdScene + ")");

    //load scene/*from  w w w. ja v  a 2  s .c om*/
    Scenes lScenes;
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ScenesMapper lScenesMapper = lSqlSession.getMapper(ScenesMapper.class);
        lScenes = lScenesMapper.selectByPrimaryKey(pIntIdScene.longValue());
    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }

    lProjectFromSceneChapterDTO = loadChapterByIdChapter(lScenes.getIdChapter());
    mLog.debug("End loadChapterByIdScene(" + pIntIdScene + ")");

    return lProjectFromSceneChapterDTO;
}

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

License:GNU General Public License

private static List<SceneRevisionDTO> loadScenesByIdChapter(Integer pIntIdChapter) {

    List<SceneRevisionDTO> lListSceneRevisionDTO = null;

    mLog.debug("Start loadScenesByIdChapter(" + pIntIdChapter + ")");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from   w w w  .j  a  v a 2  s .c  o m*/
        VSelectedSceneRevisionsMapper lVSelectedSceneRevisionsMapper = lSqlSession
                .getMapper(VSelectedSceneRevisionsMapper.class);
        VSelectedSceneRevisionsExample lVSelectedSceneRevisionsExample = new VSelectedSceneRevisionsExample();
        lVSelectedSceneRevisionsExample.createCriteria().andIdChapterEqualTo(pIntIdChapter.longValue());
        lVSelectedSceneRevisionsExample.setOrderByClause("SCENE_POSITION");

        List<VSelectedSceneRevisions> lListVSelectedSceneRevisions = lVSelectedSceneRevisionsMapper
                .selectByExampleWithBLOBs(lVSelectedSceneRevisionsExample);
        lListSceneRevisionDTO = new ArrayList<SceneRevisionDTO>();
        for (VSelectedSceneRevisions lVSelectedSceneRevisions : lListVSelectedSceneRevisions) {
            SceneRevisionDTO lSceneRevisionDTO = new SceneRevisionDTO();
            lSceneRevisionDTO.setIdScene(lVSelectedSceneRevisions.getIdScene().intValue());
            lSceneRevisionDTO.setTitle(lVSelectedSceneRevisions.getSceneDescription());
            lSceneRevisionDTO.setText(lVSelectedSceneRevisions.getScene());
            lSceneRevisionDTO.setPosition(lVSelectedSceneRevisions.getScenePosition());
            lSceneRevisionDTO.setTaskStatus(
                    TaskStatus.getTaskStatusFromValue(lVSelectedSceneRevisions.getSceneTaskStatus()));
            lSceneRevisionDTO.setIdChapter(lVSelectedSceneRevisions.getIdChapter().intValue());
            lListSceneRevisionDTO.add(lSceneRevisionDTO);
        }

    } catch (Throwable t) {
        mLog.error(t);
        throw new BibiscoException(t, BibiscoException.SQL_EXCEPTION);
    } finally {
        lSqlSession.close();
    }
    mLog.debug("End loadScenesByIdChapter(" + pIntIdChapter + ")");

    return lListSceneRevisionDTO;
}

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

License:GNU General Public License

private static ProjectDTO load() {

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

    Project lProject;/* ww w. j ava  2  s. c  o  m*/
    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProject = lProjectMapper.selectByPrimaryKey(ContextManager.getInstance().getIdProject());

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

    ProjectDTO lProjectDTO = new ProjectDTO();
    lProjectDTO.setIdProject(lProject.getIdProject());
    lProjectDTO.setName(lProject.getName());
    lProjectDTO.setLanguage(lProject.getLanguage());
    lProjectDTO.setBibiscoVersion(lProject.getBibiscoVersion());

    ArchitectureDTO lArchitectureDTO = new ArchitectureDTO();
    lArchitectureDTO.setPremiseTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getPremiseTaskStatus()));
    lArchitectureDTO.setFabulaTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getFabulaTaskStatus()));
    lArchitectureDTO.setSettingTaskStatus(TaskStatus.getTaskStatusFromValue(lProject.getSettingTaskStatus()));
    lArchitectureDTO.setStrandList(StrandManager.loadAll());

    lProjectDTO.setArchitecture(lArchitectureDTO);
    lProjectDTO.setChapterList(ChapterManager.loadAll());
    lProjectDTO.setMainCharacterList(CharacterManager.loadMainCharacters());
    lProjectDTO.setSecondaryCharacterList(CharacterManager.loadSecondaryCharacters());
    lProjectDTO.setLocationList(LocationManager.loadAll());

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

    return lProjectDTO;
}

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

License:GNU General Public License

public static List<ProjectDTO> loadAll() {

    List<ProjectDTO> lListProjectDTO = null;

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

    // delete projects entries on bibisco db
    ProjectManager.deleteProjectsEntriesOnBibiscoDB();

    // import projects
    importProjectsFromProjectsDirectory();

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w ww. j av a2 s .co m
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        ProjectsExample lProjectsExample = new ProjectsExample();
        lProjectsExample.setOrderByClause("UPPER(name) asc");
        List<Projects> lListProjects = lProjectsMapper.selectByExample(lProjectsExample);

        if (lListProjects != null && lListProjects.size() > 0) {
            lListProjectDTO = new ArrayList<ProjectDTO>();
            for (Projects lProjects : lListProjects) {

                if (projectExists(lProjects.getIdProject())) {
                    ProjectDTO lProjectDTO = new ProjectDTO();
                    lProjectDTO.setIdProject(lProjects.getIdProject());
                    lProjectDTO.setName(lProjects.getName());
                    lListProjectDTO.add(lProjectDTO);
                } else {
                    lProjectsMapper.deleteByPrimaryKey(lProjects.getIdProject());
                }
            }
        }

        lSqlSession.commit();

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

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

    return lListProjectDTO;
}

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

License:GNU General Public License

private static void insertIntoProjectDB(ProjectDTO pProjectDTO) {

    mLog.debug("Start insertIntoProjectDB(ProjectDTO)");

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

        // insert project
        ProjectWithBLOBs lProjectWithBLOBs = new ProjectWithBLOBs();
        lProjectWithBLOBs.setIdProject(pProjectDTO.getIdProject());
        lProjectWithBLOBs.setName(pProjectDTO.getName());
        lProjectWithBLOBs.setLanguage(pProjectDTO.getLanguage());
        lProjectWithBLOBs.setBibiscoVersion(pProjectDTO.getBibiscoVersion());

        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        lProjectMapper.insertSelective(lProjectWithBLOBs);

        lSqlSession.commit();

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

    mLog.debug("End insertIntoBibiscoDB(ProjectDTO)");
}

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

License:GNU General Public License

public static void delete(String pStrIdProject) {

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

    // validate preconditions
    Validate.notEmpty(pStrIdProject, "Id project cannot be empty");
    Validate.isTrue(ProjectManager.projectExists(pStrIdProject), "Project references non existent directory");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w w  w  .jav a  2s  . c om

        // delete entry on bibisco db
        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectsMapper.deleteByPrimaryKey(pStrIdProject);

        // delete file
        FileUtils.deleteDirectory(new File(getDBProjectDirectory(pStrIdProject)));

        lSqlSession.commit();

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

    mLog.debug("End delete(String)");
}

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

License:GNU General Public License

private static void insertIntoBibiscoDB(ProjectDTO pProjectDTO) {

    mLog.debug("Start insertIntoBibiscoDB(ProjectDTO)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryBibisco();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {//from w w w  .  j a  v a  2  s.co  m
        Projects lProjects = new Projects();
        lProjects.setIdProject(pProjectDTO.getIdProject());
        lProjects.setName(pProjectDTO.getName());

        ProjectsMapper lProjectsMapper = lSqlSession.getMapper(ProjectsMapper.class);
        lProjectsMapper.insertSelective(lProjects);

        lSqlSession.commit();

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

    mLog.debug("End insertIntoBibiscoDB(ProjectDTO)");
}