{filelink=883}

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

import java.util.Properties;

public class ExempleBDDErby {

	static Statement initiliserConnexion()throws Exception
	{
		 Connection conn = null;
		 conn = DriverManager.getConnection("jdbc:derby:Etudiants");
         Statement stmt = conn.createStatement();
         return stmt;

   }
   public static void main(String[] args)
   {
      try {
         Statement stmt=initiliserConnexion();
         ResultSet rs = stmt.executeQuery("SELECT Etudiant, Année, Note FROM Notes");

         while(rs.next()) {
            System.out.println("Etudiant   : "+ rs.getString(1));
            System.out.println("Année  : "+ rs.getString(2));
            System.out.println("Note: "+ rs.getString(3));
            System.out.println();
         }

         rs.close();
         stmt.close();
      } catch(Exception e) {
         System.out.println("Exception: "+ e);
         e.printStackTrace();
      }
   }
}

Attributs des fichiers: Créer un fichier et modifier son attribut.