siva np

Dear All,

I am using struts 2, display tag sample.

The following code will be the list.jsp

<display:table name="areas" pagesize="5" id="row" export="true" requestURI="areaAction_list.action"> <display:column property="areaId" title="Area" sortable="true" headerClass="sortable"> </display:column> <display:column title="Delete"> <s:url id="delete" action="areaAction_delete"> <s:param name="id" value="#attr.row.areaId"/> </s:url> <s:a href="%{delete}" targets="row">Remove</s:a> </display:column> </display:table>

the web.xml will be

<filter> <filter-name>ResponseOverrideFilter</filter-name> <filter-class>org.displaytag.filter.ResponseOverrideFilter</filter-class> <init-param> <param-name>buffer</param-name> <param-value>false</param-value> </init-param> </filter> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.action</url-pattern> </filter-mapping> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.jsp</url-pattern> </filter-mapping>

Using the above code, i can display, export the files.

But I want to display the master - detail records the same web page. The master can have one record, The detail record can have more than one.

So, I need the pagination, edit page codes in the same web page for master - details using display tag sample

Thanks & Regards,

Siva NP

Hi Nirmal,

I am using struts 2, display tag sample.

The following code will be the list.jsp

<display:table name="areas" pagesize="5" id="row" export="true" requestURI="areaAction_list.action"> <display:column property="areaId" title="Area" sortable="true" headerClass="sortable"> </display:column> <display:column title="Delete"> <s:url id="delete" action="areaAction_delete"> <s:param name="id" value="#attr.row.areaId"/> </s:url> <s:a href="%{delete}" targets="row">Remove</s:a> </display:column> </display:table>

the web.xml will be

<filter> <filter-name>ResponseOverrideFilter</filter-name> <filter-class>org.displaytag.filter.ResponseOverrideFilter</filter-class> <init-param> <param-name>buffer</param-name> <param-value>false</param-value> </init-param> </filter> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.action</url-pattern> </filter-mapping> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.jsp</url-pattern> </filter-mapping>

Using the above code, i can export the files.

Did you use the pagination in the action file ?

Did you edit the web page in the same page ?

If you answer is yes, then send me the code ?

I am also struggling in pagination, edit page using display tag

Thanks & Regards,

Siva NP

Dear All,

I am new Struts 2.0 and listing the records in the list page.

I am using the struts 2.0 and displaytable.

The listing page code is
<display:table name="areas" pagesize="6" id="row" export="true"> <display:column property="areaId" title="Area" sortable="true"/> </display:table>

The web.xml is

<filter> <filter-name>ResponseOverrideFilter</filter-name> <filter-class>org.displaytag.filter.ResponseOverrideFilter</filter-class> </filter> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.action</url-pattern> </filter-mapping> <filter-mapping> <filter-name>ResponseOverrideFilter</filter-name> <url-pattern>*.jsp</url-pattern> </filter-mapping>

The records are displayed in the list.

But I click the excel export option, I can get the blank excel sheet.

Please guide me.

Thanks & Regards,

Siva NP

Hi All,

I am using the Struts 2 - IBatis - MySQL combination.

My Master.xml file will be......

<resultMap id="BuyerResult" class="model.Master.BuyerVO"> <result property="id" column="id"></result> <result property="buyerId" column="buyer_id"></result> <result property="companyId" column="company_id"></result> <result property="branchId" column="branch_id"></result> </resultMap> <resultMap id="BuyerDetailsResult" class="model.Master.BuyerDetailsVO"> <result property="buyerId" column="buyer_id"></result> <result property="buyerName" column="buyer_name"></result> <result property="buyerAddr1" column="buyer_addr1"></result> </resultMap> <select id="listBuyer" resultMap="BuyerDetailsResult"> select b.id, b.buyer_id, b.company_id, b.branch_id, bd.buyer_id, bd.buyername, bd.buyer_addr1 from ccat.buyer b JOIN ccat.buyer_details bd ON ccat.buyer.buyer_id=ccat.buyer_details.buyer_id </select>

I need all the details from BuyerVO to the BuyerDetailsVO.

It works fine in the query browser. But it does not work in the ibatis file. Because we have configured the resultMap="BuyerDetailsResult".

How do you get the values of "BuyerResult" ?

Please guide on this issue.

Thanks & regards,

Siva N P

Hi All,

I am using the Struts 2 - IBatis - MySQL - Jasper report combination.

My Master.xml file will be......

<resultMap id="BuyerResult" class="model.Master.BuyerVO"> <result property="id" column="id"></result> <result property="buyerId" column="buyer_id"></result> <result property="companyId" column="company_id"></result> <result property="branchId" column="branch_id"></result> </resultMap> <resultMap id="BuyerDetailsResult" class="model.Master.BuyerDetailsVO"> <result property="buyerId" column="buyer_id"></result> <result property="buyerName" column="buyer_name"></result> <result property="buyerAddr1" column="buyer_addr1"></result> </resultMap> <select id="listBuyer" resultMap="BuyerDetailsResult"> select b.id, b.buyer_id, b.company_id, b.branch_id, bd.buyer_id, bd.buyername, bd.buyer_addr1 from ccat.buyer b JOIN ccat.buyer_details bd ON ccat.buyer.buyer_id=ccat.buyer_details.buyer_id </select>

It works fine in the ireport3.0.0. ie I am getting the report and sub report.

Because we use the query in the report server

select b.id, b.buyer_id, b.company_id, b.branch_id, bd.buyer_id, bd.buyername, bd.buyer_addr1 from ccat.buyer b JOIN ccat.buyer_details bd ON ccat.buyer.buyer_id=ccat.buyer_details.buyer_id

But it does not work in the struts 2 file. I am getting the report file. The field are b.id, b.company_id, b.buyer_id values are null. We can get the values of bd.branch_id, bd.buyername, bd.buyer_addr1 and also We did not get the subreport.

Because we have configured the resultMap="BuyerDetailsResult" in the ibatis query.

How do you get the report and subreport ?

Please guide on this issue.

Thanks & regards,

Siva N P

Hi All,

I am using the Struts 2 - IBatis - MySQL combination.

My Master.xml file will be......

<resultMap id="BuyerResult" class="model.Master.BuyerVO"> <result property="id" column="id"></result> <result property="buyerId" column="buyer_id"></result> <result property="companyId" column="company_id"></result> <result property="branchId" column="branch_id"></result> </resultMap> <resultMap id="BuyerDetailsResult" class="model.Master.BuyerDetailsVO"> <result property="buyerId" column="buyer_id"></result> <result property="buyerName" column="buyer_name"></result> <result property="buyerAddr1" column="buyer_addr1"></result> </resultMap> <select id="listBuyer" resultMap="BuyerDetailsResult"> select b.id, b.buyer_id, b.company_id, b.branch_id, bd.buyer_id, bd.buyername, bd.buyer_addr1 from ccat.buyer b JOIN ccat.buyer_details bd ON ccat.buyer.buyer_id=ccat.buyer_details.buyer_id </select>

I need all the details from BuyerVO to the BuyerDetailsVO.

It works fine in the query browser. But it does not work in the ibatis file. Because we have configured the resultMap="BuyerDetailsResult".

How do you get the values of "BuyerResult" ?

Please guide on this issue.

Thanks & regards,

Siva N P

Dear Sir,

I have changed the coding.

But it didn't work.


My action page is salesAction.java
public BuyerDetailsVO getBuyerList1() { buyerDetailsVO = masterDao.getBuyerDetailsByBuyerDetailsId("Buy02"); setTest(buyerDetailsVO.getDelivaryTerm()); return buyerDetailsVO; } private String test; public String getTest() { return test; } public void setTest(String test) { this.test = test; }

My jsp page name is sales.jsp
<s:form name="frmMain"> <%! String priceTerm1=new String(); String test = ""; %> <% SalesAction salction = new SalesAction(); BuyerDetailsVO boy = new BuyerDetailsVO(); if(!boy.equals(null)){ boy = salction.getBuyerList1(); priceTerm1 = boy.getCcy(); out.println(priceTerm1); } SalesDetailsVO sal = new SalesDetailsVO(); sal.setDelivery(priceTerm1); out.println(salction.getTest()); test = salction.getTest(); //out.println(" Test-->"+test); %> <s:textfield name="test" /> <table align="center" class="borderAll" border="0" width="100%"> <tr> <td class="tdLabel"><s:text name="SalesId" /></td> <td><s:textfield name="salesvo.SalesId" size="10" theme="simple" /></td> <td class="tdLabel"><s:text name="SCDate" /></td> <td><s:textfield name="salesvo.salesConfirmationDate" size="10" theme="simple" /></td> <td class="tdLabel"><s:text name="BuyerId" /></td> <td><s:select id="buyerId" name="selectedBuyer" list="BuyerList" listKey="buyerId" listValue='buyerId' onblur="setThisBuyer()" theme="simple" /></Td> <td class="tdLabel"><s:text name="ccyId" /></td> <td><s:textfield id="ccyId" name="salesvo.ccyId" size="10" theme="simple" /></td> <td><s:textfield name="salesvo.priceTerm" size="10" theme="simple" /></td> </tr> </table> ............... ............... </s:form>

The output is not coming.

regards,

Siva N P

Hi All,

I can get the values from the db and set the values.

In the action file :

private String test; and setter & getter method.

I am not able set the values in the jsp file

<s:textfield name="test" value="%{test}">

But i get the values from the text box & using out.println(test);

<input type="text" name="test" id="test" value ="<%=test %>"/>

Please guide me


Thanks & regards,

Siva N P

Sir,

I have one doubt regardding alfresco.

I think that Alfresco tool is used for content management system.

Are you able to develop application.

thanks & regards,

Siva NP