package com.example.kamil.sql;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import java.sql.*;
import java.lang.String;

    public class MainActivity extends AppCompatActivity {
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }
    public static void main(String[] args) {
    Connection myconObj = null;
    Statement mystatObj = null;
    ResultSet myresObj = null;
    String query = "SELECT * FROM tbl_client";
        try {
            myconObj = DriverManager.getConnection("jdbc:mysql://localhost:8080/parking", "root", "Qwerty123@");
            mystatObj = myconObj.createStatement();
            myresObj = mystatObj.executeQuery(query);
            while(myresObj.next()) {
                int id = myresObj.getInt(1);
                String name = myresObj.getString(2);
                String username = myresObj.getString(3);
                String password = myresObj.getString(4);
                System.out.println(id +"\t   "+ name +"\t   "+ username + "\t   " + password);
                }
            }

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