Database

Database

MySQL

package be.moondevelopment.example;

import be.moondevelopment.moonapi.framework.database.Database;
import be.moondevelopment.moonapi.framework.database.MySQL;
import be.moondevelopment.moonapi.framework.utils.ConfigUtil;
import be.moondevelopment.moonapi.framework.utils.YamlConfigUtil;
import org.bukkit.plugin.java.JavaPlugin;

import java.sql.ResultSet;
import java.sql.SQLException;

public class ExamplePlugin extends JavaPlugin {

    private static ExamplePlugin instance;

    private Database database;

    private YamlConfigUtil config;

    @Override
    public void onEnable() {
        instance = this;
        config = ConfigUtil.get(this, "config.yml");

        // Connect
        database = new MySQL(
                this,
                config.getString("mysql.host"),
                config.getInt("mysql.port"),
                config.getString("mysql.database"),
                config.getString("mysql.username"),
                config.getString("mysql.password")
        );
        database.connect();

        // Create table
        try {
            database.executeUpdate("CREATE TABLE IF NOT EXISTS example(id INT, name VARCHAR);");
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Insert data
        try {
            database.executeUpdate("INSERT INTO example(id, name) VALUES(?,?);",
                    1,
                    "MoonDevelopment"
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Get data
        try {
            ResultSet rs = database.executeQuery("SELECT * FROM example WHERE id = ?;",
                    1
            );
            while (rs.next()) {
                System.out.println(rs.getString("name"));
            }
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Update data
        try {
            database.executeUpdate("UPDATE example SET name = ? WHERE id = ?;",
                    "MoonDevelopment-Updated",
                    1
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Delete data
        try {
            database.executeUpdate("DELETE FROM example WHERE id = ?;",
                    1
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }
    }

    @Override
    public void onDisable() {
        // Disconnect
        database.disconnect();
    }

    public static ExamplePlugin getInstance() {
        return instance;
    }

    public Database getMySQLDatabase() {
        return database;
    }
}

SQLite

package be.moondevelopment.example;

import be.moondevelopment.moonapi.framework.database.Database;
import be.moondevelopment.moonapi.framework.database.SQLite;
import org.bukkit.plugin.java.JavaPlugin;

import java.sql.ResultSet;
import java.sql.SQLException;

public class ExamplePlugin extends JavaPlugin {

    private static ExamplePlugin instance;

    private Database database;

    @Override
    public void onEnable() {
        instance = this;

        // Connect
        database = new SQLite(
                this,
                "data.db"
        );
        database.connect();

        // Create table
        try {
            database.executeUpdate("CREATE TABLE IF NOT EXISTS example(id INT, name VARCHAR);");
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Insert data
        try {
            database.executeUpdate("INSERT INTO example(id, name) VALUES(?,?);",
                    1,
                    "MoonDevelopment"
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Get data
        try {
            ResultSet rs = database.executeQuery("SELECT * FROM example WHERE id = ?;",
                    1
            );
            while (rs.next()) {
                System.out.println(rs.getString("name"));
            }
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Update data
        try {
            database.executeUpdate("UPDATE example SET name = ? WHERE id = ?;",
                    "MoonDevelopment-Updated",
                    1
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }

        // Delete data
        try {
            database.executeUpdate("DELETE FROM example WHERE id = ?;",
                    1
            );
        } catch (SQLException x) {
            x.printStackTrace();
        }
    }

    @Override
    public void onDisable() {
        // Disconnect
        database.disconnect();
    }

    public static ExamplePlugin getInstance() {
        return instance;
    }

    public Database getSQLiteDatabase() {
        return database;
    }
}