java如何写一个通用方法取数据库表字段最近一天

可以使用Java中的JDBC连接数据库，并使用SQL语句查询最近一天的记录。以下是一个通用方法实现：

import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;

public class DBHelper {
    private static final String URL = "jdbc:mysql://localhost:3306/db_name";
    private static final String USER = "username";
    private static final String PASSWORD = "password";

    public static Map<String, Object> getLatestRecord(String tableName, String dateFieldName) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        Map<String, Object> result = new HashMap<>();
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(URL, USER, PASSWORD);
            stmt = conn.createStatement();
            String sql = "SELECT * FROM " + tableName + " WHERE " + dateFieldName + " = (SELECT MAX(" + dateFieldName + ") FROM " + tableName + ")";
            rs = stmt.executeQuery(sql);
            ResultSetMetaData metaData = rs.getMetaData();
            int columnCount = metaData.getColumnCount();
            if (rs.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    String columnName = metaData.getColumnLabel(i);
                    Object value = rs.getObject(columnName);
                    result.put(columnName, value);
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {
                if (rs != null) {
                    rs.close();
                }
                if (stmt != null) {
                    stmt.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        return result;
    }
}

使用时，可以调用该方法并传入表名和日期字段名参数：

Map<String, Object> latestRecord = DBHelper.getLatestRecord("table_name", "date_field_name");

该方法会返回一个Map对象，包含最近一天的记录。注意，需要根据实际情况修改数据库连接URL、用户名、密码等参数。