DBManager

/dbm - Shows you all commands
/dbm reload - Reloads the configuration file
/dbm create [PluginName] - Create a database section for a plugin

Credentials:
  BanManager: # Example Pluginname (Must be the actual Pluginname)
    Enabled: true # Enables the connection
    UseSSL: false # Enables ssl as connection protocol (default: false)
    Database: database # Name of the database
    Hostname: localhost # Name of the host
    Port: '3306' # Port of the database (default: 3306)
    Username: root # Name of the user
    Password: 'password' # Password of the user

 // Example plugin.yml
name: BanManager
version: 1.0
author: muckmuck96
main: me.muckmuck96.BanManager
depend: [DBManager]
 

// Parameters:
// plugin: This should be your plugin instance
// sql: This is your sql query
// values: Here you can insert several values for your query
// Return: HashMap<Integer, Object>()

DBMAPI.executeQuery(Plugin plugin, String sql, Object... values);

// For UPDATE, INSERT & DELETE is no special usage required
// Example usage

// Update
int id = 1;
DBMAPI.executeQuery(this, "DELETE FROM table WHERE id = ?", id);

// Insert
DBMAPI.executeQuery(this, "INSERT INTO table (username, uuid, kills) VALUES (?, ?, ?)", "muckmuck96", "UUID", 10);

// Delete
int id = 1;
DBMAPI.executeQuery(this, "DELETE FROM table WHERE id = ?", id);

// For SELECT exist a rule to use it

// Rule: By using 'SELECT * FROM table WHERE id = ?' the first value have to be the column_key which you wanna fetch from the query

HashMap<Integer, Object> result = DBMAPI.executeQuery(Plugin plugin, String sql, Object... values);

// Example usage:

// Select
int id = 1;
HashMap<Integer, Object> result = DBMAPI.executeQuery(this, "SELECT * FROM table WHERE id = ?", "username", id);

// There are 4 states you can fetch from the map
// The Integer is 0 (ERROR), 1 (RESULT_OBJECT), 2 (SUCCESS), 3 (RESULTSET)

// So if you get 1 you can fetch the object from the map

if(result.containsKey(1)){
  String username = (String) result.get(1);
}

// If you get 0 you can fetch the exception object from the map

if(result.containsKey(0)){
  Exception error = (Exception) result.get(0);
}

// At 2 you just get a success message

// If you get 3 you can fetch the resultset from the map

if(result.containsKey(3)){
  ResultSet resultSet = (ResultSet) result.get(3);
}