org.ujmp.jdbc
Class AbstractDenseJDBCMatrix2D

java.lang.Object
  extended by java.lang.Number
      extended by org.ujmp.core.matrix.AbstractMatrix
          extended by org.ujmp.core.genericmatrix.stub.AbstractGenericMatrix<Object>
              extended by org.ujmp.core.objectmatrix.stub.AbstractObjectMatrix
                  extended by org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix
                      extended by org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
                          extended by org.ujmp.jdbc.AbstractDenseJDBCMatrix2D
All Implemented Interfaces:
Closeable, Serializable, Cloneable, Comparable<Matrix>, HasAnnotation, BooleanCalculations, CanPerformCalculations, BasicDoubleCalculations, DoubleCalculations, BasicEntrywiseDoubleCalculations, CreatorDoubleCalculations, EntrywiseDoubleCalculations, HyperbolicDoubleCalculations, MiscEntrywiseDoubleCalculations, RoundingDoubleCalculations, TrigonometricDoubleCalculations, DecompositionDoubleCalculations, DiscretizeCalculations, GeneralDoubleCalculations, MiscGeneralDoubleCalculations, MissingValueDoubleCalculations, StatisticalDoubleCalculations, GenericMatrix<Object>, GenericMatrix2D<Object>, BasicMatrixProperties, Clearable, Conversions, CoordinateFunctions, CoreObject, DistanceMeasures, GettersAndSetters, HasGUIObject, HasLabel, IntCalculations, ExportMatrixInterface, Matrix, DenseMatrix, DenseMatrix2D, Matrix2D, ObjectCalculations, DenseObjectMatrix, DenseObjectMatrix2D, ObjectMatrix, ObjectMatrix2D, StringCalculations
Direct Known Subclasses:
DenseDerbyMatrix2D, DenseHSQLDBMatrix2D, DenseMySQLMatrix2D, DensePostgreSQLMatrix2D

public abstract class AbstractDenseJDBCMatrix2D
extends AbstractDenseObjectMatrix2D
implements Closeable

See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from interface org.ujmp.core.Matrix
Matrix.StorageType
 
Field Summary
 
Fields inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
factory
 
Fields inherited from interface org.ujmp.core.Matrix
ALL, chol, COLUMN, divideMatrix, divideScalar, eig, inv, LINK, lu, minusMatrix, minusScalar, mtimes, NEW, NONE, ORIG, plusMatrix, plusScalar, qr, ROW, solve, svd, timesMatrix, timesScalar, transpose, X, Y, Z
 
Constructor Summary
AbstractDenseJDBCMatrix2D(String url, String sqlStatement, String username, String password)
           
 
Method Summary
 void close()
           
 Connection getConnection(int id)
           
 Object getObject(int row, int column)
           
 Object getObject(long row, long column)
           
 String getPassword()
           
 ResultSet getResultSet(long row)
           
 PreparedStatement getSelectStatement()
           
 String getSelectString()
           
 long[] getSize()
           
 String getSQLStatement()
           
 String getUrl()
           
 String getUsername()
           
 void setObject(Object value, int row, int column)
           
 void setObject(Object value, long row, long column)
           
 
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
allCoordinates, getFactory, getObject, setObject
 
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix
contains, getStorageType
 
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractObjectMatrix
getAsDouble, getValueType, setAsDouble
 
Methods inherited from class org.ujmp.core.genericmatrix.stub.AbstractGenericMatrix
getAsObject, setAsObject
 
Methods inherited from class org.ujmp.core.matrix.AbstractMatrix
abs, addMissing, allValues, and, and, append, appendHorizontally, appendVertically, atimes, availableCoordinates, bigDecimalValue, bigIntegerValue, booleanValue, bootstrap, bootstrap, ceil, center, charValue, chebyshevDistanceTo, chol, clear, clone, compareTo, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, convert, copy, corrcoef, cos, cosh, countMissing, cov, cumprod, cumsum, dateValue, delete, delete, delete, deleteColumns, deleteColumns, deleteColumnsWithMissingValues, deleteRows, deleteRows, deleteRowsWithMissingValues, det, diff, discretize, discretizeToColumns, divide, divide, divide, divide, doubleValue, eig, eigSymm, eq, eq, equals, equalsAnnotation, equalsContent, euklideanDistanceTo, exp, exportToClipboard, exportToFile, exportToFile, exportToFile, exportToFile, exportToStream, exportToString, exportToWriter, extractAnnotation, eye, fadeIn, fadeOut, fill, flipdim, floatValue, floor, ge, ge, getAbsoluteValueMean, getAbsoluteValueSum, getAnnotation, getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsChar, getAsDate, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsShort, getAsString, getAxisAnnotation, getAxisAnnotation, getColumnCount, getColumnForLabel, getColumnLabel, getColumnObject, getCoordinatesOfMaximum, getCoordinatesOfMinimum, getCoreObjectId, getDimensionCount, getEuklideanValue, getGUIObject, getLabel, getMatrixAnnotation, getMaxValue, getMeanValue, getMinValue, getPositionForLabel, getPreferredObject, getRMS, getRowCount, getRowForLabel, getRowLabel, getRowObject, getSize, getStdValue, getValueCount, getValueSum, getZCount, ginv, gt, gt, impute, includeAnnotation, indexOfMax, indexOfMin, intValue, inv, invSPD, invSymm, isColumnVector, isDiagonal, isEmpty, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSparse, isSPD, isSquare, isSymmetric, isTransient, le, le, log, log10, log2, longValue, lowerCase, lt, lt, lu, manhattenDistanceTo, max, mean, min, minkowskiDistanceTo, minus, minus, minus, minus, mtimes, mtimes, mtimes, mtimes, mutualInf, ne, ne, nonZeroCoordinates, norm1, norm2, normalize, normF, normInf, not, notifyGUIObject, ones, or, or, pairedTTest, pinv, plus, plus, plus, plus, power, power, princomp, prod, qr, rand, randn, rank, removePunctuation, removeWords, replace, replaceMissingBy, replaceRegex, replaceRegex, reshape, round, select, select, select, selectColumns, selectColumns, selectedCoordinates, selectedCoordinates, selectRows, selectRows, setAnnotation, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsChar, setAsDate, setAsFloat, setAsInt, setAsLong, setAsMatrix, setAsShort, setAsString, setAxisAnnotation, setAxisAnnotation, setColumnLabel, setColumnObject, setLabel, setMatrixAnnotation, setRowLabel, setRowObject, setSize, showGUI, shuffle, sign, sin, sinh, solve, solveSPD, solveSymm, sortrows, sqrt, squeeze, standardize, std, stem, stringValue, subMatrix, sum, svd, swap, tan, tanh, tfIdf, times, times, times, times, toBigDecimalArray, toBigDecimalMatrix, toBigIntegerArray, toBigIntegerMatrix, toBooleanArray, toBooleanMatrix, toByteArray, toByteMatrix, toCharArray, toCharMatrix, toColumnVector, toDateArray, toDateMatrix, toDoubleArray, toDoubleMatrix, toFloatArray, toFloatMatrix, toIntArray, toIntMatrix, toListMatrix, toLongArray, toLongMatrix, toMapMatrix, toObjectArray, toObjectMatrix, toRowVector, toSetMatrix, toShortArray, toShortMatrix, toString, toStringArray, toStringMatrix, trace, transpose, transpose, transpose, tril, triu, unique, uniqueValueCount, upperCase, var, xor, xor, zeros
 
Methods inherited from class java.lang.Number
byteValue, shortValue
 
Methods inherited from class java.lang.Object
finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface org.ujmp.core.Matrix
clone
 
Methods inherited from interface org.ujmp.core.interfaces.CoreObject
getCoreObjectId
 
Methods inherited from interface org.ujmp.core.interfaces.Clearable
clear
 
Methods inherited from interface org.ujmp.core.interfaces.HasGUIObject
getGUIObject, notifyGUIObject, showGUI
 
Methods inherited from interface org.ujmp.core.interfaces.HasLabel
getLabel, setLabel
 
Methods inherited from interface org.ujmp.core.io.ExportMatrixInterface
exportToClipboard, exportToFile, exportToFile, exportToFile, exportToFile, exportToStream, exportToString, exportToWriter
 
Methods inherited from interface org.ujmp.core.interfaces.CoordinateFunctions
availableCoordinates, contains, getCoordinatesOfMaximum, getCoordinatesOfMinimum, nonZeroCoordinates, selectedCoordinates, selectedCoordinates
 
Methods inherited from interface org.ujmp.core.interfaces.GettersAndSetters
getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsChar, getAsDate, getAsDouble, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsObject, getAsShort, getAsString, getPreferredObject, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsChar, setAsDate, setAsDouble, setAsFloat, setAsInt, setAsLong, setAsMatrix, setAsObject, setAsShort, setAsString, toBigDecimalArray, toBigIntegerArray, toBooleanArray, toByteArray, toCharArray, toDateArray, toDoubleArray, toFloatArray, toIntArray, toLongArray, toObjectArray, toShortArray, toStringArray
 
Methods inherited from interface org.ujmp.core.interfaces.BasicMatrixProperties
allValues, bigDecimalValue, bigIntegerValue, booleanValue, byteValue, charValue, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, dateValue, det, doubleValue, equals, equalsAnnotation, equalsContent, floatValue, getAbsoluteValueMean, getAbsoluteValueSum, getColumnCount, getDimensionCount, getEuklideanValue, getMaxValue, getMeanValue, getMinValue, getRMS, getRowCount, getSize, getStdValue, getStorageType, getValueCount, getValueSum, getValueType, getZCount, intValue, isColumnVector, isDiagonal, isEmpty, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSparse, isSPD, isSquare, isSymmetric, isTransient, longValue, norm1, norm2, normF, normInf, rank, setSize, shortValue, stringValue, toString, trace
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.basic.BasicDoubleCalculations
atimes, divide, divide, divide, divide, minus, minus, minus, minus, mtimes, mtimes, mtimes, mtimes, plus, plus, plus, plus, times, times, times, times
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.basic.BasicEntrywiseDoubleCalculations
abs, exp, log, log10, log2, power, power, sign, sqrt
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.rounding.RoundingDoubleCalculations
ceil, floor, round
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.hyperbolic.HyperbolicDoubleCalculations
cosh, sinh, tanh
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.trigonometric.TrigonometricDoubleCalculations
cos, sin, tan
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.creators.CreatorDoubleCalculations
eye, ones, rand, randn, zeros
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.statistical.StatisticalDoubleCalculations
corrcoef, cov, cumprod, cumsum, diff, indexOfMax, indexOfMin, max, mean, min, mutualInf, pairedTTest, prod, std, sum, var
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.decomposition.DecompositionDoubleCalculations
chol, eig, eigSymm, ginv, inv, invSPD, invSymm, lu, pinv, princomp, qr, solve, solveSPD, solveSymm, svd
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.missingvalues.MissingValueDoubleCalculations
addMissing, countMissing, deleteColumnsWithMissingValues, deleteRowsWithMissingValues, impute
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.misc.MiscGeneralDoubleCalculations
append, appendHorizontally, appendVertically, center, fadeIn, fadeOut, normalize, replaceMissingBy, standardize
 
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.discretize.DiscretizeCalculations
discretizeToColumns
 
Methods inherited from interface org.ujmp.core.booleanmatrix.calculation.BooleanCalculations
and, and, eq, eq, ge, ge, gt, gt, le, le, lt, lt, ne, ne, not, or, or, xor, xor
 
Methods inherited from interface org.ujmp.core.intmatrix.calculation.IntCalculations
discretize
 
Methods inherited from interface org.ujmp.core.stringmatrix.calculation.StringCalculations
lowerCase, removePunctuation, removeWords, replaceRegex, replaceRegex, stem, tfIdf, upperCase
 
Methods inherited from interface org.ujmp.core.objectmatrix.calculation.ObjectCalculations
bootstrap, bootstrap, convert, copy, delete, delete, delete, deleteColumns, deleteColumns, deleteRows, deleteRows, extractAnnotation, fill, flipdim, includeAnnotation, replace, reshape, select, select, select, selectColumns, selectColumns, selectRows, selectRows, shuffle, sortrows, squeeze, subMatrix, swap, toColumnVector, toRowVector, transpose, transpose, transpose, tril, triu, unique, uniqueValueCount
 
Methods inherited from interface org.ujmp.core.interfaces.DistanceMeasures
chebyshevDistanceTo, euklideanDistanceTo, manhattenDistanceTo, minkowskiDistanceTo
 
Methods inherited from interface java.lang.Comparable
compareTo
 
Methods inherited from interface org.ujmp.core.annotation.HasAnnotation
getAnnotation, getAxisAnnotation, getAxisAnnotation, getColumnForLabel, getColumnLabel, getColumnObject, getMatrixAnnotation, getPositionForLabel, getRowForLabel, getRowLabel, getRowObject, setAnnotation, setAxisAnnotation, setAxisAnnotation, setColumnLabel, setColumnObject, setMatrixAnnotation, setRowLabel, setRowObject
 
Methods inherited from interface org.ujmp.core.interfaces.Conversions
toBigDecimalMatrix, toBigIntegerMatrix, toBooleanMatrix, toByteMatrix, toCharMatrix, toDateMatrix, toDoubleMatrix, toFloatMatrix, toIntMatrix, toListMatrix, toLongMatrix, toMapMatrix, toObjectMatrix, toSetMatrix, toShortMatrix, toStringMatrix
 

Constructor Detail

AbstractDenseJDBCMatrix2D

public AbstractDenseJDBCMatrix2D(String url,
                                 String sqlStatement,
                                 String username,
                                 String password)
Method Detail

getSQLStatement

public String getSQLStatement()

getObject

public Object getObject(long row,
                        long column)
Specified by:
getObject in interface GenericMatrix2D<Object>
Specified by:
getObject in interface ObjectMatrix2D

getObject

public Object getObject(int row,
                        int column)
Specified by:
getObject in interface GenericMatrix2D<Object>
Specified by:
getObject in interface ObjectMatrix2D

getSelectString

public final String getSelectString()

setObject

public void setObject(Object value,
                      long row,
                      long column)
Specified by:
setObject in interface GenericMatrix2D<Object>
Specified by:
setObject in interface ObjectMatrix2D

setObject

public void setObject(Object value,
                      int row,
                      int column)
Specified by:
setObject in interface GenericMatrix2D<Object>
Specified by:
setObject in interface ObjectMatrix2D

getSize

public long[] getSize()
Specified by:
getSize in interface BasicMatrixProperties

close

public void close()
           throws IOException
Specified by:
close in interface Closeable
Throws:
IOException

getResultSet

public ResultSet getResultSet(long row)
                       throws SQLException
Throws:
SQLException

getSelectStatement

public PreparedStatement getSelectStatement()
                                     throws SQLException
Throws:
SQLException

getConnection

public Connection getConnection(int id)
                         throws SQLException
Throws:
SQLException

getUrl

public String getUrl()

getUsername

public String getUsername()

getPassword

public String getPassword()


Copyright © 2010. All Rights Reserved.