package database;

import java.sql.*;

public class Main {

    public static void main(String[] args)
    {

        try
        {
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");

            Statement mysts= connection.createStatement();

            //mysts.executeUpdate("INSERT INTO user(login, password) VALUES ('Andrzej', 'Kowalski')");
            //mysts.executeUpdate("DELETE FROM user WHERE id=5");

            ResultSet myRs= mysts.executeQuery("SELECT * from user");


            while(myRs.next())
            {
                System.out.println(myRs.getString("id")+" "+myRs.getString("login"));
            }
        }
        catch(Exception ex)
        {
            ex.printStackTrace();
        }



    }

}