Below is an example that allows récuppérer a list of services a company (Service Computing, Communication, ...) to a database, and puts the list in a collection of type ArrayList.
This example has three classes:
This example has three classes:
- Service Class: consists only of attributes Service :
public class Service {
String codeService;
String libelleService;
}
- Class SelectServices : Allows you to connect to the database (connect method), and load the contents of the table service database in an ArrayList (Method ExtractionServices):
import java.sql.CallableStatement;
import java.sql.SQLException;
import java.sql.*;
import java.util.*;
public class SelectServices {
Connection conn;
public void connect() {
try
{
DriverManager.registerDriver(new com.mysql.jdbc.Driver ());
conn = DriverManager.getConnection
("jdbc:mysql://localhost:3306/test", "root", "root");
}
catch(SQLException sqle){
System.out.println(sqle.toString());
}
finally{
}
}
public List ExtractionServices() {
List listeServices = new ArrayList();
Service service;
try {
this.connect();
CallableStatement SelectSRV =
this.conn.prepareCall("SELECT CODE, LIBELLE FROM SERVICE");
ResultSet rs = SelectSRV.executeQuery();
while (rs.next()) {
// Allimentation ArrayList listeServices
service = new Service();
service.codeService = rs.getString("CODE");
service.libelleService = rs.getString("LIBELLE");
listeServices.add(service);
}
rs.close();
SelectSRV.close();
//return ListProjets;
this.conn.close();
} catch (SQLException sqle) {
System.out.println(sqle.toString());
} finally {
}
return listeServices;
}
}
- Classe Appel : Class to test whether the collection is allimentée :
import java.util.*;
public class Appel {
public static void main(String args[]) {
SelectServices S = new SelectServices();
List LS = new ArrayList();
LS = S.ExtractionServices();
Iterator it = LS.iterator();
while (it.hasNext())
{
Service service = it.next();
System.out.println(service.libelleService);
}
LS = new LinkedList();
}
}
