Examples with JdbcTemplate org.springframework.jdbc.core.JdbcTemplate used on opensource projects

Example 41 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class InferredDataSourceSqlScriptsTests method database1.

@Test
@Sql(scripts = "data-add-dogbert.sql", config = @SqlConfig(transactionManager = "txMgr1"))
public void database1() {
    assertInTransaction(false);
    assertUsers(new JdbcTemplate(dataSource1), "Dilbert", "Dogbert");
}

Example 42 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-framework by spring-projects.

the class InferredDataSourceTransactionalSqlScriptsTests method database2.

@Test
@Transactional("txMgr2")
@Sql(scripts = "data-add-catbert.sql", config = @SqlConfig(transactionManager = "txMgr2"))
public void database2() {
    assertInTransaction(true);
    assertUsers(new JdbcTemplate(dataSource2), "Dilbert", "Catbert");
}

Example 43 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-boot by spring-projects.

the class BatchAutoConfigurationTests method testDefaultContext.

@Test
public void testDefaultContext() throws Exception {
    this.context = new AnnotationConfigApplicationContext();
    this.context.register(TestConfiguration.class, EmbeddedDataSourceConfiguration.class, BatchAutoConfiguration.class, TransactionAutoConfiguration.class, PropertyPlaceholderAutoConfiguration.class);
    this.context.refresh();
    assertThat(this.context.getBean(JobLauncher.class)).isNotNull();
    assertThat(this.context.getBean(JobExplorer.class)).isNotNull();
    assertThat(this.context.getBean(BatchProperties.class).getInitializer().isEnabled()).isTrue();
    assertThat(new JdbcTemplate(this.context.getBean(DataSource.class)).queryForList("select * from BATCH_JOB_EXECUTION")).isEmpty();
}

Example 44 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project cachecloud by sohutv.

the class CleanUpStatisticsJob method action.

@Override
public void action(JobExecutionContext context) {
    if (!ConstUtils.WHETHER_SCHEDULE_CLEAN_DATA) {
        return;
    }
    try {
        SchedulerContext schedulerContext = context.getScheduler().getContext();
        ApplicationContext applicationContext = (ApplicationContext) schedulerContext.get(APPLICATION_CONTEXT_KEY);
        InstanceStatsCenter InstanceStatsCenter = applicationContext.getBean("instanceStatsCenter", InstanceStatsCenter.class);
        try {
            InstanceStatsCenter.cleanUpStandardStats(5);
        } catch (Exception e) {
            logger.error(e.getMessage(), e);
        }
        JdbcTemplate jdbcTemplate = applicationContext.getBean("jdbcTemplate", JdbcTemplate.class);
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(new Date());
        calendar.add(Calendar.DAY_OF_MONTH, -31);
        Date time = calendar.getTime();
        int cleanCount = jdbcTemplate.update(CLEAN_APP_HOUR_COMMAND_STATISTICS, time);
        logger.warn("clean_app_hour_command_statistics count={}", cleanCount);
        cleanCount = jdbcTemplate.update(CLEAN_APP_MINUTE_COMMAND_STATISTICS, time);
        logger.warn("clean_app_minute_command_statistics count={}", cleanCount);
        cleanCount = jdbcTemplate.update(CLEAN_APP_HOUR_STATISTICS, time);
        logger.warn("clean_app_hour_statistics count={}", cleanCount);
        cleanCount = jdbcTemplate.update(CLEAN_APP_MINUTE_STATISTICS, time);
        logger.warn("clean_app_minute_statistics count={}", cleanCount);
        //清除客户端耗时数据(保存2天)
        ClientReportCostDistriService clientReportCostDistriService = applicationContext.getBean("clientReportCostDistriService", ClientReportCostDistriService.class);
        calendar.setTime(new Date());
        calendar.add(Calendar.DAY_OF_MONTH, -2);
        long timeFormat = NumberUtils.toLong(new SimpleDateFormat("yyyyMMddHHmm00").format(calendar.getTime()));
        cleanCount = clientReportCostDistriService.deleteBeforeCollectTime(timeFormat);
        logger.warn("clean_app_client_costtime_minute_stat count={}", cleanCount);
        //清除客户端耗时汇总数据(保存14天)
        calendar.setTime(new Date());
        calendar.add(Calendar.DAY_OF_MONTH, -14);
        timeFormat = NumberUtils.toLong(new SimpleDateFormat("yyyyMMddHHmm00").format(calendar.getTime()));
        cleanCount = jdbcTemplate.update(CLEAN_APP_CLIENT_MINUTE_COST_TOTAL, timeFormat);
        logger.warn("clean_app_client_costtime_minute_stat_total count={}", cleanCount);
        //清除客户端值数据(保存2天)
        ClientReportValueDistriService clientReportValueDistriService = applicationContext.getBean("clientReportValueDistriService", ClientReportValueDistriService.class);
        calendar.setTime(new Date());
        calendar.add(Calendar.DAY_OF_MONTH, -2);
        timeFormat = NumberUtils.toLong(new SimpleDateFormat("yyyyMMddHHmm00").format(calendar.getTime()));
        cleanCount = clientReportValueDistriService.deleteBeforeCollectTime(timeFormat);
        logger.warn("clean_app_client_value_minute_stats count={}", cleanCount);
        //清除服务器统计数据
        calendar.setTime(new Date());
        calendar.add(Calendar.DAY_OF_MONTH, -7);
        String date = new SimpleDateFormat("yyyy-MM-dd").format(calendar.getTime());
        cleanCount = jdbcTemplate.update(CLEAN_SERVER_STAT_STATISTICS, date);
        logger.warn("clean_server_stat_total count={}", cleanCount);
    } catch (Exception e) {
        logger.error(e.getMessage(), e);
    }
}

Example 45 with JdbcTemplate

use of org.springframework.jdbc.core.JdbcTemplate in project spring-boot by spring-projects.

the class DataSourceHealthIndicatorTests method customQuery.

@Test
public void customQuery() {
    this.indicator.setDataSource(this.dataSource);
    new JdbcTemplate(this.dataSource).execute("CREATE TABLE FOO (id INTEGER IDENTITY PRIMARY KEY)");
    this.indicator.setQuery("SELECT COUNT(*) from FOO");
    Health health = this.indicator.health();
    System.err.println(health);
    assertThat(health.getDetails().get("database")).isNotNull();
    assertThat(health.getStatus()).isEqualTo(Status.UP);
    assertThat(health.getDetails().get("hello")).isNotNull();
}