I need to set <s:property> value in the action class

Hi dear,

what I am doing is that I have taken out all the products listed under product category and have displayed them in a jsp.

Now I want to click the product and display all the supplier that supply the product.

Anysuggestions how do i do that in struts 2.0

My jsp is as follows:

My Action class is as follows:

package net.astralpharma;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.*;

public class Showpdtsuppliers extends ActionSupport
	{
	private String productName; /*=??????????? // how do i set this value from the jsp <s:iterate>; */
	private static List<Supplier> suppliers = new ArrayList<Supplier>();
	
	public String populate()
	{
		supplierName    /*;  we need to populate this */
		return "populate";
	}
		
	public String execute() throws Exception{
	
		String url = "jdbc:mysql://localhost:3306/";
    	String dbname="astraldb";
    	String driverName="org.gjt.mm.mysql.Driver";
    	String userName="root";
    	String password="root";
    	Connection con=null;
    	PreparedStatement stat =null;
    	
    	try
    	{
    		Class.forName(driverName);
    		System.out.println("Driver Loaded");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/astraldb","root","root" );
			System.out.println("Database is connected");
			String query="Select suppliername from supplier_proddetails where productname=?";
    		stat = con.prepareStatement(query);
    		stat.setString(1, productName);
			System.out.println(stat);
			ResultSet rs = stat.executeQuery();
			System.out.println("rs"+ rs);
			while(rs.next())
			{
				System.out.println("inside while");
				Product productName = new Product();
				String s= rs.getString("supplierName");
				System.out.println("supplierName" + s);
				productName.setSupplierName(rs.getString("supplierName"));
				suppliers.add(supplierName);
				System.out.println("item added successfully");
				
			}
			return "success";
		}
		catch(Exception ex){
		ex.printStackTrace();
		System.out.println("Exception" + ex.getMessage());
		}
		return "error";
		}
		
		public String getSupplierName() {
	        return  productName;
	    }

public void setSupplierName(String supplierName) {
	        this.supplierName = supplierName;
	    }
	    
	    public List<Supplier> getSuppliers(){
	    	return suppliers;
	    }
	    
	    public void setSuppliers(List<Supplier> suppliers){
	    	this.suppliers = suppliers; 
	    }
	}

My Supplier.java is as follows:

Use the product id as a parameter in the link to display product details.

Hi David,

could you please elaborate this. I dont know how to use the id as a parameter.

Thanks and regards,

There are a few ways to do it; here's two.All of these topics are covered in the Struts 2 documentation, which I'd recommend reading before getting too much further into your project. There are at least a couple more variations, but this should be enough to get you started.

Hi Dave,

I am able to reach the action class but the productId values is coming null ie the productID is not populating. Please check.

Here is my producthandled.jsp

Here is my Showpdtsuppliers.java

package net.astralpharma;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.*;
import java.util.*;

import net.astralpharma.Productdisplay;

public class Showpdtsuppliers extends ActionSupport
	{
	
	private String productId = "";
	List<Supplier> supplierName = new ArrayList<Supplier>();
	
	
	public String populate()
	{
		supplierName=getSupplierName();
		productId=getProductId();
		return "populate";
	}
		
	public String execute() throws Exception{
	
		String url = "jdbc:mysql://localhost:3306/";
    	String dbname="astraldb";
    	String driverName="org.gjt.mm.mysql.Driver";
    	String userName="root";
    	String password="root";
    	Connection con=null;
    	PreparedStatement stat =null;
    	
    	try
    	{
    		Class.forName(driverName);
    		System.out.println("Driver Loaded");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/astraldb","root","root" );
			System.out.println("Database is connected");
			System.out.println("Product Id = " + productId);
			String query="Select suppliername from supplier_proddetails where productId=?";
    		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";
		}
		catch(Exception ex){
		ex.printStackTrace();
		System.out.println("Exception" + ex.getMessage());
		}
		return "error";
		}
		
		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;
	    }
	
}

Here is my Suppliers.java

Continuing on struts-user.