Back

Correction applications traitement des instructions SQL avec JDBC

Correction applications traitement des instructions SQL avec JDBC

  1. Objectifs

    • Établir une connexion à la base de données.
    • Exécuter une requête Update avec un Statement
    • Obtenir les résultats dans un ResultSet
    • Examiner quelques méthodes du ResultSet.

  2. Application 01

    1. Énoncé
    2. Solution : Base de données
        3. --
-- Base de données : `gestion-apprenants`
--
DROP DATABASE IF EXISTS `gestion-apprenants`;
CREATE DATABASE IF NOT EXISTS `gestion-apprenants` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `gestion-apprenants`;

-- --------------------------------------------------------

--
-- Structure de la table `apprenants`
--

DROP TABLE IF EXISTS `apprenants`;
CREATE TABLE IF NOT EXISTS `apprenants` (
  `cdeApp` int(11) NOT NULL,
  `nom` varchar(100) DEFAULT NULL,
  `prenom` varchar(100) DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `genre` tinyint(2) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `cdeGouv` int(4) DEFAULT NULL,
  `code_postal` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`cdeApp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `apprenants`
--

INSERT INTO `apprenants` (`cdeApp`, `nom`, `prenom`, `date_naissance`, `genre`, `email`, `cdeGouv`, `code_postal`) VALUES
(12325678, 'Elina', 'MOTAFA', '2000-02-10', 2, 'elina@gmail.com', 111, '3541'),
(12345678, 'Mohamed', 'SALHI', '2000-02-17', 1, 'mohamed.salhi@yahoo.fr', 100, '4100'),
(12345679, 'Tarek', 'HARZI', '2001-12-17', 1, 'tarek.harzi@gmail.fr', 110, '4100'),
(12396387, 'Salah', 'MEJBRI', '2000-12-01', 1, 'mejbri@gmail.com', 100, '5412'),
(14735236, 'Mohamed Salah', 'HAJJI', '2021-02-18', 2, 'hajjriadh@gmail.com', 100, '4587'),
(14783236, 'Mohamed Salah', 'HAJJI', '2021-03-04', 2, 'hajjriadh@gmail.com', 101, '4587'),
(14785216, 'Mohamed Salah', 'HAJJI', '2021-03-04', 1, 'hajjriadh@gmail.com', 101, '4587'),
(14785236, 'Riadh', 'HAJJI', '2021-03-03', 1, 'hajjriadh@gmail.com', 100, '4587'),
(21548754, 'ali', 'Tanezefti', '2001-11-02', 1, 'ali@yahoo.fr', 102, '8745'),
(22345678, 'Rafika', 'MENII', '2001-03-30', 2, 'rafika147@yahoo.fr', 110, '3100'),
(62396387, 'Wahida', 'MOTREJ', '2001-11-21', 2, 'mejbri@gmail.com', 102, '5412'),
(64785236, 'Riadh', 'HAJJI', '2021-02-10', 2, 'hajjriadh@gmail.com', 100, '4587');
--
-- Base de données : `motdepasse`
--
DROP DATABASE IF EXISTS `motdepasse`;
CREATE DATABASE IF NOT EXISTS `motdepasse` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `motdepasse`;

-- --------------------------------------------------------

--
-- Structure de la table `recup_mdp`
--

DROP TABLE IF EXISTS `recup_mdp`;
CREATE TABLE IF NOT EXISTS `recup_mdp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` char(32) COLLATE utf8_unicode_ci NOT NULL,
  `mail` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Déchargement des données de la table `recup_mdp`
--

INSERT INTO `recup_mdp` (`id`, `code`, `mail`) VALUES
(1, '100', 'hajjriadh@gmail.com');

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `email` varchar(100) NOT NULL,
  `date_demande_recuperation_pwd` datetime DEFAULT NULL,
  `pwd_recuperation_token` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `username`, `pwd`, `email`, `date_demande_recuperation_pwd`, `pwd_recuperation_token`) VALUES
(1, 'johndoe1', '$2y$10$W1u/5k25VPATxcJNOwFzKunINlguThOoVdN8dGF9MWndjbClXjqlK', 'hajjriadh@gmail.com', '2021-02-13 13:00:00', 'o3HUTlAJngPzK7mpO9iR'),
(2, 'johndoe3', 'Password hashé 3', 'johndoe3@monsite.tld', '2019-02-01 00:00:00', 'gfvbfd0D-5Fvjg'),
(15, 'Ali', '$2y$10$cktY60i7fOkdP/Vd2t0CYuG.M2LPbbRomdcXA6Qs0u8LauTpzLehK', 'hajjriadhh@gmail.com', NULL, '');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    3. Solution : Page listeApprenant.jsp
        4. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>
 
<HTML>
<HEAD>
  <TITLE>insérer des données à l'aide d'une instruction préparée </TITLE>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">
<style>
.div{padding-left:15px;
        box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);
        height: 40px;
        border-radius: 2px;
        font-family: arial;
        font-size: 15px;
        }
</style>
</HEAD>
  <BODY bgcolor="#ffffcc">
   <%   
       Class.forName("com.mysql.cj.jdbc.Driver");
       
   	java.sql.Connection conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/"
   			+ "gestion-apprenants","root","");
   	java.sql.Statement stmt = conn.createStatement(); 
   	java.sql.ResultSet RS = stmt.executeQuery("SELECT * from apprenants"); 
   	
        
        
%>
  
  
  <div class="container">
  <div class="row pt-4">
   <div class="col-md-8">
        <h2 class="pull-center">Liste des apprenants</h2>
       </div>
       <div class=" col-4 pb-1 d-grid gap-2 d-md-flex justify-content-md-end">
                   <a href="./insertApprenant.jsp" class="btn btn-primary" role="button" data-bs-toggle="button">Ajouter un apprenant</a>
                   
       </div>  
    </div> 
      
  
  </br>
  <table class="table table-bordered">
		<tr> 
			<th>CIN</th>
			<th>Nom</th>
			<th>Prénom</th>
			<th>Date de naissance</th>			
			<th>Genre</th>
			<th>Email</th>
			<th>Gouvernorat</th>
			<th>Code postal</th>
			<th>Actions</th>
		</tr>
		<%
		while(RS.next()) { 	
        %>
		<tr>
 
			<td><%=RS.getString(1) %></td>
			<td><%=RS.getString(2) %></td>
			<td><%=RS.getString(3) %></td>
			<td><%=RS.getString(4) %></td>
			<td><%=RS.getString(5) %></td>
            <td><%=RS.getString(6)%></td>
			<td><%=RS.getString(7)%></td>
			<td><%=RS.getString(8) %></td>
			<td align="center">
                        <a href="./afficherApprenant.jsp?id=<%=RS.getString(1) %>" class="btn btn-primary btn-sm" role="button" data-bs-toggle="button">Afficher</a>
                        <a href="./modifierApprenant.jsp?id=<%=RS.getString(1) %>" class="btn btn-success btn-sm" role="button" data-bs-toggle="button">Editer</a>
                        <a href="/edit?id=<%=RS.getString(1) %>" class="btn btn-warning btn-sm" role="button" data-bs-toggle="button">Supprimer</a>
             </td>
			</tr>
 
			<% }
			RS.close(); 
		   	stmt.close(); 
		   	conn.close(); 
			
			
			%>
 
	</table>

 
 </body> 
</html>
    4. Solution : Page afficherApprenant.jsp
        5. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>
 
<HTML>
<HEAD>
  <TITLE>insert data using prepared statement </TITLE>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">
<style>
.div{padding-left:15px;
        box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);
        height: 40px;
        border-radius: 2px;
        font-family: arial;
        font-size: 15px;
        }
</style>
</HEAD>
  <BODY bgcolor="#ffffcc">
   <%   
      Class.forName("com.mysql.cj.jdbc.Driver");
   String connectionURL = "jdbc:mysql://localhost:3306/gestion-apprenants";
   Connection connection = DriverManager.getConnection
       (connectionURL, "root", "");
   String queryString ="select * from apprenants where cdeApp=?";
   PreparedStatement stmt = connection.prepareStatement(queryString);
   String cdeApp  = request.getParameter("id");
   stmt.setString(1, cdeApp);
   ResultSet resultSet = stmt.executeQuery();
   
%>
  
  
  <div class="container pt-4">
  
  </br>
	<%
	 if (resultSet.next()) {
        %>
       <div class="card border-info mb-3" style="margin-left: 25%; margin-right: 25%;width: auto;">
  <div class="card-header">
  <div class="row">
  <div class="col-6">Fiche Apprenant</div>
  <div class="col-6">
  <ul class="nav nav-pills card-header-pills justify-content-md-end">
      <li class="nav-item">
         <a href="./listeApprenant.jsp" class="btn btn-primary btn-sm" role="button" data-bs-toggle="button">Retour</a>
      </li>
   </ul></div>
  </div>
  
  </div>
  <div class="card-body">
    <h5 class="card-title"><%=resultSet.getString(2) %></h5>
    <p class="card-text">
    <p><%=resultSet.getString(1) %></p>
			<p><strong>Nom : </strong><%=resultSet.getString(2) %></p>
			<p><strong>Prénom : </strong><%=resultSet.getString(3) %></p>
			<p><strong>Date de naissance : </strong><%=resultSet.getString(4) %></p>
			<p><strong>Genre : </strong><%=resultSet.getString(5) %></p>
            <p><strong>Email : </strong><%=resultSet.getString(6)%></p>
			<p><strong>Gouvernorat : </strong><%=resultSet.getString(7)%></p>
			<p><strong>Code postal : </strong><%=resultSet.getString(8) %></p>
    
    
  </div> 
	
			<% }
				resultSet.close(); 
				stmt.close(); 
				connection.close();		
			%>
 

 
 </body> 
</html>
    5. Solution : Page InsertApprenant.jsp
        6. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>
 
<HTML>
<HEAD>
  <TITLE>insert data using prepared statement </TITLE>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">
<style>
.div{padding-left:15px;
        box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);
        height: 40px;
        border-radius: 2px;
        font-family: arial;
        font-size: 15px;
        }
</style>
</HEAD>
  <BODY bgcolor="#ffffcc">
  <div class="container">
  <div class="row pt-4">
   <div class="col-md-8">
        <h2 class="pull-center">Ajout d'un nouveau apprenant</h2>
       </div>
       <div class=" col-4 pb-1 d-grid gap-2 d-md-flex justify-content-md-end">		 
         <a href="./listeApprenant.jsp" class="btn btn-primary" role="button" data-bs-toggle="button">Retour</a>
	    </div>  
    </div> 
   <%   
   String cdeApp = request.getParameter("cdeApp");
   String nom = request.getParameter("nom");
   String prenom = request.getParameter("prenom");
   String date_naissance = request.getParameter("date_naissance");
   String genre = request.getParameter("genre");
   String email = request.getParameter("email");
   String cdeGouv = request.getParameter("cdeGouv");
   String code_postal = request.getParameter("code_postal");
	  /*out.println(cdeApp+"cin");
	  out.println(nom+"nom"+"\n");
	  out.println(prenom+"prenom"+"\n");
	  out.println(date_naissance+"date_naissance"+"\n");
	  out.println(genre+"genre\r\n");
	  out.println(email+"email\r\n");
	  out.println(cdeGouv+"cdeGouv\r\n");
	  out.println(code_postal+"code_postal");*/
	 

    String connectionURL = "jdbc:mysql://localhost:3306/gestion-apprenants";
          // declare a connection by using Connection interface 
    Connection connection = null;
        // declare object of Statement interface that uses for 
     PreparedStatement pstatement = null;
         // Load JBBC driver "com.mysql.jdbc.Driver"
     Class.forName("com.mysql.cj.jdbc.Driver");
          int updateQuery = 0;

         // check if the text box is empty
         if(cdeApp!=null && nom!=null && prenom!=null && date_naissance!=null 
         && genre!=null && email!=null && cdeGouv!=null && code_postal!=null){
              try {
              connection = DriverManager.getConnection
              (connectionURL, "root", "");
               // sql query to insert values in the secified table.
              String queryString ="INSERT INTO apprenants (cdeApp, nom, prenom,"
  		    		+ " date_naissance, genre, email, cdeGouv, code_postal) "+
              "VALUES (?, ?, ?, ?, ?, ?, ?, ?)";
             /* createStatement() is used for create statement
              object that is used for sending sql statements to the specified database. */
              pstatement = connection.prepareStatement(queryString);
  
              pstatement.setString(1, cdeApp);
              pstatement.setString(2, nom);
              pstatement.setString(3, prenom);
              pstatement.setString(4, date_naissance);
              pstatement.setString(5, genre);
              pstatement.setString(6, email);
              pstatement.setString(7, cdeGouv);
              pstatement.setString(8, code_postal);
              
              updateQuery = pstatement.executeUpdate();
              
              if (updateQuery != 0) { %>
                   
                   
                    <div class="div" style="background: #d5efc2;" >
                       
Les données sont insérées avec succès
                    dans la base de données.
                    </div>                 
            
              <%
              }
            } 
            catch (Exception ex) {
           
            %>              
           <div class="div" style="background: #ffc2a3;">
Impossible de se connecter à la batabase.<% out.println(ex.getMessage());%>
            </div>                 
    
      <%
               }
            finally {
                // close all the connections.
                pstatement.close();
                connection.close();
            }
          }
        
%>
  
  </br>
  <div style=" border-radius: 2px;border: 1px solid blue;box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);" >
  
    <form class="row g-3 p-4" action="#" method="post">
		<div class="row">   
		   <div class="col-md-3">
			    <label for="first-name" class="form-label">CIN</label>
			    <input type="text" class="form-control" name="cdeApp" placeholder="Saisir votre cin" required>
  			</div>
  			<div class="col-md-3">
			    <label for="last-name" class="form-label">Nom</label>
			    <input type="text" class="form-control" name="nom" placeholder="Saisir votre nom" required>
  			</div> 
		  <div class="col-md-3">
			    <label for="last-name" class="form-label">Prénom</label>
			    <input type="text" class="form-control" name="prenom" placeholder="Saisir votre prénom" required>
  			</div> 
		  <div class="col-md-3">
			    <label for="last-name" class="form-label">Date de naissance</label>
			    <input type="date" class="form-control" name="date_naissance" required>
  			</div> 
		</div>  
		<div class="row">  
		   <div class="col-md-3">
				    <label for="region" class="form-label">Genre</label>
				    <select class="form-select" name="genre" required>
				      <option selected disabled value="">Choisir</option>
				      <option value="1">Homme</option>
				      <option value="2">Femme</option>				      
				    </select>
		  	</div>		  
		  <div class="col-md-3">
		    <label for="username" class="form-label">Email</label>
		    <div class="input-group">
		      <span class="input-group-text">@</span>
		      <input type="text" class="form-control" name="email" required>
		    </div>
		  </div>
		  <div class="col-md-3">
				    <label for="region" class="form-label">Gouvernorat</label>
				    <select class="form-select" name="cdeGouv" required>
				      <option selected disabled value="">Choisir</option>
				      <option value="100">Tunis</option>
				      <option value="101">Gafsa</option>				      
				    </select>
		  	</div>	
		<div class="col-md-3">
		    <label for="username" class="form-label">Code postal</label>
		    <div class="input-group">
		      <input type="text" class="form-control" name="code_postal" required>
		    </div>
		  </div>
 </div>

        <div class="row pt-4">
			  <div class="d-grid gap-2">
			    <button class="btn btn-primary btn-block" type="submit">Enregistrer</button>
			  </div>
	    </div>  
</form>
 </div>
 </div>

 
 </body> 
</html>



    6. Solution : Page ModifierApprenant.jsp
        7. <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %>
 
<HTML>
<HEAD>
  <TITLE>insert data using prepared statement </TITLE>
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-giJF6kkoqNQ00vy+HMDP7azOuL0xtbfIcaT9wjKHr8RbDVddVHyTfAAsrekwKmP1" crossorigin="anonymous">
<style>
.div{padding-left:15px;
        box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);
        height: 40px;
        border-radius: 2px;
        font-family: arial;
        font-size: 15px;
        }
</style>
</HEAD>
  <BODY bgcolor="#ffffcc">
  <div class="container">
  <div class="row pt-4">
   <div class="col-md-8">
        <h2 class="pull-center">Ajout d'un nouveau apprenant</h2>
       </div>
       <div class=" col-4 pb-1 d-grid gap-2 d-md-flex justify-content-md-end">		 
         <a href="./listeApprenant.jsp" class="btn btn-primary" role="button" data-bs-toggle="button">Retour</a>
	    </div>  
    </div> 
   <%   
   String cdeApp = request.getParameter("cdeApp");
   String nom = request.getParameter("nom");
   String prenom = request.getParameter("prenom");
   String date_naissance = request.getParameter("date_naissance");
   String genre = request.getParameter("genre");
   String email = request.getParameter("email");
   String cdeGouv = request.getParameter("cdeGouv");
   String code_postal = request.getParameter("code_postal");
   	   

	  String connectionURL = "jdbc:mysql://localhost:3306/gestion-apprenants";
	   Connection connection = null;
	   PreparedStatement pstatement = null;
	   PreparedStatement smtp = null;
	   Class.forName("com.mysql.cj.jdbc.Driver");
	   connection = DriverManager.getConnection
	       (connectionURL, "root", "");
	   String req ="select * from apprenants where cdeApp=?";
	   smtp = connection.prepareStatement(req);
	   String code  = request.getParameter("id");
	   smtp.setString(1, code);
	   ResultSet resultSet = smtp.executeQuery();
	   //out.println(code+"cin");
	   resultSet.next();
	   
	   
	   
	   
	   
     int updateQuery = 0;

         // check if the text box is empty
         if(cdeApp!=null && nom!=null && prenom!=null && date_naissance!=null 
         && genre!=null && email!=null && cdeGouv!=null && code_postal!=null){
              try {
                  
            	  
              connection = DriverManager.getConnection
              (connectionURL, "root", "");
               // sql query to insert values in the secified table.
              String queryString ="update apprenants set cdeApp=?, nom=?, prenom=?,"
  		    		+ " date_naissance=?, genre=?, email=?, cdeGouv=?, code_postal=?  where cdeApp=? ";
             /* createStatement() is used for create statement
              object that is used for sending sql statements to the specified database. */
              pstatement = connection.prepareStatement(queryString);
            		  
              pstatement.setString(1, cdeApp);
              pstatement.setString(2, nom);
              pstatement.setString(3, prenom);
              pstatement.setString(4, date_naissance);
              pstatement.setString(5, genre);
              pstatement.setString(6, email);
              pstatement.setString(7, cdeGouv);
              pstatement.setString(8, code_postal);
              pstatement.setString(9, cdeApp);

              updateQuery = pstatement.executeUpdate();
              
              if (updateQuery != 0) { %>
                   
                   
                    <div class="div" style="background: #d5efc2;" >
                       
Les données sont insérées avec succès
                    dans la base de données.
                    </div>                 
            
              <%
              }
            } 
            catch (Exception ex) {
           
            %>              
           <div class="div" style="background: #ffc2a3;">
Impossible de se connecter à la database.<% out.println(ex.getMessage());%>
            </div>                 
    
      <%
               }
            finally {
                // close all the connections.
                pstatement.close();
                connection.close();
            }
          }
        
%>
  
  </br>
  <div style=" border-radius: 2px;border: 1px solid blue;box-shadow: 0 1px 6px rgba(0, 0, 0, 0.12), 0 1px 4px rgba(0, 0, 0, 0.24);" >
  
    <form class="row g-3 p-4" action="#" method="post">
		<div class="row">   
		   <div class="col-md-3">
			    <label for="first-name" class="form-label">CIN</label>
			    <input type="text" class="form-control" name="cdeApp" value="<%=resultSet.getString(1) %>" required>
  			</div>
  			<div class="col-md-3">
			    <label for="last-name" class="form-label">Nom</label>
			    <input type="text" class="form-control" name="nom" value="<%=resultSet.getString(2) %>" required>
  			</div> 
		  <div class="col-md-3">
			    <label for="last-name" class="form-label">Prénom</label>
			    <input type="text" class="form-control" name="prenom" value="<%=resultSet.getString(3) %>" required>
  			</div> 
		  <div class="col-md-3">
			    <label for="last-name" class="form-label">Date de naissance</label>
			    <input type="date" class="form-control" value="<%=resultSet.getString(4) %>"name="date_naissance" required>
  			</div> 
		</div>  
		<div class="row">  
		   <div class="col-md-3">
				    <label for="region" class="form-label">Genre</label>
				    <select class="form-select" name="genre" required>
				      <option selected disabled value="<%=resultSet.getString(5) %>">Choisir</option>
				      <option value="1">Homme</option>
				      <option value="2">Femme</option>				      
				    </select>
		  	</div>		  
		  <div class="col-md-3">
		    <label for="username" class="form-label">Email</label>
		    <div class="input-group">
		      <span class="input-group-text">@</span>
		      <input type="text" class="form-control" value="<%=resultSet.getString(6) %>" name="email" required>
		    </div>
		  </div>
		  <div class="col-md-3">
				    <label for="region" class="form-label">Gouvernorat</label>
				    <select class="form-select" name="cdeGouv" value="<%=resultSet.getString(7) %>"required>
				      <option selected disabled value="">Choisir</option>
				      <option value="100">Tunis</option>
				      <option value="101">Gafsa</option>				      
				    </select>
		  	</div>	
		<div class="col-md-3">
		    <label for="username" class="form-label">Code postal</label>
		    <div class="input-group">
		      <input type="text" class="form-control" value="<%=resultSet.getString(8) %>"name="code_postal" required>
		    </div>
		  </div>
 </div>

        <div class="row pt-4">
			  <div class="d-grid gap-2">
			    <button class="btn btn-primary btn-block" type="submit">Enregistrer</button>
			  </div>
	    </div>  
</form>
 </div>
 </div>

 
 </body> 
</html>



Connecter une JSP avec MySQL
Sommaire du cours JSP
author avatar
Riadh HAJJI

Riadh HAJJI

Ces articles pourraient aussi vous intéresser

Protégé : Correction exercices Pilote JDBC Java : Série 01
2 février, 2021

Il n’y a pas d’extrait, car cette publication est protégée.

Exercices Pilote JDBC Java : Série 01
2 février, 2021

Le pilote JDBC Java Chargement d’un pilote JDBC Connecter une JSP avec MySQL Exercices Pilote JDBC Java : Série 01 (Correction) Exercices Pilote JDBC Java : Série 01 Objectifs Établir une connexion à la base de données. Exécuter une requête Update avec un Statement Obtenir les résultats dans un ResultSet Examiner quelques méthodes du ResultSet. Rappel JDBC, Java Data Base …

Exercices directives, scripts et actions en JSP : Série 01
23 novembre, 2020

Les éléments d’une page JSP Les déclarations en JSP Les Scriptlets en JSP Les expressions en JSP Les commentaires en JSP Les directives en JSP Les actions en JSP Exercices directives, scripts et actions en JSP : Série 01 (Correction) Exercices directives, scripts et actions en JSP : Série 01 Objectifs Se familiariser avec les fonctionnalités et la syntaxe JSP …

Laisser un commentaire

Abonnez vous à notre chaîne YouTube gratuitement