import java.sql.*;

public class JavaBD {

	public static void main(String[] args) {
		Connection con;
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con = DriverManager.getConnection("jdbc:sqlserver://" + "153.19.7.13:1401; databaseName=drodzevic;user=drodzevic;password=253957");
			String query;
			ResultSet result;
			ResultSetMetaData countCol;

			//*********Z1
			System.out.println("\n -------- ZADANIE 2 - 1\n");
			//TABELA KLIENT
			query = "SELECT * FROM Klient";
			result = con.createStatement().executeQuery(query);
			countCol = result.getMetaData();

			while(result.next())
			{
				for(int i = 1; i<countCol.getColumnCount(); i++)
				{
					System.out.print(result.getString(i) + "\t|\t");
				}
				System.out.println("");
			}
			System.out.println("\n");

			//TABELA ADRES
			query = "SELECT * FROM Adres";
			result = con.createStatement().executeQuery(query);
			countCol = result.getMetaData();

			while(result.next())
			{
				for(int i = 1; i<countCol.getColumnCount(); i++)
				{
					System.out.print(result.getString(i) + "\t|\t");
				}
				System.out.println("");
			}

			//**********Z2
			System.out.println("\n -------- ZADANIE 2 - 2\n");

			query = "SELECT nazwisko, data_ur FROM Klient";
			result = con.createStatement().executeQuery(query);
			countCol = result.getMetaData();

			while(result.next())
			{
				for(int i = 1; i<countCol.getColumnCount(); i++)
				{
					System.out.print(result.getString(i) + "\t|\t");
				}
				System.out.println("");
			}

		}
		catch (SQLException e)
		{
			System.out.println("zle");
			e.printStackTrace();
		}
		catch (ClassNotFoundException e)
		{
			System.out.println("zle2");
			e.printStackTrace();
		}


	}

}