测试您的DB2数据库:使用JMeter做性能测试

 
package com.ibm.jmetertest; 
import java.sql.*; 
 
public class JMeterPopulator 
{ 
  public static void main(String[] args) 
  { 
    try 
    { 
      Class.forName("COM.ibm.db2.jdbc.app.DB2Driver"); 
	String dbName = "loaddb"; 
	String url = "jdbc:db2:" + dbName; 
	String userName = "db2admin"; 
	String password = "db2admin"; 
	Connection con 
          = DriverManager.getConnection(url,userName, password); 
	int numOfTestRecords = 30000; 
	PreparedStatement statement 
          = con.prepareStatement("INSERT INTO LOADTABLE VALUES(?,?,?)"); 
	for (int i =0; i<numOfTestRecords; i++) 
	{ 
	  statement.setString(1,"Col1Test-" + i); 
	  statement.setString(2,"Col2Test-" + i); 
	  statement.setString(3,"Col3Test-" + i); 
	  statement.executeUpdate(); 
	  System.out.println(i); 
	} 
    } 
    catch(Exception e) 
    { 
       System.out.println("An error has occurred: " + e.toString()); 
       e.printStackTrace(); 
    } 
  } 
}