Чтобы проверить, существует ли таблица в SQLite с использованием Java, вы можете использовать следующие методы:
-
Метод 1: использование необработанного SQL-запроса
String tableName = "your_table_name"; String query = "SELECT name FROM sqlite_master WHERE type='table' AND name='" + tableName + "'"; try (Connection connection = DriverManager.getConnection("jdbc:sqlite:your_database.db"); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(query)) { if (resultSet.next()) { // Table exists System.out.println("Table exists!"); } else { // Table does not exist System.out.println("Table does not exist!"); } } catch (SQLException e) { e.printStackTrace(); } -
Метод 2: использование DatabaseMetaData
String tableName = "your_table_name"; try (Connection connection = DriverManager.getConnection("jdbc:sqlite:your_database.db")) { DatabaseMetaData metaData = connection.getMetaData(); try (ResultSet tables = metaData.getTables(null, null, tableName, null)) { if (tables.next()) { // Table exists System.out.println("Table exists!"); } else { // Table does not exist System.out.println("Table does not exist!"); } } } catch (SQLException e) { e.printStackTrace(); } -
Метод 3: использование оператора PRAGMA, специфичного для SQLite
String tableName = "your_table_name"; String pragmaQuery = "PRAGMA table_info(" + tableName + ")"; try (Connection connection = DriverManager.getConnection("jdbc:sqlite:your_database.db"); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(pragmaQuery)) { if (resultSet.next()) { // Table exists System.out.println("Table exists!"); } else { // Table does not exist System.out.println("Table does not exist!"); } } catch (SQLException e) { e.printStackTrace(); }