用java写入mysql数据库

import java.sql.*;

public class MySQLWriter {
    public static void main(String[] args) {
        Connection connection = null;
        Statement statement = null;
        try {
            // 1. 导入相关库

            // 2. 建立数据库连接
            String url = "jdbc:mysql://localhost:3306/mydatabase";
            String username = "root";
            String password = "password";
            connection = DriverManager.getConnection(url, username, password);

            // 3. 创建SQL语句
            String sql = "INSERT INTO users (name, age) VALUES ('John', 25)";

            // 4. 执行SQL语句
            statement = connection.createStatement();
            int rowsAffected = statement.executeUpdate(sql);
            System.out.println("插入成功，影响行数：" + rowsAffected);

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 5. 处理异常和关闭连接
            try {
                if (statement != null) {
                    statement.close();
                }
                if (connection != null) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}