JMeter connecting MySQL Database

1. Add the jar bundle that connects MySQL to the test plan

Mysql-connector-java-5.1.7-bin.jar

2, Thread group Add configuration component-jdbc Connection config

Input variable name for created pool input Wang

Set in database connection Configuraction

A, Databaseurl:jdbc:mysql://ip:3306/dangdang?allowmultiqueries=true&characterencoding=utf8

B,JDBC Driver Class:com.mysql.jdbc.driver

C, username password: Enter the user name and password for the database

3. Add sample---------JDBC request under Thread Group

In variable name to bound to pool: Enter the 2nd step set by Wang

4, enter the SQL statement in SQL Queery

For example: Delete database data, type to select Update

Select selection Type

Mixed types can be selected callable statement

Comment out an SQL statement preceded by--such as--a space between the Select and the statement

Type is wrong to perform unsuccessful ....

5, to see the results, you can add another view of the result tree.

JMeter connecting MySQL Database