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:org.mobicents.servlet.restcomm.dao.mybatis.MybatisStatisticsDao.java

License:Open Source License

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

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

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

License:Open Source License

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

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

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

License:Open Source License

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

            }
        }

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

From source file:org.restcomm.connect.dao.mybatis.MybatisClientsDao.java

License:Open Source License

@Override
public List<Client> getAllClients() {
    final SqlSession session = sessions.openSession();
    try {/* www .ja  va  2s .co  m*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getAllClients");
        final List<Client> clients = new ArrayList<Client>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                clients.add(toClient(result));
            }
        }
        return clients;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisExtensionsConfigurationDao.java

License:Open Source License

@Override
public List<ExtensionConfiguration> getAllConfiguration() {
    final SqlSession session = sessions.openSession();
    ExtensionConfiguration extensionConfiguration = null;
    try {//from w  w  w  . java2s.co  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getAllConfiguration");
        final List<ExtensionConfiguration> confs = new ArrayList<ExtensionConfiguration>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                confs.add(toExtensionConfiguration(result));
            }
        }
        return confs;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisIncomingPhoneNumbersDao.java

License:Open Source License

@Override
public List<IncomingPhoneNumber> getAllIncomingPhoneNumbers() {
    final SqlSession session = sessions.openSession();
    try {/*ww w .  j  a v a2s . c  o m*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getAllIncomingPhoneNumbers");
        final List<IncomingPhoneNumber> incomingPhoneNumbers = new ArrayList<IncomingPhoneNumber>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                incomingPhoneNumbers.add(toIncomingPhoneNumber(result));
            }
        }
        return incomingPhoneNumbers;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisIncomingPhoneNumbersDao.java

License:Open Source License

@Override
public List<IncomingPhoneNumber> getIncomingPhoneNumbersRegex() {
    final SqlSession session = sessions.openSession();
    try {//from  w  w w . j a  va2  s. co m
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getIncomingPhoneNumbersRegex");
        final List<IncomingPhoneNumber> incomingPhoneNumbers = new ArrayList<IncomingPhoneNumber>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                incomingPhoneNumbers.add(toIncomingPhoneNumber(result));
            }
        }
        return incomingPhoneNumbers;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisMediaResourceBrokerDao.java

License:Open Source License

@Override
public List<MediaResourceBrokerEntity> getMediaResourceBrokerEntities() {
    final SqlSession session = sessions.openSession();
    try {// w  w  w .  j a  v  a2 s  .  co m
        final List<Map<String, Object>> results = session.selectList(namespace + "getMediaServers");
        final List<MediaResourceBrokerEntity> mList = new ArrayList<MediaResourceBrokerEntity>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                mList.add(toMRBEntity(result));
            }
        }
        return mList;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisMediaServerDao.java

License:Open Source License

@Override
public List<MediaServerEntity> getMediaServers() {
    final SqlSession session = sessions.openSession();
    try {/*from  ww  w. j a v  a 2s  .c om*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getMediaServers");
        final List<MediaServerEntity> msList = new ArrayList<MediaServerEntity>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                msList.add(toMediaServer(result));
            }
        }
        return msList;
    } finally {
        session.close();
    }
}

From source file:org.restcomm.connect.dao.mybatis.MybatisOrganizationDao.java

License:Open Source License

@Override
public List<Organization> getAllOrganizations() {
    final SqlSession session = sessions.openSession();
    try {/*from  w ww  .j  av  a2s  .co m*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getAllOrganizations");
        final List<Organization> organization = new ArrayList<Organization>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                organization.add(toOrganization(result));
            }
        }
        return organization;
    } finally {
        session.close();
    }
}