Search in sources :

Example 1 with SimpleJdbcInsertOperations

use of org.springframework.jdbc.core.simple.SimpleJdbcInsertOperations in project JavaForFun by gumartinm.

the class RawSpringJDBCWithPoolExample method main.

public static void main(final String[] args) throws PropertyVetoException {
    // Just for fun, programmatic configuration.
    final DataSource dataSource = getDataSource();
    final Map<String, Object> parameters = new HashMap<String, Object>();
    parameters.put("AD_ID", 1);
    // 3. Using Spring JdbcTemplate
    final JdbcOperations jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.execute("SELECT * FROM AD");
    // 4. Using SimpleJdbcTemplate
    final SimpleJdbcOperations simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
    final int deprecatedResult = simpleJdbcTemplate.queryForInt("SELECT * FROM AD", parameters);
    logger.info("Deprecated result: " + deprecatedResult);
    // 5. Using NamedParameterJdbcTemplate
    final NamedParameterJdbcOperations namedParameterJdbcOperations = new NamedParameterJdbcTemplate(dataSource);
    final int namedResult = namedParameterJdbcOperations.queryForInt("SELECT * FROM AD", parameters);
    logger.info("Named result: " + namedResult);
    // 6. Using Spring SimpleJdbcInsert
    final SimpleJdbcInsertOperations simpleJdbcInsert = new SimpleJdbcInsert(dataSource);
    simpleJdbcInsert.withTableName("ad");
    simpleJdbcInsert.execute(parameters);
    // 7. Using Spring SimpleJdbcCall
    final SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource);
    // Now we close the whole pool :)
    ((ComboPooledDataSource) dataSource).close();
}
Also used : HashMap(java.util.HashMap) NamedParameterJdbcTemplate(org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate) JdbcOperations(org.springframework.jdbc.core.JdbcOperations) NamedParameterJdbcOperations(org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations) SimpleJdbcOperations(org.springframework.jdbc.core.simple.SimpleJdbcOperations) SimpleJdbcTemplate(org.springframework.jdbc.core.simple.SimpleJdbcTemplate) SimpleJdbcOperations(org.springframework.jdbc.core.simple.SimpleJdbcOperations) NamedParameterJdbcTemplate(org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate) JdbcTemplate(org.springframework.jdbc.core.JdbcTemplate) SimpleJdbcTemplate(org.springframework.jdbc.core.simple.SimpleJdbcTemplate) SimpleJdbcCall(org.springframework.jdbc.core.simple.SimpleJdbcCall) ComboPooledDataSource(com.mchange.v2.c3p0.ComboPooledDataSource) DataSource(javax.sql.DataSource) NamedParameterJdbcOperations(org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations) ComboPooledDataSource(com.mchange.v2.c3p0.ComboPooledDataSource) SimpleJdbcInsertOperations(org.springframework.jdbc.core.simple.SimpleJdbcInsertOperations) SimpleJdbcInsert(org.springframework.jdbc.core.simple.SimpleJdbcInsert)

Aggregations

ComboPooledDataSource (com.mchange.v2.c3p0.ComboPooledDataSource)1 HashMap (java.util.HashMap)1 DataSource (javax.sql.DataSource)1 JdbcOperations (org.springframework.jdbc.core.JdbcOperations)1 JdbcTemplate (org.springframework.jdbc.core.JdbcTemplate)1 NamedParameterJdbcOperations (org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations)1 NamedParameterJdbcTemplate (org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate)1 SimpleJdbcCall (org.springframework.jdbc.core.simple.SimpleJdbcCall)1 SimpleJdbcInsert (org.springframework.jdbc.core.simple.SimpleJdbcInsert)1 SimpleJdbcInsertOperations (org.springframework.jdbc.core.simple.SimpleJdbcInsertOperations)1 SimpleJdbcOperations (org.springframework.jdbc.core.simple.SimpleJdbcOperations)1 SimpleJdbcTemplate (org.springframework.jdbc.core.simple.SimpleJdbcTemplate)1