package dbextract;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import static dbextract.Db.*;
import static java.lang.System.out;

public class DbExtract {

    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        int countryId = 7;
        int regularly = 1;

        Date dateFrom = Date.valueOf("1950-01-01");
        Date dateTo   = Date.valueOf("1998-01-01");

        try (
                Connection connection = getConnection();
                PreparedStatement psMembers = connection.prepareStatement(
                        "SELECT * FROM members " +
//                      "WHERE country = ? AND sex = ? AND sqldate BETWEEN = ? AND = ?"
                        "WHERE country = ? AND sex = ? AND sqldate BETWEEN ? AND ?" //ORACLE SYNTAX
                )
            ) {

            psMembers.setInt (1, countryId);
            psMembers.setInt (2, regularly);
            psMembers.setDate(3, dateFrom);
            psMembers.setDate(4, dateTo);

            try (ResultSet rs = psMembers.executeQuery()) {
                int count = rs.getMetaData().getColumnCount();
                while (rs.next()) {
                    for (int i = 1; i <= count; ++i) {
                        out.print("  " + rs.getString(i));
                    }
                    out.println();
                }
            }
        }
    }
}

SELECT COUNT(*) FROM members WHERE sqldate BETWEEN '1950-01-01' AND '1998-01-01'

SELECT COUNT(*) FROM members WHERE sqldate BETWEEN '1998-01-01' AND '1950-01-01'

String endage="1950-00-00";
Stirng beginage="1998-00-00";

ps.setString(i, endage);
ps.setString(i, beginage);