Java StaticSqlSource类代码示例

本文整理汇总了Java中org.apache.ibatis.builder.StaticSqlSource类的典型用法代码示例。如果您正苦于以下问题：Java StaticSqlSource类的具体用法？Java StaticSqlSource怎么用？Java StaticSqlSource使用的例子？那么, 这里精选的类代码示例或许可以为您提供帮助。

StaticSqlSource类属于org.apache.ibatis.builder包，在下文中一共展示了StaticSqlSource类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: prepareInsertAuthorMappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareInsertAuthorMappedStatement(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor", new StaticSqlSource(config,"INSERT INTO author (id,username,password,email,bio,favourite_section) values(?,?,?,?,?,?)"), SqlCommandType.INSERT)
      .parameterMap(
          new ParameterMap.Builder(
              config, "defaultParameterMap", Author.class,
              new ArrayList<ParameterMapping>() {
                {
                  add(new ParameterMapping.Builder(config, "id", registry.getTypeHandler(int.class)).build());
                  add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).build());
                  add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).build());
                  add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).build());
                  add(new ParameterMapping.Builder(config, "bio", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).build());
                  add(new ParameterMapping.Builder(config, "favouriteSection", registry.getTypeHandler(Section.class)).jdbcType(JdbcType.VARCHAR).build());
                }
              }).build())
      .cache(authorCache).build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:20，代码来源:ExecutorTestHelper.java

示例2: prepareSelectAuthorViaOutParams

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareSelectAuthorViaOutParams(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "selectAuthorViaOutParams", new StaticSqlSource(config, "{call selectAuthorViaOutParams(?,?,?,?,?)}"), SqlCommandType.SELECT)
      .statementType(StatementType.CALLABLE)
      .parameterMap(new ParameterMap.Builder(config, "defaultParameterMap", Author.class,
          new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "id", registry.getTypeHandler(int.class)).build());
              add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).mode(ParameterMode.OUT).build());
              add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).mode(ParameterMode.OUT).build());
              add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).mode(ParameterMode.OUT).build());
              add(new ParameterMapping.Builder(config, "bio", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).mode(ParameterMode.OUT).build());
            }
          }).build())
      .resultMaps(new ArrayList<ResultMap>())
      .cache(authorCache).build();
  return ms;
}

开发者ID:txazo，项目名称:mybatis，代码行数:19，代码来源:ExecutorTestHelper.java

示例3: prepareInsertAuthorMappedStatementWithAutoKey

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareInsertAuthorMappedStatementWithAutoKey(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor", new StaticSqlSource(config,"INSERT INTO author (username,password,email,bio,favourite_section) values(?,?,?,?,?)"), SqlCommandType.INSERT)
      .parameterMap(
          new ParameterMap.Builder(config, "defaultParameterMap", Author.class, new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "bio", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).build());
              add(new ParameterMapping.Builder(config, "favouriteSection", registry.getTypeHandler(Section.class)).jdbcType(JdbcType.VARCHAR).build());
            }
          }).build())
      .cache(authorCache)
      .keyGenerator(new Jdbc3KeyGenerator())
      .keyProperty("id")
      .build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:20，代码来源:ExecutorTestHelper.java

示例4: prepareUpdateAuthorMappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareUpdateAuthorMappedStatement(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "updateAuthor", new StaticSqlSource(config,"UPDATE author SET username = ?, password = ?, email = ?, bio = ? WHERE id = ?"), SqlCommandType.UPDATE)
      .parameterMap(new ParameterMap.Builder(config, "defaultParameterMap", Author.class,
          new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "bio", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).build());
              add(new ParameterMapping.Builder(config, "id", registry.getTypeHandler(int.class)).build());
            }
          }).build())
      .cache(authorCache).build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:17，代码来源:ExecutorTestHelper.java

示例5: createSelectAuthorWithIDof99MappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement createSelectAuthorWithIDof99MappedStatement(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "selectAuthor", new StaticSqlSource(config,"SELECT * FROM author WHERE id = 99"), SqlCommandType.SELECT)
      .statementType(StatementType.STATEMENT)
      .parameterMap(new ParameterMap.Builder(config, "defaultParameterMap", Author.class, new ArrayList<ParameterMapping>()).build())
      .resultMaps(new ArrayList<ResultMap>() {
        {
          add(new ResultMap.Builder(config, "defaultResultMap", Author.class, new ArrayList<ResultMapping>() {
            {
              add(new ResultMapping.Builder(config, "id", "id", registry.getTypeHandler(int.class)).build());
              add(new ResultMapping.Builder(config, "username", "username", registry.getTypeHandler(String.class)).build());
              add(new ResultMapping.Builder(config, "password", "password", registry.getTypeHandler(String.class)).build());
              add(new ResultMapping.Builder(config, "email", "email", registry.getTypeHandler(String.class)).build());
              add(new ResultMapping.Builder(config, "bio", "bio", registry.getTypeHandler(String.class)).build());
            }
          }).build());
        }
      }).build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:21，代码来源:ExecutorTestHelper.java

示例6: createSqlSource331

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
/**
 * 3.3.1版本之前的方法
 *
 * @param parameterObject
 * @return
 */
private SqlSource createSqlSource331(Object parameterObject) {
    try {
        String sql;
        if (providerTakesParameterObject) {
            sql = (String) providerMethod.invoke(providerType.newInstance(), parameterObject);
        } else {
            sql = (String) providerMethod.invoke(providerType.newInstance());
        }
        Class<?> parameterType = parameterObject == null ? Object.class : parameterObject.getClass();
        StaticSqlSource sqlSource = (StaticSqlSource) sqlSourceParser.parse(sql, parameterType, new HashMap<String, Object>());
        return new OrderByStaticSqlSource(sqlSource);
    } catch (Exception e) {
        throw new BuilderException("Error invoking SqlProvider method ("
                + providerType.getName() + "." + providerMethod.getName()
                + ").  Cause: " + e, e);
    }
}

开发者ID:xushaomin，项目名称:apple-orm，代码行数:24，代码来源:PageProviderSqlSource.java

示例7: processMappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
/**
 * 修改SqlSource
 *
 * @param ms
 * @throws Throwable
 */
public void processMappedStatement(MappedStatement ms) throws Throwable {
    SqlSource sqlSource = ms.getSqlSource();
    MetaObject msObject = SystemMetaObject.forObject(ms);
    SqlSource pageSqlSource;
    if (sqlSource instanceof StaticSqlSource) {
        pageSqlSource = new PageStaticSqlSource((StaticSqlSource) sqlSource);
    } else if (sqlSource instanceof RawSqlSource) {
        pageSqlSource = new PageRawSqlSource((RawSqlSource) sqlSource);
    } else if (sqlSource instanceof ProviderSqlSource) {
        pageSqlSource = new PageProviderSqlSource((ProviderSqlSource) sqlSource);
    } else if (sqlSource instanceof DynamicSqlSource) {
        pageSqlSource = new PageDynamicSqlSource((DynamicSqlSource) sqlSource);
    } else {
        throw new RuntimeException("无法处理该类型[" + sqlSource.getClass() + "]的SqlSource");
    }
    msObject.setValue("sqlSource", pageSqlSource);
    //由于count查询需要修改返回值，因此这里要创建一个Count查询的MS
    msCountMap.put(ms.getId(), MSUtils.newCountMappedStatement(ms));
}

开发者ID:xushaomin，项目名称:apple-orm，代码行数:26，代码来源:SqlUtil.java

示例8: prepareInsertAuthorMappedStatementWithAutoKey

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareInsertAuthorMappedStatementWithAutoKey(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "insertAuthor", new StaticSqlSource(config,"INSERT INTO author (username,password,email,bio,favourite_section) values(?,?,?,?,?)"), SqlCommandType.INSERT)
      .parameterMap(
          new ParameterMap.Builder(config, "defaultParameterMap", Author.class, new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "bio", registry.getTypeHandler(String.class)).jdbcType(JdbcType.VARCHAR).build());
              add(new ParameterMapping.Builder(config, "favouriteSection", registry.getTypeHandler(Section.class)).jdbcType(JdbcType.VARCHAR).build());
            }
          }).build())
      .cache(authorCache)
      .keyGenerator(Jdbc3KeyGenerator.INSTANCE)
      .keyProperty("id")
      .build();
  return ms;
}

开发者ID:mybatis，项目名称:mybatis-3，代码行数:20，代码来源:ExecutorTestHelper.java

示例9: select

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
private String select(String sql) {
    String msId = newMsId(sql, SqlCommandType.SELECT);
    if (hasMappedStatement(msId)) {
        return msId;
    }
    StaticSqlSource sqlSource = new StaticSqlSource(configuration, sql);
    newSelectMappedStatement(msId, sqlSource, Map.class);
    return msId;
}

开发者ID:drtrang，项目名称:spring-boot-autoconfigure，代码行数:10，代码来源:SqlMapper.java

示例10: insert

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
private String insert(String sql) {
    String msId = newMsId(sql, SqlCommandType.INSERT);
    if (hasMappedStatement(msId)) {
        return msId;
    }
    StaticSqlSource sqlSource = new StaticSqlSource(configuration, sql);
    newUpdateMappedStatement(msId, sqlSource, SqlCommandType.INSERT);
    return msId;
}

开发者ID:drtrang，项目名称:spring-boot-autoconfigure，代码行数:10，代码来源:SqlMapper.java

示例11: update

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
private String update(String sql) {
    String msId = newMsId(sql, SqlCommandType.UPDATE);
    if (hasMappedStatement(msId)) {
        return msId;
    }
    StaticSqlSource sqlSource = new StaticSqlSource(configuration, sql);
    newUpdateMappedStatement(msId, sqlSource, SqlCommandType.UPDATE);
    return msId;
}

开发者ID:drtrang，项目名称:spring-boot-autoconfigure，代码行数:10，代码来源:SqlMapper.java

示例12: delete

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
private String delete(String sql) {
    String msId = newMsId(sql, SqlCommandType.DELETE);
    if (hasMappedStatement(msId)) {
        return msId;
    }
    StaticSqlSource sqlSource = new StaticSqlSource(configuration, sql);
    newUpdateMappedStatement(msId, sqlSource, SqlCommandType.DELETE);
    return msId;
}

开发者ID:drtrang，项目名称:spring-boot-autoconfigure，代码行数:10，代码来源:SqlMapper.java

示例13: getMappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
MappedStatement getMappedStatement() {
  final Configuration config = new Configuration();
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  return new MappedStatement.Builder(config, "testSelect", new StaticSqlSource(config, "some select statement"), SqlCommandType.SELECT).resultMaps(
      new ArrayList<ResultMap>() {
        {
          add(new ResultMap.Builder(config, "testMap", HashMap.class, new ArrayList<ResultMapping>() {
            {
              add(new ResultMapping.Builder(config, "cOlUmN1", "CoLuMn1", registry.getTypeHandler(Integer.class)).build());
            }
          }).build());
        }
      }).build();
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:15，代码来源:DefaultParameterHandlerTest.java

示例14: prepareInsertAuthorProc

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareInsertAuthorProc(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "insertAuthorProc", new StaticSqlSource(config,"{call insertAuthor(?,?,?,?)}"), SqlCommandType.INSERT)
      .parameterMap(new ParameterMap.Builder(config, "defaultParameterMap", Author.class,
          new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "id", registry.getTypeHandler(int.class)).build());
              add(new ParameterMapping.Builder(config, "username", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "password", registry.getTypeHandler(String.class)).build());
              add(new ParameterMapping.Builder(config, "email", registry.getTypeHandler(String.class)).build());
            }
          }).build())
      .cache(authorCache).build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:16，代码来源:ExecutorTestHelper.java

示例15: prepareDeleteAuthorMappedStatement

import org.apache.ibatis.builder.StaticSqlSource; //导入依赖的package包/类
public static MappedStatement prepareDeleteAuthorMappedStatement(final Configuration config) {
  final TypeHandlerRegistry registry = config.getTypeHandlerRegistry();
  MappedStatement ms = new MappedStatement.Builder(config, "deleteAuthor", new StaticSqlSource(config,"DELETE FROM author WHERE id = ?"), SqlCommandType.DELETE)
      .parameterMap(new ParameterMap.Builder(config, "defaultParameterMap", Author.class,
          new ArrayList<ParameterMapping>() {
            {
              add(new ParameterMapping.Builder(config, "id", registry.getTypeHandler(int.class)).build());
            }
          }).build())
      .cache(authorCache)
      .build();
  return ms;
}

开发者ID:yuexiahandao，项目名称:MybatisCode，代码行数:14，代码来源:ExecutorTestHelper.java

注：本文中的org.apache.ibatis.builder.StaticSqlSource类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。