Android Open Source - DKO Tmp Table Builder

From Project

Back to project page DKO.
License

The source code is released under:
GNU Lesser General Public License
If you think the Android project DKO listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package org.kered.dko;
//from  w w w. j  a va2  s  . co  m
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

import javax.sql.DataSource;

import org.kered.dko.Field.FK;

class TmpTableBuilder {

  private final String tmpTableName = "NOSCO_"+ Math.round(Math.random() * Integer.MAX_VALUE);
  private final List<Field<?>> fields;
  private final List<Object[]> rows = new ArrayList<Object[]>();

  private final Table table = new Table() {

    @Override
    protected void __NOSCO_PRIVATE_preExecute(final SqlContext context, final Connection conn) throws SQLException {
      final StringBuilder sbCreate = new StringBuilder();
      if (context.dbType == Constants.DB_TYPE.SQLSERVER) {
        sbCreate.append("CREATE TABLE #"+ tmpTableName);
      } else {
        sbCreate.append("CREATE TABLE "+ tmpTableName);
      }
      sbCreate.append(" (");
      final StringBuilder sbPS = new StringBuilder();
      sbPS.append("insert into "+ tmpTableName +" values (");
      for (int i=0; i<fields.size(); ++i) {
        final Field<?> field = fields.get(i);
        sbCreate.append(field.NAME +" "+ field.SQL_TYPE +",");
        sbPS.append("?,");
      }
      sbCreate.delete(sbCreate.length()-1, sbCreate.length());
      sbCreate.append(")");
      sbPS.delete(sbPS.length()-1, sbPS.length());
      sbPS.append(")");
      Statement stmt = null;
      PreparedStatement ps = null;
      try {
        stmt = conn.createStatement();
        final String sqlCreate = sbCreate.toString();
        final String sqlPS = sbPS.toString();
        Util.log(sqlCreate, null);
        stmt.execute(sqlCreate);
        ps = conn.prepareStatement(sqlPS);
        int i = 0;
        int added = 0;
        for (final Object[] row : rows) {
          ++i;
          for (int j=0; j<row.length; ++j) {
            final Object t = row[j];
            Util.setBindingWithTypeFixes(ps, j+1, t);
          }
          ps.addBatch();
          if (i%64 == 0) for (final int x : ps.executeBatch()) added += x;
        }
        if (i%64 != 0) {
          for (final int x : ps.executeBatch()) {
            added += x;
          }
        }
        System.err.println("TmpTableBuilder added "+ added);
      } catch (final SQLException e) {
        throw e;
      } finally {
        try {
          if (stmt!=null && !stmt.isClosed()) stmt.close();
        } catch (final SQLException e) {
          e.printStackTrace();
        }
        try {
          if (ps!=null && !ps.isClosed()) ps.close();
        } catch (final SQLException e) {
          e.printStackTrace();
        }
      }



    }

    @Override
    protected void __NOSCO_PRIVATE_postExecute(final SqlContext context, final Connection conn) throws SQLException {
      if (context.dbType == Constants.DB_TYPE.HSQL) return;
      if (conn!=null && !conn.isClosed()) {
        Statement stmt = null;
        try {
          stmt = conn.createStatement();
          final String sql = "DROP TABLE "+ tmpTableName;
          Util.log(sql, null);
          stmt.execute(sql);
        } catch (final SQLException e) {
          throw e;
        } finally {
          try {
            if (stmt!=null && !stmt.isClosed()) stmt.close();
          } catch (final SQLException e) {
            e.printStackTrace();
          }
        }
      }
    }

    @Override
    public String SCHEMA_NAME() {
      return null;
    }

    @Override
    public String TABLE_NAME() {
      return tmpTableName;
    }

    @Override
    public List<Field<?>> fields() {
      return fields;
    }

    @Override
    protected FK[] FKS() {
      return new FK[0];
    }

    @Override
    public <S> S get(final Expression.Select<S> field) {
      // TODO Auto-generated method stub
      return null;
    }

    @Override
    public <S> Table set(final Expression.Select<S> field, final S value) {
      return this;
      // TODO Auto-generated method stub

    }

    @Override
    public boolean insert() throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean update() throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean delete() throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean save() throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean exists() throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean insert(final DataSource ds) throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean update(final DataSource ds) throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean delete(final DataSource ds) throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean save(final DataSource ds) throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    public boolean exists(final DataSource ds) throws SQLException {
      // TODO Auto-generated method stub
      return false;
    }

    @Override
    protected Object __NOSCO_PRIVATE_mapType(final Object o) {
      return null;
    }

  };

  TmpTableBuilder(final Field<?>... fields) {
    final List<Field<?>> tmp = new ArrayList<Field<?>>();
    for (final Field<?> f : fields) tmp.add(f);
    this.fields = Collections.unmodifiableList(tmp);
    final StringBuilder sb = new StringBuilder();
  }

  Table buildTable() {
    return table ;
  }

  void addRow(final Object... row) {
    rows.add(row);
  }

  void clear() {
    rows.clear();
  }

}
Java Source Code List
