Package org.ujmp.jdbc.map
Class JDBCMapMatrix<K,V>
java.lang.Object
- All Implemented Interfaces:
Closeable
,Flushable
,Serializable
,AutoCloseable
,Cloneable
,Comparable<Matrix>
,Map<K,
,V> HasMetaData
,BaseMatrix
,BooleanCalculations
,CanPerformCalculations
,DenseMatrix
,DenseMatrix2D
,DenseMatrixMultiD
,BasicDoubleCalculations
,DoubleCalculations
,BasicEntrywiseDoubleCalculations
,CreatorDoubleCalculations
,EntrywiseDoubleCalculations
,HyperbolicDoubleCalculations
,MiscEntrywiseDoubleCalculations
,RoundingDoubleCalculations
,TrigonometricDoubleCalculations
,DecompositionDoubleCalculations
,DiscretizeCalculations
,GeneralDoubleCalculations
,MiscGeneralDoubleCalculations
,MissingValueDoubleCalculations
,StatisticalDoubleCalculations
,BaseGenericMatrix<Object>
,DenseGenericMatrix<Object>
,DenseGenericMatrix2D<Object>
,DenseGenericMatrixMultiD<Object>
,GenericMatrix<Object>
,GenericMatrix2D<Object>
,GenericMatrixMultiD<Object>
,SparseGenericMatrix<Object>
,SparseGenericMatrix2D<Object>
,SparseGenericMatrixMultiD<Object>
,BaseMatrixProperties
,Clearable
,Conversions
,CoordinateFunctions
,CoreObject
,DistanceMeasures
,Erasable
,ExtendedMatrixProperties
,GettersAndSetters
,HasDescription
,HasGUIObject
,HasId
,HasLabel
,IntCalculations
,MapMatrix<K,
,V> Matrix
,Matrix2D
,MatrixMultiD
,BaseObjectMatrix
,ObjectCalculations
,DenseObjectMatrix
,DenseObjectMatrix2D
,DenseObjectMatrixMultiD
,ObjectMatrix
,ObjectMatrix2D
,ObjectMatrixMultiD
,SparseObjectMatrix
,SparseObjectMatrix2D
,SparseObjectMatrixMultiD
,SparseMatrix
,SparseMatrix2D
,SparseMatrixMultiD
,StringCalculations
public class JDBCMapMatrix<K,V>
extends AbstractMapMatrix<K,V>
implements Closeable, Erasable, Flushable
- See Also:
-
Nested Class Summary
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate Connection
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private PreparedStatement
private ResultSet
private PreparedStatement
private static final long
private boolean
private PreparedStatement
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.objectmatrix.DenseObjectMatrix2D
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.objectmatrix.ObjectMatrix
Factory
Fields inherited from interface org.ujmp.core.SparseMatrix
Factory
Fields inherited from interface org.ujmp.core.SparseMatrix2D
Factory
-
Constructor Summary
ConstructorsModifierConstructorDescriptionprivate
JDBCMapMatrix
(String url, String username, String password, String tableName, String keyColumnName, String valueColumnName) private
JDBCMapMatrix
(Connection connection, String tableName, String keyColumnName, String valueColumnName) -
Method Summary
Modifier and TypeMethodDescriptionprotected void
protected void
protected final void
clearMap()
final void
close()
static <K,
V> JDBCMapMatrix<K, V> static <K,
V> JDBCMapMatrix<K, V> connect
(String url, String userName, String password, String tableName, String keyColumnName, String valueColumnName) static <K,
V> JDBCMapMatrix<K, V> connect
(Connection connection, String tableName, String keyColumnName, String valueColumnName) static <K,
V> JDBCMapMatrix<K, V> static <K,
V> JDBCMapMatrix<K, V> connectToDerby
(File folderName) static <K,
V> JDBCMapMatrix<K, V> connectToDerby
(File folderName, String tableName) static <K,
V> JDBCMapMatrix<K, V> static <K,
V> JDBCMapMatrix<K, V> connectToH2
(File file) static <K,
V> JDBCMapMatrix<K, V> connectToH2
(File file, String tableName) static <K,
V> JDBCMapMatrix<K, V> static <K,
V> JDBCMapMatrix<K, V> connectToHSQLDB
(File file) static <K,
V> JDBCMapMatrix<K, V> connectToHSQLDB
(File file, String tableName) static <K,
V> JDBCMapMatrix<K, V> connectToHSQLDB
(File file, String userName, String password, String tableName) static <K,
V> JDBCMapMatrix<K, V> connectToHSQLDB
(File file, String userName, String password, String tableName, String keyColumnName, String valueColumnName) static <K,
V> JDBCMapMatrix<K, V> connectToMySQL
(String serverName, int port, String userName, String password, String databaseName, String tableName) static <K,
V> JDBCMapMatrix<K, V> connectToMySQL
(String serverName, int port, String username, String password, String databaseName, String tableName, String columnForKeys, String columnForValues) static <K,
V> JDBCMapMatrix<K, V> static <K,
V> JDBCMapMatrix<K, V> connectToSQLite
(File file) static <K,
V> JDBCMapMatrix<K, V> connectToSQLite
(File file, String tableName) final boolean
containsKey
(Object key) final boolean
containsValue
(Object value) private final void
createTable
(String tableName, String keyColumnName, String valueColumnName) final void
erase()
void
flush()
final V
final Connection
final String
final Class<?>
final String
final SQLUtil.SQLDialect
final String
final String
getURL()
final Class<?>
final String
keySet()
protected final V
putIntoMap
(K key, V value) protected final V
removeFromMap
(Object key) final int
size()
Methods inherited from class org.ujmp.core.mapmatrix.AbstractMapMatrix
clear, clone, entrySet, getAsString, getObject, getObject, getSize, indexOfKey, isEmpty, put, putAll, remove, setObject, setObject, values
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
getDimensionCount, getObject, setObject
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix
availableCoordinates, containsCoordinates, isSparse
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.AbstractMatrix
abs, addMissing, allCoordinates, allValues, and, and, append, appendHorizontally, appendVertically, atimes, bigDecimalValue, bigIntegerValue, booleanValue, bootstrap, bootstrap, ceil, center, charValue, chebyshevDistanceTo, chol, 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, 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, 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, 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.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.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 java.util.Map
compute, computeIfAbsent, computeIfPresent, equals, forEach, getOrDefault, hashCode, merge, putIfAbsent, remove, replace, replace, replaceAll
Methods inherited from interface org.ujmp.core.Matrix
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 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
-
updateStatement
-
deleteStatement
-
selectByKeyStatement
-
containsKeyStatement
-
containsValueStatement
-
keyStatement
-
dropTableStatement
-
countStatement
-
-
Constructor Details
-
JDBCMapMatrix
private JDBCMapMatrix(String url, String username, String password, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
JDBCMapMatrix
private JDBCMapMatrix(Connection connection, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
-
Method Details
-
getConnection
-
getURL
-
getTableName
-
getDatabaseName
-
getKeyClass
-
getValueClass
-
getKeyColumnName
-
getValueColumnName
-
getSQLDialect
-
clearMap
protected final void clearMap()- Specified by:
clearMap
in classAbstractMapMatrix<K,
V>
-
keySet
-
removeFromMap
- Specified by:
removeFromMap
in classAbstractMapMatrix<K,
V>
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceCloseable
- Throws:
IOException
-
erase
- Specified by:
erase
in interfaceErasable
- Throws:
IOException
-
putIntoMap
- Specified by:
putIntoMap
in classAbstractMapMatrix<K,
V>
-
get
-
containsKey
- Specified by:
containsKey
in interfaceMap<K,
V> - Overrides:
containsKey
in classAbstractMapMatrix<K,
V>
-
containsValue
- Specified by:
containsValue
in interfaceMap<K,
V> - Overrides:
containsValue
in classAbstractMapMatrix<K,
V>
-
beforeWriteObject
- Throws:
IOException
-
beforeReadObject
- Throws:
IOException
ClassNotFoundException
-
flush
- Specified by:
flush
in interfaceFlushable
- Throws:
IOException
-
size
public final int size() -
createTable
private final void createTable(String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
connectToMySQL
public static <K,V> JDBCMapMatrix<K,V> connectToMySQL(String serverName, int port, String username, String password, String databaseName, String tableName, String columnForKeys, String columnForValues) throws SQLException - Throws:
SQLException
-
connectToMySQL
public static <K,V> JDBCMapMatrix<K,V> connectToMySQL(String serverName, int port, String userName, String password, String databaseName, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
- Throws:
SQLException
IOException
-
connectToSQLite
- Throws:
SQLException
IOException
-
connectToDerby
- Throws:
SQLException
IOException
-
connectToHSQLDB
- Throws:
SQLException
-
connectToH2
- Throws:
SQLException
IOException
-
connectToH2
- Throws:
SQLException
-
connectToH2
public static <K,V> JDBCMapMatrix<K,V> connectToH2(File file, String tableName) throws SQLException - Throws:
SQLException
-
connectToDerby
- Throws:
SQLException
-
connectToDerby
public static <K,V> JDBCMapMatrix<K,V> connectToDerby(File folderName, String tableName) throws SQLException - Throws:
SQLException
-
connectToSQLite
- Throws:
SQLException
-
connectToSQLite
public static <K,V> JDBCMapMatrix<K,V> connectToSQLite(File file, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
public static <K,V> JDBCMapMatrix<K,V> connectToHSQLDB(File file, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
public static <K,V> JDBCMapMatrix<K,V> connectToHSQLDB(File file, String userName, String password, String tableName) throws SQLException - Throws:
SQLException
-
connectToHSQLDB
public static <K,V> JDBCMapMatrix<K,V> connectToHSQLDB(File file, String userName, String password, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
connect
public static <K,V> JDBCMapMatrix<K,V> connect(String url, String userName, String password, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-
connect
public static <K,V> JDBCMapMatrix<K,V> connect(String url, String userName, String password, String tableName) throws SQLException - Throws:
SQLException
-
connect
public static <K,V> JDBCMapMatrix<K,V> connect(Connection connection, String tableName, String keyColumnName, String valueColumnName) throws SQLException - Throws:
SQLException
-