如何使用struts2在jqgrid中显示两个表数据-jqgrid插件和休眠 [英] how to show two tables data in jqgrid using struts2 - jqgrid plugin and hibernate

问题描述

我正在使用Struts 2.3.7，struts2-jquery-grid-plugin-3.5.0和hibernate 3.6.我想显示来自两个不同表的jqgrid上的数据.

I am using Struts 2.3.7, struts2-jquery-grid-plugin-3.5.0 and hibernate 3.6. I want to show data on jqgrid which is coming from two different tables.

我的问题是我必须在一个jqgrid中显示两个表数据.前三个jqgrid列由Issue表填充，最后一个列name="assignedTo"由Issue_Tracker表填充.如何在最后一列即assignedTo中显示数据.任何帮助都将是适当的.

My problem is that I have to show two tables data in one jqgrid .First three jqgrid column is filled by Issue table and last Column name="assignedTo" is filled by Issue_Tracker table. How to show the data in last column i.e. assignedTo. Any help would be appropriated.

我的jqgrid是

<sjg:grid
    id="gridtable"
    caption="Issue-Summary"
    dataType="json"
    href="%{remoteurl}"
    pager="true"
    gridModel="gridModel"
    rowList="10,15,20"
    rowNum="15"
    rownumbers="true"
    reloadTopics="reloadGrid"
>
    <sjg:gridColumn name="issue_id"  id="issueId"  index="id" title="Issue-ID" formatter="integer"  sortable="false"/>
    <sjg:gridColumn name="issue_description" index="id" title="Issue-Details"  sortable="false"/>
    <sjg:gridColumn name="issue_raised_date" index="date" title="Issue-Date"  formatter="date"  sortable="false"/>

    <sjg:gridColumn name="assignedTo"  index="assigned" title="Assigned To"  sortable="false"/>
</sjg:grid>

我有pojo:

Issue.java

Issue.java

public class Issue implements Serializable
{
private Integer issue_id;
private String  issue_description;
private Date issue_raised_date;

getters and setters

另一个pojo是

Issue_Tracker.java

Issue_Tracker.java

public class Issue_Tracker implements Serializable
{  
     private Integer issue_id;
     private String assignedTo;

我的岛"如下所示，以显示jqgrid中的问题列表

public List<Issue> showHelpDeskIssues(DetachedCriteria dc, int from, int size)
{

    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
     try
      {

        Criteria criteria = dc.getExecutableCriteria(session);
        criteria.setFirstResult(from);
        criteria.setMaxResults(size);
        criteria.add(Restrictions.eq("status","Escalate To"));

        return criteria.list();
      }
      catch (HibernateException e)
      {
        e.printStackTrace();
        throw e;
      }
}

推荐答案

U可以在数据库中创建具有两个表的组合列的视图.为此视图创建PoJo和Mapping类，并轻松执行！

U can Make a view in DB with combination columns of two tables.Create PoJo and Mapping class for that view and execute with ease!

这篇关于如何使用struts2在jqgrid中显示两个表数据-jqgrid插件和休眠的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！