Examples of com.ibatis.sqlmap.client.SqlMapClient

com.ibatis.sqlmap.client.SqlMapClient
utocommit simple query --these are just examples...not patterns // Employee emp = (Employee) sqlMap.queryForObject("getEmployee", new Integer(1)); // // transaction --these are just examples...not patterns // try { sqlMap.startTransaction() Employee emp2 = new Employee(); // ...set emp2 data Integer generatedKey = (Integer) sqlMap.insert ("insertEmployee", emp2); emp2.setFavouriteColour ("green"); sqlMap.update("updateEmployee", emp2); sqlMap.commitTransaction(); } finally { sqlMap.endTransaction(); } // // session --these are just examples...not patterns // try { SqlMapSession session = sqlMap.openSession() session.startTransaction() Employee emp2 = new Employee(); // ...set emp2 data Integer generatedKey = (Integer) session.insert ("insertEmployee", emp2); emp2.setFavouriteColour ("green"); session.update("updateEmployee", emp2); session.commitTransaction(); } finally { try { session.endTransaction(); } finally { session.close(); } // Generally your session scope would be in a wider context and therefore the // ugly nested finally block above would not be there. Realize that sessions // MUST be closed if explicitly opened (via openSession()). } // // batch --these are just examples...not patterns // try { sqlMap.startTransaction() List list = (Employee) sqlMap.queryForList("getFiredEmployees", null); sqlMap.startBatch (); for (int i=0, n=list.size(); i < n; i++) { sqlMap.delete ("deleteEmployee", list.get(i)); } sqlMap.executeBatch(); sqlMap.commitTransaction(); } finally { sqlMap.endTransaction(); } @see SqlMapClientBuilder @see SqlMapSession @see SqlMapExecutor


    /**
     * Calls insert on the SqlMapClient.
     */
    public void process(Exchange exchange) throws Exception {
        SqlMapClient client = endpoint.getSqlMapClient();
        Object body = exchange.getIn().getBody();
        if (body == null) {
            // must be a poll so lets do a query
            Message msg = exchange.getOut(true);
            if (LOG.isTraceEnabled()) {
                LOG.trace("Querying for list: " + statement);
            }
            List list = client.queryForList(statement);
            msg.setBody(list);
            msg.setHeader(IBatisConstants.IBATIS_STATEMENT_NAME, statement);
        } else {
            // lets handle arrays or collections of objects
            Iterator iter = ObjectHelper.createIterator(body);
            while (iter.hasNext()) {
                Object value = iter.next();
                if (LOG.isTraceEnabled()) {
                    LOG.trace("Inserting: " + value + " using statement: " + statement);
                }
                client.insert(statement, value);
            }
        }
    }

View Full Code Here


    if (ObjectUtils.isEmpty(configLocations)) {
      throw new IllegalArgumentException("At least 1 'configLocation' entry is required");
    }


    SqlMapClient client = null;
    SqlMapConfigParser configParser = new SqlMapConfigParser();
    for (Resource configLocation : configLocations) {
      InputStream is = configLocation.getInputStream();
      try {
        client = configParser.parse(is, properties);

View Full Code Here

public class IbatisPagingItemReaderParameterTests extends AbstractPagingItemReaderParameterTests {


  @Override
  @SuppressWarnings("deprecation")
  protected AbstractPagingItemReader<Foo> getItemReader() throws Exception {
    SqlMapClient sqlMapClient = createSqlMapClient();


    IbatisPagingItemReader<Foo> reader = new IbatisPagingItemReader<Foo>();
    reader.setQueryId("getPagedFoosLimitAndUp");
    reader.setParameterValues(Collections.<String, Object>singletonMap("limit", 2));
    reader.setSqlMapClient(sqlMapClient);

View Full Code Here


    return reader;
  }


  private SqlMapClient createSqlMapClient() throws Exception {
    SqlMapClient client = SqlMapClientBuilder.buildSqlMapClient(new ClassPathResource("ibatis-config.xml", getClass()).getInputStream());
    return client;
  }

View Full Code Here

    assertEquals(ITEM_COUNT, results.size());
    reader.close();
  }


  private IbatisPagingItemReader<Foo> getItemReader() throws Exception {
    SqlMapClient sqlMapClient = createSqlMapClient();


    IbatisPagingItemReader<Foo> reader = new IbatisPagingItemReader<Foo>();
    if ("postgres".equals(System.getProperty("ENVIRONMENT"))) {
      reader.setQueryId("getPagedFoosPostgres");
    } else if ("oracle".equals(System.getProperty("ENVIRONMENT"))) {

View Full Code Here

@SuppressWarnings("deprecation")
public class IbatisPagingItemReaderCommonTests extends AbstractDatabaseItemStreamItemReaderTests {


  @Override
  protected ItemReader<Foo> getItemReader() throws Exception {
    SqlMapClient sqlMapClient = createSqlMapClient();


    IbatisPagingItemReader<Foo> reader = new IbatisPagingItemReader<Foo>();
    reader.setQueryId("getPagedFoos");
    reader.setPageSize(2);
    reader.setSqlMapClient(sqlMapClient);

View Full Code Here

    assertEquals(ITEM_COUNT, results.size());
    reader.close();
  }


  private IbatisPagingItemReader<Foo> getItemReader() throws Exception {
    SqlMapClient sqlMapClient = createSqlMapClient();


    IbatisPagingItemReader<Foo> reader = new IbatisPagingItemReader<Foo>();
    reader.setQueryId("getPagedFoos");
    reader.setPageSize(2);
    reader.setSqlMapClient(sqlMapClient);

View Full Code Here

  private static final Map<String, SqlMapClient> sqlMapClients = new HashMap<String, SqlMapClient>();


  @Override
  protected SqlMapClient buildSqlMapClient(Resource configLocation, Properties properties) throws IOException {
    String configURI = configLocation.getURI().toString();
    SqlMapClient client = sqlMapClients.get(configURI);
    if (client == null) {
      InputStream is = configLocation.getInputStream();
      client = buildSqlMapClient(is, properties);
      sqlMapClients.put(configURI, client);
    }

View Full Code Here

        }
    }
    
    @Test
    public void testAnotherAwfulTableInsert() {
        SqlMapClient sqlMap = getSqlMapClient();
        
        try {
            Anotherawfultable record = new Anotherawfultable();
            record.setId(5);
            record.setSelect("select");
            record.setInsert("insert");
            
            sqlMap.insert("MBGTEST_ANOTHERAWFULTABLE.insert", record);
            
            Anotherawfultable key = new Anotherawfultable();
            key.setId(5);
            
            Anotherawfultable returnedRecord = (Anotherawfultable)
                sqlMap.queryForObject("MBGTEST_ANOTHERAWFULTABLE.selectByPrimaryKey",
                        key);
            
            assertEquals(record.getId(), returnedRecord.getId());
            assertEquals(record.getSelect(), returnedRecord.getSelect());
            assertEquals(record.getInsert(), returnedRecord.getInsert());

View Full Code Here

  }


  @Override
  public void afterPropertiesSet() throws Exception {
    super.afterPropertiesSet();
    SqlMapClient c = (SqlMapClient)getObject();
    if(sqlExecutor != null && c instanceof SqlMapClientImpl) {
      SqlMapClientImpl client = (SqlMapClientImpl)c;
      SqlMapExecutorDelegate delegate = client.getDelegate();
      try {
        ReflectUtil.setFieldValue(delegate, "sqlExecutor", SqlExecutor.class, sqlExecutor);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.ibatis.sqlmap.client.SqlMapClient

$.BasicDaoiBatis

$.SqlMapClientFactoryBean

cn.org.rapid_framework.ibatis.spring.SqlMapClientFactoryBean

com.common.tool.ReadProperties

com.google.feedserver.samples.adapters.IBatisCollectionAdapter

com.ibatis.db.sqlmap.XmlSqlMapBuilder

elicitation.action.test.TestAction

elicitation.action.user.LoginXAction

elicitation.service.user.LoginService

mbg.test.ib2j5.miscellaneous.MiscellaneousTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.