下午花了两个小时研究了一下Jmeter发送JDBC请求,现在把基本操作流程分享一下。
做JDBC请求,首先需要两个jar包:mysql驱动-mysql-connector-java-5.1.13-bin.jar 和 sqlServer驱动-sqljdbc4.jar,将这两个jar包放到Jmeter目录中的lib文件下,然后重启Jmeter。(需要jar包的直接联系本人哦)
1:添加线程组
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMDM4MDY5OTAtMTQ4NDMxNzY0LnBuZw%3D%3D.png?w=700&webp=1)
2:添加 JDBC Connection Configuration
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMDM4NTYyMDktOTA2NzIzNDE5LnBuZw%3D%3D.png?w=700&webp=1)
3:配置 JDBC Connection Configuration 基本参数(注意Variable Name命名必须和之后JDBC Request中的Variable Name 命名一致)
Driver Class 可写成org.gjt.mm.mysql.Driver,也可写成com.mysql.jdbc.Driver,以响应正确为基准
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMDQ5NDYxMTUtMTExMTYzNjk0MS5wbmc%3D.png?w=700&webp=1)
4:添加 JDBC request
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMDU3MTQ5OTAtNzQ4MzE2OTA1LnBuZw%3D%3D.png?w=700&webp=1)
4: JDBC request 中,键入sql查询语句
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMDU4NTM1MjEtMTUzMzU1MTg2Mi5wbmc%3D.png?w=700&webp=1)
5:执行线程,查看结果如下
![Jmeter发送JDBC请求 Jmeter发送JDBC请求](https://image.shishitao.com:8440/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvOTQ2NDU0LzIwMTcxMi85NDY0NTQtMjAxNzEyMjEyMTAzMzQxOTMtODk3NjU1Mjk0LnBuZw%3D%3D.png?w=700&webp=1)
基本内容就是这么多,后面会再说说如何从jdbc响应中取值做关联