mysql查询取前五百条数据,Java JDBC一次显示前500条记录，提交，显示下500条记录等...

So I want to be able to display 500 records at a time, commit and print that it has been displayed records 1 to 500 records have been committed. And than do the next 500 records and commit again until reached the maximum records which is over 20k records. I managed to get the first 500 records but I am stuck how can I commit them and in commit them and continue to get the next 500 records and so on.

public static void selectRecordsIcore() throws SQLException {

Connection dbConnection = null;

PreparedStatement preparedStatement = null;

Statement statement = null;

String selectTableSQL = "SELECT profile_id, ingress_flag, egress_flag, ce_ingress_flag, ce_egress_flag from COS_PROFILE"

+ " WHERE profile_id >= ? AND profile_id <= ?;";

try {

dbConnection = getInformixConnec