Package org.ujmp.jdbc.set
Class JDBCSetMatrix<V>
- All Implemented Interfaces:
Closeable
,Flushable
,Serializable
,AutoCloseable
,Cloneable
,Comparable<Matrix>
,Iterable<V>
,Collection<V>
,Set<V>
,HasMetaData
,BaseMatrix
,BooleanCalculations
,CanPerformCalculations
,DenseMatrix
,DenseMatrix2D
,DenseMatrixMultiD
,BasicDoubleCalculations
,DoubleCalculations
,BasicEntrywiseDoubleCalculations
,CreatorDoubleCalculations
,EntrywiseDoubleCalculations
,HyperbolicDoubleCalculations
,MiscEntrywiseDoubleCalculations
,RoundingDoubleCalculations
,TrigonometricDoubleCalculations
,DecompositionDoubleCalculations
,DiscretizeCalculations
,GeneralDoubleCalculations
,MiscGeneralDoubleCalculations
,MissingValueDoubleCalculations
,StatisticalDoubleCalculations
,BaseGenericMatrix<V>
,DenseGenericMatrix<V>
,DenseGenericMatrix2D<V>
,DenseGenericMatrixMultiD<V>
,GenericMatrix<V>
,GenericMatrix2D<V>
,GenericMatrixMultiD<V>
,SparseGenericMatrix<V>
,SparseGenericMatrix2D<V>
,SparseGenericMatrixMultiD<V>
,BaseMatrixProperties
,Clearable
,Conversions
,CoordinateFunctions
,CoreObject
,DistanceMeasures
,Erasable
,ExtendedMatrixProperties
,GettersAndSetters
,HasDescription
,HasGUIObject
,HasId
,HasLabel
,IntCalculations
,Matrix
,Matrix2D
,MatrixMultiD
,ObjectCalculations
,SetMatrix<V>
,SparseMatrix
,SparseMatrix2D
,SparseMatrixMultiD
,StringCalculations
public class JDBCSetMatrix<V>
extends AbstractSetMatrix<V>
implements Closeable, Erasable, Flushable
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate Connection
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private ResultSet
private PreparedStatement
private static final long
private boolean
private PreparedStatement
Fields inherited from class org.ujmp.core.AbstractMatrix
guiObject, size
Fields inherited from interface org.ujmp.core.BaseMatrix
ALL, COLUMN, LINK, NEW, NONE, ORIG, ROW, X, Y, Z
Fields inherited from interface org.ujmp.core.DenseMatrix
Factory
Fields inherited from interface org.ujmp.core.DenseMatrix2D
Factory
Fields inherited from interface org.ujmp.core.interfaces.HasDescription
DESCRIPTION
Fields inherited from interface org.ujmp.core.annotation.HasMetaData
DIMENSIONMETADATA
Fields inherited from interface org.ujmp.core.Matrix
chol, divideMatrix, divideScalar, eig, Factory, inv, lu, minusMatrix, minusScalar, mtimes, plusMatrix, plusScalar, qr, solve, svd, timesMatrix, timesScalar, transpose
Fields inherited from interface org.ujmp.core.SparseMatrix
Factory
Fields inherited from interface org.ujmp.core.SparseMatrix2D
Factory
-
Constructor Summary
ConstructorsModifierConstructorDescriptionprivate
private
JDBCSetMatrix
(Connection connection, String tableName, String columnName) -
Method Summary
Modifier and TypeMethodDescriptionprotected boolean
protected void
protected void
protected final void
clearSet()
final void
close()
static <V> JDBCSetMatrix<V>
static <V> JDBCSetMatrix<V>
connectToDerby
(File folderName) static <V> JDBCSetMatrix<V>
connectToDerby
(File folderName, String tableName) static <V> JDBCSetMatrix<V>
static <V> JDBCSetMatrix<V>
connectToH2
(File file) static <V> JDBCSetMatrix<V>
connectToH2
(File file, String tableName) static <V> JDBCSetMatrix<V>
static <V> JDBCSetMatrix<V>
connectToHSQLDB
(File fileName) static <V> JDBCSetMatrix<V>
connectToHSQLDB
(File fileName, String tableName) static <V> JDBCSetMatrix<V>
connectToHSQLDB
(File fileName, String userName, String password, String tableName) static <V> JDBCSetMatrix<V>
connectToHSQLDB
(File fileName, String userName, String password, String tableName, String columnName) static <V> JDBCSetMatrix<V>
connectToMySQL
(String serverName, int port, String userName, String password, String databaseName, String tableName) static <V> JDBCSetMatrix<V>
connectToMySQL
(String serverName, int port, String username, String password, String databaseName, String tableName, String columnName) static <V> JDBCSetMatrix<V>
static <V> JDBCSetMatrix<V>
connectToSQLite
(File file) static <V> JDBCSetMatrix<V>
connectToSQLite
(File file, String tableName) boolean
private final void
createTable
(String tableName, String columnName) final void
erase()
void
flush()
final Connection
final String
final Class<?>
final String
final SQLUtil.SQLDialect
final String
final String
getURL()
iterator()
protected final boolean
removeFromSet
(Object key) final int
size()
Methods inherited from class org.ujmp.core.setmatrix.AbstractSetMatrix
add, addAll, clear, containsAll, getObject, getObject, getSize, isEmpty, remove, removeAll, retainAll, setObject, toArray, toArray
Methods inherited from class org.ujmp.core.genericmatrix.stub.AbstractDenseGenericMatrix2D
getDimensionCount, getObject, setObject
Methods inherited from class org.ujmp.core.genericmatrix.stub.AbstractDenseGenericMatrix
availableCoordinates, containsCoordinates, isSparse
Methods inherited from class org.ujmp.core.genericmatrix.stub.AbstractGenericMatrix
getAsObject, setAsObject, setObject
Methods inherited from class org.ujmp.core.AbstractMatrix
abs, addMissing, allCoordinates, allValues, and, and, append, appendHorizontally, appendVertically, atimes, bigDecimalValue, bigIntegerValue, booleanValue, bootstrap, bootstrap, ceil, center, charValue, chebyshevDistanceTo, chol, clone, compareTo, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, convert, convertEncoding, corrcoef, cos, cosh, cosineSimilarity, cosineSimilarityTo, countMissing, cov, cumprod, cumsum, dateValue, delete, delete, delete, deleteColumns, deleteColumns, deleteColumnsWithMissingValues, deleteRows, deleteRows, deleteRowsWithMissingValues, det, diag, diff, discretize, discretize, discretizeToBoolean, discretizeToColumns, divide, divide, divide, divide, doubleValue, eig, eigSymm, eq, eq, equals, equalsAnnotation, equalsContent, euklideanDistance, euklideanDistanceTo, exp, exportTo, extractAnnotation, eye, fadeIn, fadeOut, fill, fireValueChanged, fireValueChanged, fireValueChanged, flipdim, floatValue, floor, ge, ge, getAbsoluteValueMean, getAbsoluteValueSum, getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsByteArray, getAsChar, getAsDate, getAsDouble, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsShort, getAsString, getColumnCount, getColumnForLabel, getColumnLabel, getColumnList, getCoordinatesOfMaximum, getCoordinatesOfMinimum, getCoreObjectId, getDescription, getDimensionLabel, getDimensionMetaData, getEuklideanValue, getFactory, getGUIObject, getId, getLabel, getLabelObject, getMaxValue, getMeanValue, getMetaData, getMetaData, getMetaDataDimensionMatrix, getMetaDataDouble, getMetaDataMatrix, getMetaDataString, getMinValue, getPositionForLabel, getPreferredObject, getRMS, getRowCount, getRowForLabel, getRowLabel, getRowList, getSize, getStdValue, getValueCount, getValueSum, getValueType, getZCount, ginv, grayScale, gt, gt, importFrom, impute, includeAnnotation, indexOfMax, indexOfMin, intValue, inv, invSPD, invSymm, isColumnVector, isDiagonal, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSPD, isSquare, isSymmetric, isTransient, le, le, log, log10, log2, logistic, longValue, lowerCase, lt, lt, lu, manhattenDistance, manhattenDistanceTo, max, mean, min, minkowskiDistance, minkowskiDistanceTo, minus, minus, minus, minus, mtimes, mtimes, mutualInf, nans, ne, ne, nonZeroCoordinates, norm1, norm2, normalize, normF, normInf, not, ones, or, or, pairedTTest, pdet, pinv, pinv, plus, plus, plus, plus, power, power, princomp, prod, qr, rand, randn, rank, removePunctuation, removeWords, replace, replaceMissingBy, replaceRegex, replaceRegex, reshape, round, save, save, select, select, select, selectColumns, selectColumns, selectedCoordinates, selectedCoordinates, selectRows, selectRows, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsByteArray, setAsChar, setAsDate, setAsDouble, setAsFloat, setAsInt, setAsLong, setAsMatrix, setAsShort, setAsString, setColumnLabel, setContent, setDescription, setDimensionLabel, setDimensionMetaData, setId, setLabel, setMetaData, setMetaData, setMetaDataDimensionMatrix, setRowLabel, setSize, share, share, showGUI, shuffle, sign, sin, sinh, solve, solveSPD, solveSymm, sortrows, sqrt, squeeze, standardize, std, stem, stringValue, subMatrix, sum, svd, svd, swap, tan, tanh, tanh, tfIdf, times, times, times, times, toBigDecimalArray, toBigDecimalMatrix, toBigIntegerArray, toBigIntegerMatrix, toBooleanArray, toBooleanMatrix, toByteArray, toByteMatrix, toCharArray, toCharMatrix, toColumnVector, toDateArray, toDoubleArray, toDoubleMatrix, toFloatArray, toFloatMatrix, toHtml, toIntArray, toIntMatrix, toListMatrix, toLongArray, toLongMatrix, toMapMatrix, toObjectArray, toObjectMatrix, toRowVector, toSetMatrix, toShortArray, toShortMatrix, toString, toStringArray, toStringMatrix, trace, translate, 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.BaseMatrix
getFactory
Methods inherited from interface org.ujmp.core.interfaces.BaseMatrixProperties
allValues, equals, equalsAnnotation, equalsContent, getColumnCount, getColumnList, getDimensionCount, getRowCount, getRowList, getSize, getValueCount, getValueType, getZCount, isColumnVector, isDiagonal, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSparse, isSquare, isSymmetric, isTransient, setSize, toString
Methods inherited from interface org.ujmp.core.doublematrix.calculation.basic.BasicDoubleCalculations
atimes, divide, divide, divide, divide, minus, minus, minus, minus, 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, logistic, power, power, sign, sqrt
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 java.util.Collection
parallelStream, removeIf, stream, toArray
Methods inherited from interface java.lang.Comparable
compareTo
Methods inherited from interface org.ujmp.core.interfaces.Conversions
toBigDecimalMatrix, toBigIntegerMatrix, toBooleanMatrix, toByteMatrix, toCharMatrix, toDoubleMatrix, toFloatMatrix, toIntMatrix, toListMatrix, toLongMatrix, toMapMatrix, toObjectMatrix, toSetMatrix, toShortMatrix, toStringMatrix
Methods inherited from interface org.ujmp.core.interfaces.CoordinateFunctions
allCoordinates, availableCoordinates, containsCoordinates, getCoordinatesOfMaximum, getCoordinatesOfMinimum, nonZeroCoordinates, selectedCoordinates, selectedCoordinates
Methods inherited from interface org.ujmp.core.interfaces.CoreObject
getCoreObjectId
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.creators.CreatorDoubleCalculations
eye, nans, ones, rand, randn, zeros
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.decomposition.DecompositionDoubleCalculations
chol, eig, eigSymm, ginv, inv, invSPD, invSymm, lu, pinv, pinv, princomp, qr, solve, solveSPD, solveSymm, svd, svd
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.discretize.DiscretizeCalculations
discretize, discretize, discretizeToBoolean, discretizeToColumns
Methods inherited from interface org.ujmp.core.interfaces.DistanceMeasures
chebyshevDistanceTo, cosineSimilarity, cosineSimilarityTo, euklideanDistance, euklideanDistanceTo, manhattenDistance, manhattenDistanceTo, minkowskiDistance, minkowskiDistanceTo
Methods inherited from interface org.ujmp.core.interfaces.ExtendedMatrixProperties
bigDecimalValue, bigIntegerValue, booleanValue, byteValue, charValue, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, dateValue, det, doubleValue, floatValue, getAbsoluteValueMean, getAbsoluteValueSum, getEuklideanValue, getMaxValue, getMeanValue, getMinValue, getRMS, getStdValue, getValueSum, intValue, isSPD, longValue, norm1, norm2, normF, normInf, pdet, rank, setContent, shortValue, stringValue, trace
Methods inherited from interface org.ujmp.core.genericmatrix.GenericMatrix2D
setObject
Methods inherited from interface org.ujmp.core.interfaces.GettersAndSetters
getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsByteArray, getAsChar, getAsDate, getAsDouble, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsObject, getAsShort, getAsString, getPreferredObject, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsByteArray, 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.HasDescription
getDescription, setDescription
Methods inherited from interface org.ujmp.core.interfaces.HasGUIObject
getGUIObject, showGUI
Methods inherited from interface org.ujmp.core.interfaces.HasLabel
getLabel, getLabelObject, setLabel
Methods inherited from interface org.ujmp.core.annotation.HasMetaData
getColumnForLabel, getColumnLabel, getDimensionLabel, getDimensionMetaData, getMetaData, getMetaData, getMetaDataDimensionMatrix, getMetaDataDouble, getMetaDataMatrix, getMetaDataString, getPositionForLabel, getRowForLabel, getRowLabel, setColumnLabel, setDimensionLabel, setDimensionMetaData, setMetaData, setMetaData, setMetaDataDimensionMatrix, setRowLabel
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.hyperbolic.HyperbolicDoubleCalculations
cosh, sinh, tanh, tanh
Methods inherited from interface org.ujmp.core.Matrix
clone, exportTo, fireValueChanged, fireValueChanged, fireValueChanged, importFrom, save, save, share, share, toHtml
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.misc.MiscEntrywiseDoubleCalculations
grayScale
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.missingvalues.MissingValueDoubleCalculations
addMissing, countMissing, deleteColumnsWithMissingValues, deleteRowsWithMissingValues, impute
Methods inherited from interface org.ujmp.core.objectmatrix.calculation.ObjectCalculations
bootstrap, bootstrap, convert, delete, delete, delete, deleteColumns, deleteColumns, deleteRows, deleteRows, diag, 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.doublematrix.calculation.entrywise.rounding.RoundingDoubleCalculations
ceil, floor, round
Methods inherited from interface java.util.Set
equals, hashCode, spliterator
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.stringmatrix.calculation.StringCalculations
convertEncoding, lowerCase, removePunctuation, removeWords, replaceRegex, replaceRegex, stem, tfIdf, translate, upperCase
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.trigonometric.TrigonometricDoubleCalculations
cos, sin, tan
-
Field Details
-
serialVersionUID
private static final long serialVersionUID- See Also:
-
tableExists
private boolean tableExists -
connection
-
resultSet
-
truncateTableStatement
-
insertStatement
-
deleteStatement
-
containsKeyStatement
-
countStatement
-
selectAllStatement
-
dropTableStatement
-
-
Constructor Details
-
JDBCSetMatrix
private JDBCSetMatrix(String url, String username, String password, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
JDBCSetMatrix
private JDBCSetMatrix(Connection connection, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
-
Method Details
-
connectToDerby
- Throws:
SQLException
IOException
-
connectToDerby
- Throws:
SQLException
-
connectToDerby
public static <V> JDBCSetMatrix<V> connectToDerby(File folderName, String tableName) throws SQLException - Throws:
SQLException
-
connectToH2
- Throws:
SQLException
IOException
-
connectToH2
- Throws:
SQLException
-
connectToH2
- Throws:
SQLException
-
connectToSQLite
- Throws:
SQLException
IOException
-
connectToSQLite
- Throws:
SQLException
-
connectToSQLite
- Throws:
SQLException
-
connectToMySQL
public static <V> JDBCSetMatrix<V> connectToMySQL(String serverName, int port, String username, String password, String databaseName, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
connectToMySQL
public static <V> JDBCSetMatrix<V> connectToMySQL(String serverName, int port, String userName, String password, String databaseName, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
- Throws:
SQLException
IOException
-
connectToHSQLDB
- Throws:
SQLException
-
connectToHSQLDB
public static <V> JDBCSetMatrix<V> connectToHSQLDB(File fileName, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
public static <V> JDBCSetMatrix<V> connectToHSQLDB(File fileName, String userName, String password, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
public static <V> JDBCSetMatrix<V> connectToHSQLDB(File fileName, String userName, String password, String tableName, String columnName) throws SQLException - Throws:
SQLException
-
getConnection
-
getURL
-
getTableName
-
getDatabaseName
-
getKeyClass
-
getKeyColumnName
-
getSQLDialect
-
clearSet
protected final void clearSet()- Specified by:
clearSet
in classAbstractSetMatrix<V>
-
removeFromSet
- Specified by:
removeFromSet
in classAbstractSetMatrix<V>
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceCloseable
- Throws:
IOException
-
erase
- Specified by:
erase
in interfaceErasable
- Throws:
IOException
-
addToSet
- Specified by:
addToSet
in classAbstractSetMatrix<V>
-
contains
-
beforeWriteObject
- Throws:
IOException
-
beforeReadObject
- Throws:
IOException
ClassNotFoundException
-
flush
- Specified by:
flush
in interfaceFlushable
- Throws:
IOException
-
createTable
- Throws:
SQLException
-
size
public final int size() -
iterator
-