- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 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
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
private Connection getConnection() throws SQLException {
Connection conn = null;
try{
conn = DriverManager.getConnection(OnlineUsers.db,OnlineUsers.user,OnlineUsers.pass);
} catch (Exception e) {
log.severe(name + ": " + e.getMessage());
}
checkConnection(conn);
return conn;
}
private boolean checkConnection (Connection conn) throws SQLException {
if (conn == null) {
log.severe("Could not connect to the database. Check your credentials in online-users.settings");
throw new SQLException();
}
if (!conn.isValid(5)) {
log.severe("Could not connect to the database.");
throw new SQLException();
}
return true;
}
private boolean execute(String sql) {
return execute(sql, null);
}
private boolean execute(String sql, String player) {
Connection conn = null;
PreparedStatement ps = null;
try {
conn = getConnection();
ps = conn.prepareStatement(sql);
if (player != null && !player.equalsIgnoreCase("")) {
ps.setString(1, player);
}
if (ps.execute()) {
return true;
}
} catch (SQLException ex) {
log.severe(name + ": " + ex.getMessage());
String msg = name + ": could not execute the sql \"" + sql + "\"";
if (player != null ) {
msg += " ?=" +player;
}
log.severe(msg);
} finally {
try {
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException ex) {
log.severe(name + ": " + ex.getMessage());
}
}
return false;
}
Follow us!