Hello Gurus,
I've been fixing this "Nothing to display" problem for week now but to no
avail. Can somebody please help?? See code below...
public void contextInitialized(ServletContextEvent sce) {
dataset dtset = new dataset();
ResultSet rs = dtset.getDataSet(this.conn, " Select * from oss_users
", "" , " order by id"); This returning the list
ArrayList userList = new ArrayList();
users user = new users();
try {
rs.last();
int ctr = 0;
rs.first();
for (ctr = 0; ctr < rs.getRow(); ctr++ ){
user.setId(rs.getString("ID"));
user.setPassword(rs.getString("PASSWORD"));
user.setUsername(rs.getString("USERNAME"));
user.setFname(rs.getString("FNAME"));
user.setMname(rs.getString("MNAME"));
user.setLname(rs.getString("LNAME"));
user.setEmail(rs.getString("EMAIL"));
user.setPosition(rs.getString("POSITION"));
user.setAge(rs.getString("AGE"));
userList.add(user);
rs.next();
}
} catch (SQLException e){
e.printStackTrace();
}
sce.getServletContext().setAttribute("dtSet", userList);
}
In my jsp:
<display:table name="${dtSet}" export="true" id="row" class="dataTable"
defaultsort="1" defaultorder="ascending"
pagesize="16" cellspacing="0" >
<display:column property="ID" title="ID"
class="hidden" headerClass="hidden" media="html" />
<display:column property="USERNAME"
title="Username" sortable="true" class="username" headerClass="username" />
<display:column property="PASSWORD"
title="password" class="hidden" headerClass="hidden" media="html" />
<display:column property="FNAME"
title="First Name" sortable="true" class="fname" headerClass="fname" />
<display:column property="LNAME"
title="Last Name" sortable="true" class="lname" />
<display:column property="MNAME"
title="Middle Name" sortable="true" class="mname" headerClass="mname" />
<display:column property="EMAIL"
title="Email Address" sortable="true" class="email" headerClass="email" />
<display:column property="POSITION"
title="Position" sortable="false" class="position" headerClass="position" />
<display:column property="AGE" title="AGE"
sortable="false" class="age" headerClass="age" />
</display:table>
In my web.xml,
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="
http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd";>
<welcome-file-list>
<welcome-file>users.jsp</welcome-file>
</welcome-file-list>
<listener>
<listener-class>oss.service.dataloader</listener-class>
</listener>
</web-app>
Regards,
Joseph
--
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
