import javax.xml.crypto.dsig.spec.ExcC14NParameterSpec;
import javax.xml.transform.Result;
import java.sql.*;
public class DBConnect {
    private Connection conn = null;
    private Statement st;
    private ResultSet rs;

    public  DBConnect(){
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn = DriverManager.getConnection("jdbc:mysql://mysql.agh.edu.pl/handerek",
                            "handerek","JKq9WYUyTzrtyWcE1");
            st = conn.createStatement();

        } 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 GetData(){
        try{
            String query="SELECT * FROM `books` WHERE 1";
            rs =  st.executeQuery(query);
            while(rs.next())
            {
                String title = rs.getString("title");
                System.out.println(title);
            }


        }catch(Exception ex){
            System.out.print(ex);
            ex.printStackTrace();
        }
    }
}




public class Main {
    public static void main(String[] args)
    {
      DBConnect connect = new DBConnect();
        connect.GetData();
    }
}