/
DatabaseHelper.java
51 lines (46 loc) · 1.77 KB
/
DatabaseHelper.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
package passwordgeneratorfx;
import java.sql.*;
import java.util.Calendar;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.scene.control.Alert;
import javafx.scene.control.ButtonType;
public class DatabaseHelper {
private String url;
private String user;
private String pw;
private static Connection con;
public DatabaseHelper(String url, String user, String pw) {
this.url = url;
this.user = user;
this.pw = pw;
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url, user, pw);
} catch (SQLException | ClassNotFoundException | InstantiationException | IllegalAccessException ex) {
Logger.getLogger(DatabaseHelper.class.getName()).log(Level.SEVERE, null, ex);
Alert alert = new Alert(Alert.AlertType.ERROR, "Can't connect to database. Is the server running?", ButtonType.OK);
alert.showAndWait();
}
}
public boolean writeToDB(String[] values) {
try {
Calendar calendar = Calendar.getInstance();
String query = "INSERT INTO entries (service, hash) VALUES (?, ?);";
PreparedStatement preSt = con.prepareStatement(query);
preSt.setString(1, values[0]);
preSt.setString(2, values[1]);
preSt.execute();
return true;
} catch (SQLException ex) {
Logger.getLogger(DatabaseHelper.class.getName()).log(Level.SEVERE, null, ex);
return false;
} finally {
try {
con.close();
} catch (SQLException ex) {
Logger.getLogger(DatabaseHelper.class.getName()).log(Level.SEVERE, null, ex);
}
}
}
}