Examples of org.springframework.jdbc.core.simple.SimpleJdbcTemplate

Package org.springframework.jdbc.core.simple

Examples of org.springframework.jdbc.core.simple.SimpleJdbcTemplate

org.springframework.jdbc.core.simple.SimpleJdbcTemplate
Java-5-based convenience wrapper for the classic Spring {@link org.springframework.jdbc.core.JdbcTemplate}, taking advantage of varargs and autoboxing, and exposing only the most commonly required operations in order to simplify JdbcTemplate usage.
Use the {@link #getJdbcOperations()} method (or a straight JdbcTemplate)if you need to invoke less commonly used template methods. This includes any methods specifying SQL types, methods using less commonly used callbacks such as RowCallbackHandler, updates with PreparedStatementSetters rather than argument arrays, and stored procedures as well as batch operations. @author Rod Johnson @author Rob Harrop @author Juergen Hoeller @author Thomas Risberg @since 2.0 @see ParameterizedRowMapper @see SimpleJdbcDaoSupport @see org.springframework.jdbc.core.JdbcTemplate @deprecated since Spring 3.1 in favor of {@link org.springframework.jdbc.core.JdbcTemplate} and{@link org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate}. The JdbcTemplate and NamedParameterJdbcTemplate now provide all the functionality of the SimpleJdbcTemplate.

    protected void setUp() throws Exception {
        super.setUp();


        // create database and insert dummy data
        final DataSource ds = getMandatoryBean(DataSource.class, "dataSource");
        jdbc = new SimpleJdbcTemplate(ds);
        jdbc.getJdbcOperations().execute("create table books (title varchar(50))");
        jdbc.update("insert into books (title) values (?)", "Camel in Action");
    }

View Full Code Here

    protected void setUp() throws Exception {
        super.setUp();


        // create database and insert dummy data
        final DataSource ds = getMandatoryBean(DataSource.class, "dataSource");
        jdbc = new SimpleJdbcTemplate(ds);
        jdbc.getJdbcOperations().execute("create table books (title varchar(50))");
        jdbc.update("insert into books (title) values (?)", "Camel in Action");
    }

View Full Code Here

    protected void setUp() throws Exception {
        super.setUp();


        // create database and insert dummy data
        final DataSource ds = getMandatoryBean(DataSource.class, "dataSource");
        jdbc = new SimpleJdbcTemplate(ds);
    }

View Full Code Here

          .getApplicationContext().getBean("txTemplate");
      dataSource = (DataSource) ApplicationContextHolder
          .getApplicationContext().getBean(
              "collectionReaderDataSource");
    }
    simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
    namedJdbcTemplate = new NamedParameterJdbcTemplate(dataSource);
  }

View Full Code Here

    {
        DataSource dataSource = new SimpleDriverDataSource(new jdbcDriver(), URL, USERNAME, PASSWORD);
        migrationManager = new DataSourceMigrationManager(dataSource);
        migrationManager.setMigrationResolver(new ResourceMigrationResolver("classpath:/test_migrations/hsql/"));


        jdbcTemplate = new SimpleJdbcTemplate(dataSource);
    }

View Full Code Here


        DataSource dataSource = new SimpleDriverDataSource(new Driver(), URL, USERNAME, PASSWORD);
        migrationManager = new DataSourceMigrationManager(dataSource);
        migrationManager.setMigrationResolver(new ResourceMigrationResolver("classpath:/test_migrations/sqlserver_2000/"));


        jdbcTemplate = new SimpleJdbcTemplate(dataSource);
    }

View Full Code Here


        DataSource dataSource = new SimpleDriverDataSource(new Driver(), URL, USERNAME, PASSWORD);
        migrationManager = new DataSourceMigrationManager(dataSource);
        migrationManager.setMigrationResolver(new ResourceMigrationResolver("classpath:/test_migrations/postgresql_8/"));


        jdbcTemplate = new SimpleJdbcTemplate(dataSource);
    }

View Full Code Here

        Resource script = new ClassPathResource("/test_migrations/groovy_1/001_create_users.groovy");
        Connection connection = dataSource.getConnection();
        new GroovyMigration("1", script).migrate(DatabaseType.H2, connection);
        connection.close();


        SimpleJdbcTemplate jdbcTemplate = new SimpleJdbcTemplate(dataSource);
        assertThat(jdbcTemplate.queryForInt("select count(*) from users"), is(1));
    }

View Full Code Here

    public void setup()
    {
        DataSource dataSource = DatabaseTestUtils.createUniqueDataSource();
        migrationManager = new DataSourceMigrationManager(dataSource);


        jdbcTemplate = new SimpleJdbcTemplate(dataSource);
    }

View Full Code Here

    {
        DataSource dataSource = new SimpleDriverDataSource(new Driver(), URL, USERNAME, PASSWORD);
        migrationManager = new DataSourceMigrationManager(dataSource);
        migrationManager.setMigrationResolver(new ResourceMigrationResolver("classpath:/test_migrations/h2/"));


        jdbcTemplate = new SimpleJdbcTemplate(dataSource);
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.core.simple.SimpleJdbcTemplate

$.IndexAction

cn.org.rapid_framework.web.session.store.JdbcSessionStore

com.carbonfive.db.jdbc.datasource.RoutingDataSourceSpringTest

com.carbonfive.db.migration.DataSourceMigrationManagerTest

com.carbonfive.db.migration.GroovyMigrationTest

com.carbonfive.db.migration.H2MigrationTest

com.carbonfive.db.migration.HSQLMigrationTest

com.carbonfive.db.migration.MySQLMigrationTest

com.carbonfive.db.migration.PostgreSQLMigrationTest

com.carbonfive.db.migration.SimpleVersionStrategyTest

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.