Jmeter connects to the database process diagram

1. Download the MySQL jdbc driver (mysql-connector-java-5.1.28.jar) 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 - Configuration Components - 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 username

Password: Database connection password

5. Add JDBC Request

The Variable Name in the JDBC Request is consistent with the Variable Name value in the JDBC Connection Configuration

Query Type: You can select the type of SQL, whether it is a query, modification or deletion operation.

6. Add a result tree to see if the data response is correct

Note: If you want to execute multiple SQL statements at one time, separate each SQL statement with a semicolon (;). However, when configuring the Database URL in the JDBC Connection Configuration, add a parameter at the end: ?allowMultiQueries=true, and select Callable statement for Quer Type, as shown in the following figure:

The result is perfect, and I feel very happy~~~~~~

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.