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, Object parameter);

Source Link

Document

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

Usage

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

License:Open Source License

/**
 * return a List of NntpGroups we are subscribed to
 *///from  www  . j a v  a2  s.co m
public List<NntpGroup> getGroups() throws Exception {
    SqlSession session = sqlFactory.openSession();
    List resultSet = session.selectList("getGroups", this.groupsTable);
    session.close();

    return resultSet;
}

From source file:org.apache.camel.component.mybatis.DefaultMyBatisProcessingStrategy.java

License:Apache License

public List<?> poll(MyBatisConsumer consumer, MyBatisEndpoint endpoint) throws Exception {
    SqlSession session = endpoint.getSqlSessionFactory().openSession();
    try {/*from  w w w .  j  ava2 s .  c  o  m*/
        List<Object> objects = session.selectList(endpoint.getStatement(), null);
        session.commit();
        return objects;
    } catch (Exception e) {
        session.rollback();
        throw e;
    } finally {
        session.close();
    }
}

From source file:org.apache.camel.component.mybatis.MyBatisProducer.java

License:Apache License

private void doSelectList(Exchange exchange, SqlSession session) throws Exception {
    Object result;/*  w ww . j  av a 2s  .  c o  m*/
    Object in = exchange.getIn().getBody();
    if (in != null) {
        LOG.trace("SelectList: {} using statement: {}", in, statement);
        result = session.selectList(statement, in);
    } else {
        LOG.trace("SelectList using statement: {}", statement);
        result = session.selectList(statement);
    }

    doProcessResult(exchange, result);
}

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

License:Open Source License

@Override
public List<Account> getAccounts(final Sid accountSid) {
    final SqlSession session = sessions.openSession();
    try {//from  www  .j  a  va  2 s  .  c o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getAccounts",
                accountSid.toString());
        final List<Account> accounts = new ArrayList<Account>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                accounts.add(toAccount(result));
            }
        }
        return accounts;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<Application> getApplications(final Sid accountSid) {
    final SqlSession session = sessions.openSession();
    try {//from  w  w  w.java  2s  .c  o  m
        final List<Map<String, Object>> results = session.selectList(namespace + "getApplications",
                accountSid.toString());
        final List<Application> applications = new ArrayList<Application>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                applications.add(toApplication(result));
            }
        }
        return applications;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<CallDetailRecord> getCallDetailRecords(CallDetailRecordFilter filter) {

    final SqlSession session = sessions.openSession();

    try {//from  ww w .  java  2s. c o m
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getCallDetailRecordByUsingFilters", filter);
        final List<CallDetailRecord> cdrs = new ArrayList<CallDetailRecord>();

        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                cdrs.add(toCallDetailRecord(result));
            }
        }
        return cdrs;
    } finally {
        session.close();
    }
}

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

License:Open Source License

private List<CallDetailRecord> getCallDetailRecords(final String selector, Object input) {
    final SqlSession session = sessions.openSession();
    try {/*from www  .  java2s  .  co m*/
        final List<Map<String, Object>> results = session.selectList(selector, input);
        final List<CallDetailRecord> cdrs = new ArrayList<CallDetailRecord>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                cdrs.add(toCallDetailRecord(result));
            }
        }
        return cdrs;
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public List<Client> getClients(final Sid accountSid) {
    final SqlSession session = sessions.openSession();
    try {/*from w  ww. j  a v a 2s  . co m*/
        final List<Map<String, Object>> results = session.selectList(namespace + "getClients",
                accountSid.toString());
        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.mobicents.servlet.restcomm.dao.mybatis.MybatisConferenceDetailRecordsDao.java

License:Open Source License

@Override
public List<ConferenceDetailRecord> getConferenceDetailRecords(ConferenceDetailRecordFilter filter) {

    final SqlSession session = sessions.openSession();

    try {//from ww w  . jav a2s .c om
        final List<Map<String, Object>> results = session
                .selectList(namespace + "getConferenceDetailRecordByUsingFilters", filter);
        final List<ConferenceDetailRecord> cdrs = new ArrayList<ConferenceDetailRecord>();

        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                cdrs.add(toConferenceDetailRecord(result));
            }
        }
        return cdrs;
    } finally {
        session.close();
    }
}

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

License:Open Source License

private List<ConferenceDetailRecord> getConferenceDetailRecords(final String selector, Object input) {
    final SqlSession session = sessions.openSession();
    try {//  ww  w.j a v a  2  s .com
        final List<Map<String, Object>> results = session.selectList(selector, input);
        final List<ConferenceDetailRecord> cdrs = new ArrayList<ConferenceDetailRecord>();
        if (results != null && !results.isEmpty()) {
            for (final Map<String, Object> result : results) {
                cdrs.add(toConferenceDetailRecord(result));
            }
        }
        return cdrs;
    } finally {
        session.close();
    }
}