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

  protected SqlMapClient getSqlMapClient() throws FeedServerAdapterException {
    String dataSourceId = config.getFeedConfigLocation();
    if (sqlMapClients.containsKey(dataSourceId)) {
      return sqlMapClients.get(dataSourceId);
    } else {
      SqlMapClient client;
      try {
        client =
            SqlMapClientBuilder.buildSqlMapClient(config.getAdapterConfiguration()
                .getAdapterConfigAsReader());
      } catch (IOException e) {

View Full Code Here

  }


  @Override
  @SuppressWarnings("unchecked")
  public Feed retrieveFeed(RequestContext request) throws FeedServerAdapterException {
    SqlMapClient client = getSqlMapClient();
    String queryId = config.getFeedId() + "-get-feed";
    List<Map<String, Object>> rows;
    try {
      rows = client.queryForList(queryId, getRequestParams(request));
    } catch (SQLException e) {
      throw new FeedServerAdapterException(
          FeedServerAdapterException.Reason.ERROR_EXECUTING_ADAPTER_REQUEST, e.getMessage());
    }
    Feed feed = createFeed();

View Full Code Here

  @Override
  @SuppressWarnings("unchecked")
  public Entry retrieveEntry(RequestContext request, Object entryId)
      throws FeedServerAdapterException {
    String queryId = config.getFeedId() + "-get-entry";
    SqlMapClient client = getSqlMapClient();
    Map<String, Object> row;
    try {
      row = (Map<String, Object>) client.queryForObject(queryId, entryId,  getRequestParams(request));
    } catch (SQLException e) {
      throw new FeedServerAdapterException(
          FeedServerAdapterException.Reason.ERROR_EXECUTING_ADAPTER_REQUEST, e.getMessage());
    }
    if (row == null) {

View Full Code Here

    return createEntryFromProperties(null, row);
  }


  @Override
  public Entry createEntry(RequestContext request, Entry entry) throws FeedServerAdapterException {
    SqlMapClient client = getSqlMapClient();
    String queryId = config.getFeedId() + "-insert-entry";
    Object newEntryId;
    try {
      Map<String, Object> params = getRequestParams(request);
      params.putAll(getPropertyMapForEntry(entry));
      newEntryId = client.insert(queryId, params);
    } catch (SQLException e) {
      throw new FeedServerAdapterException(
          FeedServerAdapterException.Reason.ERROR_EXECUTING_ADAPTER_REQUEST, e.getMessage());
    }
    return retrieveEntry(request, newEntryId);

View Full Code Here

  }


  @Override
  public Entry updateEntry(RequestContext request, Object entryId, Entry entry)
      throws FeedServerAdapterException {
    SqlMapClient client = getSqlMapClient();
    String queryId = config.getFeedId() + "-update-entry";
    try {
        Map<String, Object> params = getRequestParams(request);
        params.putAll(getPropertyMapForEntry(entry));
      return client.update(queryId, params) > 0 ? retrieveEntry(request,
          entryId) : null;
    } catch (SQLException e) {
      throw new FeedServerAdapterException(
          FeedServerAdapterException.Reason.ERROR_EXECUTING_ADAPTER_REQUEST, e.getMessage());
    }

View Full Code Here

  }


  @Override
  public void deleteEntry(RequestContext request, Object entryId) throws FeedServerAdapterException {
    String queryId = config.getFeedId() + "-delete-entry";
    SqlMapClient client = getSqlMapClient();
    try {
      Map<String, Object> params = getRequestParams(request);
      params.put("id", entryId);
      if (!(client.delete(queryId, params) > 0)) {
        throw new FeedServerAdapterException(
            FeedServerAdapterException.Reason.ERROR_EXECUTING_ADAPTER_REQUEST, "could not delete");
      }
    } catch (SQLException e) {
      throw new FeedServerAdapterException(

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.