Advertisement
Guest User

Untitled

a guest
Nov 9th, 2016
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function readFromTable() {
  2.  
  3.   var address = '91.134.124.240:3306';
  4.   var user = 'wachumb1_test';
  5.   var userPwd = 'skola123';
  6.   var db = 'wachumb1_test';
  7.    
  8.   var dbUrl = 'jdbc:mysql://' + address + '/' + db;
  9.    
  10.   var conn = Jdbc.getConnection(dbUrl, user, userPwd);
  11.  
  12.   var start = new Date();
  13.   var stmt = conn.createStatement();
  14.   stmt.setMaxRows(1000);
  15.   var results = stmt.executeQuery('SELECT * FROM skola');
  16.   var numCols = results.getMetaData().getColumnCount();
  17.  
  18.   while (results.next()) {
  19.     var rowString = '';
  20.     for (var col = 0; col < numCols; col++) {
  21.       rowString += results.getString(col + 1) + '\t';
  22.     }
  23.     Logger.log(rowString)
  24.   }
  25.  
  26.   results.close();
  27.   stmt.close();
  28.  
  29.   var end = new Date();
  30.   Logger.log('Time elapsed: %sms', end - start);
  31. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement