Forum:

Printing DB values inside table tag in JSP

ashwin bala

Ranch Hand

Posts: 52

posted 2 years ago

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: 614

I like...

posted 2 years ago

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

Ranch Hand

Posts: 2826

posted 2 years ago

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?

It is sorta covered in the JavaRanch Style Guide.

Printing DB values inside table tag in JSP

Similar Threads