Lấy bản ghi cuối cùng từ MySQL bằng Java (JDBC)

Dùng ORDER BY id DESC LIMIT 1 trong truy vấn SQL, sau đó gọi executeQuery() từ Java.

Tạo bảng trong database sample:

mysql> CREATE TABLE javaGetDataDemo (
    -> Id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> FirstName VARCHAR(10),
    -> LastName VARCHAR(10)
    -> );

Chèn dữ liệu:

mysql> INSERT INTO javaGetDataDemo(FirstName, LastName) VALUES('John','Smith'), ('Carol','Taylor');

Mã Java hoàn chỉnh:

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

public class GetDataFromMySQLToJava {
    public static void main(String[] args) {
        String JdbcURL = "jdbc:mysql://localhost:3306/sample?useSSL=false";
        String Username = "root";
        String password = "123456";
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            System.out.println("Connecting to database..............." + JdbcURL);
            con = DriverManager.getConnection(JdbcURL, Username, password);
            Statement st = con.createStatement();
            String query = "SELECT * FROM javaGetDataDemo ORDER BY Id DESC LIMIT 1;";
            rs = st.executeQuery(query);
            if (rs.next()) {
                String fname = rs.getString("FirstName");
                String lname = rs.getString("LastName");
                System.out.println("FirstName:" + fname);
                System.out.println("LastName:" + lname);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Kết quả chạy: hiển thị bản ghi cuối cùng (Carol Taylor).