JMeter connect MySQL database, and conduct database operation;

1, before the operation JMeter Connection MySQL database, we need to download a jar package online. and add to the test plan; Mysql-connector-java-5.1.13-bin.jar the jar into Lib in the JMeter directory.

2. Create a new configuration component in the thread group: JDBC Connection config;

3. Fill in the Testmysql connection name, then select the corresponding update Statement; Add a SQL statement, or SELECT statement if it is a query;

Run, view result tree: Insert statement execution succeeded. can go to MySQL query whether this statement, really exist oh;

JMeter connect MySQL database, and conduct database operation;