Forum:

Retrieve data from database in JSP(simple CRUD)

Greenhorn

Posts: 3

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello! I just started learning Java EE, created simple MySQL DB and decided to retrieve DB data in JSP page using servlets. But nothing shows up, only table headers. Although printed out everything to the console using main method, just to make sure that the getAll() method in DAO layer works. Could you please tell me what am I doing wrong here:

Controller Servlet:

web.xml:

index.jsp:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
 <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Show all tenants</title>
</head>
<body>
<table border=1>
         <thead>
             <tr>
 
 <th>Tenant ID</th>
 <th>First Name</th>
 <th>Last Name</th>
 <th>Phone</th>
 <th>Email</th>
                 
             </tr>
         </thead>
         <tbody>
             <c:forEach items="${tenants}" var="tenant">
                 <tr>
                 
 <td><c:out value="${tenant.id}" /></td> 
 <td><c:out value="${tenant.firstName}" /></td>
 <td><c:out value="${tenant.lastName}" /></td>
 <td><c:out value="${tenant.phone}" /></td>
 <td><c:out value="${tenant.email}" /></td>
                 </tr>
             </c:forEach>
         </tbody>
     </table>
  
</body>
</html>

Untitled.jpg

Bear Bibeault

Sheriff

Posts: 67699

173

I like...

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Your web.xml is wrong. It shouldn't be using the old DOCTYPE. See the JspFaq (this one: https://coderanch.com/how-to/java/ElOrJstlNotWorkingAsExpected) for information on properly setting up the web.xml.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Bear Bibeault

Sheriff

Posts: 67699

173

I like...

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

You should also be declaring your JSP/HTML as HTML5, not HTML4. You are apparently using some pretty old and dated source material.

[Asking smart questions] [About Bear] [Books by Bear]

Serge Pietel

Greenhorn

Posts: 3

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:You should also be declaring your JSP/HTML as HTML5, not HTML4. You are apparently using some pretty old and dated source material.

Thanks for quick response, I changed my web.xml specifying HTML5 in it, but it didn't help, same output:( Currently reading Head First JSP & Servlets.

Bear Bibeault

Sheriff

Posts: 67699

173

I like...

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The HTML5 declaration is for the HTML (generated by the JSP) and has nothing to do with the web.xml.

Read the FAQ I linked to; it will show you how to properly configure the web.xml.

[Asking smart questions] [About Bear] [Books by Bear]

Serge Pietel

Greenhorn

Posts: 3

posted 7 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:

The HTML5 declaration is for the HTML (generated by the JSP) and has nothing to do with the web.xml.

Read the FAQ I linked to; it will show you how to properly configure the web.xml.

Thanks, I read it... Probably the problem was with my Eclipse's workspace: I deleted one messy project in it, reconfigured Tomcat server and cleaned my project and it works!

What could go wrong in a swell place like "The Evil Eye"? Or with this tiny ad?

The Low Tech Laboratory Movie Kickstarter is LIVE NOW!

https://www.kickstarter.com/projects/paulwheaton/low-tech