protected int executePrepare(Table table,List<Column> columns,String SQL,boolean keep,int type) throws SQLException {
  int bindNo=1;
  PreparedStatement statement=null;
  int affectedRows=0;
  try {
    statement=dbConn.prepareStatement(SQL);
    for (    Column c : columns) {
      setColumnValue(statement,bindNo,c);
      bindNo++;
    }
    affectedRows=statement.executeUpdate();
  }
  finally {
    if (statement != null && !keep) {
      statement.close();
      statement=null;
    }
  }
  if (keep && type > -1)   table.setStatement(type,statement);
  return affectedRows;
}

protected int executePrepare ( Table table , List < Column > columns , String SQL , boolean keep , int type ) throws SQLException { int bindNo = 1 ; PreparedStatement statement = null ; int affectedRows = 0 ; try { statement = dbConn . prepareStatement ( SQL ) ; for ( Column c : columns ) { setColumnValue ( statement , bindNo , c ) ; bindNo ++ ; } affectedRows = statement . executeUpdate ( ) ; } finally { if ( statement != null && ! keep ) { statement . close ( ) ; statement = null ; } } if ( keep && type > - 1 ) table . setStatement ( type , statement ) ; return affectedRows ; }
executes a prepared statement using values supplied as arguments .
