<!-- If the browser does not support frames put the first topic content here --> <div class="WordSection1"> <p class="MsoNormal" align="center" style= 'margin-bottom:0cm;margin-bottom:.0001pt; text-align:center;line-height:normal'> <b><span style= 'font-size:20.0pt; font-family:"Times New Roman",serif'>EXEMPLE DE GESTION DE BDD SOUS MYSQL</span></b></p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal'> </p> <p class="MsoNormal" style= 'margin-top:6.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal'> Etape 1 : Créer un projet Java Application</p> <p class="MsoNormal" style= 'margin-top:9.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal'> Etape 2 : Ajouter la librairie MySql</p> <p class="MsoNormal" style= 'margin-top:0cm;margin-right:0cm;margin-bottom:0cm; margin-left:42.55pt;margin-bottom:.0001pt;line-height:normal'> <span style= 'position:absolute;z-index:251657728;left:0px;margin-left:92px; margin-top:136px;width:128px;height:20px'> <img width="102" height="16" src= "Cours1_synthese_Mysql_fichiers/image001.png" alt= "image" /></span><img width="190" height="210" id="Image 1" src= "Cours1_synthese_Mysql_fichiers/image002.jpg" alt="image" name= "Image 1" /></p> <p class="MsoNormal" style= 'margin-top:0cm;margin-right:0cm;margin-bottom:0cm; margin-left:42.55pt;margin-bottom:.0001pt;line-height:normal'> </p> <p class="MsoNormal" style= 'margin-top:0cm;margin-right:0cm;margin-bottom:0cm; margin-left:42.55pt;margin-bottom:.0001pt;line-height:normal'> </p> <p class="MsoNormal" style= 'margin-top:0cm;margin-right:0cm;margin-bottom:0cm; margin-left:42.55pt;margin-bottom:.0001pt;line-height:normal'> </p> <p class="MsoNormal" style= 'margin-top:0cm;margin-right:0cm;margin-bottom:0cm; margin-left:42.55pt;margin-bottom:.0001pt;line-height:normal'> <img width="538" height="163" src= "Cours1_synthese_Mysql_fichiers/image003.png" alt="image" /></p> <p class="MsoNormal" style= 'margin-top:9.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal'> </p> <p class="MsoNormal" style= 'margin-top:9.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal'> </p> <p class="MsoNormal" style= 'margin-top:9.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal'> Etape 3 : Codage de l'utilisation de la BDD (Exemple ci-dessous avec la bdd "gesemp")</p> <div style= 'border:solid windowtext 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt'> <p class="MsoNormal" style= 'margin-top:2.0pt;margin-right:0cm;margin-bottom:0cm; margin-left:0cm;margin-bottom:.0001pt;line-height:normal;border:none; padding:0cm'> <b>import java.sql.*;</b></p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> public class AccesMysql</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> public static void main (String[] args)</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> Connection conn;</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> Statement stmt;</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> ResultSet rs;</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> String pilote = "com.mysql.cj.jdbc.Driver";</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> String url = new String("jdbc:mysql://localhost/gesemp?useSSL=FALSE&characterEncoding=UTF8");</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> try</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> Class.forName(pilote);</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> conn = DriverManager.getConnection(url,"root","");</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> stmt = conn.createStatement();</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> rs = stmt.executeQuery("select * from emp");</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> while (rs.next())</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> System.out.println("numero : " + rs.getInt(1)); // ou System.out.println("numero : " + rs.getInt("empno"));</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> System.out.println("nom : " + rs.getString(2)); // ou System.out.println("nom : " + rs.getString("ename"));</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> }</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> rs.close();</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> stmt.close();</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> conn.close();</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> } </p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> catch (SQLException sqle)</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> System.out.println("Erreur SQL: " + sqle.getMessage());</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> }</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> catch (ClassNotFoundException cnfe)</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> {</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> System.out.println("Erreur SQL: " + cnfe.getMessage());</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> } </p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> }</p> <p class="MsoNormal" style= 'margin-bottom:0cm;margin-bottom:.0001pt;line-height: normal;border:none;padding:0cm'> }</p> </div> </div>
Table des matières
Sujets
Recherche
Help content
Help content
Générée avec
chmProcessor
Générée avec
chmProcessor