ROOT/exo9/addbook.jsp

   1 <%@ page import="java.io.*, java.util.*, javax.servlet.*, java.sql.*" %>
   2 <%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
   3
   4 <meta charset="UTF-8">
   5 <html>
   6 <body>
   7
   8 <h1>Ajouter un livre</h1>
   9 <form method="POST" action="addbook.jsp?new=true">
  10   Titre:<br>
  11   <input type="text" name="title"><br>
  12   Auteur:<br>
  13   <input type="text" name="author"><br><br>
  14   <input type="submit" value="Submit">
  15 </form>
  16
  17 <%
  18 request.setCharacterEncoding("UTF-8");
  19 String isNew = request.getParameter("new");
  20
  21 if (isNew != null && isNew.equals("true")) {
  22     String title = request.getParameter("title");
  23     String author = request.getParameter("author");
  24     Connection connection = null;
  25     PreparedStatement stmt = null;
  26     try {
  27         String connectionURL = "jdbc:mysql://localhost/MyBd?useUnicode=yes&characterEncoding=UTF-8";
  28         Class.forName("com.mysql.jdbc.Driver").newInstance();
  29         connection = DriverManager.getConnection(connectionURL, "MyBd", "MyBd");
  30         if(!connection.isClosed()) {
  31             stmt = connection.prepareStatement("INSERT INTO details_livres (nom_livre, auteur) VALUES (?, ?)");
  32             stmt.setString(1, title);
  33             stmt.setString(2, author);
  34             stmt.executeUpdate();
  35             out.println("Book " + title + " by " + author + " successfully added");
  36         }
  37         } catch (Exception e){
  38             out.println("Unable to connect to database or run query: " + e);
  39         }
  40         finally {
  41             if (connection != null)
  42                 connection.close();
  43             if (stmt != null)
  44                 stmt.close();
  45         }
  46
  47 }
  48
  49 %>
  50
  51 </body>
  52 </html>