SQLConnectionThread.java

package me.gtacraft.plugins.gangs.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/*
 * Multithreaded SQL "pooling" for running queries to and from the database server.
 * Reset connection every 1,000 connections or on timeout, whichever happens first.
 */

public class SQLConnectionThread {
    private static Connection con = null;
    public static int query_count = 0;

    public static Connection getConnection() {
        try{
            if(query_count >= 1000) {
                if(con != null){
                    con.close();
                }

                con = DriverManager.getConnection(SQLVars.formatSqlCall(SQLVars.SQL_URL), SQLVars.SQL_USER, SQLVars.SQL_PASS);
                query_count = 0;
            }
            if(con==null || con.isClosed()){
                Class.forName("com.mysql.jdbc.Driver");
                con = DriverManager.getConnection(SQLVars.formatSqlCall(SQLVars.SQL_URL), SQLVars.SQL_USER, SQLVars.SQL_PASS);
            }
        } catch(Exception e) {
            e.printStackTrace();
        }

        query_count++;
        return con;
    }

    public static ResultSet getResultSet(String query) {
        PreparedStatement pst = null;

        try {
            pst = SQLConnectionThread.getConnection().prepareStatement(query);
            pst.execute();

            ResultSet rs = pst.getResultSet();
            return rs;
        } catch(Exception err) {
            err.printStackTrace();
            return null;
        }
    }
}