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;@Initpublic 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")); }