Commit | Line | Data |
---|---|---|
d2793705 JB |
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> |