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

Introduction

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

Prototype

<E> List<E> selectList(String statement);

Source Link

Document

Retrieve a list of mapped objects from the statement key and parameter.

Usage

From source file:mybatis.client.MyJFrame.java

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed

    // 3) factory  SqlSession? 
    SqlSession ss = factory.openSession(true);

    // 4) sql  //from   w  w w .  ja  v a  2s .  co m
    List<MemVO> lists = ss.selectList("mem.total");

    // 5) 
    StringBuffer sb = new StringBuffer("?\t?\t??\t?\t??\n"
            + "--------------------------------------------------------------"
            + "--------------------------------------------------------------");

    System.out.println("lists :" + lists.size());

    viewData(lists);
    ss.close();
}

From source file:net.hasor.db.orm.mybatis3.SqlExecutorTemplate.java

License:Apache License

public <E> List<E> selectList(final String statement) throws SQLException {
    return this.execute(new SqlSessionCallback<List<E>>() {
        public List<E> doSqlSession(SqlSession sqlSession) {
            return sqlSession.selectList(statement);
        }/*from  w  w w  . j  a  v a 2  s. c  om*/
    });
}

From source file:net.nexxus.db.DBManagerImpl.java

License:Open Source License

/**
 * return a List of NntpGroups belonging to an NntpServer
 * @return//  w ww  . j a v a 2  s. c  o m
 * @throws Exception
 */
public List<NntpGroup> getServerGroups() throws Exception {
    SqlSession session = sqlFactory.openSession();
    List resultSet = session.selectList("getGroupList");
    session.close();

    return resultSet;
}

From source file:org.makersoft.shards.unit.session.ShardedSqlSessionTests.java

License:Open Source License

@Test
public void testSelectAllUsers() throws Exception {
    SqlSession session = factory.openSession();
    try {/*from  w w  w .  j  a v a  2 s . co  m*/
        List<User> users = session.selectList("org.makersoft.shards.mapper.UserMapper.findAll");
        Assert.assertEquals(0, users.size());
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisAvailablePhoneNumbersDao.java

License:Open Source License

private List<AvailablePhoneNumber> getAvailablePhoneNumbers(final String selector, final Object parameter) {
    final SqlSession session = sessions.openSession();
    try {/* w  w  w  .j av a 2s. c  o m*/
        List<Map<String, Object>> results = null;
        if (parameter == null) {
            results = session.selectList(selector);
        } else {
            results = session.selectList(selector, parameter);
        }
        final List<AvailablePhoneNumber> availablePhoneNumbers = new ArrayList<AvailablePhoneNumber>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                availablePhoneNumbers.add(toAvailablePhoneNumber(result));
            }
        }
        return availablePhoneNumbers;
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisGatewaysDao.java

License:Open Source License

@Override
public List<Gateway> getGateways() {
    final SqlSession session = sessions.openSession();
    try {// w ww  . jav  a  2  s .  c  o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getGateways");
        final List<Gateway> gateways = new ArrayList<Gateway>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                gateways.add(toGateway(result));
            }
        }
        return gateways;
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisRegistrationsDao.java

License:Open Source License

@Override
public List<Registration> getRegistrations() {
    final SqlSession session = sessions.openSession();
    try {/*  w w  w  .  j  av a 2s. co  m*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getRegistrations");
        final List<Registration> records = new ArrayList<Registration>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                records.add(toPresenceRecord(result));
            }
        }
        return records;
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisStatisticsDao.java

License:Open Source License

@Override
public List<StatisticsTopTenCallers> getTopTenCallers() {
    final SqlSession session = sessions.openSession();
    try {//from   w  ww.j a  v  a 2s.  c om
        final List<Map<String, Object>> results = session.selectList(namespace + "Toptencallers");
        final List<StatisticsTopTenCallers> statistics = new ArrayList<StatisticsTopTenCallers>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                statistics.add(toTopTenCallers(result));

            }
        }

        return statistics;
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisStatisticsDao.java

License:Open Source License

@Override
public List<StatisticsTopTenSMS> getTopTenSMS() {
    final SqlSession session = sessions.openSession();
    try {//from w ww  . j a v  a 2  s .c o m
        final List<Map<String, Object>> results = session.selectList(namespace + "Toptensendersms");
        final List<StatisticsTopTenSMS> statistics = new ArrayList<StatisticsTopTenSMS>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                statistics.add(toTopTenSMS(result));
            }
        }

        return statistics;
    } finally {
        session.close();
    }
}

From source file:org.mobicents.servlet.restcomm.dao.mybatis.MybatisStatisticsDao.java

License:Open Source License

@Override
public List<StatisticsCallsPerDayLast30Days> getCallsPerDayLast30Days() {
    final SqlSession session = sessions.openSession();
    try {/* ww w. java2  s. co  m*/
        final List<Map<String, Object>> results = session
                .selectList(namespace + "Numberofcallsperdaylast30days");
        final List<StatisticsCallsPerDayLast30Days> statistics = new ArrayList<StatisticsCallsPerDayLast30Days>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                statistics.add(toCallsPerDayLast30Days(result));

            }
        }

        return statistics;
    } finally {
        session.close();
    }
}