We already know numerous ways of performing database operations through the controller either by using direct operations or by using database method. When it comes to performing the operations through visualforce pages, REST API comes into the picture. But do we have only REST API for the work? No, it isn’t. We can also perform Database operations through AJAX.

Database operations through AJAX

Let’s get started with the code.

<apex:page >
         * Webkul Software.
         * @category  Webkul
         * @author    Webkul
         * @copyright Copyright (c) 2010-2016 Webkul Software Private Limited (https://webkul.com)
         * @license   https://store.webkul.com/license.html
    <script src="/soap/ajax/42.0/connection.js" type="text/javascript"></script>
    <div id="create">
    <button type="button" id="createAccount" onclick="createAccount()">Create Account</button><br/><br/>
    <div id="update">
    <button type="button" id="updateAccount" onclick="updateAccount()">Update Account</button><br/><br/>
    <div id="read">
    <button type="button" id="readAccount" onclick="readAccount()">Read Account</button><br/><br/>
    <div id="delete">
    <button type="button" id="deleteAccount" onclick="deleteAccount()">Delete Account</button>
    <script type="text/javascript">
        //Establish the connection
        sforce.connection.sessionId = '{!$Api.Session_ID}';
        //Create account
        var accountId='';
        function createAccount(){
            var account = new sforce.SObject("Account");
            account.Name = 'Test Account';        
            account = sforce.connection.create([account]);
            var result =  unescape(JSON.stringify(account));
            accountId = result.substring(result.indexOf("id:'")+9,result.indexOf("id:'")+27);       
            console.log(JSON.stringify('accountId: '+accountId));
            document.getElementById('create').innerHTML = result;
         //Update Account
        function updateAccount(){
            var account = new sforce.SObject("Account");
            account.Id = accountId;
            account.Name = '{!$User.CompanyName}';        
            account = sforce.connection.update([account]);
            var result =  unescape(JSON.stringify(account));
            accountId = result.substring(result.indexOf("id:'")+9,result.indexOf("id:'")+27);       
            console.log(JSON.stringify('accountId: '+accountId));
            document.getElementById('update').innerHTML = result +'Account Updated';
        //Read account
        function readAccount(){
            var account = sforce.connection.query("Select Id,Name from Account where Account.Id='"+accountId+"'");
            records = account.getArray("records");
            var str =''
            for (var i=0; i< records.length; i++) {
              var record = records[i];
              str = unescape(JSON.stringify(record));
            document.getElementById('read').innerHTML = str;
        //Delete Account
        function deleteAccount(){
            var deleteAccount = sforce.connection.deleteIds([accountId]);
            if (deleteAccount[0].getBoolean("success")) {
              document.getElementById('delete').innerHTML ="account with id " + accountId + " is deleted";
            } else {
              document.getElementById('delete').innerHTML = "failed to delete account " + accountId;



database operations through ajax


That’s all about database operations by using ajax, for any further queries feel free to contact us at:
Or let us know your views on how to make this code better, in the comments section below.


Leave A Reply

Please verify that you are not a robot.

Tell us about Your Company

How can we help you with your business?

    Message Sent!

    If you have more details or questions, you can reply to the received confirmation email.

    Back to Home