X-Git-Url: https://git.piment-noir.org/?a=blobdiff_plain;f=ROOT%2Fexo9%2FconnectJspMysql.jsp;h=8ce40ed9faca33a3a97bdf9956fcec6240826ca3;hb=HEAD;hp=8d0f0827184ff053a095bed1d35aee1dc9885837;hpb=8639833058a983de10b1571c8f99c8d01e793804;p=TD_webapps.git

diff --git a/ROOT/exo9/connectJspMysql.jsp b/ROOT/exo9/connectJspMysql.jsp
index 8d0f082..8ce40ed 100644
--- a/ROOT/exo9/connectJspMysql.jsp
+++ b/ROOT/exo9/connectJspMysql.jsp
@@ -1,16 +1,19 @@
 <%@ page import="java.io.*, java.util.*, javax.servlet.*, java.sql.*" %>
 <%
 
+Connection connection = null;
 try {
-    String connectionURL = "jdbc:mysql://localhost/bdVols";
-    Connection connection = null;
+    String connectionURL = "jdbc:mysql://localhost/MyBd?useUnicode=yes&characterEncoding=UTF-8";
     Class.forName("com.mysql.jdbc.Driver").newInstance();
-    connection = DriverManager.getConnection(connectionURL, "fraggle", "$Love79!");
+    connection = DriverManager.getConnection(connectionURL, "MyBd", "MyBd");
     if(!connection.isClosed())
         out.println("Successfully connected to " + connectionURL + " MySQL server using TCP/IP");
-    connection.close();
     } catch (Exception e){
-            out.println("Unable to connect to database: " + e);
+        out.println("Unable to connect to database: " + e);
+    }
+    finally {
+        if (connection != null)
+            connection.close();
     }
 
 %>