التخطي إلى المحتوى الرئيسي

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);

            

        }

            

        }

    

     

}







التسميات:

تعليقات

إرسال تعليق

POST Answer of Questions and ASK to Doubt

المشاركات الشائعة من هذه المدونة

Uncontrolled form input in React-JS

  Uncontrolled form input in React-JS? If we want to take input from users without any separate event handling then we can uncontrolled the data binding technique. The uncontrolled input is similar to the traditional HTML form inputs. The DOM itself handles the form data. Here, the HTML elements maintain their own state that will be updated when the input value changes. To write an uncontrolled component, you need to use a ref to get form values from the DOM. In other words, there is no need to write an event handler for every state update. You can use a ref to access the input field value of the form from the DOM. Example of Uncontrolled Form Input:- import React from "react" ; export class Info extends React . Component {     constructor ( props )     {         super ( props );         this . fun = this . fun . bind ( this ); //event method binding         this . input = React . createRef ();...
إرسال تعليق
قراءة المزيد

JSP Page design using Internal CSS

  JSP is used to design the user interface of an application, CSS is used to provide set of properties. Jsp provide proper page template to create user interface of dynamic web application. We can write CSS using three different ways 1)  inline CSS:-   we will write CSS tag under HTML elements <div style="width:200px; height:100px; background-color:green;"></div> 2)  Internal CSS:-  we will write CSS under <style> block. <style type="text/css"> #abc { width:200px;  height:100px;  background-color:green; } </style> <div id="abc"></div> 3) External CSS:-  we will write CSS to create a separate file and link it into HTML Web pages. create a separate file and named it style.css #abc { width:200px;  height:100px;  background-color:green; } go into Jsp page and link style.css <link href="style.css"  type="text/css" rel="stylesheet"   /> <div id="abc"> </div> Exam...
إرسال تعليق
قراءة المزيد

JDBC using JSP and Servlet

JDBC means Java Database Connectivity ,It is intermediates from Application to database. JDBC has different type of divers and provides to communicate from database server. JDBC contain four different type of approach to communicate with Database Type 1:- JDBC-ODBC Driver Type2:- JDBC Vendor specific Type3 :- JDBC Network Specific Type4:- JDBC Client-Server based Driver  or JAVA thin driver:- Mostly we prefer Type 4 type of Driver to communicate with database server. Step for JDBC:- 1  Create Database using MYSQL ,ORACLE ,MS-SQL or any other database 2   Create Table using database server 3   Create Form according to database table 4  Submit Form and get form data into servlet 5  write JDBC Code:-     5.1)   import package    import java.sql.*     5.2)  Add JDBC Driver according to database ide tools     5.3)  call driver in program         ...
4 تعليقات
قراءة المزيد