Salesforce CRUD Operation using Apex class and Visualforce

Salesforce CRUD Operation using APEX Class and VisualForce by Shiva Sir

Student Object Insert Code:-

 CODE 1st:-

<apex:page controller="StuInsert" >

    <apex:form >

    <apex:pageBlock title="Collage Details">

       <apex:pageBlockSection columns="2">

                <apex:inputField value="{!coll.Name}"/> 

                <apex:inputField value="{!coll.fees__c}"/>

                <apex:commandButton value="Save Collage" action="{!save}"/>      

            </apex:pageBlockSection>

        

    </apex:pageBlock>

    </apex:form>

</apex:page>

APEX CODE for Data Insertion:-

public class StuInsert {

    public stu__c coll {get;set;}

    public StuInsert()

    {

        coll = new stu__c();

    }

  

public PageReference save() {

//coll.Name = 'raja';

       // coll.fees__c = 350000;

        insert coll;

return null;

}   

}

Example 2:-

<apex:page controller="StuOperation">

  <!-- Begin Default Content REMOVE THIS -->

  <h1>STUDENT INSERTION FORM</h1>

  

  <apex:form >

    <apex:pageBlock title="Stu Details">

        <apex:pageblockSection title="Student Information">

            <apex:inputField value="{!coll.Name}"/>

            <apex:inputField value="{!coll.fees__c}"/>

          

        </apex:pageblockSection>

        <apex:pageBlockButtons >

            <apex:commandButton value="Save Student" action="{!save}"/>

        </apex:pageBlockButtons>

    </apex:pageBlock>

    </apex:form>

</apex:page>

APEX CLASS:-

public class StuOperation {

public stu__c coll;

public StuOperation() {

coll = [SELECT Id, Name, fees__c FROM stu__c WHERE Id = :ApexPages.currentPage().getParameters().get('id')];

    

}

public stu__c getColl() {

return coll;

}

public PageReference save() {

upsert coll;

PageReference pref = new ApexPages.StandardController(coll).view();

return pref;

}    

}

................................................................................................................................................

Student Visualforce Page Container:-

<apex:page controller="StuCrudOperation">

  <apex:form >

      <apex:pageBlock id="anyName">

        <apex:pageblocktable value="{!allRec}" var="a">

              <apex:column value="{!a.id}"/>

               <apex:column value="{!a.Name}"/>

               <apex:column value="{!a.fees__c}"/>

             

          </apex:pageblocktable>

          <apex:pageblocktable value="{!allStus}" var="obj">

              <apex:column headerValue="Name">

                  <apex:inputtext value="{!obj.Name}"/>

              </apex:column>

              <apex:column headerValue="fees">

                  <apex:inputtext value="{!obj.fees__c}"/>

              </apex:column>

             

          </apex:pageblocktable>

          

          <apex:commandButton value="addRow" action="{!addRowMethod}" rerender="anyName"/>

          <apex:commandButton value="removeRow" action="{!removeRowMethod}"/>

          

          <apex:commandButton value="save" action="{!saveMethod}"/>

          <apex:commandButton value="Clear" action="{!clearMethod}" reRender="anyName"/>

      </apex:pageBlock>

  </apex:form>

</apex:page>

............................................................................................................................................................

public class StuCrudOperation {

 public List<stu__c> allStus{get;set;}

 public List<stu__c> allRec{get;set;}

    public StuCrudOperation()

    {

        allRec = [select Id,Name,fees__c from stu__c];

        allStus = new List<stu__c>();

        stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

   

    public void addRowMethod(){

       stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

        

    public void removeRowMethod(){

        integer count = allStus.size();

        allStus.remove(count-1);

    }

    public void saveMethod(){

        insert allStus;

    }

    

    public void clearMethod(){

         integer finalCount = allStus.size();

         allStus.clear();

         for(integer i=0;i<finalCount;i++){

            stu__c acc1 = new stu__c();

            allStus.add(acc1);

            

        }

            

        }

    

     

}

<apex:page controller="StuCrudOperation">

  <apex:form >

  <apex:pageBlock >

 <apex:inputText id="paramText"/>

 <apex:commandButton value="click" oncomplete="findData()" /> 

</apex:pageBlock>

      <apex:pageBlock id="anyName">

        <apex:pageblocktable value="{!allRec}" var="a">

       

              <apex:column value="{!a.id}" id="stuid"/>

               <apex:column value="{!a.Name}" id="stuname" />

               <apex:column value="{!a.fees__c}" id="stufees"/>

               <apex:column ><a href="" onclick="findData()">Edit</a></apex:column>

               <apex:column ><a href="#">Delete</a></apex:column>

          </apex:pageblocktable>

          <apex:pageblocktable value="{!allStus}" var="obj">

              <apex:column headerValue="Name">

                  <apex:inputHidden value="{!obj.Id}" id="txtid" />

                  <apex:inputtext value="{!obj.Name}" id="txtname"/>

              </apex:column>

              <apex:column headerValue="fees">

                  <apex:inputtext value="{!obj.fees__c}" id="txtfee"/>

                 

                 

              </apex:column>

             

          </apex:pageblocktable>

          

          <apex:commandButton value="addRow" action="{!addRowMethod}" rerender="anyName"/>

          <apex:commandButton value="removeRow" action="{!removeRowMethod}"/>

          

          <apex:commandButton value="save" action="{!saveMethod}"/>

          <apex:commandButton value="edit"  action="{!editMethod}"/>

          <apex:commandButton value="delete" action="{!deleteMethod}"/>

          <apex:commandButton value="Clear" action="{!clearMethod}" reRender="anyName"/>

      </apex:pageBlock>

  </apex:form>

    <script>

    function findData()

    {

   

     //  var name=document.getElementById('paramText').value;

        var tid= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stuid').textContent;

       var name= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stuname').textContent;

       var fees= document.getElementById('j_id0:j_id1:anyName:j_id4:0:stufees').textContent;

       document.getElementById('j_id0:j_id1:anyName:j_id4:0:j_id19').value=tid;

       document.getElementById('j_id0:j_id1:anyName:j_id9:0:txtname').value=name; 

       document.getElementById('j_id0:j_id1:anyName:j_id9:0:txtfee').value=fees; 

       

        alert('hello' + name);

       

    }

    </script>

</apex:page>

...................................................................................

public class StuCrudOperation {

 public List<stu__c> allStus{get;set;}

 public List<stu__c> allRec{get;set;}

 public stu__c coll;

    public String myid{get;set;}

    public StuCrudOperation()

    {

        allRec = [select Id,Name,fees__c from stu__c];

        allStus = new List<stu__c>();

        stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

   

    public void addRowMethod(){

       stu__c acc1 = new stu__c();

        allStus.add(acc1);

    }

        

    public void removeRowMethod(){

        integer count = allStus.size();

        allStus.remove(count-1);

    }

    public void saveMethod(){

        insert allStus;

    }

     public void editMethod(){

       coll = [SELECT Id, Name, fees__c FROM stu__c WHERE Id = :allStus[0].Id];

       coll.Name = allStus[0].Name;

       coll.fees__c  = allStus[0].fees__c;

       update coll;

    }

     public void deleteMethod(){

        coll = [SELECT Id, Name, fees__c FROM stu__c WHERE Id = :allStus[0].Id];

        delete coll;

    }

    public void clearMethod(){

         integer finalCount = allStus.size();

         allStus.clear();

         for(integer i=0;i<finalCount;i++){

            stu__c acc1 = new stu__c();

            allStus.add(acc1);

            

        }

            

        }

    

     

}