1. 启动Jmeter
2. 添加 DBC Connection Configuration
右键线程组->添加->配置元件->JDBC Connection Configuration
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiYWan5SZsRGZp1mYfN3X0xWdhZWZk9CXzV2Zh1Wavw1M29CXsBXb09CXn9Gbi9CXuNmLt92YuEmbpNnLyU2Zh1Wavw1LcpDc0RHaiojIsJye.gif)
添加后进行必要的配置
3. 添加参数化所需变量
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiYWan5SZsRGZp1mYfN3X0xWdhZWZk9CXzV2Zh1Wavw1M29CXsBXb09CXn9Gbi9CXuNmLt92YuEmbpNnLyU2Zh1Wavw1LcpDc0RHaiojIsJye.gif)
配置
<a href="https://s4.51cto.com/wyfs02/M00/9D/10/wKioL1l5lxnQpkvHAAAxSO5tvTs171.png" target="_blank"></a>
4. 添加JDBC Request
右键线程组->添加->Sampler->JDBC Request
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiYWan5SZsRGZp1mYfN3X0xWdhZWZk9CXzV2Zh1Wavw1M29CXsBXb09CXn9Gbi9CXuNmLt92YuEmbpNnLyU2Zh1Wavw1LcpDc0RHaiojIsJye.gif)
配置:
<a href="https://s5.51cto.com/wyfs02/M01/9D/10/wKiom1l5l1zxEP_WAABMv7UWbQ8566.png" target="_blank"></a>
4.1插入一千条数据
5. 添加查看结果树
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLiYWan5SZsRGZp1mYfN3X0xWdhZWZk9CXzV2Zh1Wavw1M29CXsBXb09CXn9Gbi9CXuNmLt92YuEmbpNnLyU2Zh1Wavw1LcpDc0RHaiojIsJye.gif)
6. 最后如下,对线程组进行必要的配置后,运行查看
本文转自 32氪 51CTO博客,原文链接:http://blog.51cto.com/10672221/1951440