package DBConnection;

import org.sqlite.SQLiteConfig;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class DBConnection {
    private static final String URL = "jdbc:sqlite:test:db";
    private Connection connection = null;

    private static final String USERNAME = "dbuser";
    private static final String PASSWORD = "dbpassword";
    private static final String CONN = "jdbc:sqlite:cookBook.sqlite";

    public static Connection getConnection() throws SQLException{
        try{
            Class.forName("org.sqlite.JDBC");
            return DriverManager.getConnection(CONN);
        }catch(ClassNotFoundException e){
            e.printStackTrace();
        }
        return null;
    }


    private void closeConnection() throws SQLException{
        connection.close();
    }

    void createLogin(){
        try{
            final Statement statement = connection.createStatement();
            statement.executeUpdate("SELECT imie, nazwisko FROM Studenci;");
        }catch (SQLException e){
            e.printStackTrace();
        }
    }

}