import com.google.common.collect.Lists;
import com.google.common.collect.Multimap;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
public class DataCollectorExample {
public static void main(String[] args) {
List<String> dataList = Lists.newArrayList("data1", "data2", "data3");
Connection connection = null;
try {
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
} catch (SQLException e) {
e.printStackTrace();
}
Multimap<String, String> dataMap = DataCollector.collect(dataList);
for (String key : dataMap.keySet()) {
String query = "INSERT INTO mytable (key, value) VALUES (?, ?)";
for (String value : dataMap.get(key)) {
try (PreparedStatement statement = connection.prepareStatement(query)) {
statement.setString(1, key);
statement.setString(2, value);
statement.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
