ngrinder 入库mysql_nGrinder TestRunnerInsertMysqlSingle.groovy

s

C:\Users\Lindows\workspace\GroovyTest\src\com\iteye\lindows\mysql\TestRunnerInsertMysqlSingle.groovy

1 packagecom.iteye.lindows.mysql

2

3 importjunit.framework.Assert

4 importnet.grinder.script.GTest

5 importnet.grinder.scriptengine.groovy.junit.GrinderRunner

6 importnet.grinder.scriptengine.groovy.junit.annotation.AfterThread

7 importnet.grinder.scriptengine.groovy.junit.annotation.BeforeProcess

8 importnet.grinder.scriptengine.groovy.junit.annotation.BeforeThread

9 importorg.junit.Test

10 importorg.junit.runner.RunWith

11

12 importjava.sql.Connection

13 importjava.sql.DriverManager

14 importjava.sql.ResultSet

15 importjava.sql.Statement

16

17 import staticnet.grinder.script.Grinder.grinder

18 import staticorg.junit.Assert.assertTrue

19

20 /**

21 * java代码示例，连接数据库进行查询

22 *

23 * @author Lindows

24 */

25 @RunWith(GrinderRunner)

26 classTestRunnerInsertMysqlSingle {

27 public staticGTest insertTable

28 public staticConnection conn;

29 public static Statement stmt; //创建Statement对象

30

31 @BeforeProcess

32 public static voidbeforeProcess() {

33 insertTable = new GTest(1, "插入表数据")

34 try{

35 Class.forName("com.mysql.jdbc.Driver");

36 grinder.logger.info("成功加载MySQL驱动！");

37 String url="jdbc:mysql://10.37.136.162:3306/performance_test"; //JDBC的URL

38 String username = "performance_user";

39 String passwd = "performance!QAZ";

40 conn =DriverManager.getConnection(url, username, passwd);

41 stmt = conn.createStatement(); //创建Statement对象

42 grinder.logger.info("成功创建stmt！");

43 } catch(Exception e) {

44 e.printStackTrace()

45 }

46 }

47

48 @BeforeThread

49 public voidbeforeThread() {

50 insertTable.record(this, "insertTable")

51 grinder.statistics.delayReports=true

52 }

53

54 @Test

55 public voidinsertTable() {

56 try{

57 grinder.logger.info("成功连接到数据库！");

58 StringBuffer sql = newStringBuffer()

59 sql.append("insert into tab_002(column_int,column_double,column_decimal,column_varchar_name,column_varchar_address,column_text,column_timestamp_create_time,column_timestamp_update_time) values (1000,300.25,600.98,'jack','")

60 .append("China BeiJing")

61 .append(new Random().nextInt(99999999))

62 .append("', 'work in lindows for 3 years','2017-06-12 18:00:00','2017-06-13 15:00:00')")

63 grinder.logger.info(sql.toString())

64 Thread.sleep(new Random().nextInt(10)) //这里可以设置思考时间10ms

65 assertTrue(!stmt.execute(sql.toString()))//执行sql insert，!stmt.execute(sql)该写法只于insert true确认

66 //assertTrue(stmt.execute(sql));//执行sql query , !stmt.execute(sql)该写法只适用于query true确认

67 }catch(Exception e) {

68 e.printStackTrace();

69 }

70 }

71

72 @AfterThread

73 public voidafterThread() {

74 stmt.close();

75 conn.close();

76 }

77 }

C:\Users\Lindows\Desktop\lab\groovy\libs

1 asm-3.3.1.jar2 commons-lang-2.6.jar3 commons-lang3-3.3.2.jar4 commons-logging-1.0.4.jar5 grinder-core-3.9.1.jar6 grinder-dcr-agent-3.9.1.jar7 grinder-http-3.9.1.jar8 grinder-http-patch-3.9.1-patch.jar9 grinder-httpclient-3.9.1.jar10 grinder-httpclient-patch-3.9.1-patch.jar11 grinder-patch-3.9.1-patch.jar12 hamcrest-all-1.1.jar13 json-20090211.jar14 junit-dep-4.11.jar15 log4j-1.2.15.jar16 logback-classic-1.0.0.jar17 logback-core-1.0.0.jar18 mysql-connector-java-5.1.36 (1).jar19 ngrinder-core-3.4.jar20 ngrinder-groovy-3.4.jar21 ngrinder-runtime-3.4.jar22 ngrinder-sh-3.4.jar23 slf4j-api-1.6.4.jar

junit  test运行异常：

java.lang.RuntimeException: Please add

-javaagent:C:\Users\Lindows\Desktop\lab\groovy\libs\grinder-dcr-agent-3.9.1.jar

in 'Run As JUnit' vm argument.

at net.grinder.engine.process.JUnitThreadContextInitializer.initialize(JUnitThreadContextInitializer.java:72)

at net.grinder.scriptengine.groovy.junit.GrinderRunner.initializeGrinderContext(GrinderRunner.java:142)

at net.grinder.scriptengine.groovy.junit.GrinderRunner.(GrinderRunner.java:112)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at org.junit.internal.builders.AnnotatedBuilder.buildRunner(AnnotatedBuilder.java:29)

at org.junit.internal.builders.AnnotatedBuilder.runnerForClass(AnnotatedBuilder.java:21)

at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:59)

at org.junit.internal.builders.AllDefaultPossibilitiesBuilder.runnerForClass(AllDefaultPossibilitiesBuilder.java:26)

at org.junit.runners.model.RunnerBuilder.safeRunnerForClass(RunnerBuilder.java:59)

at org.junit.internal.requests.ClassRequest.getRunner(ClassRequest.java:26)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.(JUnit4TestReference.java:33)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestClassReference.(JUnit4TestClassReference.java:25)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestLoader.createTest(JUnit4TestLoader.java:48)

at org.eclipse.jdt.internal.junit4.runner.JUnit4TestLoader.loadTests(JUnit4TestLoader.java:38)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:452)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)

at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

解决一： -javaagent:C:\Users\Lindows\Desktop\lab\groovy\libs\grinder-dcr-agent-3.9.1.jar

Debug As JUnit Test ，，，ok！

end