Method of JMeter connecting to database

First, go to the database to check your database version , Command select version ();

Get into Mysql Official website （https://www.mysql.com/） Download the corresponding jar package

Select the version corresponding to your database ：

Unzip the downloaded file , Then decompress the jar The bag is on your jmeter/lib Under the table of contents .

Restart jmeter, Right click the new thread group –> add to –> The configuration element –>JDBC Connection Configuration

JDBC Connection Configuration The properties are configured as follows :

Variable Name： Custom user name .

Datebase URL： Fill in the database URL,jdbc:mysql: Your database address ： Your database port number

Username： Your database name

Password： Your database connection password

JDBC Postprocessor （ After SQL）：

 JDBC Preprocessor （ In front of SQL）： Basically the same as the post

variables names Set to A,,C, Then the following variables will be set to ：

　　A_#=2 ( Total number of lines )
　　A_1= The first 1 Column , The first 1 That's ok
　　A_2= The first 1 Column , The first 2 That's ok
　　C_#=2 ( Total number of lines )
　　C_1= The first 3 Column , The first 1 That's ok
　　C_2= The first 3 Column , The first 2 That's ok

　　 If the returned result is 0, that A_# and C_# Will be set to 0, Other variables don't set values .

　　 If you return for the first time 6 Row data , The second time only returns 3 Row data , So the first time there were so many 3 Row data variables are cleared .

　　 have access to ${A_#}、${A_1}... To get the corresponding value .