1 files changed, 65 insertions, 0 deletions
diff --git a/src/main/java/dev/tylerm/khs/database/connections/MySQLConnection.java b/src/main/java/dev/tylerm/khs/database/connections/MySQLConnection.java
new file mode 100644
index 0000000..0f7ce30
--- /dev/null
+++ b/src/main/java/dev/tylerm/khs/database/connections/MySQLConnection.java
@@ -0,0 +1,65 @@
+/*
+ * This file is part of Kenshins Hide and Seek
+ *
+ * Copyright (c) 2022 Tyler Murphy.
+ *
+ * Kenshins Hide and Seek free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * he Free Software Foundation version 3.
+ *
+ * Kenshins Hide and Seek is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program. If not, see <http://www.gnu.org/licenses/>.
+ *
+ */
+
+package dev.tylerm.khs.database.connections;
+
+import com.zaxxer.hikari.HikariConfig;
+import com.zaxxer.hikari.HikariDataSource;
+import dev.tylerm.khs.Main;
+import dev.tylerm.khs.configuration.Config;
+
+import java.sql.Connection;
+import java.sql.SQLException;
+
+public class MySQLConnection implements DatabaseConnection {
+
+    private final HikariDataSource ds;
+
+    public MySQLConnection(){
+
+        HikariConfig config = new HikariConfig();
+
+        Main.getInstance().getLogger().info("Database host: " + Config.databaseHost);
+        Main.getInstance().getLogger().info("Database port: " + Config.databasePort);
+        Main.getInstance().getLogger().info("Database user: " + Config.databaseUser);
+        Main.getInstance().getLogger().info("Database pass: xxxxxxxxxxx");
+        Main.getInstance().getLogger().info("Database name: " + Config.databaseName);
+
+
+        config.setDriverClassName(org.mariadb.jdbc.Driver.class.getName());
+        config.setJdbcUrl("jdbc:mariadb://"+ Config.databaseHost+":"+ Config.databasePort+"/"+ Config.databaseName.trim());
+        config.addDataSourceProperty("cachePrepStmts", "true");
+        config.addDataSourceProperty("prepStmtCacheSize", "250");
+        config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
+        config.addDataSourceProperty("user", Config.databaseUser);
+        config.addDataSourceProperty("password", Config.databasePass);
+        config.addDataSourceProperty("autoCommit", "true");
+        config.setAutoCommit(true);
+        config.setMaximumPoolSize(20);
+
+        ds = new HikariDataSource(config);
+
+    }
+
+    @Override
+    public Connection connect() throws SQLException {
+        return ds.getConnection();
+    }
+
+}