<%
for(int i = 1; i <= metaData.getColumnCount();i++)
{
System.out.println("displaydata " + metaData.getColumnType(i));
switch(metaData.getColumnType(i))
{
case 1:
//System.out.println("displaydata " +resultSet.getInt(i));
%>|
<%=resultSet.getString(i)%>
| <%
break;
case -1:
//System.out.println("displaydata " +resultSet.getString(i));
%>
<%=resultSet.getString(i)%>
| <%
break;
case 6:
//System.out.println("displaydata " +resultSet.getFloat(i));
%>
<%=resultSet.getFloat(i)%>
| <%
break;
case -7:
//System.out.println("displaydata " +resultSet.getBoolean(i));
%>
<%=resultSet.getBoolean(i)%>
| <%
break;
}
}
%>
<%
}
%>