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