Guest User

Untitled

a guest
Aug 5th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. function SetChannelSetting(channel_id, settings_key, settings_value) {
  2.  
  3.  
  4. var dbSetChannelSetting = DatabaseConnectionFactory.createDatabaseConnection("com.mysql.jdbc.Driver","jdbc:mysql://localhost:3306/mirthdb","USR","PWD");
  5.  
  6. var sSQL = "INSERT INTO CHANNEL_SETTINGS VALUES ('" + channel_id + "','" + settings_key + "','" + settings_value + "') ON DUPLICATE KEY UPDATE SETTINGS_VALUE='" + settings_value + "'";
  7.  
  8. dbSetChannelSetting.executeUpdate(sSQL);
  9.  
  10. dbSetChannelSetting.close();
  11. }
Add Comment
Please, Sign In to add comment