Um... What exactly are you trying to do here? Do you just need the
product id from the url string, or are you trying to fetch something
from a different backend? If you just need it from the string, just
use indexOf and substring.
Nils-H
On Thu, May 28, 2009 at 11:41 AM, Prashant Singh
<prashantk.si...@yahoo.co.in> wrote:
>
>
>
>
> Hi dear,
>
> I have been trying to read the productID from the url but it goes into an
> infinite loop at point 1. I am posting the code below. Please help.
>
>
>
>
>
>
> package net.astralpharma;
> import java.io.*;
> import com.opensymphony.xwork2.ActionContext;
> import com.opensymphony.xwork2.ActionSupport;
> import org.apache.struts2.ServletActionContext;
>
> import java.io.BufferedReader;
> import java.io.IOException;
> import java.net.URL;
> import java.net.URLConnection;
> import java.sql.*;
> import java.util.*;
>
> import net.astralpharma.Connect;
> import net.astralpharma.Product;
> import net.astralpharma.Productdisplay;
>
> public class Showprodsuppliers extends ActionSupport
> {
> private String productID;
> private String productName;
> List<Supplier> supplierName = new ArrayList<Supplier>();
>
>
> public String execute() throws Exception{
> StringBuffer sb = new StringBuffer("http://localhost:8080/Astralpharma1/astralpharma/astralpharma/showprodsuppliers.action?productID=1";);
>
> URL url = new URL(sb.toString());
> URLConnection urlConn = url.openConnection();
> urlConn.setUseCaches(true);
> urlConn.setDoOutput(true);
> urlConn.setDoInput(true);
> System.out.println("reached point 1");
>
> OutputStreamWriter osr = new OutputStreamWriter(urlConn.getOutputStream());
>
> BufferedReader br = new BufferedReader(new InputStreamReader(urlConn.getInputStream()));
>
> String tempStr;
> StringBuffer buffer = new StringBuffer();
> System.out.println("Reached point 2");
>
> while((tempStr = br.readLine())!= null)
> {
> buffer.append(tempStr + "<br>\n");
>
> }
> br.close();
>
> StringTokenizer st = new StringTokenizer(buffer.toString());
> ArrayList<String> output = new ArrayList<String>();
> System.out.println("reached point 3");
> while(st.hasMoreTokens())
> {
> String server = st.nextToken();
> try{
> if(st.nextToken().contentEquals("productID"));
> {
> productID=st.nextToken().valueOf("productID");
> System.out.println("Value of productID" + productID);
> }
> }
> catch(Exception e)
> {
> System.out.println("Exception" + e.getMessage());
> }
> }
> System.out.println("Reached point 4");
>
> Connect connect = new Connect();
> Connection con = connect.useConnection();
> String query="Select suppliername from supplier_proddetails where productid=?";
> PreparedStatement stat = con.prepareStatement(query);
> stat.setString(1, productID);
> System.out.println(stat);
> ResultSet rs = stat.executeQuery();
> System.out.println("rs"+ rs);
> while(rs.next())
> {
> System.out.println("inside while");
> supplierName.add(new Supplier((rs.getString("supplierName"))));
> System.out.println("item added successfully");
> }
> return "success";
> }
>
> public List<Supplier> getSupplierName() {
> return supplierName;
> }
>
> public void setSupplierName(List<Supplier> supplierName) {
> this.supplierName = supplierName;
> }
>
> public String getProductID() {
> return productID;
> }
>
> public void setProductID(String productID ) {
> this.productID = productID ;
> }
>
>
> public String getProductName() {
> return productName;
> }
>
> public void setProductName(String productName) {
> this.productName = productName;
> }
>
> }
>
>
>
> My front end jsp is as follows:
>
> <%@ taglib prefix="s" uri="/struts-tags" %>
>
> <html>
> <head>
> <title>Product Handled</title>
> <link href="<s:url value="/css/main.css"/>" rel="stylesheet"
> type="text/css"/>
> </head>
>
> <body>
> <table class="productTable">
>
>
>
> <tr><td>This Page Gives the List of Products handled by Astral
> Pharmaceuticals</td></tr>
>
> <tr><td>Products Handled</td></tr>
>
> <s:iterator value="productDetail" >
> <tr><td><a href="showprodsuppliers.action?productID=<s:property
> value="productID"/>">
> <s:property value="productName"/>
> </a></td></tr>
> </s:iterator>
>
> </table>
>
>
> </body>
> </html>
>
> The url i am generating is as follows:
> http://localhost:8080/Astralpharma1/astralpharma/astralpharma/showprodsuppliers.action?productID=1
> I just need to get the productID from the url.
>
> Sincerely,
> Prashant Singh
>
>
>
>
> Explore and discover exciting holidays and getaways with Yahoo! India
> Travel http://in.travel.yahoo.com/
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@struts.apache.org
For additional commands, e-mail: user-h...@struts.apache.org
