How to save data from an array into a database in Java?

To store array data into a database, you need to use Java’s JDBC (Java Database Connectivity) interface to connect to the database and execute SQL statements to insert the data into a table. Firstly, you need to import the JDBC-related packages, such as:

import java.sql.*;

Next, you need to connect to the database. Here is an example of connecting to a MySQL database:

String url = "jdbc:mysql://localhost:3306/mydatabase"; // 数据库连接URL
String username = "root"; // 数据库用户名
String password = "password"; // 数据库密码
Connection connection = DriverManager.getConnection(url, username, password); // 连接数据库

Next, you can create a PreparedStatement object to execute the SQL statement. Assuming you have a table named “mytable” with two columns “column1” and “column2”, you can use the following code to store the data from the array into the database:

String sql = "INSERT INTO mytable (column1, column2) VALUES (?, ?)"; // SQL插入语句
PreparedStatement statement = connection.prepareStatement(sql); // 创建PreparedStatement对象
// 假设数组data包含要插入的数据
for (int i = 0; i < data.length; i++) {
    statement.setString(1, data[i]); // 设置第一个参数的值（column1）
    statement.setString(2, data[i]); // 设置第二个参数的值（column2）
    statement.executeUpdate(); // 执行SQL语句插入数据
}
statement.close(); // 关闭PreparedStatement对象
connection.close(); // 关闭数据库连接

In the above code, you need to replace “column1” and “column2” with the actual column names in your table, and replace “data” with the array you want to insert. Lastly, remember to close the PreparedStatement object and database connection after the operation is complete. Please note that the code above is just an example, you will need to make appropriate modifications based on your actual situation. Additionally, when using JDBC to access a database, you also need to handle exceptions, transactions, and other issues.