Example usage for org.apache.ibatis.session SqlSession 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.baomidou.mybatisplus.test.mysql.TransactionalTest.java

License:Apache License

/**
 * <p>//from  w  w w  . j a  v a 2s . c  om
 * 
 * </p>
 */
public static void main(String[] args) {
    /*
    * ?
    */
    InputStream in = TransactionalTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession sqlSession = sessionFactory.openSession();
    /**
     * ?
     */
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    int rlt = userMapper.insert(new User(IdWorker.getId(), "1", 1, 1));
    System.err.println("--------- insertInjector --------- " + rlt);

    //session.commit();
    sqlSession.rollback();
    sqlSession.close();
}

---

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

License:Apache License

public static void main(String[] args) {
    // ?//w w  w.  j  a v a 2s  . com
    InputStream in = UserMapperTest.class.getClassLoader().getResourceAsStream("mysql-config.xml");
    MybatisSessionFactoryBuilder mf = new MybatisSessionFactoryBuilder();
    mf.setGlobalConfig(new GlobalConfiguration(new MySqlInjector()));
    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();

    UserMapper userMapper = session.getMapper(UserMapper.class);
    RoleMapper roleMapper = session.getMapper(RoleMapper.class);

    /**
     * sjy @TableFieldel, ?resultMap
     */
    Role role = new Role();
    role.setId(IdWorker.getId());
    role.setName("admin");
    int rlt = roleMapper.insert(role);
    System.err.println("--------- insert role --------- " + rlt);

    PhoneNumber phone = new PhoneNumber("81", "0576", "82453832");

    User userA = new User();
    userA.setId(IdWorker.getId());
    userA.setName("junyu_shi");
    userA.setAge(15);
    userA.setTestType(1);
    userA.setRole(role);
    userA.setPhone(phone);
    rlt = userMapper.insert(userA);
    System.err.println("--------- insert user --------- " + rlt);

    User whereUser = userMapper.selectOne(userA);
    System.err.println("--------- select user --------- " + whereUser.toString());

    // ?el?, User??roleIdUser,
    // Role?resultmap?. ?, ?user.setRoleId(), ?updateUser.
    role = new Role();
    role.setId(IdWorker.getId());
    role.setName("root");
    roleMapper.insert(role);
    userA.setRole(role);
    userMapper.updateById(userA);
    System.err.println("--------- upadte user's role --------- " + rlt);

    whereUser = userMapper.selectOne(userA);
    System.err.println("--------- select user --------- " + whereUser.toString());

    userMapper.delete(new EntityWrapper<>(userA));
    System.err.println("--------- delete user --------- " + rlt);

}

---

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

License:Apache License

/**
 * RUN // w w  w  .  ja  v a 2s  .  c om
 * <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/*w w w. j a  v a  2  s  .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();
}

---

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

License:Apache License

/**
 *
 * RUN   MySql  /*from www  .  j  a  va2 s .  c  o  m*/
 *
 */
public static void main(String[] args) {

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

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

    /** ? oracle */
    GlobalConfiguration gc = new GlobalConfiguration();
    gc.setDbType("oracle");
    mf.setGlobalConfig(gc);

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

    SqlSessionFactory sessionFactory = mf.build(in);
    SqlSession session = sessionFactory.openSession();
    TestUserMapper testUserMapper = session.getMapper(TestUserMapper.class);
    System.err.println(" debug run  test_user ??? ");
    session.delete("deleteAll");

    /**
     * ?
     */
    int rlt = testUserMapper.insert(new TestUser("10", "abc", 18, 1));
    System.err.println("\n--------------insert-------" + rlt);
    sleep();

    /**
     * ??
     */
    List<TestUser> ul = new ArrayList<>();
    ul.add(new TestUser("11", "1a", 11, 1));
    ul.add(new TestUser("12", "2a", 12, 2));
    ul.add(new TestUser("a", 1, 1));
    ul.add(new TestUser("b", 2, 2));
    ul.add(new TestUser("c", 3, 1));
    for (TestUser u : ul) {
        rlt = testUserMapper.insert(u);
    }
    System.err.println("\n--------------insertBatch-------" + rlt);
    sleep();

    /**
     * ?
     */
    List<TestUser> ul1 = new ArrayList<>();
    ul1.add(new TestUser("10", "update-0a", 11, 1));
    ul1.add(new TestUser("11", "update-1a", 11, 1));
    ul1.add(new TestUser("12", "update-2a", 12, 2));
    for (TestUser u : ul1) {
        rlt = testUserMapper.updateById(u);
    }
    System.err.println("\n--------------updateBatchById-------" + rlt);
    sleep();

    System.err.println(
            "\n------------------list  ---- testType = 1 ?--id--DESC--?--------");
    Page<TestUser> page = new Page<>(1, 2);
    EntityWrapper<TestUser> ew = new EntityWrapper<>(new TestUser(1), "TEST_ID DESC");
    List<TestUser> paginList = testUserMapper.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());

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

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

---

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

License:GNU General Public License

public static ArchitectureItem load(ArchitectureItemType pArchitectureItemType) {

    ArchitectureItem lArchitectureItem = null;

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/* www  . j a  v  a 2 s . com*/
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        ProjectWithBLOBs lProjectWithBLOBs = lProjectMapper
                .selectByPrimaryKey(ContextManager.getInstance().getIdProject());

        if (lProjectWithBLOBs != null) {

            switch (pArchitectureItemType) {
            case FABULA:
                lArchitectureItem = new ArchitectureItem();
                lArchitectureItem.setTaskStatus(
                        TaskStatus.getTaskStatusFromValue(lProjectWithBLOBs.getFabulaTaskStatus()));
                lArchitectureItem.setText(lProjectWithBLOBs.getFabula());
                break;

            case PREMISE:
                lArchitectureItem = new ArchitectureItem();
                lArchitectureItem.setTaskStatus(
                        TaskStatus.getTaskStatusFromValue(lProjectWithBLOBs.getPremiseTaskStatus()));
                lArchitectureItem.setText(lProjectWithBLOBs.getPremise());
                break;

            case SETTING:
                lArchitectureItem = new ArchitectureItem();
                lArchitectureItem.setTaskStatus(
                        TaskStatus.getTaskStatusFromValue(lProjectWithBLOBs.getSettingTaskStatus()));
                lArchitectureItem.setText(lProjectWithBLOBs.getSetting());
                break;
            default:
                break;
            }
        }

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

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

    return lArchitectureItem;
}

---

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

License:GNU General Public License

public static void save(ArchitectureItem pArchitectureItem, ArchitectureItemType pArchitectureItemType) {

    mLog.debug("Start save(ArchitectureItem, ArchitectureItemType)");

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  www. j a v  a 2s .c  om*/
        ProjectMapper lProjectMapper = lSqlSession.getMapper(ProjectMapper.class);
        ProjectWithBLOBs lProjectWithBLOBs = lProjectMapper
                .selectByPrimaryKey(ContextManager.getInstance().getIdProject());

        switch (pArchitectureItemType) {
        case FABULA:
            lProjectWithBLOBs.setFabulaTaskStatus(pArchitectureItem.getTaskStatus().getValue());
            lProjectWithBLOBs.setFabula(pArchitectureItem.getText());
            break;

        case PREMISE:
            lProjectWithBLOBs.setPremiseTaskStatus(pArchitectureItem.getTaskStatus().getValue());
            lProjectWithBLOBs.setPremise(pArchitectureItem.getText());
            break;

        case SETTING:
            lProjectWithBLOBs.setSettingTaskStatus(pArchitectureItem.getTaskStatus().getValue());
            lProjectWithBLOBs.setSetting(pArchitectureItem.getText());
            break;
        default:
            break;
        }

        lProjectMapper.updateByPrimaryKeyWithBLOBs(lProjectWithBLOBs);
        lSqlSession.commit();

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

    mLog.debug("End save(ArchitectureItem, ArchitectureItemType)");

}

---

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

License:GNU General Public License

public static ChapterDTO insert(ChapterDTO pChapterDTO) {

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {/*from  w ww  .j  av  a2s .  co m*/
        ChaptersWithBLOBs lChapters = new ChaptersWithBLOBs();
        lChapters.setTitle(pChapterDTO.getTitle());
        lChapters.setPosition(pChapterDTO.getPosition());
        lChapters.setReasonTaskStatus(TaskStatus.TODO.getValue());

        ChaptersMapper lChaptersMapper = lSqlSession.getMapper(ChaptersMapper.class);
        lChaptersMapper.insert(lChapters);

        pChapterDTO.setIdChapter(lChapters.getIdChapter().intValue());
        pChapterDTO.setTaskStatus(TaskStatus.TODO);

        lSqlSession.commit();

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

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

    return pChapterDTO;
}

---

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

License:GNU General Public License

public static ChapterDTO load(Integer pIntIdChapter) {

    ChapterDTO lChapterDTO;/*from   ww w .ja  v  a  2  s. c  o m*/

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

    SqlSessionFactory lSqlSessionFactory = SqlSessionFactoryManager.getInstance().getSqlSessionFactoryProject();
    SqlSession lSqlSession = lSqlSessionFactory.openSession();
    try {

        VChaptersMapper lChaptersMapper = lSqlSession.getMapper(VChaptersMapper.class);
        VChaptersExample lVChaptersExample = new VChaptersExample();
        lVChaptersExample.createCriteria().andIdChapterEqualTo(pIntIdChapter.longValue());
        VChaptersWithBLOBs lChaptersWithBLOBs = lChaptersMapper.selectByExampleWithBLOBs(lVChaptersExample)
                .get(0);

        lChapterDTO = new ChapterDTO();
        lChapterDTO.setIdChapter(lChaptersWithBLOBs.getIdChapter().intValue());
        lChapterDTO.setPosition(lChaptersWithBLOBs.getPosition());
        lChapterDTO.setTitle(lChaptersWithBLOBs.getTitle());
        lChapterDTO.setReason(lChaptersWithBLOBs.getReason());
        lChapterDTO.setReasonTaskStatus(
                TaskStatus.getTaskStatusFromValue(lChaptersWithBLOBs.getReasonTaskStatus()));
        lChapterDTO.setNote(lChaptersWithBLOBs.getNote());
        lChapterDTO.setWordCount(lChaptersWithBLOBs.getWords());
        lChapterDTO.setCharacterCount(lChaptersWithBLOBs.getCharacters());
        lChapterDTO.setSceneList(loadScenes(lSqlSession, pIntIdChapter));
        lChapterDTO.setTaskStatus(calculateChapterTaskStatus(lChaptersWithBLOBs));

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

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

    return lChapterDTO;
}

---

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

License:GNU General Public License

private static List<SceneDTO> loadScenes(SqlSession pSqlSession, Integer pIntIdChapter) {

    List<SceneDTO> lListSceneRevision = null;

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

    VScenesMapper lVScenesMapper = pSqlSession.getMapper(VScenesMapper.class);
    VScenesExample lVScenesExample = new VScenesExample();
    lVScenesExample.createCriteria().andIdChapterEqualTo(pIntIdChapter);
    lVScenesExample.setOrderByClause("position");
    List<VScenes> lListVScenes = lVScenesMapper.selectByExample(lVScenesExample);

    if (lListVScenes != null && lListVScenes.size() > 0) {
        lListSceneRevision = new ArrayList<SceneDTO>();
        for (VScenes lVScenes : lListVScenes) {

            SceneDTO lSceneDTO = new SceneDTO();
            lSceneDTO.setIdScene(lVScenes.getIdScene().intValue());
            lSceneDTO.setIdChapter(lVScenes.getIdChapter());
            lSceneDTO.setPosition(lVScenes.getPosition());
            lSceneDTO.setDescription(lVScenes.getDescription());
            lSceneDTO.setTaskStatus(TaskStatus.getTaskStatusFromValue(lVScenes.getTaskStatus()));
            lSceneDTO.setWordCount(lVScenes.getWords());
            lSceneDTO.setCharacterCount(lVScenes.getCharacters());
            lListSceneRevision.add(lSceneDTO);
        }/*www .j  a  v a2s .c o  m*/
    }

    mLog.debug("End loadScenes(SqlSession, Integer)");

    return lListSceneRevision;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »