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:com.sec.ose.airs.persistence.SPDXMapperImpl.java

License:Open Source License

@Override
public int insertFile(SPDXFileDTO file) {
    SqlSession session = factory.openSession(true);
    int result;//from   w  ww  . j  av a 2s  .c  om

    try {
        result = session.insert("insertFile", file);
    } finally {
        session.close();
    }

    return result;
}

From source file:com.sec.ose.airs.persistence.SPDXMapperImpl.java

License:Open Source License

@Override
public int insertOtherLicense(SPDXOtherLicenseDTO lic) {
    SqlSession session = factory.openSession(true);
    int result;/*from   w  ww .j  a v  a  2  s.com*/

    try {
        result = session.insert("insertOtherLicense", lic);
    } finally {
        session.close();
    }

    return result;
}

From source file:com.spring.dao.CiudadDAOImpl.java

@Override
public void save(Ciudad c) {
    SqlSession session = new MyBatisUtil().getSession();
    try {/*ww w.  j  a  va  2  s .c  om*/
        session.insert("Ciudad.save", c);
    } finally {
        session.commit();
        session.close();
    }
}

From source file:com.sycros.SCWebConsole.business.dao.LicenseBzDaoImpl.java

License:Open Source License

@Override
public int insertLicenseInfo(SqlSession sqlSession, LicenseBzDto licenseBzDto) throws Exception {
    // TODO Auto-generated method stub
    return sqlSession.insert("com.sycros.SCWebConsole.business.business-mapper.insertLicenseInfo",
            licenseBzDto);/*w w w .  ja  v a  2  s  .  c  om*/
}

From source file:com.sycros.SCWebConsole.business.dao.LicenseBzDaoImpl.java

License:Open Source License

@Override
public int insertLicenseProductInfo(SqlSession sqlSession, LicenseBzDto licenseBzDto) throws Exception {
    // TODO Auto-generated method stub
    return sqlSession.insert("com.sycros.SCWebConsole.business.business-mapper.insertLicenseProductInfo",
            licenseBzDto);/*from   w w w.  ja v  a 2s . c o m*/
}

From source file:com.tianjunwei.selectKey.SelectKeyMain.java

License:Apache License

public static void main(String[] args) {
    //mybatis?/*from   ww  w  . ja v  a 2s . co  m*/
    String resource = "learn/mybatis-config.xml";
    InputStream is = SelectKeyMain.class.getClassLoader().getResourceAsStream(resource);
    //sqlSession
    SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
    SqlSession session = sessionFactory.openSession();
    User user = new User();
    user.setAge(10);
    user.setNames("yao");
    session.insert("com.tianjunwei.selectKey.entity.User.add", user);
    session.commit();
    System.err.println(user.getId());
    session.insert("com.tianjunwei.selectKey.entity.User.insert", user);
    session.commit();
    System.err.println(user.getId());
}

From source file:com.yimidida.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 w  w  .j a  v  a 2 s.c  om

    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);
    }

    final Object params = ParameterUtil.resolve(parameter, shardId);

    final int rows = session.insert(statement, params);

    //fixed set keys
    if (params instanceof Map) {
        Map map = (Map) params;
        Configuration configuration = session.getConfiguration();
        MappedStatement ms = configuration.getMappedStatement(statement);

        if (parameter != null && ms != null && ms.getKeyProperties() != null) {
            String keyProperty = ms.getKeyProperties()[0]; // just one key property is supported
            final MetaObject metaParam = configuration.newMetaObject(parameter);
            if (keyProperty != null && metaParam.hasSetter(keyProperty)) {
                metaParam.setValue(keyProperty, map.get(keyProperty));
            }
        }
    }

    return rows;
}

From source file:fr.cph.stock.dao.AccountDaoImpl.java

License:Apache License

@Override
public final void insert(final Account account) {
    SqlSession session = getSqlSessionFactory();
    try {//w  ww  .  j  a v  a2s .  co m
        session.insert("AccountDao.insertOneAccount", account);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:fr.cph.stock.dao.CompanyDaoImpl.java

License:Apache License

@Override
public final void insert(final Company company) {
    SqlSession session = getSqlSessionFactory();
    try {// w  w w. j av  a 2  s.co m
        session.insert("CompanyDao.insertOneCompany", company);
        session.commit();
    } finally {
        session.close();
    }
}

From source file:fr.cph.stock.dao.CurrencyDaoImpl.java

License:Apache License

@Override
public final void insert(final CurrencyData currencyData) {
    SqlSession session = getSqlSessionFactory();
    try {//from w w  w  . j ava 2  s . c  o  m
        session.insert("CurrencyData.insertOneCurrencyData", currencyData);
        session.commit();
    } finally {
        session.close();
    }

}