查询:
Map personViewMap = UtilMisc.toMap("personPropertyId","2");
personPropertyViewList = delegator.findByAnd("personPropertyView", personViewMap);
对应SQL:
SELECT * FROM PERSONPROPERTYVIEW WHERE PERSONPROPERTYID=2;
当.findByAnd()第二个参数不输入时则无条件,查询所有。
删除:
Map planetValues = UtilMisc.toMap("personId", 1);
GenericValue planetGV = delegator.findByPrimaryKey("personDemo", planetValues);
planetGV.remove();
对应SQL:
DELETE FROM PERSONDEMO WHERE PERSONID = 1;
更新:
Map planetValues = UtilMisc.toMap("personId", "5"); //条件
GenericValue planetGV = delegator.findByPrimaryKey("personDemo", planetValues); //表
planetGV.put("personName", "updateName"); // 修改内容
planetGV.store();
对应SQL:
UPDATE PERSONDEMO SET PERSONNAME = "updateName" WHERE PERSONID=5;
新增:
/**
* delegator.getNextSeqId("tableName") : 获得唯一性的字符数字,从10000开始,作为主键ID使用
*/
String id = delegator.getNextSeqId("TABLENAME"); Map planetValues = UtilMisc.toMap("ID",id,"TITLE",title,"NAME",name); GenericValue planetGV = delegator.makeValue("TABLENAME", planetValues); planetGV.create();
对应SQL:
INSERT INTO PERSONDEMO ("ID","TITLE","NAME") VALUES(id,title,name);
友情链接:OFBIZ-API : http://ci.apache.org/projects/ofbiz/site/javadocs/