public class DataBaseAdmin {

    private QueryRunner queryRunner;
    
    public DataBaseUser(BasicDataSource basicDataSource) {
        this.queryRunner = new QueryRunner(basicDataSource);
    }

    // Примеры запросов
    public JSONArray userGetPayments(int userId, boolean paid, boolean active, boolean wait, boolean finish, boolean activate) throws SQLException {
        return getQueryRunner().query("SELECT p.*, s.id AS site_id, url FROM payments AS p LEFT JOIN site AS s ON s.id=p.site_id WHERE p.user_id = ? AND p.paid = ? AND active = ? AND wait = ? AND finish = ? AND (activate = ?  OR activate = ?);", new ResultSetHandler<JSONArray>() {
            public JSONArray handle(ResultSet rs) throws SQLException {
                return DataSource.getDbResultArray(rs);
            }
        }, userId, paid, active, wait, finish, activate, !activate);
    }

    public JSONObject userGetInfo(int userId) throws SQLException {
        return getQueryRunner().query(SqlCore.SQL_USER_INFO_GET, new ResultSetHandler<JSONObject>() {
            public JSONObject handle(ResultSet rs) throws SQLException {
                return DataSource.getDbSingleRow(rs);
            }
        }, userId);
    }

    public int paymentAdd(Payment pm) throws SQLException {
        return getQueryRunner().insert(SqlCore.SQL_PAYMENT_ADD, new ScalarHandler<Long>(), pm.getUserId(), pm.getSiteId(), pm.getRateId(), pm.getStart(), pm.getEnd(), pm.isPaid(), pm.isActive(), pm.isWait(), pm.isFinish(), pm.isActivate()).intValue();
    }

    public boolean paymentUpdate(Payment pm) throws SQLException {
        return getQueryRunner().update(SqlCore.SQL_PAYMENT_UPDATE, pm.getUserId(), pm.getSiteId(), pm.getRateId(), pm.getStart(), pm.getEnd(), pm.isPaid(), pm.isActive(), pm.isWait(), pm.isFinish(), pm.isActivate(), pm.isError(), pm.getMessage(), pm.getId())>0;
    }

}

BasicDataSource BDS = Core.getDataSource();

DataBaseUser dbUser = new DataBaseUser(BDS);
DataBaseAdmin dbAdmin = new DataBaseAdmin(BDS);

BDS.getConnection().close();

 DataBase db = new DataBase(getDataSource());

 db.getDbUser().getUserIdByHash(user.getHash())

 db.close();

public class DataBase {

    private DataBaseUser dbUser;
    private DataBaseAdmin dbAdmin;
    private DataBaseChat dbChat;

    private QueryRunner queryRunner;

    public DataBase(BasicDataSource basicDataSource) {

        queryRunner = new QueryRunner(basicDataSource);

        dbUser = new DataBaseUser(queryRunner);
        dbAdmin = new DataBaseAdmin(queryRunner);
        dbChat = new DataBaseChat(queryRunner);

    }

    public DataBaseUser getDbUser() {
        return dbUser;
    }

    public DataBaseAdmin getDbAdmin() {
        return dbAdmin;
    }

    public DataBaseChat getDbChat() {
        return dbChat;
    }

    public void close() throws SQLException {
        queryRunner.getDataSource().getConnection().close();
    }

}

DataBase db = new DataBase(getDataSource());

                    User user = getUser(SESSION);

                    user.setHash(COOKIES.getValue(NAME_USER_HASH));

                    if (!user.getHash().isEmpty()) {

                        user.setId(db.getDbUser().getUserIdByHash(user.getHash()));

                        if (user.getId() > 0) {

                            user.update(db.getDbUser().getUserFullInfo(user.getId()));

                            user.getAuth().setAuth();

                            COOKIES.create("/", NAME_USER_HASH, user.getHash(), COOKIES_AGE_MONTH);

                            user.setLastVisit(new LastVisit(getCurrentDate(), TIME_FORMAT.format(Calendar.getInstance().getTime())));

                            db.getDbUser().updateAuth(user.getId(), UTILS.getClientIpAddress(), user.getHash(), user.getLastVisit().getDate(), user.getLastVisit().getTime());

                            if (user.getSite() != null && user.getSite().getId()>0) {
                                user.setSite(new Site(db.getDbAdmin().siteGetFullInfo(user.getId(), user.getSite().getId())));
                            }

                            user.setChat(new Chat());

                        } else {
                            user = new User();
                        }

                    } else {
                        user = new User();
                    }

                    user.getDeviceType().setWeb();

                    String token = HASHES.generateToken(UTILS.getRequest());

                    COOKIES.create("/", NAME_TOKEN, token, COOKIES_AGE_SESSION);

                    SESSION.set(NAME_TOKEN, token);

                    SESSION.set(NAME_SERVER_ACCESS, true);

                    SESSION.set(NAME_USER, user);

                    //BDS.getConnection().close();
                    db.close();