SQLite JDBC 驱动程序在Java中访问和创建SQLite数据库文件的库完整项目源代码.zip

package org.sqlite.jdbc3; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.SQLFeatureNotSupportedException; import java.sql.Statement; import java.sql.Struct; import java.sql.Types; import java.util.ArrayList; import java.util.Arrays; import java.util.Collections; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Properties; import java.util.regex.Matcher; import java.util.regex.Pattern; import java.util.stream.Collectors; import org.sqlite.SQLiteConnection; import org.sqlite.core.CoreStatement; import org.sqlite.jdbc3.JDBC3DatabaseMetaData.ImportedKeyFinder.ForeignKey; import org.sqlite.util.QueryUtils; import org.sqlite.util.StringUtils; public abstract class JDBC3DatabaseMetaData extends org.sqlite.core.CoreDatabaseMetaData { private static String driverName; private static String driverVersion; static { try (InputStream sqliteJdbcPropStream = JDBC3DatabaseMetaData.class .getClassLoader() .getResourceAsStream("sqlite-jdbc.properties")) { if (sqliteJdbcPropStream == null) { throw new IOException("Cannot load sqlite-jdbc.properties from jar"); } final Properties sqliteJdbcProp = new Properties(); sqliteJdbcProp.load(sqliteJdbcPropStream); driverName = sqliteJdbcProp.getProperty("name"); driverVersion = sqliteJdbcProp.getProperty("version"); } catch (Exception e) { // Default values driverName = "SQLite JDBC"; driverVersion = "3.0.0-UNKNOWN"; } } protected JDBC3DatabaseMetaData(SQLiteConnection conn) { super(conn); } /** @see java.sql.DatabaseMetaData#getConnection() */ public Connection getConnection() { return conn; } /** @see java.sql.DatabaseMetaData#getDatabaseMajorVersion() */ public int getDatabaseMajorVersion() throws SQLException { return Integer.parseInt(conn.libversion().split("\\.")[0]); } /** @see java.sql.DatabaseMetaData#getDatabaseMinorVersion() */ public int getDatabaseMinorVersion() throws SQLException { return Integer.parseInt(conn.libversion().split("\\.")[1]); } /** @see java.sql.DatabaseMetaData#getDriverMajorVersion() */ public int getDriverMajorVersion() { return Integer.parseInt(driverVersion.split("\\.")[0]); } /** @see java.sql.DatabaseMetaData#getDriverMinorVersion() */ public int getDriverMinorVersion() { return Integer.parseInt(driverVersion.split("\\.")[1]); } /** @see java.sql.DatabaseMetaData#getJDBCMajorVersion() */ public int getJDBCMajorVersion() { return 4; } /** @see java.sql.DatabaseMetaData#getJDBCMinorVersion() */ public int getJDBCMinorVersion() { return 2; } /** @see java.sql.DatabaseMetaData#getDefaultTransactionIsolation() */ public int getDefaultTransactionIsolation() { return Connection.TRANSACTION_SERIALIZABLE; } /** @see java.sql.DatabaseMetaData#getMaxBinaryLiteralLength() */ public int getMaxBinaryLiteralLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxCatalogNameLength() */ public int getMaxCatalogNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxCharLiteralLength() */ public int getMaxCharLiteralLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnNameLength() */ public int getMaxColumnNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnsInGroupBy() */ public int getMaxColumnsInGroupBy() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnsInIndex() */ public int getMaxColumnsInIndex() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnsInOrderBy() */ public int getMaxColumnsInOrderBy() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnsInSelect() */ public int getMaxColumnsInSelect() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxColumnsInTable() */ public int getMaxColumnsInTable() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxConnections() */ public int getMaxConnections() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxCursorNameLength() */ public int getMaxCursorNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxIndexLength() */ public int getMaxIndexLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxProcedureNameLength() */ public int getMaxProcedureNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxRowSize() */ public int getMaxRowSize() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxSchemaNameLength() */ public int getMaxSchemaNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxStatementLength() */ public int getMaxStatementLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxStatements() */ public int getMaxStatements() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxTableNameLength() */ public int getMaxTableNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxTablesInSelect() */ public int getMaxTablesInSelect() { return 0; } /** @see java.sql.DatabaseMetaData#getMaxUserNameLength() */ public int getMaxUserNameLength() { return 0; } /** @see java.sql.DatabaseMetaData#getResultSetHoldability() */ public int getResultSetHoldability() { return ResultSet.CLOSE_CURSORS_AT_COMMIT; } /** @see java.sql.DatabaseMetaData#getSQLStateType() */ public int getSQLStateType() { return DatabaseMetaData.sqlStateSQL99; } /** @see java.sql.DatabaseMetaData#getDatabaseProductName() */ public String getDatabaseProductName() { return "SQLite"; } /** @see java.sql.DatabaseMetaData#getDatabaseProductVersion() */ public String getDatabaseProductVersion() throws SQLException { return conn.libversion(); } /** @see java.sql.DatabaseMetaData#getDriverName() */ public String getDriverName() { return driverName; } /** @see java.sql.DatabaseMetaData#getDriverVersion() */ public String getDriverVersion() { return driverVersion; } /** @see java.sql.DatabaseMetaData#getExtraNameCharacters() */ public String getExtraNameCharacters() { return ""; } /** @see java.sql.DatabaseMetaData#getCatalogSeparator() */ public String getCatalogSeparator() { return "."; } /** @see java.sql.DatabaseMetaData#getCatalogTerm() */ public String getCatalogTerm() { return "catalog"; } /** @see java.sql.DatabaseMetaData#getSchemaTerm() */ public String getSchemaTerm() { return "schema"; } /** @see java.sql.DatabaseMetaData#getProcedureTerm() */ public String getProcedureTerm() { return "not_implemented"; } /** @see java.sql.DatabaseMetaData#getSearchStringEscape() */ public String getSearchStringEscape() { return "\\"; } /** @see java.sql.DatabaseMetaData#getIdentifierQuoteString() */ public String getIdentifierQuoteString() { return "\""; } /** * @see java.sql.DatabaseMetaData#getSQLKeywords() * @see <a href="https://www.sqlite.org/lang_keywords.html">SQLite Keywords</a> */ public String getSQLKeywords() { return "ABORT,ACTION,AFTER,ANALYZE,ATTACH,AUTOINCREMENT,BEFORE," + "CASCADE