Retriew the values from the database using Struts2.

[Sandeep Poojary]

Hi all,
I am new to Struts technology. I want to retriew the values from the database and display in the browser using Struts2.

Regards,
Sandeep

[yash wardhan]

retrieve the data in action and pass it to the jsp.

Thanks,

[Tom Rispoli]

There are a lot of components to your question. To Retrieve the data from your db really isn't a struts issue, its done the same as with any other application running on a J2EE server. Set up the datasource on your server and use jdbc to handle your query. There are some other tools out there to help you handle the database transactions but I'm not too familiar with them.

As far as passing the action to the JSP goes, all you need to do is take the data you've retrieved from your DB and store it in properties of your action class (with correctly named getter and setter methods to access it). Once in your JSP you'll just need to specify the name of the property of your action class that you want to display in the the struts2 tag. Take a look at:

struts2 action example

for examples on coding the action class and

tag API

for examples of how to use the tags.

[Rajesh k Jha]

Hello Everyone,
I am having the same problem as Sandeep had, I tried to my level best but still i am not able to get the data in the jsp.
But one thing i made possible to fetch single data in jsp, but i am looking for the iteration of all the data from database.
File name is LoginDaoImpl.java

    

public List<CompanyDetails> getCompanyDetails() {	
		List<CompanyDetails> courses = null;
		try {
			session = DatabaseConnectionDao.Connection();
			transaction = session.beginTransaction();
			courses = session.createQuery("from CompanyDetails").list();
			transaction.commit();
			System.out.println("Successfully fetching company data");
		} catch (Exception e) {
			e.printStackTrace();
			transaction.rollback();
			System.out.println("Not Getting any company information form here");
		} 
		finally {
			if (session != null) {
				session.close();
			}
		}
		return courses;
	}

And in JSP file i am writing.

   
 <% 
               LoginDaoImpl userDAO = new LoginDaoImpl();
               CompanyDetails companydetails = new CompanyDetails();
               List list= userDAO.getCompanyDetails();
               Iterator iter = list.iterator();
   			if (iter.hasNext()) {
   				companydetails = (CompanyDetails) iter.next();
   				
   				
   				  				
   				}
               
                          %>
                          <table>
                        <tr>
                                    
                            <s:iterator value="companydetails" var="contact">
                        
                          <td><s:property value="id"/>
                           </td>
                           <td><s:property value="companyName"/>
                           </td>
                          </tr>
                          </s:iterator>
                          </table>
 

But when i use

  
 <%=contact.getId() %>
  

I am able to get the single value, but i want all the values of the database thorugh iterator.

I have seperate setter/getter (POJO) class for the Company

 
public class CompanyDetails{

//	private static final long serialVersionUID = -6659925652584240539L;

	private int id ;
	 private String companyName;
	private String imageUrl;
    private String location;
   
	  public CompanyDetails() {
    }

	public int getId() {
		return id;
	}

	public void setId(int Id) {
		this.id = Id;
	}

	public String getCompanyName() {
		return companyName;
	}

	public void setCompanyName(String companyName) {
		this.companyName = companyName;
	}

	public String getImageUrl() {
		return imageUrl;
	}

	public void setImageUrl(String imageUrl) {
		this.imageUrl = imageUrl;
	}
	
	 public String getLocation() {
			return location;
		}

		public void setLocation(String location) {
			this.location = location;
		}


}
   

Please help me out with the output of database in the JSP page using struts2 way.

Thanks

[Joe Ess]

You should not need the Java scriptlet. Struts 2 does the work of connecting the JSP with the Action.
If your action has a method getCompanyDetails, the value parameter for the iterator tag should be "companyDetails".
Also, you should do all database queries in the execute method (or whatever you set the action method to be). Should an error occur, you'll want to set an error message or redirect to an error page, and you can't do that in an accessor method.