package test.db;

import java.sql.*;

public class Main {

    public static void main(String[] args) {
        try {
            Connection conn = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\ramon\\OneDrive\\Escritorio\\testjava.db"); // Creación de la base de datos testjava.db
            Statement statement = conn.createStatement();

            statement.execute("CREATE TABLE IF NOT EXISTS contacts " +
                                    "(name TEXT, phone INTEGER, email TEXT)");
            statement.execute("DELETE FROM contacts");
            statement.execute("INSERT INTO contacts (name, phone, email) " +
                                    "VALUES ('Ramon', 654, 'ramon@gmail.com')");
            statement.execute("INSERT INTO contacts (name, phone, email) " +
                                     "VALUES ('Jane', 654123, 'jane@gmail.com')");
            statement.execute("INSERT INTO contacts (name, phone, email) " +
                                    "VALUES ('Lewis', 6543333, 'lewis@gmail.com')");

           // statement.execute("UPDATE contacts SET phone=1234 WHERE name='Jane'");
           // statement.execute("DELETE FROM contacts WHERE name = 'Jane'");

            statement.execute("SELECT * FROM contacts");
            ResultSet results = statement.getResultSet();
            while (results.next()){
                System.out.println("name : " + results.getString("name")
                                + ", phone: " + results.getString("phone")
                                + ", email: " + results.getString("email"));
            }

            results.close();
            statement.close();
            conn.close();

        }
        catch (SQLException e){
            System.out.println("something went wrong: " + e.getMessage());
        }
    }
}