Bdd.java

public class Bdd {

	String url;
	String user;
	String databaseName;
	String passwd;


	Connection conn = null; Statement st = null; ResultSet rs = null;


	public Bdd() {

	}

	public Bdd(String purl, String puser, String ppasswd, String pdatabaseName) {
		this.url = purl;
		this.user = puser;
		this.passwd = ppasswd;
		this.databaseName = pdatabaseName;
	}

	public void Connection(){

		try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Driver O.K.");
			conn = DriverManager.getConnection("jdbc:mysql://"
					+ this.url
					+ ":3306/"
					+ this.databaseName, this.user, this.passwd);
			System.out.println("Connexion effective !");

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

	public void Disconnect(){
		try {
			conn.close();
			System.out.println("Déconnection éffectué");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	public void getDonnees(){
		try{
			st = conn.createStatement();

			rs = st.executeQuery("SELECT * FROM Metarduino ORDER BY Id");

			while (rs.next()) {
				System.out.println(rs.getInt("Temperature"));
			}
		}catch (Exception e) {
			e.printStackTrace();
		}

	}