Printable View
hello friends,
i am having a problem in displaying the data in a table format using jstl forEach tag. i am using springs and retrieving data from a controller using model and view and storing it in an ArrayList. now i want to display it to the user using a jsp page. Please help.
Code:<table>
<c:forEach var="script" items="${scripts}" varStatus="varCounter">
<tr>
<td>${script.name}</td>
<td>${script.type}</td>
</tr>
</c:forEach>
</table>
LoginFormController.java
public class LoginFormController extends SimpleFormController {
@Override
protected ModelAndView onSubmit(Object command) throws ServletException {
Statement stmt;
Connection connection;
ArrayList processName=new ArrayList();
ArrayList description=new ArrayList();
ArrayList parentId=new ArrayList();
ArrayList processType=new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
connection=DriverManager.getConnection("jdbc:mysql ://localhost:3306/emsdb","root","mysql");
stmt=connection.createStatement();
String data="select * from processt";
ResultSet resultSet=stmt.executeQuery(data);
while(resultSet.next()){
String row1=resultSet.getString("ProcessName");
processName.add(row1);
String row2=resultSet.getString("Description");
description.add(row2);
String row3=resultSet.getString("ParentId");
parentId.add(row3);
String row4=resultSet.getString("ProcessType");
processType.add(row4);
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ModelAndView modelAndView = new ModelAndView(getSuccessView());
modelAndView.addObject("name", processName);
modelAndView.addObject("description", description);
modelAndView.addObject("parentId", parentId);
modelAndView.addObject("processType", processType);
return modelAndView;
}
thanks for the reply petr
this is my controller class and i have created a view for it to show the values in table format....please modify this code.
success.jsp
<%@page import="java.util.ArrayList"%>
<%@ page session="false"%>
<%@ taglib prefix="core" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="spring" uri="/spring" %>
<html>
<head>
<title>Success</title>
</head>
<body>
<table BORDER="1">
<tr>
<th>Name</th>
<th>Description</th>
<th>parent-Id</th>
<th>Process-Type</th>
</tr>
<core:forEach begin="1" end="5">
<tr>
<td><core:out value="${name}"/></td>
<td><core:out value="${description}"/></td>
<td><core:out value="${parentId}"/></td>
<td><core:out value="${processType}"/></td>
</tr>
</core:forEach>
</table>
<center>
<a href="login.html">Back</a>
</center>
</body>
</html>
do i need to create a pojo class for the controller to retrieve the data.
Please reply i m stuckkk.... :mad::eek::(