Advertisement
Guest User

asddas

a guest
Nov 14th, 2016
90
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 stmt = conn.prepareStatement('INSERT INTO skola '
  13.       + '(text) values ("Juraj")');
  14.   stmt.execute();*/
  15.   Logger.clear();
  16.   var start = new Date();
  17.   var stmt = conn.createStatement();
  18.   stmt.setMaxRows(1000);
  19.   var results = stmt.executeQuery("SELECT * FROM skola");
  20.   var numCols = results.getMetaData().getColumnCount();
  21.  
  22.   var i = 0;
  23.   var strs = 'ABCDEFG';
  24.   while (results.next()) {
  25.     var rowString = '';
  26.     var j = 1;
  27.     for (var col = 0; col < numCols; col++) {
  28.       SpreadsheetApp.getActiveSpreadsheet().getRange(strs.charAt(i)+j.toString()).setValue(results.getString(col + 1));
  29.       j++;
  30.       rowString += results.getString(col + 1) + '\t';
  31.     }
  32.     Logger.log(rowString)
  33.     i++;
  34.   }
  35.  
  36.   results.close();
  37.   stmt.close();
  38.  
  39.   var end = new Date();
  40.   Logger.log('Time elapsed: %sms', end - start);
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement