使用JAVA协议测试SQL SERVER数据库

1． 在LoadRunner的Virtual User Generator中增加SQL SERVER的环境变量：在Run-time Settings-Java Environment Settings-Classpath中增加msbase.jar、mssqlserver.jar、msutil.jar这三个包。

2． 在Virtual User Generator中选择Java Vuser协议

3． 输入以下内容：

  public int action() {

       try{

            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

                     Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.1.145:1433;databaseName=fund","sa","password");

            String sql="select * from(select distinct a.NewsTextID,a.PUBLISHDATE, a.Title,ROW_NUMBER() OVER (ORDER BY a.NewsTextID desc) AS ROWID from fund.dbo.NewsText a left join fund.dbo.CategoryInfoLink_bocom b on a.NewsTextID = b.INFOID where b.categoryid like '01%' )c WHERE ROWID>=110 and ROWID<=130 order by c.NewsTextID desc";//这就是在测试的SQL语句

            PreparedStatement pstmt=conn.prepareStatement(sql);

          //6执行语句

           pstmt.execute();

           //7程序提交

           pstmt.close();

           conn.close();

       }

       catch(Exception e){

                    }

              return 0;

      }//end of action   

4．记得Licsene的问题，就可以直接测试SQL SERVER了，相应的测试任何的数据库都可以用这种方法。