Below is the implementation of Hashtable & Array list in java
<%
//Declare hashtable & arraylist
Hashtable ht_data = new Hashtable();
ArrayList al_data = null;
try {
StringBuffer SEL_SQL = new StringBuffer("SELECT id,name, ");
SEL_SQL.append("nvl(to_char(DOB,'DD-MM-YYYY'),'NA')DOB");
SEL_SQL.append(" FROM EMPLOYEE WHERE ID=6587)");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SEL_SQL.toString());
while (rs.next()) {
al_data = new ArrayList();
al_data.add(rs.getString("id"));
al_data.add(rs.getString("name"));
al_data.add(rs.getString("DOB"));
ht_maindata.put(i, al_maindata);
}//WHILE LOOP END
%>
<table width="682" border="1" align="center" cellpadding="0" cellspacing="2" class="table_bgcolor" id="content">
<tr height="30">
<th class="normal">ID</th>
<th class="normal">NAME</th>
<th class="normal">DOB</th>
</tr>
<%
if (ht_data.size() > 0) {
for (int s = 0; s < ht_data.size(); s++) {
ArrayList al = (ArrayList) ht_data.get(s);
%>
<tr height="30">
<td class="normal"><%=index%></td>
<td class="normal"><%=al.get(0)%></td>
<td class="normal"><%=al.get(1)%></td>
<td class="normal"><%=al.get(2)%></td>
</tr>
<%
}//for
//if
}//try
catch(Exception e)
{
System.out.println(e.getMessage());
finally
{
try{
connection.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}//catch
%>
<%
//Declare hashtable & arraylist
Hashtable ht_data = new Hashtable();
ArrayList al_data = null;
try {
StringBuffer SEL_SQL = new StringBuffer("SELECT id,name, ");
SEL_SQL.append("nvl(to_char(DOB,'DD-MM-YYYY'),'NA')DOB");
SEL_SQL.append(" FROM EMPLOYEE WHERE ID=6587)");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SEL_SQL.toString());
while (rs.next()) {
al_data = new ArrayList();
al_data.add(rs.getString("id"));
al_data.add(rs.getString("name"));
al_data.add(rs.getString("DOB"));
ht_maindata.put(i, al_maindata);
}//WHILE LOOP END
%>
<table width="682" border="1" align="center" cellpadding="0" cellspacing="2" class="table_bgcolor" id="content">
<tr height="30">
<th class="normal">ID</th>
<th class="normal">NAME</th>
<th class="normal">DOB</th>
</tr>
<%
if (ht_data.size() > 0) {
for (int s = 0; s < ht_data.size(); s++) {
ArrayList al = (ArrayList) ht_data.get(s);
%>
<tr height="30">
<td class="normal"><%=index%></td>
<td class="normal"><%=al.get(0)%></td>
<td class="normal"><%=al.get(1)%></td>
<td class="normal"><%=al.get(2)%></td>
</tr>
<%
}//for
//if
}//try
catch(Exception e)
{
System.out.println(e.getMessage());
finally
{
try{
connection.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}//catch
%>
No comments:
Post a Comment