Advertisement
Guest User

Untitled

a guest
Sep 7th, 2017
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.75 KB | None | 0 0
  1. <h1>Please Enter The Car Details</h1>
  2. <form >
  3. Car No:<input type="number" id="carnum" placeholder="Please enter your no" ><br><br>
  4. Details:<input type="text" id= "details" placeholder="Please enter car details" > <br><br>
  5. <input type="submit" value="Register" onclick="loadFeeds1()">
  6.  
  7. </form>
  8.  
  9. var users = WL.Server.createSQLStatement("insert into car(carno,details) values (?,?)");
  10. function getusers(carno,details) {
  11. return WL.Server.invokeSQLStatement({
  12. preparedStatement : users,
  13. parameters : [carno,details]
  14. });
  15. }
  16.  
  17. function loadFeeds1(){
  18. var invocationData = {
  19. adapter:"car2",
  20. procedure:"getuser",
  21. parameters:["carno","details"]
  22. };
  23.  
  24.  
  25. WL.Server.invokeProcedure(invocationData,{
  26. onSuccess :loadFeedsSuccess1,
  27. onFailure :loadFeedsFailure1,
  28. });
  29. }
  30.  
  31. function loadFeedsSuccess1() {
  32.  
  33. WL.Logger.debug("inserted");
  34.  
  35.  
  36. }
  37.  
  38. function loadFeedsFailure1() {
  39. WL.Logger.debug("failed");
  40.  
  41. }
  42.  
  43. function loadFeeds1(){
  44. var invocationData = {
  45. adapter:"car2",
  46. procedure:"getuser",
  47. parameters:[$('#carnum').val(),$('#details').val()]
  48. };
  49.  
  50. WL.Server.invokeProcedure(invocationData,{
  51. onSuccess :loadFeedsSuccess1,
  52. onFailure :loadFeedsFailure1,
  53. });
  54. }
  55.  
  56. <h1>Test Insert Into Database</h1>
  57. <input type="text" id="value1" placeholder="value1"/><br/>
  58. <input type="text" id="value2" placeholder="value2"/><br/>
  59. <input type="button" value="Insert values to database" onclick="insertValuesToDB();"/>
  60.  
  61. function insertValuesToDB() {
  62. var invocationData = {
  63. adapter: 'insertValuesAdapter',
  64. procedure: 'insertValuesProcedure',
  65. parameters: [$('#value1').val(), $('#value2').val()]
  66. };
  67.  
  68. WL.Client.invokeProcedure(invocationData, {onSuccess: insertSuccess, onFailure: insertFailure});
  69. }
  70.  
  71. function insertSuccess() {
  72. alert("success");
  73. }
  74.  
  75. function insertFailure() {
  76. alert("failure");
  77. }
  78.  
  79. ...
  80. ...
  81. <connectivity>
  82. <connectionPolicy xsi:type="sql:SQLConnectionPolicy">
  83. <dataSourceDefinition>
  84. <driverClass>com.mysql.jdbc.Driver</driverClass>
  85. <url>jdbc:mysql://localhost:3306/worklight_training</url>
  86. <user>Worklight</user>
  87. <password>Worklight</password>
  88. </dataSourceDefinition>
  89. </connectionPolicy>
  90. <loadConstraints maxConcurrentConnectionsPerNode="5" />
  91. </connectivity>
  92.  
  93. <procedure name="insertValuesProcedure"/>
  94. ...
  95. ...
  96.  
  97. var insertValuesProcedureStatement = WL.Server.createSQLStatement("INSERT INTO users(userId, firstName, lastName, password) VALUES (?,?, 'someLastName', 'somePassword')");
  98.  
  99. function insertValuesProcedure(value1,value2) {
  100. return WL.Server.invokeSQLStatement({
  101. preparedStatement : insertValuesProcedureStatement,
  102. parameters : [value1,value2]
  103. });
  104. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement