Odoo(OpenERP)伺服器支援通過XML-RPC接口通路、操作資料庫,基于此可實作與其他系統的互動與內建。
本文是使用Java通過XMLRPC接口操作Odoo資料庫的簡單示例。本例引用的jar包包括xmlrpc-common-3.1.3.jar, xmlrpc-client-3.1.3.jar和ws-commons-util-1.0.2.jar,如需要,可點選這裡下載下傳。
package memo.by.weichen;
import java.net.URL;
import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.xmlrpc.client.XmlRpcClient;
import org.apache.xmlrpc.client.XmlRpcClientConfigImpl;
/**
*
* 通過XML-RPC接口通路Odoo資料庫
* [email protected] 8.0
* by WeiChen
*
*/
public class OdooWSDemo {
public static final String URL = "http://127.0.0.1:8069";
public static final String DB = "demo";
public static final int USERID = 1;
public static final String PASS = "demo";
public static void main(String[] args) throws Exception{
XmlRpcClientConfigImpl config = new XmlRpcClientConfigImpl();
XmlRpcClient client = new XmlRpcClient();
config.setServerURL(new URL(String.format("%s/xmlrpc/2/object", URL)));
client.setConfig(config);
// 建立客戶
Integer id = (Integer) client.execute(
"execute_kw", Arrays.asList(
DB, USERID, PASS, "res.partner", "create",
Arrays.asList(new HashMap() {
{
put("name", "蘇州園區永旺夢樂城");
put("customer", Boolean.TRUE);
}
})));
// 更新客戶
client.execute("execute_kw", Arrays.asList(
DB, USERID, PASS,
"res.partner", "write",
Arrays.asList(
Arrays.asList(id),
new HashMap() {{ put("name", "永旺夢樂城蘇州園區店"); }}
)
));
// 查找客戶
List<Object> partners = Arrays.asList((Object[])client.execute("execute_kw", Arrays.asList(
DB, USERID, PASS,
"res.partner", "name_get",
Arrays.asList(Arrays.asList(id))
)));
if(partners!=null&&partners.size()>0){// partners格式: [[id, name]]
Object[] partner = (Object[])partners.get(0);
if(partner.length==2)
System.out.println("客戶名: "+partner[1]);
}
// 删除客戶
client.execute("execute_kw", Arrays.asList(
DB, USERID, PASS,
"res.partner", "unlink",
Arrays.asList(Arrays.asList(id))));
// 客戶清單
List<Object> customers = Arrays.asList((Object[]) client.execute(
"execute_kw", Arrays.asList(
DB, USERID, PASS, "res.partner", "search_read",
Arrays.asList(Arrays.asList(
// 設定查詢條件
// Arrays.asList("is_company", "=", true),
Arrays.asList("customer", "=", true))),
new HashMap() {
{// 查詢name字段, 限定最多傳回100條記錄
put("fields", Arrays.asList("name"));
put("limit", 100);
}
})));
System.out.println("**********客戶清單**********");
for (int i=0;i<customers.size();i++){
Map customer = (Map)customers.get(i);
String name = (String)customer.get("name");
System.out.println(name);
}
System.out.println("****************************");
}
}
參考資料:
[1] https://www.odoo.com/documentation/8.0/api_integration.html