package Database;

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

public class Database {


	public Database() {

		/*try {
		      Class.forName("org.postgresql.Driver");
		      System.out.println("Driver O.K.");

		      String url = "jdbc:postgresql://localhost:5432/gestionentreprise";
		      String user = "chris";
		      String passwd = "199710";

		      Connection conn = DriverManager.getConnection(url, user, passwd);
		      System.out.println("Connexion effective !");

		    } catch (Exception e) {
		      e.printStackTrace();
		    }      */
		String url = "jdbc:mysql://sql7.freemysqlhosting.net:3306/sql7292995";
		String user = "sql7292995";
		String passwd = "nn4Y4shvHf";

		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Driver O.K.");


		      Connection conn = DriverManager.getConnection(url, user, passwd);
		      System.out.println("Connexion effective !");

		      //RECUPER DATA
		      /*
		      Statement stmt=conn.createStatement();
		      ResultSet rs=stmt.executeQuery("select * from test");
		      while(rs.next())
		      System.out.println(rs.getString(1)+"  "+rs.getString(2));  */

		   // create a sql date object so we can use it in our INSERT statement


		      // the mysql insert statement
		      String query = " insert into test (id, nom)"
		        + " values (?, ?)";

		      // create the mysql insert preparedstatement
		      PreparedStatement preparedStmt = conn.prepareStatement(query);
		      preparedStmt.setString (1, "Tamere ?");
		      preparedStmt.setString (2, "ET ouai");


		      // execute the preparedstatement
		      preparedStmt.execute();

		      System.out.println("done");

		      conn.close();

		    } catch (Exception e) {
		      e.printStackTrace();
		    }
	}
}