JMeter Operations Database (MySQL for example)

JMeter can not directly connect to the database, first install a jmeter connection to the MySQL database file Mysql-connector-java-5.1.7-bin.jar (do not install, put in a location.) ）

Different database, such as Oracle, SQL Server and other different jar packages, can be found on the Internet.

First build a thread group, all set to 1 times first see if it can be used.

This jar package was found in the test plan:

First, connect to the database. Add JDBC Connection configuration, set connection information, account password and other content:

Variable name to set a random, then will use.

URL, account number, password and other content set up well.

Executes the SQL statement after it is configured. To add a JDBC request:

Show tables; First look at which tables are in the database. The results of the operation are shown in the results tree. Note the English semicolon.

SELECT * from App_student; Query App_student the contents of this table

Query type: statement types, queries with Select, additions and deletions instead of update, together with can choose callable

If you want to modify the table contents, use Update.

First look at the structure of the App_student table, as follows

The number of coins to be modified for all personnel is 999:

JMeter Operations Database (MySQL for example)