Forum:

Struts

Arraylist and Hashtable issue

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Ranchers,

I am having an ArrayList with Hashtables. I iterated ArrayList on jsp. But iam not getting values in select box..please check my jsp, dao and dbutils.

MyJSP

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.util.ArrayList"%>
<%@taglib uri="http://java.sun.com/jstl/core" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>User Profile</title>
</head>
<body>
<form onsubmit="return submitFun()"  action="UserProfileCreate.do" method="post">

<table width="600" border="0" cellspacing="0" cellpadding="0" align="center" class=border>
        <tr> 
          <td colspan="2" align="center"> 
            <table border="0" cellspacing="2" cellpadding="1" class=white width=100%>
				
				<tr> 
                <td valign="middle" class=bodybg align="right" width="23%" >Select User<font color=red>*</font></td>
                <td  align="left" valign="middle" class=bodybg colspan=3>

<select name="userId">
                  <option value="">Select User</option>
                  <c:set var="userList" value="userList" scope="request"/>
                  <jsp:useBean id="userList" class="java.util.ArrayList"></jsp:useBean>
                    <c:forEach items="userList" var="item" varStatus="counter"></c:forEach>
                    
                    <jsp:useBean id="mapItem" beanName="${item[0]}" type="java.util.Hashtable"></jsp:useBean>
                    
                    	 
                     
                        	<option value='${mapItem["user_id"] }'>${mapItem["user_id"]}</option>
                     	
                  </select> 
                 
                </td>
              </tr>
				
              <tr> 
                <td valign="middle" class=bodybg align="right" width="23%" >First Name<font color=red>*</font></td>
                <td  align="left" valign="middle" class=bodybg colspan=3>

<tr> 
                <td valign='middle' class='bodybg' align='right' >Email Id<font color=red>*</font></td>
                <td valign='middle' class='bodybg' align='left'  > 
                    <input name="emailId" type="text" class="textbox" maxlength="15" >
                </td>
              </tr>
               <tr> 
                <td valign='middle' class='bodybg' align='right' >Mobile Number<font color=red>*</font></td>
                <td valign='middle' class='bodybg' align='left'  > 
                    <input name="mobileNo" type="text" class="textbox" maxlength="15" >
                </td>
              </tr>
             
              <tr> 
                <td valign='middle' class='bodybg' align='right' ></td>
                <td valign='middle' class='bodybg' align='left'  > 
                    <input value="submit" type="submit" class="textbox" />
                </td>
              </tr>
           </table>   
</form>
</body>
</html>

MY DAO

public static ArrayList rsToArrayList(ResultSet resultSet)
	  {
	    ArrayList arrayList = new ArrayList();
	    if (resultSet!=null)
	    {
	      try
	      {
	        ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
	        //com.spry.common.Logger.logNew("0");
	        while(resultSet.next())
	        {
	         // com.spry.common.Logger.logNew("1");
	          Hashtable hashtable = new Hashtable();
	          for (int i=1;i<=resultSetMetaData.getColumnCount();i++)
	          {
	            //com.spry.common.Logger.logNew("inside the for loop");
	            if (resultSet.getObject(i)==null)
	              hashtable.put(resultSetMetaData.getColumnName(i),"");
	            else
	              hashtable.put(resultSetMetaData.getColumnName(i),resultSet.getObject(i));              
	          }
	          //com.spry.common.Logger.logNew("2");
	          arrayList.add(hashtable);
	          //com.spry.common.Logger.logNew("3");
	        }
	      }
	      catch(SQLException sqle)
	      {
	        
	        sqle.printStackTrace();
	      }
	    }
	    return arrayList;
	  }

Please check my code and tell me where iam doing mistake.

Thanks
Vipul Kumar.

K. Tsang

Bartender

Posts: 3648

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Before you look at JSP, make sure your result set has records then array list is not empty.

I suggest you may want to use the old fashion simpler way (aka looping the result set directly) inside your listUsers() method to make sure it's not the query. If that works, then it's your DBUtil.rsToArrayList() method.

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Rancher,

Thanks for the reply. Data is coming from database. Please verify my jsp. tell me how to access hashmap value in a arraylist

Thanks
vipul kumar

Seetharaman Venkatasamy

Ranch Hand

Posts: 5575

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

requirement is you need to show the list of map key/value's right?

I am going to tell you how to display list of maps in jsp.

here you go: Use Servlet and JSP. just call the servlet first, then forward to jsp from there...

in servlet:

In JSP:(index.jsp)

simple! is not it?

* if you follow design1 architecture(using only JSPs) . then you need to move servlet logic to a class
and the class processing should take before the JSTL loop.

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Rancher,

Thanks for response. which version of core tags allowing expressions in items attribute.?

Thanks
Vipul Kumar.

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Rancher,

i am getting this exception .

Exception:- According to TLD or attribute directive in tag file, attribute items does not accept any expressions

that is why, i asked jstl core tags version

Thanks
Vipul Kumar.

Seetharaman Venkatasamy

Ranch Hand

Posts: 5575

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

vipul bondugula wrote:
Exception:- According to TLD or attribute directive in tag file, attribute items does not accept any expressions

do you use <%= %> ? perhaps, it is not supported in JSTL1.0

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Rancher,

I am using EL Expressions.

Thanks
Vipul Kumar

Stefan Evans

Bartender

Posts: 1845

posted 9 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

You are using JSTL1.0. You should be using JSTL1.1 at least.

The issue is with your tag library declaration:

should be

(note the subtle addition of /jsp in there)

JSTL1.0 is intended for old containers - Servlet 2.3/JSP1.2. (eg Tomcat 4)
If you are using anything newer than that then use the JSTL1.1 uri.
JSP2.0 is the point at which EL expressions started being interpreted by the server, which was a fundamental change for the tag library - so they gave it a new URI to distinguish which to use.

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks Stefan,

Expression Language issues solved. EL expressions are embedded in jsp 2.0. Thanks for the information.

But my issue is , start of the post. to display elements in hashmap which is in arraylist..

Thanks
Vipul Kumar.

Stefan Evans

Bartender

Posts: 1845

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Sorry, I thought Seetharaman had already answered your query, and my answer was to help with troubleshooting an error message with his solution.
Taking a closer look at his answer, it doesn't seem to be what you were implementing.

This should be closer:

Changes I made
- added EL expression markers to the "items" attribute on your c:forEach.
- changed your <c:forEach> loop to nest the <option> values within it.
- removed the useBean statements. They are not necessary when using EL and JSTL. Only when you are using scriptlets as they define a scriptlet variable on the page as well as putting the bean in scope.
- changed the syntax ${mapItem["user_id"] } to ${mapItem.user_id} which is equivalent.

That should do it.

Returning a List of Maps indexed by column name is a bit of a code smell because database columns might be renamed etc without you ever being informed about it, thus breaking the page.
Preferable would be to define a java bean to return the values to the page that you want, and load values from the result set into a List of Beans.

vipul John

Ranch Hand

Posts: 252

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thanks Stefan

Returning a List of Maps indexed by column name is a bit of a code smell because database columns might be renamed etc without you ever being informed about it, thus breaking the page.
Preferable would be to define a java bean to return the values to the page that you want, and load values from the result set into a List of Beans.

Even though below question is irrelavent , please answer query....

Suppose if iam using struts 1.2. can i use form bean as a java bean to return values to the page...form bean is also a java bean , right?

Thanks
Vipul Kumar.

Stefan Evans

Bartender

Posts: 1845

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If you are using Struts1.2 you might have more luck in our Struts forum :-)

But yes, you can use the form bean to return values to the page. In fact I'm pretty sure that is a common use case.
Normally you should work within the bounds of the framework though rather than short-circuiting things.

However, with my previous answer returning a list of beans rather than a list of maps, my answer remains the same.
A List of beans is always preferable to a list of maps because it defines more strictly what the values are, and they won't change if you change your database columns.
The only difference with stripes is I might use the form to return that list rather than setting it as an scoped attribute.

Bear Bibeault

Sheriff

Posts: 67637

173

I like...