Sqlite-JDBC update with LIMIT子句？

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:sqlite:path/to/database.db";
        String sql = "UPDATE your_table SET column1 = ? WHERE id IN (SELECT id FROM your_table LIMIT ?)";

        try (Connection conn = DriverManager.getConnection(url);
             PreparedStatement pstmt = conn.prepareStatement(sql)) {

            // 设置更新的值
            pstmt.setString(1, "new_value");

            // 设置LIMIT的值
            pstmt.setInt(2, 10);

            // 执行更新操作
            int rowsUpdated = pstmt.executeUpdate();
            System.out.println("Rows updated: " + rowsUpdated);

        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }
}