How To Take Data From Arraylist To Jsp Page, Jsp Accessingdatabase FromJSP

Home Tutorialhelp Comment how to take data from arraylist to jsp page

Comment

hitesh

how to take data from arraylist to jsp page,
January 21, 2008 at 9:31 PM

hi,
i m feeling problem in fetching data from arraylist to jsp page as it my jdk version is 1.4 i cannot use the higher version generics please help me
my source code is

Action class

try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,"root","root");
try{
Statement st = (Statement) con.createStatement();
String sqll ="select * from "+hitesh+" order by "+arrangeby;
ResultSet rs = (ResultSet) st.executeQuery(sqll);
ArrayList ls=new ArrayList();
while (rs.next()){
Leave leave=new Leave();

ls.add(rs.getString(1));
ls.add(rs.getString(2));
ls.add(rs.getString(3));
ls.add(rs.getString(4));
ls.add(rs.getString(5));
ls.add(rs.getString(6));
ls.add(rs.getString(7));
ls.add(rs.getString(8));
ls.add(rs.getString(9));
ls.add(rs.getString(10));
ls.add(rs.getString(11));
ls.add(rs.getString(12));
ls.add(rs.getString(13));
ls.add(rs.getString(14));
ls.add(rs.getString(15));
ls.add(rs.getString(16));
ls.add(rs.getString(17));
ls.add(rs.getString(18));
ls.add(rs.getString(19));
ls.add(rs.getString(20));
ls.add(rs.getString(21));
ls.add(rs.getString(22));
ls.add(rs.getString(23));
ls.add(rs.getString(24));
ls.add(rs.getString(25));
request.setAttribute("list",ls);

}

System.out.println("1 row affected");
}
catch (SQLException s){
System.out.println("SQL statement is not executed!");
System.out.println("select * from "+hitesh+" order by "+arrangeby);
}
}
catch (Exception e){
e.printStackTrace();
}

jsp page
<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic"%>
<%@ page language="java" import="java.sql.*" %>

<html>
<head>
<title> VIEW</title>
</head>

<body>
<html:form action="/uview">
<table>
<tr><td><html:link forward="hom">HOME</html:link></td>
<td><html:link forward="log">LOGOUT</html:link></td></tr>
<tr><td><bean:message key= "viewby"></bean:message></td>
<td><html:select property="selectview">
<option value="Policy_holders_fname">Name
<option value="plan">Plan
<option value="term">Terms
<option value=" date_of_last_premium_paid"> Premium Pain on
<option value="sum_asshured">Sum Assured
<option value="policy_no"> Policy No
<option value=" mode_of_payment">Mode
<option value=" date_of_birth">Date of Birth
<option value="branch_code">Branch Code </html:select> </td>
<td><html:submit value="VIEW"></html:submit></td></tr>
<table cellspacing="5" cellpadding="5" border="1"> <tr>
<td>Policy Holder First Name</td>
<td>Middle Name</td>
<td>Last Name</td>
<td>Sex</td>
<td>Address</td>
<td>Date of Birth</td>
<td>Email Id</td>
<td>Phone NO.</td>
<td>Mobile No.</td>
<td>Policy No.</td>
<td>Branch Code</td>
<td>Date of Commencement</td>
<td>Sum Asshured</td>
<td>Plan</td>
<td>Term</td>
<td>Mode of Payment</td>
<td>Premium Amount</td>
<td>Premium Due Date</td>
<td>Date of Last Premium Paid</td>



</html:form>

</table>

</table>

</body>
</html>

please help me
View All Comments | View Tutorial