[大数据]向数据库插入10w条数据

感慨：10w条数据仅仅需要几百毫秒，厉害呀addBatch
Long begin = new Date().getTime();
			//分批插入兑换码
			Connection conn = null;
			try {
				log.info("开始将生成的兑换码批量插入数据库");
				conn =  DriverManager.getConnection(jdbcProperties.getUrl(), jdbcProperties.getUsername(), jdbcProperties.getPassword());//获取连接
                // 设置事务为非自动提交
				conn.setAutoCommit(false);
				PreparedStatement pst = conn.prepareStatement(" ");
				String prefix = "INSERT INTO t_exchange_code (exchange_id,exchange_code,STATUS,creat_time) VALUES";  //此处为对应插入表的列
				StringBuffer suffix = new StringBuffer();
				for(int i = 0;i<exchangeCodes.size();i++){
					suffix.append("( "+exchangeCodes.get(i).getExchangeId()+",\""+exchangeCodes.get(i).getExchangeCode()+"\","+exchangeCodes.get(i).getStatus()+",\""+DateUtils.getTime()+"\"),");
				}
				String sql = prefix + suffix.substring(0, suffix.length() - 1);
                // 添加执行SQL
				pst.addBatch(sql);
                // 执行操作
				pst.executeBatch();
                // 提交事务
				conn.commit();
				pst.close();
				//关闭事务
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			Long end = new Date().getTime();
			log.info("兑换码number={}插入数据库花费的时间为time={}",exchangeCodes.size(),(end - begin) / 1000 + " s");
		}

import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;

/**
 * <一句话功能简述> <功能详细描述>
 *
 * @author chunyanye
 * @version 2021/10/29
 * @see [相关类/方法]
 * @since [cloud-phone-platform]
 */
@Data
@Component
@ConfigurationProperties (prefix = "spring.datasource.druid.master")
public class JdbcProperties
{
	//华为云AK/SK
	private String url;
	private String username;
	private String password;
}