Examples of org.springframework.jdbc.core.ConnectionCallback

org.springframework.jdbc.core.ConnectionCallback
Generic callback interface for code that operates on a JDBC Connection. Allows to execute any number of operations on a single Connection, using any type and number of Statements.
This is particularly useful for delegating to existing data access code that expects a Connection to work on and throws SQLException. For newly written code, it is strongly recommended to use JdbcTemplate's more specific operations, for example a query or update variant. @author Juergen Hoeller @since 1.1.3 @see JdbcTemplate#execute(ConnectionCallback) @see JdbcTemplate#query @see JdbcTemplate#update

        HashMap keys = new HashMap(1);
        keys.put(getGeneratedKeyNames()[0], key);
        keyHolder.getKeyList().add(keys);
      }
      else {
        jdbcTemplate.execute(new ConnectionCallback() {
          public Object doInConnection(Connection con) throws SQLException, DataAccessException {
            // Do the insert
            PreparedStatement ps = null;
            try {
              ps = con.prepareStatement(getInsertString());

View Full Code Here

                return new MapMaker().makeComputingMap(new Function<DbMediaSource, DbDialect>() {


                    public DbDialect apply(final DbMediaSource source) {
                        DataSource dataSource = dataSourceService.getDataSource(pipelineId, source);
                        final JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
                        return (DbDialect) jdbcTemplate.execute(new ConnectionCallback() {


                            public Object doInConnection(Connection c) throws SQLException, DataAccessException {
                                DatabaseMetaData meta = c.getMetaData();
                                String databaseName = meta.getDatabaseProductName();
                                int databaseMajorVersion = meta.getDatabaseMajorVersion();

View Full Code Here

        this.transactionTemplate = new TransactionTemplate();
        transactionTemplate.setTransactionManager(new DataSourceTransactionManager(jdbcTemplate.getDataSource()));
        transactionTemplate.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRES_NEW);


        // 初始化一些数据
        jdbcTemplate.execute(new ConnectionCallback() {


            public Object doInConnection(Connection c) throws SQLException, DataAccessException {
                DatabaseMetaData meta = c.getMetaData();
                databaseName = meta.getDatabaseProductName();
                databaseMajorVersion = meta.getDatabaseMajorVersion();

View Full Code Here

        return findTable(jdbcTemplate, catalogName, schemaName, tableName, null);
    }


    public static Table findTable(final JdbcTemplate jdbcTemplate, final String catalogName, final String schemaName,
                                  final String tableName, final DdlUtilsFilter filter) throws Exception {
        return (Table) jdbcTemplate.execute(new ConnectionCallback() {


            public Object doInConnection(Connection con) throws SQLException, DataAccessException {
                Table table = null;
                DatabaseMetaDataWrapper metaData = new DatabaseMetaDataWrapper();

View Full Code Here

    @SuppressWarnings("unchecked")
    public static List<Table> findTables(final JdbcTemplate jdbcTemplate, final String catalogName,
                                         final String schemaName, final String tableNamePattern,
                                         final DdlUtilsFilter filter, final DdlTableNameFilter tableNameFilter)
                                                                                                               throws Exception {
        return (List<Table>) jdbcTemplate.execute(new ConnectionCallback() {


            public Object doInConnection(Connection con) throws SQLException, DataAccessException {
                List<Table> tables = new ArrayList<Table>();
                DatabaseMetaDataWrapper metaData = new DatabaseMetaDataWrapper();

View Full Code Here

        assertEquals(expected, actual);
    }


    @Test
    public void rollback() throws Exception {
        template.execute(new ConnectionCallback() {


            public Object doInConnection(Connection con) throws SQLException, DataAccessException {
                con.setAutoCommit(false);
                con.createStatement().execute("INSERT INTO test (a, b, c) VALUES (4, 5, 6)");
                con.rollback();

View Full Code Here

0 1

TOP

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

com.alibaba.otter.node.etl.common.db.dialect.AbstractDbDialect

com.alibaba.otter.node.etl.common.db.dialect.DbDialectFactory

com.alibaba.otter.shared.common.utils.meta.DdlUtils

com.taobao.datasource.resource.adapter.jdbc.local.LocalTxDataSourceHsqldbTest

org.skyway.spring.util.dao.call.oracle.OracleTypeHandler

org.springframework.jdbc.core.simple.AbstractJdbcInsert

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.