package Login_Registration_Project;


import java.sql.*;
import java.util.*;

/**
 * Created by Salek on 29.01.2017.
 */
public class Login {
    public static void main (String[] args) {



        String url = "jdbc:mysql://localhost:3306/javabase";
        String user = "java";
        String passwd = "password";

        try {
            //  1. Get a connection to the DB
            Connection myConn = DriverManager.getConnection(url, user, passwd);
            //  2. Create a statement
            Statement myStmt = myConn.createStatement();
            //  3. Execute SQL query

            Scanner input = new Scanner (System.in);

            System.out.println("Please Login to the Clinic.");
            System.out.println("Login - Pesel: ");
            String Login = input.nextLine();
            System.out.println("Password: ");
            String Password = input.nextLine();

            String myQuery = "select * from shadow" +
                    " where Password = '" + Password + "' and Pesel = '" + Login + "'";


//            System.out.println(myQuery);
            ResultSet myRs = myStmt.executeQuery(myQuery);

            myRs.last(); // moves cursor to the last row, remember to do myRs.first() if you want to get it back to the first row,
                        // it doesn't matter now because we are getting only 1 row so first row is a last row anyway.

            int rowCount = myRs.getRow();
//            System.out.println(rowCount);

            while (myRs.next()){
                 System.out.println(myRs.getString("Password") + " " + myRs.getString("Pesel"));

            }

            if (rowCount == 0) {
                System.out.println("Login or/and password are not correct! Please try again.");
            }

            else System.out.println("Login succesfull!");
        }


        catch (Exception exc) {
        exc.printStackTrace();
        }

    }
}