org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations Java Examples

@Test
public void testInsertion() {
	NamedParameterJdbcOperations namedParameterJdbcOperations = new NamedParameterJdbcTemplate(jdbcOperations);
	Map<String, Object> mapA = new HashMap<>();
	mapA.put("a", "hello1");
	mapA.put("b", 42);
	Map<String, Object> mapB = new HashMap<>();
	mapB.put("a", "hello2");
	mapB.put("b", null);
	Map<String, Object> mapC = new HashMap<>();
	mapC.put("a", "hello3");
	channels.input().send(MessageBuilder.withPayload(mapA).build());
	channels.input().send(MessageBuilder.withPayload(mapB).build());
	channels.input().send(MessageBuilder.withPayload(mapC).build());
	Assert.assertThat(namedParameterJdbcOperations.queryForObject(
			"select count(*) from messages where a = :a and b = :b", mapA, Integer.class), is(1));
	Assert.assertThat(namedParameterJdbcOperations.queryForObject(
			"select count(*) from messages where a = :a and b IS NULL", mapB, Integer.class), is(1));
	Assert.assertThat(namedParameterJdbcOperations.queryForObject(
			"select count(*) from messages where a = :a and b IS NULL", mapC, Integer.class), is(1));
}
 

@Bean
@Primary
@ConditionalOnSingleCandidate(JdbcTemplate.class)
@ConditionalOnMissingBean(NamedParameterJdbcOperations.class)
public NamedParameterJdbcTemplate namedParameterJdbcTemplate(JdbcTemplate jdbcTemplate) {
    return new NamedParameterJdbcTemplate(jdbcTemplate);
}
 

@Override
public void afterPropertiesSet() {

    Assert.state(this.mappingContext != null, "MappingContext is required and must not be null!");
    Assert.state(this.converter != null, "RelationalConverter is required and must not be null!");

    if (this.operations == null) {

        Assert.state(beanFactory != null, "If no JdbcOperations are set a BeanFactory must be available.");

        this.operations = beanFactory.getBean(NamedParameterJdbcOperations.class);
    }

    if (this.dataAccessStrategy == null) {

        Assert.state(beanFactory != null, "If no DataAccessStrategy is set a BeanFactory must be available.");

        this.dataAccessStrategy = this.beanFactory.getBeanProvider(DataAccessStrategy.class) //
                                                  .getIfAvailable(() -> {
                                                      SqlGeneratorSource sqlGeneratorSource = new SqlGeneratorSource(
                                                              this.mappingContext,
                                                              this.converter,
                                                              this.dialect);
                                                      return new DefaultDataAccessStrategy(sqlGeneratorSource,
                                                                                           this.mappingContext,
                                                                                           this.converter,
                                                                                           this.operations);
                                                  });
    }

    if (this.queryMappingConfiguration == null) {
        this.queryMappingConfiguration = QueryMappingConfiguration.EMPTY;
    }

    if (beanFactory != null) {
        entityCallbacks = EntityCallbacks.create(beanFactory);
    }

    super.afterPropertiesSet();
}
 

public QuerydslJdbcRepositoryFactory(DataAccessStrategy dataAccessStrategy,
                                     RelationalMappingContext context,
                                     JdbcConverter converter,
                                     Dialect dialect, ApplicationEventPublisher publisher,
                                     NamedParameterJdbcOperations operations,
                                     SQLQueryFactory sqlQueryFactory) {
    super(dataAccessStrategy, context, converter, dialect, publisher, operations);
    this.publisher = publisher;
    this.context = context;
    this.converter = converter;
    this.accessStrategy = dataAccessStrategy;
    this.sqlQueryFactory = sqlQueryFactory;
}
 

@Before
public void setup() {
	this.operations = mock(JdbcOperations.class);
	this.namedParameterOperations = mock(NamedParameterJdbcOperations.class);
	this.template = new SimpleJdbcTemplate(operations);
	this.namedParameterTemplate = new SimpleJdbcTemplate(namedParameterOperations);
}
 

@Bean
NamedParameterJdbcOperations operations() {
    return new NamedParameterJdbcTemplate(dataSource());
}
 

@Bean
NamedParameterJdbcOperations operations() {
    return new NamedParameterJdbcTemplate(dataSource());
}
 

public void setJdbcOperations(NamedParameterJdbcOperations operations) {
    this.operations = operations;
}
 

public void setJdbcOperations (NamedParameterJdbcOperations aJdbcOperations) {
  jdbc = aJdbcOperations;
}
 

public void setJdbcOperations (NamedParameterJdbcOperations aJdbcOperations) {
  jdbc = aJdbcOperations;
}
 

/**
 * @param jdbcTemplate the jdbc template to use
 */
public DefaultJdbcListFactory(NamedParameterJdbcOperations jdbcTemplate) {
	this.jdbcTemplate = jdbcTemplate;
}
 

/**
 * Expose the Spring NamedParameterJdbcTemplate to allow invocation of
 * less commonly used methods.
 */
@Override
public NamedParameterJdbcOperations getNamedParameterJdbcOperations() {
	return this.namedParameterJdbcOperations;
}
 

@Bean
public NamedParameterJdbcOperations namedParameterJdbcOperations(DataSource dataSource) {
    return new NamedParameterJdbcTemplate(dataSource);
}
 

/**
 * Create a new SimpleJdbcTemplate for the given Spring NamedParameterJdbcTemplate.
 * @param namedParameterJdbcTemplate the Spring NamedParameterJdbcTemplate to wrap
 */
public SimpleJdbcTemplate(NamedParameterJdbcOperations namedParameterJdbcTemplate) {
	this.namedParameterJdbcOperations = namedParameterJdbcTemplate;
}
 

/**
 * Expose the Spring NamedParameterJdbcTemplate to allow invocation of less
 * commonly used methods.
 */
NamedParameterJdbcOperations getNamedParameterJdbcOperations();