Untitled

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.lang.*;

public class DataSelect extends HttpServlet {

   public void doGet(HttpServletRequest request, HttpServletResponse response)
         throws ServletException, IOException  {

      response.setContentType("text/html");
      PrintWriter out = response.getWriter();

      try {
         Class.forName("com.mysql.jdbc.Driver");
      } catch (ClassNotFoundException e) {

      }

      try {
            Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/naga","root","root");

            Statement stmt=conn.createStatement();
            String sql = "SELECT id, age, first, last  FROM employees";
            ResultSet rs = stmt.executeQuery(sql);

            List<Object> list = new ArrayList<Object>();

            while(rs.next()){

               list.add(rs.getString("id"));
               list.add(rs.getString("age"));
               list.add(rs.getString("first"));
               list.add(rs.getString("last"));

            }

               request.setAttribute("data", list);
               request.getRequestDispatcher("ss.jsp").forward(request, response);


         rs.close();
         stmt.close();
         conn.close();

      } catch(SQLException se) {
         se.printStackTrace();
         out.println(se);

      }
   }
}

<%@ page import="java.io.*,java.util.*,java.sql.*"%>
    <%@ page import="javax.servlet.http.*,javax.servlet.*" %>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
    <%@ 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>
        <title>SS JSP</title>
        <link rel="stylesheet" type="text/css" href="css/bootstrap.css">
    </head>
    <body>
        <div class="container">
            <table class="table table-striped table-bordered">
                <thead>
                    <tr>
                        <td>ID</td>
                        <td>Age</td>
                        <td>Name</td>
                        <td>Address</td>
                    </tr>
                </thead>
                <tbody>
                    <c:forEach var="rowd" items="${data}">
                        <tr>
                           <td>${rowd.id}</td>
                        </tr>
                    </c:forEach>
                </tbody>
            </table>
        </div>
    </body>
    </html>

<c:forEach var="rowd" items="${data}">
    <tr>
    <td>${rowd}</td>
    </tr>
</c:forEach>

<c:forEach var="rowd" items="${data}">
    <tr>
        <td>${rowd.id}</td>
        <td>${rowd.age</td>
    </tr>
 </c:forEach>

HTTP Status 500 ? Internal Server Error
Type Exception Report

Message An exception occurred processing JSP page [/ss.jsp] at line [29]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: An exception occurred processing JSP page [/ss.jsp] at line [29]

26:
27:                 <c:forEach var="rowd" items="${data}">
28:                     <tr>
29:                        <td>${rowd.id}</td>
30:                     </tr>
31:                 </c:forEach>
32:             </tbody>


Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:584)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    DataSelect.doGet(DataSelect.java:44)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause

javax.el.PropertyNotFoundException: Property [id] not found on type [java.lang.String]
    javax.el.BeanELResolver$BeanProperties.get(BeanELResolver.java:260)
    javax.el.BeanELResolver$BeanProperties.access$300(BeanELResolver.java:212)
    javax.el.BeanELResolver.property(BeanELResolver.java:347)
    javax.el.BeanELResolver.getValue(BeanELResolver.java:92)
    org.apache.jasper.el.JasperELResolver.getValue(JasperELResolver.java:110)
    org.apache.el.parser.AstValue.getValue(AstValue.java:169)
    org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:190)
    org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:944)
    org.apache.jsp.ss_jsp._jspx_meth_c_005fforEach_005f0(ss_jsp.java:203)
    org.apache.jsp.ss_jsp._jspService(ss_jsp.java:154)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    DataSelect.doGet(DataSelect.java:44)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:635)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Note The full stack trace of the root cause is available in the server logs.

while(rs.next()){

               list.add(rs.getString("id"));
               list.add(rs.getString("age"));
               list.add(rs.getString("first"));
               list.add(rs.getString("last"));

            }

while(rs.next()){

                Person person = new Person();
                person.setId(rs.getString("id"));
                person.setAge(rs.getString("id"));
                person.setFirst(rs.getString("first"));
                person.setLast(rs.getString("last"));
                list.add(person);
            }