根据输入的电话号码查询联系人
在salesforce 平台下,根据输入的电话号码查询联系人有很多。这里用到简单的 Apex 和 visualforce来实现。下面给出对应的.cls 文件和 .page 文件:
1. SearchContactsByPhone.cls
public with sharing class SearchContactsByPhone {
//the search results
public List<Contact> results {get;set;}
//the contact instance to capture the search criteria
public Contact searchCon {get;set;}
public SearchContactsByPhone(){
searchCon = new Contact();
}
/**
* @return
*/
public PageReference excuteSearch(){
if( results!=null){
results.clear();
}
String whereStr='';
// only add a phone clause if the user has entered some text
if(!String.isEmpty(searchCon.Phone)){
String wcPhone=searchCon.Phone;
whereStr+= ' \'' + wcPhone+ '\'';
}
if(whereStr!=''){
String queryStr = 'select Id,Name,Phone from Contact where Phone= '+whereStr;
results = Database.query(queryStr);
}
return null;
}
}
在上诉的类中,有一点应是值得注意的whereStr+= ' \' ' + wcPhone+ '\' ',主要明确Phone 的数据类型,还有就是转义字符的应用。
2.SearchContacts.page
<apex:page controller="SearchContactsByPhone">
<apex:form >
<apex:pageBlock title="Search Contacts By Phone">
<apex:pageBlockSection >
<apex:inputField value="{!searchCon.Phone}"/>
<apex:commandButton value="go" action="{!excuteSearch}" />
</apex:pageBlockSection>
<apex:pageBlockTable value="{!results}" var="con">
<apex:column value="{!con.Name}"/>
<apex:column value="{!con.Phone}"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>
很乐意和大家一起学习Salesforce 相关知识,同时也希望和大家一起讨论。最后 附上 Salesforce 认证相关资源。