import java.sql.*;
import com.mysql.jdbc.Driver;

public class jdbcExample {

  public static void main(String args[]) {
    System.out.println("\n\nStarting...\n\n");
    String sql = "SELECT * FROM genres;";
    String url = "jdbc:mysql://localhost:3306/music_app";
    try {
      Class.forName("com.mysql.jdbc.Driver");
      Connection cn = DriverManager.getConnection(url, "music_app", "music_app");
      Statement stmt = cn.createStatement();
      ResultSet rs = stmt.executeQuery(sql);
      System.out.println("Genres in the database:\n\n");
      while (rs.next()) {
        int id = rs.getInt("id");
        String str = rs.getString("name");
        String desc = rs.getString("description");
        System.out.println(id + "\t" + str + "\t" + desc + "\n");
      }
      cn.close();
    } catch(Exception e) {
      System.out.println(e);
    } finally {

    }
  }

}