package javaClasses7;

import java.sql.*;

public class DB{
  private Connection conn = null;
  private Statement stmt = null;
  private ResultSet rs = null;

  public void connect(){
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      conn = DriverManager.getConnection("jdbc:mysql://mysql.agh.edu.pl/database",
                                    "database","password");
 	} catch (SQLException ex) {
      // handle any errors
      System.out.println("SQLException: " + ex.getMessage());
      System.out.println("SQLState: " + ex.getSQLState());
      System.out.println("VendorError: " + ex.getErrorCode());
    }catch(Exception e){e.printStackTrace();}
  }

  public void listAll(){
    try {
      connect();
      stmt = conn.createStatement();

      // Wyciagamy wszystkie pola z tabeli
      rs = stmt.executeQuery("SELECT * FROM books");

      while(rs.next()){
        String isbn = rs.getString(0);
 	String title = rs.getString(1);
	String author = rs.getString(2);
 	String year = rs.getString(3);
        System.out.println("ISBN: "+isbn+ "TITLE: "+title+ "AUTHOR: "+author+ "YEAR: "+year);
      }
    }catch (SQLException ex){
      // handle any errors

    }finally {
      // zwalniamy zasoby, które nie będą potrzebne
      if (rs != null) {
        try {
          rs.close();
        } catch (SQLException sqlEx) { } // ignore
        rs = null;
      }

      if (stmt != null) {
        try {
          stmt.close();
        } catch (SQLException sqlEx) { } // ignore

        stmt = null;
      }
    }
  }

	public static void main(String[] args){
	DB db = new DB();
	db.listAll();
	}

}