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 = "SELECT * FROM adres";
			ResultSet result = con.createStatement().executeQuery(query);
			ResultSetMetaData countCol = result.getMetaData();

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

			while(wynik_zapytania.next())
			{
			for (int i=1;i<=ile_kolumn;i++)
			 {
				11. System.out.print(wynik_zapytania.getString(i)+" - ");
				12. }
				13. System.out.println(" <koniec>");
				14. }


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


	}

}