LoadRunner JAVA協議 來測試SQL效能

大家可能都知道 ODBC 協議是可以錄製下來,SQL SERVER 2000 但是這個協議是底層的協議,所以好多東西是我們不想要的,也有好多東西,是我們不知道的.所以參數化,及維護指令碼太難度了..由於這樣的原因,所以本要用JAVA代碼來寫了一個測試SQL的程式.

   /* * LoadRunner Java scrīpt. (Build: 873) * Writer fangtiesui * scrīpt Descrīption: SQL 查詢效能測試指令碼  * DATE : 2008-09-19                     */import java.io.*;import lrapi.lr;import java.sql.*;public class Actions{        int sum = 0; public int init() throws Throwable {return 0;}//end of init        public int action() throws Throwable {         try{    String sqldriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";Class.forName(sqldriver);System.out.println("資料庫驅動程式註冊成功！");String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school";String user = "sa";String password = "sa";String sel = "select * from student where id >950";Connection conn = DriverManager.getConnection(url,user,password);       System.out.println("資料庫連接成功");lr.start_transaction("查詢學生表");       Statement sta = conn.createStatement();       ResultSet rs = sta.executeQuery(sel);       System.out.print("/t"+"id"+"/t"+"name" + "/t"+"addr"+"/t"+"tel"+"/n");     while(rs.next())     {      System.out.print("/t"+rs.getInt(1));      System.out.print("/t"+rs.getString(2));      System.out.print("/t"+rs.getString(3));      System.out.println("/t"+rs.getString(4));      sum = sum + 1 ;     }      rs.close();      sta.close();      conn.close(); }catch(Exception e){e.printStackTrace(); System.out.println("Test Failed");   }               lr.message("Sum = "+sum);lr.end_transaction("查詢學生表", lr.AUTO);return 0;}//end of actionpublic int end() throws Throwable {return 0;}//end of end}