Problem z stworzeniem tabel w bazie danych.

Question

Cześć mam problem z stworzeniem tabeli w moim programie,dostaje następujący błąd. "[SQLITE_ERROR] SQL error or missing database (near "(": syntax error)"

oto mój kod:

import java.sql.*;


public class shelter_Database {

    public static void main(String[] args){
        createDatabase("Employees.db");
        connect();
        createNewTable();

    }

    //Creating database

    public static void createDatabase(String Employees) {
        String url = "jdbc:sqlite:C:/Users/Kacper/Desktop/Shelter/Database" + Employees;

        try (Connection connection = DriverManager.getConnection(url)) {
            if (connection != null) {
                DatabaseMetaData metaData = connection.getMetaData();
                System.out.println("The driver name is " + metaData.getDriverName());
                System.out.println("A new database has been created.");
            }
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }

//Connecting to the database

    public static void connect() {
        Connection connection = null;
        try {
            String url = "jdbc:sqlite:C:/Users/Kacper/Desktop/Shelter/DatabaseEmployees";
            connection = DriverManager.getConnection(url);
            System.out.println("Connection with Employees database has been established");
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        } finally {
            try {
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException ex) {
                System.out.println(ex.getMessage());
            }
        }
    }

    //Creating new table
    public static void createNewTable() {
        String url = "jdbc:sqlite:C://Users/Kacper/Desktop/Shelter/DatabaseEmployees";

        String sql = "CREATE TABLE IF NOT EXISTS (\n"
                + " id integer PRIMARY KEY,\n"
                + " name text NOT NULL,\n"
                + " surname text NOT NULL,\n"
                + " age integer\n"
                + " capacity real\n"
                + ");";

        try (Connection connection = DriverManager.getConnection(url);
             Statement statement = connection.createStatement()) {
            statement.execute(sql);
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }
}

druga klasa

 

public class Employees {
    private String name,surname;
    private int age;

    public void setName(String name){
       this.name = name;
    }
    public void setSurname(String surname) {
        this.surname = surname;
    }
    public void setAge(int age) {
        this.age = age;
    }

    public String getName(String name) {
        return name;
    }
    public String getSurname(String surname) {
        return name;
    }

    public int getAge(int age){
        return age;
    }
}

 

Answer 1

Masz problem z zapytaniem SQL, spróbuj:
 

String sql = "CREATE TABLE IF NOT EXISTS (id integer PRIMARY KEY, name text NOT NULL, surname text NOT NULL,age integer, capacity real)";