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

Introduction

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

Prototype

<T> T selectOne(String statement, Object parameter);

Source Link

Document

Retrieve a single row mapped from the statement key and parameter.

Usage

From source file:mybatis.client.MyJFrame.java

public MemVO searchid(String s_id) {

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

    // 4) sql          
    MemVO list = ss.selectOne("mem.searchId", s_id);

    return list;//from   w ww.j  a v  a2s . c  o  m

}

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

License:Apache License

public <T> T selectOne(final String statement, final Object parameter) throws SQLException {
    return this.execute(new SqlSessionCallback<T>() {
        public T doSqlSession(SqlSession sqlSession) {
            return sqlSession.selectOne(statement, parameter);
        }/*from w  ww.j  ava2 s . c o m*/
    });
}

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

License:Open Source License

/**
 * retrieve a header from the DB//from   w w w. j  av a  2s  . co  m
 */
public NntpArticleHeader getHeader(NntpGroup group, NntpArticleHeader header) throws Exception {
    try {
        String table = DBUtils.convertGroup(group.getName());
        HashMap map = new HashMap();
        map.put("table", table);
        map.put("id", header.getID());
        SqlSession session = sqlFactory.openSession();
        header = session.selectOne("getHeader", map);
        session.close();
    } catch (Exception e) {
        log.error("failed retrieving header from DB: " + e.getMessage());
        e.printStackTrace();
        throw e;
    }

    return header;
}

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

License:Open Source License

/** 
 * update the given NntpGroup to have its min and max article id's
 * set/*w w  w.  j a v  a 2  s.c o  m*/
 */
public NntpGroup getGroupMinMax(NntpGroup group) throws Exception {
    SqlSession session = sqlFactory.openSession();
    HashMap<Long, Long> map = session.selectOne("getMinMax", DBUtils.convertGroup(group.getName()));
    if (map == null || map.isEmpty()) {
        group.setLowID(0L);
        group.setHighID(0L);
    } else {
        Long min = map.get("min");
        Long max = map.get("max");
        group.setLowID(min.longValue());
        group.setHighID(max.longValue());
    }

    return group;
}

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

License:Open Source License

public NntpServer getServer() throws Exception {
    SqlSession session = sqlFactory.openSession();
    NntpServer server = (NntpServer) session.selectOne("getServer", this.serverTable);
    session.close();/*from   www.j av  a 2  s . c  om*/

    return server;
}

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

License:Apache License

private void doSelectOne(Exchange exchange, SqlSession session) throws Exception {
    Object result;//from   w ww.ja  va 2  s. c  o m
    Object in = exchange.getIn().getBody();
    if (in != null) {
        LOG.trace("SelectOne: {} using statement: {}", in, statement);
        result = session.selectOne(statement, in);
    } else {
        LOG.trace("SelectOne using statement: {}", statement);
        result = session.selectOne(statement);
    }

    doProcessResult(exchange, result);
}

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

License:Open Source License

private Account getAccount(final String selector, final Object parameters) {
    final SqlSession session = sessions.openSession();
    try {//from   www  .ja va 2  s .c o  m
        final Map<String, Object> result = session.selectOne(selector, parameters);
        if (result != null) {
            return toAccount(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

private Application getApplication(final String selector, final String parameter) {
    final SqlSession session = sessions.openSession();
    try {//from   w  ww.  j  a va  2s .  c  o  m
        final Map<String, Object> result = session.selectOne(selector, parameter);
        if (result != null) {
            return toApplication(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public CallDetailRecord getCallDetailRecord(final Sid sid) {
    final SqlSession session = sessions.openSession();
    try {/*from   w  ww  . jav  a 2  s  . c o m*/
        final Map<String, Object> result = session.selectOne(namespace + "getCallDetailRecord", sid.toString());
        if (result != null) {
            return toCallDetailRecord(result);
        } else {
            return null;
        }
    } finally {
        session.close();
    }
}

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

License:Open Source License

@Override
public Integer getTotalCallDetailRecords(CallDetailRecordFilter filter) {

    final SqlSession session = sessions.openSession();
    try {/*from   w  w w .  ja  v  a2 s .c  o m*/
        final Integer total = session.selectOne(namespace + "getTotalCallDetailRecordByUsingFilters", filter);
        return total;
    } finally {
        session.close();
    }

}