Class JDBCMapMatrix<K,​V>

    • Field Detail

      • tableExists

        private boolean tableExists
      • connection

        private transient java.sql.Connection connection
      • resultSet

        private transient java.sql.ResultSet resultSet
      • truncateTableStatement

        private transient java.sql.PreparedStatement truncateTableStatement
      • insertStatement

        private transient java.sql.PreparedStatement insertStatement
      • updateStatement

        private transient java.sql.PreparedStatement updateStatement
      • deleteStatement

        private transient java.sql.PreparedStatement deleteStatement
      • selectByKeyStatement

        private transient java.sql.PreparedStatement selectByKeyStatement
      • containsKeyStatement

        private transient java.sql.PreparedStatement containsKeyStatement
      • containsValueStatement

        private transient java.sql.PreparedStatement containsValueStatement
      • keyStatement

        private transient java.sql.PreparedStatement keyStatement
      • dropTableStatement

        private transient java.sql.PreparedStatement dropTableStatement
      • countStatement

        private transient java.sql.PreparedStatement countStatement
    • Constructor Detail

      • JDBCMapMatrix

        private JDBCMapMatrix​(java.lang.String url,
                              java.lang.String username,
                              java.lang.String password,
                              java.lang.String tableName,
                              java.lang.String keyColumnName,
                              java.lang.String valueColumnName)
                       throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • JDBCMapMatrix

        private JDBCMapMatrix​(java.sql.Connection connection,
                              java.lang.String tableName,
                              java.lang.String keyColumnName,
                              java.lang.String valueColumnName)
                       throws java.sql.SQLException
        Throws:
        java.sql.SQLException
    • Method Detail

      • getConnection

        public final java.sql.Connection getConnection()
      • getURL

        public final java.lang.String getURL()
      • getTableName

        public final java.lang.String getTableName()
      • getDatabaseName

        public final java.lang.String getDatabaseName()
      • getKeyClass

        public final java.lang.Class<?> getKeyClass()
      • getValueClass

        public final java.lang.Class<?> getValueClass()
      • getKeyColumnName

        public final java.lang.String getKeyColumnName()
      • getValueColumnName

        public final java.lang.String getValueColumnName()
      • keySet

        public final java.util.Set<K> keySet()
        Specified by:
        keySet in interface java.util.Map<K,​V>
      • close

        public final void close()
                         throws java.io.IOException
        Specified by:
        close in interface java.lang.AutoCloseable
        Specified by:
        close in interface java.io.Closeable
        Throws:
        java.io.IOException
      • erase

        public final void erase()
                         throws java.io.IOException
        Specified by:
        erase in interface Erasable
        Throws:
        java.io.IOException
      • get

        public final V get​(java.lang.Object key)
        Specified by:
        get in interface java.util.Map<K,​V>
      • containsKey

        public final boolean containsKey​(java.lang.Object key)
        Specified by:
        containsKey in interface java.util.Map<K,​V>
        Overrides:
        containsKey in class AbstractMapMatrix<K,​V>
      • containsValue

        public final boolean containsValue​(java.lang.Object value)
        Specified by:
        containsValue in interface java.util.Map<K,​V>
        Overrides:
        containsValue in class AbstractMapMatrix<K,​V>
      • beforeWriteObject

        protected void beforeWriteObject​(java.io.ObjectOutputStream os)
                                  throws java.io.IOException
        Throws:
        java.io.IOException
      • beforeReadObject

        protected void beforeReadObject​(java.io.ObjectInputStream is)
                                 throws java.io.IOException,
                                        java.lang.ClassNotFoundException
        Throws:
        java.io.IOException
        java.lang.ClassNotFoundException
      • flush

        public void flush()
                   throws java.io.IOException
        Specified by:
        flush in interface java.io.Flushable
        Throws:
        java.io.IOException
      • size

        public final int size()
        Specified by:
        size in interface java.util.Map<K,​V>
      • createTable

        private final void createTable​(java.lang.String tableName,
                                       java.lang.String keyColumnName,
                                       java.lang.String valueColumnName)
                                throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToMySQL

        public static <K,​V> JDBCMapMatrix<K,​V> connectToMySQL​(java.lang.String serverName,
                                                                          int port,
                                                                          java.lang.String username,
                                                                          java.lang.String password,
                                                                          java.lang.String databaseName,
                                                                          java.lang.String tableName,
                                                                          java.lang.String columnForKeys,
                                                                          java.lang.String columnForValues)
                                                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToMySQL

        public static <K,​V> JDBCMapMatrix<K,​V> connectToMySQL​(java.lang.String serverName,
                                                                          int port,
                                                                          java.lang.String userName,
                                                                          java.lang.String password,
                                                                          java.lang.String databaseName,
                                                                          java.lang.String tableName)
                                                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToHSQLDB

        public static <K,​V> JDBCMapMatrix<K,​V> connectToHSQLDB()
                                                                    throws java.sql.SQLException,
                                                                           java.io.IOException
        Throws:
        java.sql.SQLException
        java.io.IOException
      • connectToSQLite

        public static <K,​V> JDBCMapMatrix<K,​V> connectToSQLite()
                                                                    throws java.sql.SQLException,
                                                                           java.io.IOException
        Throws:
        java.sql.SQLException
        java.io.IOException
      • connectToDerby

        public static <K,​V> JDBCMapMatrix<K,​V> connectToDerby()
                                                                   throws java.sql.SQLException,
                                                                          java.io.IOException
        Throws:
        java.sql.SQLException
        java.io.IOException
      • connectToHSQLDB

        public static <K,​V> JDBCMapMatrix<K,​V> connectToHSQLDB​(java.io.File file)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToH2

        public static <K,​V> JDBCMapMatrix<K,​V> connectToH2()
                                                                throws java.sql.SQLException,
                                                                       java.io.IOException
        Throws:
        java.sql.SQLException
        java.io.IOException
      • connectToH2

        public static <K,​V> JDBCMapMatrix<K,​V> connectToH2​(java.io.File file)
                                                                throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToH2

        public static <K,​V> JDBCMapMatrix<K,​V> connectToH2​(java.io.File file,
                                                                       java.lang.String tableName)
                                                                throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToDerby

        public static <K,​V> JDBCMapMatrix<K,​V> connectToDerby​(java.io.File folderName)
                                                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToDerby

        public static <K,​V> JDBCMapMatrix<K,​V> connectToDerby​(java.io.File folderName,
                                                                          java.lang.String tableName)
                                                                   throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToSQLite

        public static <K,​V> JDBCMapMatrix<K,​V> connectToSQLite​(java.io.File file)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToSQLite

        public static <K,​V> JDBCMapMatrix<K,​V> connectToSQLite​(java.io.File file,
                                                                           java.lang.String tableName)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToHSQLDB

        public static <K,​V> JDBCMapMatrix<K,​V> connectToHSQLDB​(java.io.File file,
                                                                           java.lang.String tableName)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToHSQLDB

        public static <K,​V> JDBCMapMatrix<K,​V> connectToHSQLDB​(java.io.File file,
                                                                           java.lang.String userName,
                                                                           java.lang.String password,
                                                                           java.lang.String tableName)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connectToHSQLDB

        public static <K,​V> JDBCMapMatrix<K,​V> connectToHSQLDB​(java.io.File file,
                                                                           java.lang.String userName,
                                                                           java.lang.String password,
                                                                           java.lang.String tableName,
                                                                           java.lang.String keyColumnName,
                                                                           java.lang.String valueColumnName)
                                                                    throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connect

        public static <K,​V> JDBCMapMatrix<K,​V> connect​(java.lang.String url,
                                                                   java.lang.String userName,
                                                                   java.lang.String password,
                                                                   java.lang.String tableName,
                                                                   java.lang.String keyColumnName,
                                                                   java.lang.String valueColumnName)
                                                            throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connect

        public static <K,​V> JDBCMapMatrix<K,​V> connect​(java.lang.String url,
                                                                   java.lang.String userName,
                                                                   java.lang.String password,
                                                                   java.lang.String tableName)
                                                            throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • connect

        public static <K,​V> JDBCMapMatrix<K,​V> connect​(java.sql.Connection connection,
                                                                   java.lang.String tableName,
                                                                   java.lang.String keyColumnName,
                                                                   java.lang.String valueColumnName)
                                                            throws java.sql.SQLException
        Throws:
        java.sql.SQLException