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

Introduction

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

Prototype

int insert(String statement, Object parameter);

Source Link

Document

Execute an insert statement with the given parameter object.

Usage

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

License:Open Source License

/**
 * remove an NntpGroup from our groups list
 *//*from  www  . j a v  a2  s.c  o  m*/
public void removeGroup(NntpGroup group) throws Exception {
    HashMap<String, String> map = new HashMap<String, String>();
    map.put("table", groupsTable);
    map.put("name", group.getName());

    SqlSession session = sqlFactory.openSession();
    session.insert("removeGroup", map);
    session.commit();
    session.close();
}

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

License:Open Source License

/**
 * add an NntpGroup to an NntpServers group listing
 * @param group//from   w  w  w.ja v  a 2  s  .  c  om
 * @throws Exception
 */
public void addServerGroup(NntpGroup group) throws Exception {
    HashMap map = new HashMap();
    map.put("name", group.getName());
    map.put("hi", group.getHighID());
    map.put("low", group.getLowID());

    SqlSession session = sqlFactory.openSession();
    session.insert("addGroupToGroupList", map);
    session.commit();
    session.close();
}

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

License:Open Source License

public void addServerGroups(List<NntpGroup> groups) throws Exception {
    HashMap map = new HashMap();
    SqlSession session = sqlFactory.openSession();
    Iterator<NntpGroup> iter = groups.iterator();
    while (iter.hasNext()) {
        NntpGroup group = iter.next();/*from  w  ww  .  j  av  a  2 s . c o  m*/
        map.put("name", group.getName());
        map.put("hi", group.getHighID());
        map.put("low", group.getLowID());
        session.insert("addGroupToGroupList", map);
    }
    session.commit();
    session.close();
}

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

License:Open Source License

/**
 * create the needed DB table to hold our 
 * NntpServer entities /*  w w  w  .j a v a  2 s.  c o  m*/
 */
public void createServerTable() throws Exception {
    SqlSession session = sqlFactory.openSession();
    session.insert("createServerTable", serverTable);
    session.commit();
    session.close();
}

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

License:Open Source License

/**
 * add an NntpGroup to our groups list// w ww .ja v  a 2s.  com
 */
public void addServer(NntpServer server) throws Exception {
    HashMap map = new HashMap();
    map.put("table", serverTable);
    map.put("server", server.getServer());
    map.put("port", server.getPort());
    map.put("username", server.getUsername());
    map.put("password", server.getPassword());

    SqlSession session = sqlFactory.openSession();
    session.insert("addServer", map);
    session.commit();
    session.close();
}

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

License:Open Source License

/**
 * remove an NntpServer from our groups list
 */// ww  w  .jav  a 2  s .  c  o m
public void removeServer(NntpServer server) throws Exception {
    HashMap<String, String> map = new HashMap<String, String>();
    map.put("table", serverTable);
    map.put("server", server.getServer());

    SqlSession session = sqlFactory.openSession();
    session.insert("removeServer", map);
    session.commit();
    session.close();
}

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

License:Apache License

private void doInsert(Exchange exchange, SqlSession session) throws Exception {
    Object result;/*from ww w.j a va2  s .c o  m*/
    Object in = exchange.getIn().getBody();
    if (in != null) {
        // lets handle arrays or collections of objects
        Iterator<?> iter = ObjectHelper.createIterator(in);
        while (iter.hasNext()) {
            Object value = iter.next();
            LOG.trace("Inserting: {} using statement: {}", value, statement);
            result = session.insert(statement, value);
            doProcessResult(exchange, result);
        }
    } else {
        LOG.trace("Inserting using statement: {}", statement);
        result = session.insert(statement);
        doProcessResult(exchange, result);
    }
}

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

License:Apache License

private void doInsertList(Exchange exchange, SqlSession session) throws Exception {
    Object result;//  ww  w  .  j a va  2 s  . com
    Object in = exchange.getIn().getBody();
    if (in != null) {
        // just pass in the body as Object and allow MyBatis to iterate using its own foreach statement
        LOG.trace("Inserting: {} using statement: {}", in, statement);
        result = session.insert(statement, in);
        doProcessResult(exchange, result);
    } else {
        LOG.trace("Inserting using statement: {}", statement);
        result = session.insert(statement);
        doProcessResult(exchange, result);
    }
}

From source file:org.makersoft.shards.session.impl.ShardedSqlSessionImpl.java

License:Open Source License

@Override
public int insert(String statement, Object parameter) {
    ShardId shardId = this.selectShardIdForNewObject(statement, parameter);
    if (shardId == null) {
        shardId = this.getShardIdForStatementOrParameter(statement, parameter);
    }/*from w  ww.  j av  a2  s . co m*/

    Assert.notNull(shardId);

    // ?id
    setCurrentSubgraphShardId(shardId);

    log.debug(String.format("Inserting object of type %s to shard %s", parameter.getClass(), shardId));

    SqlSession session = shardIdsToShards.get(shardId).establishSqlSession();

    IdGenerator idGenerator = shardedSqlSessionFactory.getIdGenerator();
    if (idGenerator != null) {
        //TODO(fengkuok) ? DB?session
        Serializable id = idGenerator.generate(session, parameter);

        log.debug(String.format(
                "Generating id for object %s ,the type of IdGenerator is %s and generated Id is %s.",
                parameter.getClass(), idGenerator.getClass(), id));

        ParameterUtil.generatePrimaryKey(parameter, id);
    }

    return session.insert(statement, ParameterUtil.resolve(parameter, shardId));
}

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

License:Open Source License

@Override
public void addAccount(final Account account) {
    final SqlSession session = sessions.openSession();
    try {//www  . j a  v a  2s  .c  o m
        session.insert(namespace + "addAccount", toMap(account));
        session.commit();
    } finally {
        session.close();
    }
}