/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package basededonnées;

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

/**
 *
 * @author thibaut
 */
public class Main
{

	/**
	 * @param args the command line arguments
	 */
	public static void main (String[] args)
	{
		int i = 0;
		try
		{
			Class.forName ("com.mysql.jdbc.Driver").newInstance ();	      // spécification du driver
			Connection c = DriverManager.getConnection ("jdbc:mysql://localhost/tp10", "root", "");	      //creation de la connexion
			Statement st = c.createStatement ();	  //creation d'un tube de communication

			/* Requetes de selections */

			ResultSet rs = st.executeQuery ("select * from track where Artist like \"The Beatles\"");	  // requete de selection
			while (rs.next ())
			{
				System.out.println (rs.getString ("Track_Title"));
			}
			System.out.println ();
			rs = st.executeQuery ("select * from cd where SET_ID = 0");	  // requete de selection
			while (rs.next ())
			{
				System.out.println (rs.getString ("Disk_Title"));
			}

			/* requete de creation, suppression etc...*/

			int n = st.executeUpdate ("CREATE table if not exists Artist (nom VARCHAR (50), id INT)");		  // creation de la table artiste

			System.out.println ();
			rs = st.executeQuery ("select distinct Artist from track order by Track_ID ");	  // requete de selection
			while (rs.next ())
			{
				System.out.println ("sa rentre ds la boucle");
				//System.out.println(rs.getString("Artist"));
				n = st.executeUpdate ("insert into Artist(nom,id) values ('" + rs.getString ("Artist") + "'," + Statement.RETURN_GENERATED_KEYS + ")");
				System.out.println ("c'est passé");
				i++;
			}
			c.close ();

		} catch (Exception e)
		{
			System.out.println ("exception capturée: " + e);
		}
	}
}