Hello,
Can someone shed light please?
Regards
On Fri, Jun 27, 2008 at 8:58 AM, Joseph Bautista <[EMAIL PROTECTED]>
wrote:
> 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
> --
>
>
--
Joseph DC Bautista
Senior Activation Analyst - OSS
Tel +971 4 369 2063
Mobile +971 55 953 1596
www.du.ae
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
displaytag-user mailing list
displaytag-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/displaytag-user
