Examples of org.springframework.jdbc.core.JdbcTemplate

org.springframework.jdbc.core.JdbcTemplate
This is the central class in the JDBC core package. It simplifies the use of JDBC and helps to avoid common errors. It executes core JDBC workflow, leaving application code to provide SQL and extract results. This class executes SQL queries or updates, initiating iteration over ResultSets and catching JDBC exceptions and translating them to the generic, more informative exception hierarchy defined in the org.springframework.dao package.
Code using this class need only implement callback interfaces, giving them a clearly defined contract. The {@link PreparedStatementCreator} callbackinterface creates a prepared statement given a Connection, providing SQL and any necessary parameters. The {@link ResultSetExtractor} interface extractsvalues from a ResultSet. See also {@link PreparedStatementSetter} and{@link RowMapper} for two popular alternative callback interfaces.
Can be used within a service implementation via direct instantiation with a DataSource reference, or get prepared in an application context and given to services as bean reference. Note: The DataSource should always be configured as a bean in the application context, in the first case given to the service directly, in the second case to the prepared template.
Because this class is parameterizable by the callback interfaces and the {@link org.springframework.jdbc.support.SQLExceptionTranslator}interface, there should be no need to subclass it.
All SQL operations performed by this class are logged at debug level, using "org.springframework.jdbc.core.JdbcTemplate" as log category. @author Rod Johnson @author Juergen Hoeller @author Thomas Risberg @since May 3, 2001 @see PreparedStatementCreator @see PreparedStatementSetter @see CallableStatementCreator @see PreparedStatementCallback @see CallableStatementCallback @see ResultSetExtractor @see RowCallbackHandler @see RowMapper @see org.springframework.jdbc.support.SQLExceptionTranslator

    @Before
    public void setUp() throws Exception {
        super.setUp();


        dataSource = context.getRegistry().lookup("myNonXADataSource", DataSource.class);
        jdbcTemplate = new JdbcTemplate(dataSource);
        jdbcTemplate.afterPropertiesSet();
    }

View Full Code Here

        super.setUp();


        // START SNIPPET: e5
        // create database and insert dummy data
        final DataSource ds = getMandatoryBean(DataSource.class, "dataSource");
        jdbc = new JdbcTemplate(ds);
        jdbc.execute("create table books (title varchar(50))");
        jdbc.update("insert into books (title) values (?)", new Object[] {"Camel in Action"});
        // END SNIPPET: e5
    }

View Full Code Here

    protected void setUp() throws Exception {
        DriverManagerDataSource dataSource = new DriverManagerDataSource(url, user, password);
        dataSource.setDriverClassName(driverClass);
        ds = dataSource;


        JdbcTemplate jdbc = new JdbcTemplate(ds);
        // START SNIPPET: setup
        jdbc.execute("create table customer (id varchar(15), name varchar(10))");
        jdbc.execute("insert into customer values('cust1','jstrachan')");
        jdbc.execute("insert into customer values('cust2','nsandhu')");
        // END SNIPPET: setup
        super.setUp();
    }

View Full Code Here

        super.setUp();
    }


    protected void tearDown() throws Exception {
        super.tearDown();
        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("drop table customer");
    }

View Full Code Here

    protected void setUp() throws Exception {
        DriverManagerDataSource dataSource = new DriverManagerDataSource(url, user, password);
        dataSource.setDriverClassName(driverClass);
        ds = dataSource;


        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("create table customer (id varchar(15), name varchar(10))");
        jdbc.execute("insert into customer values('cust1','jstrachan')");
        jdbc.execute("insert into customer values('cust2','nsandhu')");
        super.setUp();
    }

View Full Code Here

        super.setUp();
    }


    protected void tearDown() throws Exception {
        super.tearDown();
        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("drop table customer");
    }

View Full Code Here

    protected void setUp() throws Exception {
        DriverManagerDataSource dataSource = new DriverManagerDataSource(url, user, password);
        dataSource.setDriverClassName(driverClass);
        ds = dataSource;


        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("create table customer (id varchar(15), name varchar(10))");
        jdbc.execute("insert into customer values('cust1','jstrachan')");
        jdbc.execute("insert into customer values('cust2','nsandhu')");
        super.setUp();
    }

View Full Code Here

        super.setUp();
    }


    protected void tearDown() throws Exception {
        super.tearDown();
        JdbcTemplate jdbc = new JdbcTemplate(ds);
        jdbc.execute("drop table customer");
    }

View Full Code Here

    private JdbcTemplate jdbcTemplate;
    private String query;


    public SqlEndpoint(String uri, String query, Component component, DataSource dataSource, Map parameters) throws Exception {
        super(uri, component);
        this.jdbcTemplate = new JdbcTemplate(dataSource);
        IntrospectionSupport.setProperties(jdbcTemplate, parameters, "template.");
        this.query = query;
    }

View Full Code Here

    
    protected void setUp() throws Exception {
        Class.forName(driverClass);
        super.setUp();


        jdbcTemplate = new JdbcTemplate(ds);
        jdbcTemplate.execute("create table projects (id integer primary key,"
                             + "project varchar(10), license varchar(5))");
        jdbcTemplate.execute("insert into projects values (1, 'Camel', 'ASF')");
        jdbcTemplate.execute("insert into projects values (2, 'AMQ', 'ASF')");
        jdbcTemplate.execute("insert into projects values (3, 'Linux', 'GPL')");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.springframework.jdbc.core.JdbcTemplate

ch.inftec.ju.db.DbSpecificHandlerDefault

ch.inftec.ju.db.DbSpecificHandlerMySql

ch.inftec.ju.db.DbSpecificHandlerOracle

ch.inftec.ju.db.JuConnUtils

com.alibaba.otter.node.etl.common.db.DbDialectTest

com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker

com.bank.repository.internal.JdbcAccountRepository

com.bank.service.TransferServiceTests

com.github.hakko.musiccabinet.dao.jdbc.JdbcDatabaseAdministrationDao

com.github.hakko.musiccabinet.dao.util.PostgreSQLUtil

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.