解决Mysql删除自增ID的无序问题

在这里插入代码片
AffairOperating源码
package com.itcast.userDemo.utils.db;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;

import javax.sql.DataSource;

/**
 * 针对数据库的增删改操作 事务处理
 */
public class AffairOperating {
    private JdbcTemplate template;
    private DataSource dataSource;

    public AffairOperating() {
        dataSource = new JDBCUtils().getDataSource(); //这是自定义了,主要是为了获取数据库连接池
        template=new JdbcTemplate(dataSource);
    }
    //事务管理
    private DataSourceTransactionManager getDataSourceTransactionManager(){
        return new DataSourceTransactionManager(this.dataSource);
    }
    //开启事务
    private TransactionStatus beginTransaction(DataSourceTransactionManager manager) {
        DefaultTransactionDefinition definition=new DefaultTransactionDefinition();
        definition.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        return manager.getTransaction(definition);
    }

    /**
     * 针对数据的更新操作
     * @param sql
     * @param args
     * @return true:操作成功,false:操作失败
     */
    public boolean update(String sql,Object... args){
        boolean state=true;
        DataSourceTransactionManager manager = getDataSourceTransactionManager();
        TransactionStatus transactionStatus = beginTransaction(manager);

        try {
            this.template.update(sql,args);
            manager.commit(transactionStatus);
        }catch (Exception e) {
            e.printStackTrace();
            state=false;
            manager.rollback(transactionStatus);
        }

        return state;
    }
    public boolean update(String sql){
        boolean state=true;
        DataSourceTransactionManager manager = getDataSourceTransactionManager();
        TransactionStatus transactionStatus = beginTransaction(manager);

        try {
            this.template.update(sql);
            manager.commit(transactionStatus);
        }catch (Exception e) {
            e.printStackTrace();
            state=false;
            manager.rollback(transactionStatus);
        }

        return state;
    }
}

在这里插入代        
		List<User> users = findAll();  //清空前要先获取表中的所有信息
        AffairOperating operating = new AffairOperating();
        operating.update("TRUNCATE TABLE user");    //清空表
        for (User user : users) {
            String sql="insert into user (name,age,sex,address,birthday,qq,email) values(?,?,?,?,?,?,?)";
            operating.update(sql,user.getName(),
                    user.getAge(),
                    user.getSex(),
                    user.getAddress(),
                    user.getBirthday(),
                    user.getQq(),
                    user.getEmail()
            );
        }
        码片