Jmeter connection database process diagram

1. Download the jdbc driver (mysql-connector-java-5.1.28.jar) of MySQL and put it in the...\ apache-jmeter-3.3\ lib\ directory.

Driver download address: https://dev.mysql.com/downloads/connector/j/

2. Add the driver address under the test plan

3. Select thread group-add-configure original-JDBC Connection Configuration

4. Configure JDBC Connection Configuration

Variable Name: this name is customized and will be used in JDBC Request

Database URL:jdbc:mysql:// database IP address: database port / database name

JDBC Driver Class:com.mysql.jdbc.Driver

Username: database connection user name

Password: database connection password

5. Add JDBC Request

The Variable Name in JDBC Request is the same as the Variable Name in JDBC Connection Configuration.

Query Type: you can choose the type of sql, query, modify or delete operation.

6. Add the view result tree to see whether the data response is correct.

Note: if you want to execute multiple SQL statements at one time, each SQL statement is separated by a semicolon (;), but add a parameter-allowMultiQueries=true at the end of configuring Database URL in JDBC Connection Configuration, and Quer Type must select Callable statement, as shown in the following figure:

The result is perfect, the mood is very happy ~

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.