package com.company;
import java.sql.*;

public class Main
{

    public static void main(String[] args)
    {

        try
        {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/eap?autoReconnect=true&useSSL=false","root", "Dattass2015");
            PreparedStatement statement = connection.prepareStatement("select * from user");
            ResultSet rs = statement.executeQuery();

            //Statement statement1 = connection.createStatement();
           // statement1.executeUpdate("INSERT INTO user VALUES (21, 'Popescu', 'Ioana', 'popescu.ioana@yahoo.com', 'Popescu1995', 0, 0)");

                while (rs.next())
                    System.out.println(rs.getInt("id_user") + " " + rs.getString("nume") + "  " + rs.getString("prenume") + "   \n" + rs.getString("email") + "   " + rs.getString("parola") + "     " + rs.getInt("access_level") + " " + rs.getInt("deleted_user")+ "\n");
                   // System.out.println(rs.getString("nume"));
                   // System.out.println(rs.getString("prenume"));
                   // System.out.println(rs.getString("email"));
                   // System.out.println(rs.getString("parola"));
                   // System.out.println(rs.getInt("access_level"));
                   // System.out.println(rs.getInt("deleted_user"));
           // Statement statement1 = connection.createStatement();
           // statement1.executeUpdate("INSERT INTO user VALUES (21, 'Popescu', 'Ioana', 'popescu.ioana@yahoo.com', 'Popescu1995', 0, 0)");



        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
        }
        catch (SQLException e)
        {
            e.printStackTrace();
        }
    }
}