EXEMPLE DE GESTION DE BDD SOUS MYSQL

Etape 1 : Créer un projet Java Application

Etape 2 : Ajouter la librairie MySql

Etape 3 : Codage de l'utilisation de la BDD (Exemple ci-dessous avec la bdd "gesemp")

import java.sql.*;

public class AccesMysql

{

         public static void main (String[] args)

         {

               Connection conn;

               Statement stmt;

               ResultSet rs;

               String pilote = "com.mysql.cj.jdbc.Driver";

               String url = new String("jdbc:mysql://localhost/gesemp?useSSL=FALSE&characterEncoding=UTF8");

               try

               {

                     Class.forName(pilote);

                     conn = DriverManager.getConnection(url,"root","");

                     stmt = conn.createStatement();

                     rs = stmt.executeQuery("select * from emp");

                     while (rs.next())

                     {

                           System.out.println("numero : " + rs.getInt(1)); // ou System.out.println("numero : " + rs.getInt("empno"));

                           System.out.println("nom : " + rs.getString(2)); // ou System.out.println("nom : " + rs.getString("ename"));

                     }

                     rs.close();

                     stmt.close();

                     conn.close();

               }                       

               catch (SQLException sqle)

               {

                     System.out.println("Erreur SQL: " + sqle.getMessage());

               }

               catch (ClassNotFoundException cnfe)

               {

                     System.out.println("Erreur SQL: " + cnfe.getMessage());

               }   

         }

}