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

  public OracleTypeHandler(DatabaseMetaData databaseMetaData) throws SQLException {
    super(databaseMetaData);
  }


  public Object transformInputValue(JdbcTemplate jdbcTemplate, SqlParameter sqlParameter, Object value){
    ConnectionCallback connectionCallback;


    switch (sqlParameter.getSqlType()){
      case Types.STRUCT:
      case Types.ARRAY:
        connectionCallback = new TransformInputConnectionCallback(sqlParameter, value);

View Full Code Here


    return value;
  }


  public Object transformOutputValue(JdbcTemplate jdbcTemplate, SqlParameter sqlParameter, Object value, Class<?> type) {
    ConnectionCallback connectionCallback;


    switch (sqlParameter.getSqlType()){
      case Types.STRUCT:
      case Types.ARRAY:
      case OracleTypes.CURSOR:

View Full Code Here

            getGeneratedKeyNames().length  + " columns specified: " + Arrays.asList(getGeneratedKeyNames()));
      }
      // This is a hack to be able to get the generated key from a database that doesn't support
      // get generated keys feature.  HSQL is one, PostgreSQL is another.  Has to be done with the same
      // connection.
      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

        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

        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

        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

        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

        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

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.