/**
 * You will need to dowlonad MySQL Connector/JL:
 * http://dev.mysql.com/downloads/connector/j
 * javac HelloDB.java
 * java  -cp .:mysql-connector-java-5.1.30-bin.jar HelloDB
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class HelloDB {

    static final String DB_URL = "jdbc:mysql://localhost/homework3";
    static final String USER = "soule";
    static final String PASS = "password";
  
    public static void main(String[] args) {
        
        try {
            Class.forName("com.mysql.jdbc.Driver");                        
            Connection connect = DriverManager.getConnection(DB_URL,USER,PASS);            
            
            Statement statement = connect.createStatement();
            ResultSet resultSet = statement.executeQuery("select * from BOOK");
            
            System.out.println("The columns in the table are: ");
            System.out.println("Table: " + resultSet.getMetaData().getTableName(1));
            for  (int i = 1; i<= resultSet.getMetaData().getColumnCount(); i++){
                System.out.println("Column " +i  + " "+ resultSet.getMetaData().getColumnName(i));
            }            
            while (resultSet.next()) {
                String isbn = resultSet.getString("ISBN");
                String author = resultSet.getString(2);
                String title = resultSet.getString(3);
                System.out.println("ISBN: " + isbn);
                System.out.println("author: " + author);
                System.out.println("title: " + title);                
            }
            resultSet.close();
            statement.close();
            connect.close();
        } catch (Exception e) { 
            System.out.println("problem...");
        } 

    }

}