dataGrid editDataGrid

一、dataGrid的初始化

1、使用HQL查询得到的带类型的list, DataModel为Grid提供数据， public List<cwbz> query(java.lang.String query) { Query q = entityManager.createQuery("SELECT o FROM cwbz o WHERE " + query); List<cwbz> results = (List<cwbz>) q.getResultList(); return results; }

@DataModel(id="ptGrid") private List<String[]> getPtGrid(){ return icwbzService.queryGridSql2("普通"); }

 

 2、使用createNativeQuery查询SQL，再将结果重新 封装成 带类型的list,最后交给DataModel

public List<cwbz> queryGridSql(String query) { Query q = entityManager .createNativeQuery("select j.jbyy,c.* from mwt_cwbz c,mwt_cjbyy j where c.JbyyDM=j.jbyyDM and c.SFLX=?1"); //nativeQuery 不能返回 <cwbz>类型 q.setParameter(1, query); Object[] results = (Object[]) q.getResultList().toArray(); List<cwbz> ls = new ArrayList<cwbz>(); for(int i=0;i<results.length;i++){ cwbz c = new cwbz(); c.setJbyyDM( ((Vector) results[i]).get(0).toString() ); c.setId( ((Vector) results[i]).get(1).toString()); ls.add(c); }

参考：http://www.operamasks.org/forum/thread-7465-1-2.html

 

 3、使用createNativeQuery查询SQL,转换为数组or list，xhtml不用id、而用value="#{ptGrid[0]}"显示列

public List<String[]> queryGridSql2(String query) { Query q = entityManager .createNativeQuery("select j.jbyy,c.* from mwt_cwbz c,mwt_cjbyy j where c.JbyyDM=j.jbyyDM and c.SFLX=?1"); //nativeQuery 不能返回 <cwbz>类型 q.setParameter(1, query); return q.getResultList(); }

<w:editDataGrid id="ptGrid" height="300" var="ptGridvar"> <w:outputColumn id="id" value="#{ptGridvar[0]}" hidden="true"></w:outputColumn>

a、不用dataModel初始化grid：

@Bind(id="ptGrid", attribute="value") private List<String[]> ptGrid_value; @Init public void initPtGrid_value(){ System.out.print("asdfasfdasf"); ptGrid_value=icwbzService.queryGridSql2("普通"); } //action须grid.reload

b、用dataModel初始grid

@DataModel(id="ptGrid") private List<String[]> getPtGrid(){ return icwbzService.queryGridSql(/"普通/"); }

 

参考：http://www.operamasks.org/forum/thread-7465-1-2.html

 

 

 

二、editDataGrid的修改

1、modifiedData的使用前提

    @Bind(id="ptGrid", attribute="modifiedData") private Object ptGrid_modifieddata; @Bind(id = "ptGrid", attribute = "bindBean") private Class bindBean = cwbz.class; //不要忘记，不加会出错 if(ptGrid_modifieddata != null){ update((cwbz[]) modifiedData); } private void update(cwbz[] cwbzs) { for (cwbz c1: cwbzs) { cwbzService.update(c1); } }

 

2、modifiedData的返回类型————JSONArray

   //遍历 JSONArray JSONArray ja = (JSONArray) o; if( ja==null || ja.size()==0) { return;} JSONObject jo; for( int i=0;i<ja.size();i++){ jo = (JSONObject)ja.get(i); jo.get("sksf"); System.out.print("jo.get: "+jo.get("sksf")); }