]> matita.cs.unibo.it Git - logicplayer.git/blobdiff - server/com/company/dbConnect.java
Now uses localhost to send e-mail.
[logicplayer.git] / server / com / company / dbConnect.java
index e7c7e20224ce72bb98cd83ffc7a5874e6cd44be1..309a9796dd6a6ed08834c9fed85d9612eb9b145a 100644 (file)
@@ -18,7 +18,21 @@ public class dbConnect
     private static Connection db;
     private static Statement stmt;
     dbConnect()
-    {}
+    {
+        try {
+            Class.forName("com.mysql.jdbc.Driver").newInstance();
+            db = DriverManager.getConnection(global.dbConstant.dbLink + global.dbConstant.dbName, global.dbConstant.dbAdmin, global.dbConstant.dbPassword);
+            stmt = db.createStatement();
+        } catch (ClassNotFoundException e) {
+            e.printStackTrace();
+        } catch (SQLException e) {
+            e.printStackTrace();
+        } catch (InstantiationException e) {
+            e.printStackTrace();
+        } catch (IllegalAccessException e) {
+            e.printStackTrace();
+        }
+    }
 
 
     public static Long time()
@@ -79,7 +93,7 @@ public class dbConnect
             {
                 EmailSender email = new EmailSender(global.emailConstant.email,
                         global.emailConstant.emailPass,
-                        "smtp.gmail.com",
+                        global.emailConstant.smtpName,
                         global.emailConstant.email,
                         user,
                         "OGGETTO: recupero password LogicPlayer",
@@ -319,9 +333,6 @@ public class dbConnect
     }
 
     public String dbQuery(String input) throws SQLException, ClassNotFoundException, IllegalAccessException, InstantiationException, IOException, NoSuchAlgorithmException {
-        Class.forName("com.mysql.jdbc.Driver").newInstance();
-        db = DriverManager.getConnection(global.dbConstant.dbLink+global.dbConstant.dbName, global.dbConstant.dbAdmin, global.dbConstant.dbPassword);
-        stmt = db.createStatement();
         deletetmp();
         if (input.charAt(0) == '0')
             return splitUsrPass(input.substring(2), 0);