Forum:

Struts

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

Greenhorn

Posts: 18

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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:

Prashant Singh

David Newton

Author

Posts: 12617

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Prashant K. Singh

Greenhorn

Posts: 18

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi David,

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

Thanks and regards,

Prashant Singh

David Newton

Author

Posts: 12617

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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.

Prashant K. Singh

Greenhorn

Posts: 18

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Prashant Singh

David Newton

Author

Posts: 12617

I like...

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Continuing on struts-user.

Every time you till, you lose 30% of your organic matter. But this tiny ad is durable:

free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth

https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter