how to create summary and detail table

[roy ramos]

Hi,

can anybody help me into this

i have table a summary table shown below
how can i add link using ID as a parameter to pass to details table from another jsp

 
</TR>
            <% while(resultset.next()){ %>
            <TR>
                <TD> <%= resultset.getString("ID") %></TD>
                <TD> <%= resultset.getString("NAME") %></TD>
             </TR>

   

need help
thanks,
-roy

[Seetharaman Venkatasamy]

roy ramos wrote:
how can i add link using ID as a parameter to pass to details table from another jsp

 
</TR>
            <% while(resultset.next()){ %>
            <TR>
                <TD> <%= resultset.getString("ID") %></TD>
                <TD> <%= resultset.getString("NAME") %></TD>
             </TR>

   

    

       <TR>
                <TD> 
               <a href='<%= request.getContextPath() %>/controller?id=<%= resultset.getString("ID")  %>'><%=  resultset.getString("ID") %></a>
                </TD>
                <TD> <%= resultset.getString("NAME") %></TD>
             </TR>

getting sql connection in jsp is discouraged , reconstruct your architecture.

by the way: use EL instead of scriptlet(expression) . scriptlet in jsp consider as poor practice

[roy ramos]

Hi Seetharaman,

thank you very much on your reply, i'm very new in programming especially in jsp and this is my 1st building blocks to familiar myself in programming

anyways i follow your code and it show some error and this is the logs generated

Mar 17, 2010 1:30:47 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.lang.AbstractMethodError
at net.sourceforge.jtds.jdbc.JtdsResultSet.getNString(JtdsResultSet.java:1405)
at org.apache.jsp.page.empmasterpg_jsp._jspService(empmasterpg_jsp.java:280)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
at java.lang.Thread.run(Thread.java:619)

[Seetharaman Venkatasamy]

rebuild your application/servlet . and it would be better to post your servlet code

[roy ramos]

Hi Seetharaman,

Here is my created servlet, is this ok?

package pack;

import java.sql.*;
import java.sql.ResultSet.*;

/**
 *
 * @author roy-g.ramos
 */
public class id_list {

    
    String url="jdbc:jtds:sqlserver://server/database";
    Connection conn=null;
    private String id="";
    private String name="";

    public void setID(String input){
        id=input;
    }
    public String getID(){
        return id;
    }
    public void setNAME(String input){
        name=input;
    }
    public String getNAME(){
        return name;
    }
    {
      try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection con= DriverManager.getConnection(url, "uname", "password");
            Statement s= null;
            ResultSet rs = null;
            String sql= "select no, name from table";
            s= con.createStatement();
            rs= s.executeQuery(sql);

            while (rs.next()){
                id=rs.getString("no");
                name=rs.getString("name").trim();
            }
        }
        catch (Exception e){
            
        }
    }
}
    

[Mark E Hansen]

Ummm, that's not a servlet.

[roy ramos]

opsss sorry it's a bean

Mark E Hansen wrote:Ummm, that's not a servlet.