使用Java将数据添加到数据库

   <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <version>8.0.26</version>
    </dependency>
</dependencies>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydb";
        String user = "root";
        String password = "your_password";

        try {
            // 加载驱动程序
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 建立连接
            Connection connection = DriverManager.getConnection(url, user, password);

            // 准备插入数据的SQL语句
            String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);

            // 设置参数并执行SQL语句
            preparedStatement.setInt(1, 1);
            preparedStatement.setString(2, "John Doe");
            preparedStatement.executeUpdate();

            // 关闭连接
            preparedStatement.close();
            connection.close();

            System.out.println("数据已成功插入数据库");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}