1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| import java.sql.*;
import java.util.ArrayList;
public class Affichage {
public ArrayList listBoxCategorie()
{
ArrayList listBoxCategorie = new ArrayList();
String pilote = "com.mysql.jdbc.Driver";
try
{
// Chargement du pilote JDBC
Class.forName(pilote);
// Etablir la connexion
Connection connexion = DriverManager.getConnection("jdbc:mysql://localhost/projet","root","");
Statement instruction = connexion.createStatement();
ResultSet resultat = instruction.executeQuery("SELECT * FROM categ_donnees");
while(resultat.next()){
listBoxCategorie.add(resultat.getString("Nom_categ"));
}
resultat.close();
instruction.close();
}
catch (Exception e){
System.err.println("echec pilote : "+e);
}
return listBoxCategorie;
}
} |