@Controller("baseAction") 
@Scope("prototype") 
public class BaseAction<T> extends ActionSupport implements RequestAware,SessionAware,ApplicationAware,ModelDriven<T> { 
 
  //page和rows和分頁有關(guān)，pageMap存放查詢的數(shù)據(jù)，然后打包成json格式用的 
  //page和rows實(shí)現(xiàn)get和set方法，pageMap只需要實(shí)現(xiàn)get方法即可，因?yàn)閜ageMap不是接收前臺(tái)參數(shù)的，是讓struts獲取的 
  protected Integer page; 
  protected Integer rows; 
  protected Map<String, Object> pageMap = null;//讓不同的Action自己去實(shí)現(xiàn) 
    //省略get和set方法…… 
   
  /******************* 下面還是原來BaseAction部分 *************************/ 
  //service對(duì)象 
  @Resource 
  protected CategoryService categoryService; 
  @Resource 
  protected AccountService accountService; 
 
  //域?qū)ο?
  protected Map<String, Object> request; 
  protected Map<String, Object> session; 
  protected Map<String, Object> application; 
     
  @Override 
  public void setApplication(Map<String, Object> application) { 
    this.application = application; 
  } 
  @Override 
  public void setSession(Map<String, Object> session) { 
    this.session = session; 
  } 
  @Override 
  public void setRequest(Map<String, Object> request) { 
    this.request = request; 
  } 
   
  //ModelDriven 
  protected T model; 
  @Override 
  public T getModel() { 
    ParameterizedType type = (ParameterizedType)this.getClass().getGenericSuperclass(); 
    Class clazz = (Class)type.getActualTypeArguments()[0]; 
    try { 
      model = (T)clazz.newInstance(); 
    } catch (Exception e) { 
      throw new RuntimeException(e); 
    }   
    return model; 
  } 
} 

@Controller("categoryAction") 
@Scope("prototype") 
public class CategoryAction extends BaseAction<Category> { 
   
  public String queryJoinAccount() { 
 
    //用來存儲(chǔ)分頁的數(shù)據(jù) 
    pageMap = new HashMap<String, Object>(); 
     
    //根據(jù)關(guān)鍵字和分頁的參數(shù)查詢相應(yīng)的數(shù)據(jù)。這個(gè)方法我們?cè)赟ervice中寫過了，當(dāng)時(shí)完成級(jí)聯(lián)查詢 
    List<Category> categoryList = categoryService.queryJoinAccount(model.getType(), page, rows); 
    pageMap.put("rows", categoryList); //存儲(chǔ)為JSON格式，從上一節(jié)的json文件可以看出，一個(gè)key是total,一個(gè)key是rows，這里先把rows存放好 
    //根據(jù)關(guān)鍵字查詢總記錄數(shù) 
    Long total = categoryService.getCount(model.getType()); //這個(gè)方法沒寫，我們等會(huì)兒去Service層完善一下 
//   System.out.println(total); 
    pageMap.put("total", total); //存儲(chǔ)為JSON格式，再把total存放好 
 
    return "jsonMap"; 
  } 
} 

//CategoryService接口 
public interface CategoryService extends BaseService<Category> { 
  //查詢類別信息，級(jí)聯(lián)管理員 
  public List<Category> queryJoinAccount(String type, int page, int size); //使用類別的名稱查詢 
  //根據(jù)關(guān)鍵字查詢總記錄數(shù) 
  public Long getCount(String type); 
} 
 
//CategoryServiceImpl實(shí)現(xiàn)類 
@SuppressWarnings("unchecked") 
@Service("categoryService") 
public class CategoryServiceImpl extends BaseServiceImpl<Category> implements CategoryService { 
 
  @Override 
  public List<Category> queryJoinAccount(String type, int page, int size) { 
    String hql = "from Category c left join fetch c.account where c.type like :type"; 
    return getSession().createQuery(hql) 
        .setString("type", "%" + type + "%") 
        .setFirstResult((page-1) * size) //從第幾個(gè)開始顯示 
        .setMaxResults(size) //顯示幾個(gè) 
        .list(); 
  } 
 
  @Override 
  public Long getCount(String type) { 
    String hql = "select count(c) from Category c where c.type like :type"; 
    return (Long) getSession().createQuery(hql) 
      .setString("type", "%" + type + "%") 
      .uniqueResult(); //返回一條記錄:總記錄數(shù) 
  } 
} 

<struts> 
   
  <constant name="struts.devMode" value="true" /> 
   
  <package name="shop" extends="json-default"><!-- jason-default繼承了struts-default --> 
   
    <global-results> 
      <result name="aindex">/WEB-INF/main/aindex.jsp</result> 
    </global-results> 
 
    <!-- class對(duì)應(yīng)的是Spring中配置該Action的id值，因?yàn)橐唤oSpring管理 --> 
    <action name="category_*" class="categoryAction" method="{1}"> 
      <!-- 必須要先添加json包，然后上面繼承json-default --> 
      <result name="jsonMap" type="json"> 
        <!-- 要轉(zhuǎn)換成json對(duì)象的數(shù)據(jù) --> 
        <param name="root">pageMap</param> 
        <!-- 配置黑名單，過濾不需要的選項(xiàng) ，支持正則表達(dá)式 
        json格式：{total:3,rows:[{account:{id:2,login:"user",name:"客服A",pass:"user"},hot:true,id:3,…}]} 
        --> 
        <param name="excludeProperties"> 
          <!-- rows[0].account.pass--> 
                    <!-- 這里顯示不了正則表達(dá)式， CSDN的一個(gè)bug，我接個(gè)圖放下面 --> 
        </param> 
      </result> 
    </action> 
     
    <action name="account_*" class="accountAction" method="{1}"> 
      <result name="index">/index.jsp</result> 
    </action> 
     
    <!-- 用來完成系統(tǒng) 請(qǐng)求轉(zhuǎn)發(fā)的action,所有的請(qǐng)求都交給execute--> 
    <action name="send_*_*" class="sendAction"> 
      <result name="send">/WEB-INF/{1}/{2}.jsp</result> 
    </action> 
  </package> 
 
</struts> 

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
 <head> 
  <%@ include file="/public/head.jspf" %> 
  <script type="text/javascript"> 
    $(function(){ 
      $('#dg').datagrid({   
        //url地址改為請(qǐng)求categoryAction 
        url:'category_queryJoinAccount.action', 
        loadMsg:'Loading......', 
        queryParams:{type:''},//type參數(shù)，這里不需要傳具體的type，因?yàn)槲覀円@示所有的 
        //width:300, 
        fitColumns:true, 
        striped:true, 
        nowrap:true, 
        singleSelect:true, 
        pagination:true, 
        rowStyler: function(index,row){ 
          console.info("index" + index + "," + row) 
          if(index % 2 == 0) { 
            return 'background-color:#fff;'; 
          } else { 
            return 'background-color:#ff0;'; 
          } 
           
        },    
        frozenColumns:[[ 
          {field:'checkbox',checkbox:true}, 
          {field:'id',title:'編號(hào)',width:200}  //這里的field字段要和數(shù)據(jù)庫中的一樣，也就是要跟json數(shù)據(jù)中的一樣        
        ]], 
        columns:[[            
          {field:'type',title:'類別名稱',width:100, //字段type 
            formatter: function(value,row,index){ 
              return "<span title=" +　value + ">" + value + "</span>"; 
            } 
          },   
          {field:'hot',title:'熱賣',width:100, //字段hot 
            formatter: function(value,row,index){ 
              if(value) { //如果是hot，該值為true，value是boolean型變量 
                return "<input type='checkbox' checked='checked' disabled='true'"; //勾選 
              } else { 
                return "<input type='checkbox' disable='true'"; //不勾選 
              } 
            } 
          }, 
          {field:'account.login',title:'所屬管理員',width:200, //account.login管理員登錄名 
            formatter: function(value,row,index){ 
              if(row.account != null && row.account.login != null) { 
                return row.account.login; //如果登錄名不為空，顯示登錄名 
              } else { 
                return "此類別沒有管理員"; 
              } 
          }   
          } 
        ]]   
      });  
    }); 
  </script> 
 </head> 
  
 <body> 
  <table id="dg"></table> 
 </body> 
</html>