Hello All, I am trying to retreive a list from the session and display that list on a jsp, but I am not entirely sure of the correct syntax for reading the list. Any help would be appreciated. Here is the code that I am cuurently using: Action class: package round;
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import java.util.Map; import com.opensymphony.xwork2.ActionContext; import example.ExampleSupport; public class GetListAction extends ExampleSupport{ public String getList() throws SQLException { Round round = new Round(); List<Round> eventList = new ArrayList<Round>(); Map session = (Map)ActionContext.getContext().get("session"); String userName = String.valueOf(session.get("userName")); try { Statement stmt; Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/Nexus"; String sql = "Select * " + "FROM round WHERE userName='" + userName + "'"; Connection con = DriverManager.getConnection( url,"root", "*****"); stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ round.setMatchID(rs.getInt(1)); round.setEventID(rs.getInt(2)); round.setUserName(rs.getString(3)); round.setRound(rs.getInt(4)); round.setPersona(rs.getString(5)); round.setResult(rs.getInt(6)); round.setOpponent(rs.getString(7)); eventList.add(round); } con.close(); }catch( Exception e ) { e.printStackTrace(); } session.put("eventList", eventList); System.err.println("Session objects: " + session.get("eventList")); return SUCCESS; } } Query is successful, and System.err.println displays: Session objects: [EMAIL PROTECTED] JSP: <[EMAIL PROTECTED] prefix="s" uri="/struts-tags" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" " http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <title>Welcome to Nexus!!!</title> <LINK rel="stylesheet" type="text/css" href="../css/styles.css"> </head> <body background="../images/containment.jpg"> <table width="100%"> <tr> <td width="10%" rowspan="4"> <s:include value="../includes/menu.jsp"/> </td> <td> <table border="0" width="90%" align="center"> <tr> <td align="center"> <h3> Welcome to the Nexus, <s:property value="#session.userInfo.firstName"/> </h3> </td> </tr> <tr> <td align="center"> <table class="round"> <tr> <th><font color="white">Match ID</font></th> <th><font color="white">Event ID</font></th> <th><font color="white">Persona Used</font></th> <th><font color="white">Opponent</font></th> <th><font color="white">Result</font></th> <th><font color="white">Round</font></th> </tr> <tr> <s:iterator value="#eventList.round" status="rowstatus"> <tr> <s:if test="#rowstatus.odd == true"> <td style="background: grey"> <s:property value="matchID" /> <s:property value="eventID" /> <s:property value="persona" /> <s:property value="opponent" /> <s:property value="result" /> <s:property value="round" /> </s:if> <s:else> <s:property value="matchID" /> <s:property value="eventID" /> <s:property value="persona" /> <s:property value="opponent" /> <s:property value="result" /> <s:property value="round" /> </s:else> </tr> </s:iterator> </tr> </table> </td> </tr> </table> </table> </body> </html> Displays users first name, but not the list. Struts2 mapping: <action name="viewTournaments" class="round.GetListAction" method="getList"> <result name="success">/jsp/tournament/tournamentList.jsp</result> <interceptor-ref name="basicStack"/> </action> Thanks in advance for the help, Chriss