FAQ
有任何問題歡迎在此提出,我們會儘快為您解答。
private Object getUpdate(Map args) throws Exception{
String Form_NumList[]=(String[])(String[])args.get("Form_Num");
String BrandList[] = (String[])(String[])args.get("Brand1");
String ModleList[] = (String[])(String[])args.get("Modle1");
String ColorList[] = (String[])(String[])args.get("Color1");
String QualityList[] = (String[])(String[])args.get("Quality1");
DataService ds = (DataService)ServiceLoader.getService("DataService");
TrackableItem trackableItem = null;
TrackableItemDAO dao = TrackableItemDAO.getInstance();
trackableItem = new TrackableItem(true);
BigDecimal SaasOrgKey = new BigDecimal("1");
trackableItem.setSaasOrgKey(SaasOrgKey);//不可為空 (有點怪 因為我是修改 原本就有值了說)
trackableItem.setNetQuantityUom("Piece");//不可為空 (同上)
trackableItem.setAttribute2(Form_NumList[0]);
trackableItem.setAttribute3(BrandList[0]);
trackableItem.setAttribute4(ModleList[0]);
trackableItem.setAttribute5(ColorList[0]);
trackableItem.setAttribute8(QualityList[0]);
trackableItem.saveAndCommit("TrackableItemHandler");
ds.commitTransaction(tx);
String dGridXML = "<?xml version=\"1.0\" encoding=\"utf-8\"?>"
+"<Response>"
+"<Status>success</Status>"
+"<Data>Update</Data>"
+"</Response>";
return dGridXML;
private Object getInsert(Map args) throws Exception{
String Form_NumList[]=(String[])(String[])args.get("Form_Num");
String KeyList[] = (String[])(String[])args.get("Key1");
String BrandList[] = (String[])(String[])args.get("Brand1");
String ModleList[] = (String[])(String[])args.get("Modle1");
String ColorList[] = (String[])(String[])args.get("Color1");
String QualityList[] = (String[])(String[])args.get("Quality1");
DataService ds = (DataService)ServiceLoader.getService("DataService");
OrganizationService os = (OrganizationService)ServiceLoader.getService(OrganizationService.NAME);
Transaction tx = ds.beginTransaction();
TrackableItem trackableItem = null;
TrackableItemDAO dao = TrackableItemDAO.getInstance();
trackableItem = new TrackableItem(true);
BigDecimal TrackableKey = new BigDecimal(KeyList[0]);
trackableItem.setTrackableKey(TrackableKey);
BigDecimal SaasOrgKey = new BigDecimal("1");
trackableItem.setSaasOrgKey(SaasOrgKey);
trackableItem.setTrackableNumber(KeyList[0]);
trackableItem.setStatus("ACTIVE");
Double NetQuantity = new Double("1");
trackableItem.setNetQuantity(NetQuantity);
trackableItem.setNetQuantityUom("Piece");
BigDecimal RootKey = new BigDecimal(KeyList[0]);
trackableItem.setRootKey(RootKey);
BigDecimal ParentKey = new BigDecimal(KeyList[0]);
trackableItem.setParentKey(ParentKey);
trackableItem.setAttribute2(Form_NumList[0]);
trackableItem.setAttribute3(BrandList[0]);
trackableItem.setAttribute4(ModleList[0]);
trackableItem.setAttribute5(ColorList[0]);
trackableItem.setAttribute8(QualityList[0]);
trackableItem.save("TrackableItemHandler");
dao.save(trackableItem);
ds.commitTransaction(tx);
String dGridXML ="<?xml version=\"1.0\" encoding=\"utf-8\"?>"
+"<Response>"
+"<Status>success</Status>"
+"<Data>Insert</Data>"
+"</Response>";
return dGridXML;
請問 學長
在java端
沒辦法用一般的SQL語法去寫嗎 ?
可以,你現在不管上下二種都是用SQL語法寫,
只是你到底是要用透過bin去跟DB溝通(上面),
還是要直接傳指令給DB去執行SQL語法(下面),你要先確定好。








