Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <h1>Please Enter The Car Details</h1>
- <form >
- Car No:<input type="number" id="carnum" placeholder="Please enter your no" ><br><br>
- Details:<input type="text" id= "details" placeholder="Please enter car details" > <br><br>
- <input type="submit" value="Register" onclick="loadFeeds1()">
- </form>
- var users = WL.Server.createSQLStatement("insert into car(carno,details) values (?,?)");
- function getusers(carno,details) {
- return WL.Server.invokeSQLStatement({
- preparedStatement : users,
- parameters : [carno,details]
- });
- }
- function loadFeeds1(){
- var invocationData = {
- adapter:"car2",
- procedure:"getuser",
- parameters:["carno","details"]
- };
- WL.Server.invokeProcedure(invocationData,{
- onSuccess :loadFeedsSuccess1,
- onFailure :loadFeedsFailure1,
- });
- }
- function loadFeedsSuccess1() {
- WL.Logger.debug("inserted");
- }
- function loadFeedsFailure1() {
- WL.Logger.debug("failed");
- }
- function loadFeeds1(){
- var invocationData = {
- adapter:"car2",
- procedure:"getuser",
- parameters:[$('#carnum').val(),$('#details').val()]
- };
- WL.Server.invokeProcedure(invocationData,{
- onSuccess :loadFeedsSuccess1,
- onFailure :loadFeedsFailure1,
- });
- }
- <h1>Test Insert Into Database</h1>
- <input type="text" id="value1" placeholder="value1"/><br/>
- <input type="text" id="value2" placeholder="value2"/><br/>
- <input type="button" value="Insert values to database" onclick="insertValuesToDB();"/>
- function insertValuesToDB() {
- var invocationData = {
- adapter: 'insertValuesAdapter',
- procedure: 'insertValuesProcedure',
- parameters: [$('#value1').val(), $('#value2').val()]
- };
- WL.Client.invokeProcedure(invocationData, {onSuccess: insertSuccess, onFailure: insertFailure});
- }
- function insertSuccess() {
- alert("success");
- }
- function insertFailure() {
- alert("failure");
- }
- ...
- ...
- <connectivity>
- <connectionPolicy xsi:type="sql:SQLConnectionPolicy">
- <dataSourceDefinition>
- <driverClass>com.mysql.jdbc.Driver</driverClass>
- <url>jdbc:mysql://localhost:3306/worklight_training</url>
- <user>Worklight</user>
- <password>Worklight</password>
- </dataSourceDefinition>
- </connectionPolicy>
- <loadConstraints maxConcurrentConnectionsPerNode="5" />
- </connectivity>
- <procedure name="insertValuesProcedure"/>
- ...
- ...
- var insertValuesProcedureStatement = WL.Server.createSQLStatement("INSERT INTO users(userId, firstName, lastName, password) VALUES (?,?, 'someLastName', 'somePassword')");
- function insertValuesProcedure(value1,value2) {
- return WL.Server.invokeSQLStatement({
- preparedStatement : insertValuesProcedureStatement,
- parameters : [value1,value2]
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement