使用java.sql.DriverManager;进行数据批量写入
首先下载mysql-connect连接驱动包,https://dev.mysql.com/downloads/connector/j/5.1.html
将驱动包mysql-connector-j-8.2.0.jar放入项目lib下并右键选择add as library。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
public class BatchSQLExample {
public static void main(ArrayList<HashMap> args) {
try {
Connection Database_Connection = null;
//mysql驱动
String driver = "com.mysql.cj.jdbc.Driver";
//测试驱动连接
try{
Class.forName(driver);
}
catch (ClassNotFoundException e){
e.printStackTrace();
}
String url = "jdbc:mysql://localhost:3306/sakila?useOldAliasMetadataBehavior%3Dtrue%26serverTimezone%3DGMT%2B8%26useUnicode%3Dtrue%26characterEncoding%3DUTF-8%26useSSL%3Dfalse%26nullCatalogMeansCurrent%3Dtrue";
String user = "root";
String password = "123456";
Database_Connection = DriverManager.getConnection(url, user, password);
String sql = "INSERT INTO user (id, username) VALUES (?, ?)";
PreparedStatement preparedStatement = Database_Connection.prepareStatement(sql);
for (int i = 0; i < args.size(); i++) {
System.out.println(i);
HashMap tempmap1 = new HashMap();
tempmap1 = args.get(i);
preparedStatement.setInt(1, (int) tempmap1.get("id"));
preparedStatement.setString(2, (String) tempmap1.get("username"));
preparedStatement.addBatch();
}
int[] result = preparedStatement.executeBatch();
System.out.println("Rows affected: " + result.length);
preparedStatement.close();
Database_Connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
调用批量写入函数
BatchSQLExample batchsql = new BatchSQLExample();
ArrayList<HashMap> paramList = new ArrayList<>();
HashMap tempmap = new HashMap<>();
tempmap.put("id",1);
tempmap.put("username","hw");
paramList.add(tempmap);
tempmap = new HashMap<>();
tempmap.put("id",2);
tempmap.put("username","qyq");
paramList.add(tempmap);
System.out.println(paramList);
batchsql.main(paramList);
标签:java,HashMap,mysql,数据库,tempmap,写入,sql,String
From: https://www.cnblogs.com/hanwang/p/18364554