Jmeter链接数据库原来这么简单~

╰半橙微兮° 2024-05-23 18:39 41阅读 0赞

![5ed80d7da6904639a76a02864c8beec2.png][]

[2024软件测试面试刷题，这个小程序（永久刷题），靠它快速找到工作了！（刷题APP的天花板）\_软件测试刷题小程序-CSDN博客文章浏览阅读3k次，点赞86次，收藏13次。你知不知道有这么一个软件测试面试的刷题小程序。里面包含了面试常问的软件测试基础题，web自动化测试、app自动化测试、接口测试、性能测试、自动化测试、安全测试及一些常问到的人力资源题目。最主要的是他还收集了像阿里、华为这样的大厂面试真题，还有互动交流板块……\_软件测试刷题小程序编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502编辑https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502![icon-default.png?t=N7T8][icon-default.png_t_N7T8]https://blog.csdn.net/AI\_Green/article/details/134931243?spm=1001.2014.3001.5502][2024_APP_-CSDN_3k_86_13_web_app_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502]

测接口正确性不可避免要连数据库验证数据正确性。此文以个人理解整理jmeter连接数据库，数据验证，数据供后续请求使用的方法。

### **01 连接数据库** ###

常用数据库如MySQL，**driver class如果没有可用的**，需要外部引入数据库驱动的可以把驱动包放在jmeter本身的jar包路径下，方便引用，也防止外部目录改变或清理后找不到包报错。

添加JDBC Connection Configuration，配置连接数据库相关参数

![8bedd1247d8049fe86267e68103214c6.png][]

*  database URL格式：jdbc:mysql://ip:port/table?allowMutiQueries=true&characterEncoding=utf-8
 *  characterEncoding=utf-8：解决插入乱码
 *  allowMutiQueries=true：可以同时写多条sql，否则会报错

接口测试的时候为了避免不必要的乱码，输入尽量用英文代替中文

### **02 查询数据库JDBC Request** ###

查询单条，select statement，连接串中可以不加allowMutiQueries=true

![图片][d4c266204742913ba3bf3c1b35216ecf.png]

查询多条，callable statement，config连接串中必须加allowMutiQueries=true，否则查询报错

![图片][8f8546fee6838b08a0c413ef819c4ca7.png]

多条结果显示如下：

![图片][42334c57a0f2f13e8f19f51140468733.png]

### **0****3 查询结果使用** ###

直接**保存到jmeter变量-Variable names中**，直接引用，如下：

![图片][4a230f6fd76c2259fd56d2111fd6bc4d.png]

上图中，我查询了4条数据，引用时用 $\{variable name\_n\} 取值，n是需要的第几条数据。如下图：

![图片][bda835e119a2fa62a8fb6916a4252980.png]

添加检查点、结果树，run之后发现是成功查询、引用到数据的。

![图片][2f34751665ca48c66b51b0171fb17fad.png]

这个方法方便直接，也可以把数据结果保存到文件中，后面再更新

行动吧，在路上总比一直观望的要好，未来的你肯定会感谢现在拼搏的自己！如果想学习提升找不到资料，没人答疑解惑时，**请及时加入群： 759968159**，里面有各种测试开发资料和技术可以一起交流哦。

**最后：** 下方这份完整的软件测试视频教程已经整理上传完成，需要的朋友们可以自行领取**`【保证100%免费】`**

![06b7bc1a690d4c4f826248342215214c.png][]

**软件测试面试文档**

我们学习必然是为了找到高薪的工作，下面这些面试题是来自阿里、腾讯、字节等一线互联网大厂最新的面试资料，并且有字节大佬给出了权威的解答，刷完这一套面试资料相信大家都能找到满意的工作。![在这里插入图片描述][cc56d6ee4baf482688db0e1410e2bb51.png]

![在这里插入图片描述][755123cb1321421b96888db976754489.png]

![3010ebc19b1042d4a4e99e0c9334bb1c.gif][]

[5ed80d7da6904639a76a02864c8beec2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/8b4aa1953d2e46afbbe04d74ccf7afdf.png
[icon-default.png_t_N7T8]: https://csdnimg.cn/release/blog_editor_html/release2.3.6/ckeditor/plugins/CsdnLink/icons/icon-default.png?t=N7T8
[2024_APP_-CSDN_3k_86_13_web_app_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502_icon-default.png_t_N7T8_icon-default.png_t_N7T8_https_blog.csdn.net_AI_Green_article_details_134931243_spm_1001.2014.3001.5502]: https://blog.csdn.net/AI_Green/article/details/134931243?spm=1001.2014.3001.5502
[8bedd1247d8049fe86267e68103214c6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/eb0c6fdc00bc41efb1685f3ded8a01c2.png
[d4c266204742913ba3bf3c1b35216ecf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/fdad1fcf91c94adb91c71de77024afdb.png
[8f8546fee6838b08a0c413ef819c4ca7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/154cbc59d7be43eeaf7874ed407d767c.png
[42334c57a0f2f13e8f19f51140468733.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/56a8c427a0f14cfb9f9f14097ce589c4.png
[4a230f6fd76c2259fd56d2111fd6bc4d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/d056219f93f346958ba7e924f8f5753d.png
[bda835e119a2fa62a8fb6916a4252980.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/cd6325ac7834416a95cec2775dffa839.png
[2f34751665ca48c66b51b0171fb17fad.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/004b2a1ec53a4093878f736b9a4600c0.png
[06b7bc1a690d4c4f826248342215214c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/12fe942df6bc4686b237b90618a26306.png
[cc56d6ee4baf482688db0e1410e2bb51.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/3c571557313d43a2908de1776d2b24fa.png
[755123cb1321421b96888db976754489.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/63ee4907b5e147ffba9dc16e5fb07e79.png
[3010ebc19b1042d4a4e99e0c9334bb1c.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/05/23/80216a2fed1c4debb42a1d775a2b49cb.gif