是否可以通过 JMeter 在 mysql 数据库表中上传文件?
我是新的JMeter用户.我已经知道如何使用jmeter进行测试.现在我的问题是，是否可以通过JMeter上传mysql表中的文件?
I am new JMeter user.I already know how to use jmeter for testing.Now my question is,Is it possible to upload file in mysql table by JMeter?
推荐答案
如果我正确理解了您的用例 - 您需要将文件插入 MySQL BLOB 或 CLOB 字段.它可以通过 JMeter 实现.
If I'm correctly getting your use case - you need to insert a file into MySQL BLOB or CLOB field. It's doable via JMeter.
选项 1:
您是否尝试过 JMeter JDBC 请求的 Prepared Update Statement 选项采样器?它应该能够为您解决问题.
Have you tried Prepared Update Statement option of JMeter JDBC Request Sampler? It should be able to do the trick for you.
选项 2
如果你需要更多的灵活性 JMeter 可以通过 Beanshell 扩展.您只需要删除 MySQL JDBC Connector 并将其放在 JMeter 类路径中的任何位置(通常是它是用于扩展 jar 的/lib/ext 文件夹).
If you need more flexibility JMeter can be extended via Beanshell. All you need is to drop MySQL JDBC Connector and drop it anywhere in JMeter classpath (usually it's /lib/ext folder for extension jars).
完成后，您可以建立 MySQL 连接并将文件插入 MySQL 数据库.示例代码如下:
Once done you can establish MySQL connection and insert your file into MySQL database. Example code is below:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
Class.forName("com.mysql.jdbc.Driver");
Connection connect = DriverManager.getConnection("jdbc:mysql://host:port/databasename?user=databaseuser&password=databasepassword");
PreparedStatement preparedStatement = connect.prepareStatement("INSERT INTO MY_TABLE(id, blob_col) VALUES(1, LOAD_FILE('/full/path/to/file/myfile.png')");
preparedStatement.executeUpdate();
connect.close();
相关文章