MySQLManager

MySQLManager

This utility will help to work with the MySQL database.
Version Support: 1.8 - 1.15.1

// MySQLManager(class):

public MySQL connect(JavaPlugin plugin, String host, int port, String database, String user, String password) // connect mysql

// MySQL(class):

public AsyncMySQL async() // async

public void insert(String query, InsertHandler handler, Object... args) // insert

public void update(String query, UpdateHandler handler, Object... args) // update

public void delete(String query, DeleteHandler handler, Object... args) // delete

public void select(String query, SelectHandler handler, Object... args) // select

public void execute(String query) // execute

//
// Example to usage:
//

MySQLManager mysqlmanager = MySQLManager.getInstance();
MySQL mysql = mysqlmanager.connect(this, "localhost", 3306, "database", "root", "password");
        
mysql.execute("CREATE TABLE IF NOT EXISTS `economy` (`id` INTEGER PRIMARY KEY,`player` varchar(255) NOT NULL UNIQUE,`balance` INTEGER(255) NOT NULL)");

Main.mysql.select("SELECT * FROM economy", rs -> {
     while (rs.next()) {
          this.accounts.put(rs.getString("player").toLowerCase(), new Account(rs.getString("player"), rs.getLong("balance")));
     }
});