Apex SOQL クエリを作成するサンプル

環境
Salesforce

構文
1.sObjectの配列を返す
例 Account[] accts = [SELECT Name,Phone FROM Account];
2 つの項目 (名前と電話) を持つすべての取引先レコードを取得し、Account sObject の配列を返します。
SOQL クエリを Apex コード内に含めるには、SOQL ステートメントを角括弧でラップして、
戻り値を sObject の配列に割り当てます。

2.SOQL クエリの変数にアクセスする
例 [SELECT FirstName,LastName FROM Contact WHERE Department=:targetDepartment];
WHERE 句内で targetDepartment 変数を使用します。

使用例

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
public class ContactSearch {
public static List<Contact> searchForContacts(String lastname, String postalcode) {
try {
List<Contact> cts = [SELECT Id, Name FROM Contact WHERE LastName = :lastname AND MailingPostalCode = :postalcode];
return cts;
} catch (Exception e) {
System.debug('An extention has occured: ' + e.getMessage());
return null;
}
}
}
public class ContactSearch { public static List<Contact> searchForContacts(String lastname, String postalcode) { try { List<Contact> cts = [SELECT Id, Name FROM Contact WHERE LastName = :lastname AND MailingPostalCode = :postalcode]; return cts; } catch (Exception e) { System.debug('An extention has occured: ' + e.getMessage()); return null; } } }
public class ContactSearch {
    public static List<Contact> searchForContacts(String lastname, String postalcode) {
        try {
            List<Contact> cts = [SELECT Id, Name FROM Contact  WHERE LastName = :lastname AND MailingPostalCode = :postalcode];
            return cts;
        } catch (Exception e) {
            System.debug('An extention has occured: ' + e.getMessage());
            return null;
        }
    }
}

動作確認
ContactSearch.searchForContacts('Rogers J1ack’, '27215’);

Apex

Posted by arkgame