query="SELECT * FROM Articolo ORDER BY titolo DESC";
ResultSet r = stmt.executeQuery(query);
%>
<table border="1">
<tr><td> titolo </td> <td> articolo </td> <td> data inser </td></tr>
<%
while(r.next())
{
Tot = r.getString("titolo");
Art = r.getString("articolo");
dat = r.getString("data_inserimento");
String meta = "";
String metadata = "";
meta = Art.substring(0,40);
metadata = dat.substring(0, 10);
StringBuffer sb = new StringBuffer(meta);
sb.replace(37,40, "...");
String s2 = sb.toString();
%>
<tr>
<td> <%= Tot %> </td>
<td>
';"><%= s2 %> </td>
<td> <%= metadata %> </td>
</tr>
<%
}
%>
</table>