要比较ElasticSearch索引数据和数据库记录，可以使用ElasticSearch的API来检索索引数据，并使用数据库查询语言（如SQL）来查询数据库记录。以下是一个使用Java编写的示例代码：

import org.elasticsearch.action.search.SearchRequest;
import org.elasticsearch.action.search.SearchResponse;
import org.elasticsearch.client.RequestOptions;
import org.elasticsearch.client.RestClient;
import org.elasticsearch.client.RestHighLevelClient;
import org.elasticsearch.index.query.QueryBuilders;
import org.elasticsearch.search.SearchHit;
import org.elasticsearch.search.builder.SearchSourceBuilder;

import java.io.IOException;
import java.sql.*;

public class ElasticsearchDatabaseComparison {

    public static void main(String[] args) {
        RestHighLevelClient client = new RestHighLevelClient(
                RestClient.builder(new HttpHost("localhost", 9200, "http")));

        // Compare Elasticsearch index data and database records
        try {
            // Get Elasticsearch index data
            SearchRequest searchRequest = new SearchRequest("index_name");
            SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
            searchSourceBuilder.query(QueryBuilders.matchAllQuery());
            searchRequest.source(searchSourceBuilder);

            SearchResponse searchResponse = client.search(searchRequest, RequestOptions.DEFAULT);
            SearchHit[] hits = searchResponse.getHits().getHits();

            // Get database records
            Connection connection = DriverManager.getConnection("jdbc:postgresql://localhost:5432/db_name", "username", "password");
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery("SELECT * FROM table_name");

            // Compare data
            while (resultSet.next()) {
                // Get database record
                int id = resultSet.getInt("id");
                String name = resultSet.getString("name");
                // ...

                // Compare with Elasticsearch index data
                for (SearchHit hit : hits) {
                    String esId = hit.getId();
                    String esName = hit.getSourceAsMap().get("name").toString();
                    // ...

                    if (id == Integer.parseInt(esId) && name.equals(esName)) {
                        System.out.println("Match found for id: " + id);
                    }
                }
            }

            // Close connections
            resultSet.close();
            statement.close();
            connection.close();
        } catch (IOException | SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                client.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    }
}

请确保替换代码中的以下部分，以适应您的环境：

• localhost: ElasticSearch和数据库的主机名或IP地址
• 9200: ElasticSearch的端口号
• index_name: ElasticSearch的索引名称
• db_name: 数据库的名称
• username: 数据库的用户名
• password: 数据库的密码
• table_name: 数据库中的表名称

此代码通过使用Elasticsearch的Java高级客户端（RestHighLevelClient）和Java的JDBC（java.sql）库来连接到Elasticsearch和数据库，并执行相应的查询操作来比较数据。