Forum:

Printing DB values inside table tag in JSP

Ranch Hand

Posts: 52

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,

In the below JSP code, on the dropdown value change event, I am fetching values from the database and displaying inside table tag.I am doing it scriplets code.
I request you to check the code once as it is not printing the database values.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<style>
table, th, td {
    border: 1px solid black;
    border-collapse: collapse;
}
</style>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
</head>
<body>
<script type="text/javascript">

<table>
 <%@ page import="java.util.*" %>
 <%
 com.ComponentFamilyBean ncf = new com.ComponentFamilyBean();
 ArrayList<com.ComponentFamilyBean> alf = (ArrayList<com.ComponentFamilyBean>)request.getAttribute("ComponentsFamilyList");
int x = 0;
if(alf != null)
{
    for(int y=0;x<alf.size();y++)
    {
    	System.out.println("list size"+alf.size());
    	%><tr><%
		for(int z=0;z<5&&x<alf.size();z++)
		{
			ncf = alf.get(x);
			System.out.print(ncf.getComponentFamilyName());
			%>
			
			<td><a href="#"><%=ncf.getComponentFamilyName()%></a></td>
			<%x = x+1;
		}
		%></tr><%
 	}
}%> 
</table>

<table>
<%@ page import="java.util.*" %>
 <%
 com.ComponentBean nc = new com.ComponentBean();
 ArrayList<com.ComponentBean> al = (ArrayList<com.ComponentBean>)request.getAttribute("ComponentsList");
int k = 0;
if(al != null)
{
for(int i=0;k<al.size();i++)
{
%><tr><%
	for(int j=0;j<5&&k<al.size();j++){
		nc = al.get(k);%>
		<td><a href=""><%=nc.getComponentName()%></a></td>
		<%k = k+1;
	}
	%></tr><%
 }
}%>
</table>
</body>
</html>

In the above code, the second table was displaying values.I have issue only with the first table tag code.Request your help in this.

Tapas Chand

Ranch Hand

Posts: 624

I like...

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

1. What is printed in console in first for loop?
2. What is printed in console in second for loop?
3. Request.getAttribute(String val) should not be used in case of Ajax call.

Scriplets are discredited since some 15 years. Avoid them.
Use JQuery and JSON for ajax calls, it will make your life way too simple.

Dave Tolls

Rancher

Posts: 4801

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Along with the points raised by Tapas, what is the HTML returned by the Ajax call?
What resource on the server is that call going to?
What is the code for that?

Also, what is the HTML produced on the browser by that JSP, specifically for that table that is having a problem?

Don't get me started about those stupid light bulbs.