Menu

Database Table

Help
Bunty
2006-07-06
2012-10-09
  • Bunty

    Bunty - 2006-07-06

    i want to display the content of my database usin DisplayTag Pagination...m using NetBeans5.5 with tomcat 5.5.16.

    Please Help....

    Following is my code....

    <jsp:scriptlet>
    List rows1= null;

        try {
        ResultSet rs;
        Statement stmt;
        Class.forName(&quot;com.mysql.jdbc.Driver&quot;);
    
    
        Connection conn = DriverManager.getConnection(&quot;jdbc:mysql://localhost:3306/test?user=root&amp;amp;password=passit&quot;);
    
        String sql = &quot;SELECT * FROM gc&quot;;
        stmt = conn.createStatement();
        rs = stmt.executeQuery(sql);
        RowSetDynaClass resultSet = new RowSetDynaClass(rs, false);
    
        rows1=resultSet.getRows();
        request.setAttribute(&quot;rows2&quot;,rows1);
    
        String dd = resultSet.getName();
    
        out.println(dd);//printing name
        out.println(rows1);//printing content of rows
    
        rs=null;
        stmt=null;
        } catch(Exception e) {
        e.printStackTrace();
        }
    
    
    &lt;/jsp:scriptlet&gt;
    

    When i run the above code it displays the following

    org.apache.commons.beanutils.RowSetDynaClass [org.apache.commons.beanutils.BasicDynaBean@1fa6d18, org.apache.commons.beanutils.BasicDynaBean@1049d3, org.apache.commons.beanutils.BasicDynaBean@15ed659, org.apache.commons.beanutils.BasicDynaBean@14a7a12, org.apache.commons.beanutils.BasicDynaBean@9444d1, org.apache.commons.beanutils.BasicDynaBean@32060c, org.apache.commons.beanutils.BasicDynaBean@2b323e, org.apache.commons.beanutils.BasicDynaBean@1efb4be, org.apache.commons.beanutils.BasicDynaBean@435a3a, org.apache.commons.beanutils.BasicDynaBean@1d8c528, org.apache.commons.beanutils.BasicDynaBean@77eaf8, org.apache.commons.beanutils.BasicDynaBean@e35bb7]

    When i add

    <display:table name="rows1" />

    it display nothing found to display.

    Please help what i do?

    BuntyIndia

     
    • Ajanthan R

      Ajanthan R - 2006-12-05

      try this:
      <display:table name="rows2.rows" />

       

Log in to post a comment.