Advertisement
Guest User

Untitled

a guest
Sep 7th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var ipAddress = '0.0.0.0';
  2. var userName = 'username';
  3. var userPassword = 'userpwd';
  4. var dbName = 'dbname';
  5. var tableName = "default_table";
  6.  
  7. var dbUrl = 'jdbc:mysql://' + ipAddress + '/' + dbName;
  8.  
  9. function test(){
  10.   //needs proper database info still
  11.   var range = SpreadsheetApp.getActiveSheet().getRange(1, 1);
  12.   var e = {range:range};
  13.   onEdit(e);
  14. }
  15.  
  16. function onEdit(e){
  17.   var range = e.range;
  18.   var row = range.getRow();
  19.   var col = range.getColumn();
  20.   var activeSheet = SpreadsheetApp.getActiveSheet();
  21.   var sheetName = activeSheet.getName();
  22.   var columnName = activeSheet.getRange(1, col).getValue();
  23.   var updatedValue = activeSheet.getRange(row, col).getValue();
  24.   var tableName = getTableName(sheetName);
  25.   updateRecord(tableName, columnName, row, updatedValue);
  26. }
  27.  
  28. function getTableName(sheetName) {
  29.   return tableName;
  30. }
  31.  
  32. function updateRecord(tableName, columnName, row, updatedValue){
  33.   var conn = Jdbc.getConnection(dbUrl, userName, userPassword);
  34.  
  35.   var stmt = conn.prepareStatement("UPDATE (tableName) " +
  36.                                   "SET (columnName)=(updatedValue) " +
  37.                                   "WHERE index=(row)");
  38.   stmt.setString(1, tableName);
  39.   stmt.setString(2, columnName);
  40.   stmt.setString(3, updatedValue);
  41.   stmt.setString(4, row);
  42.   stmt.execute();
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement