1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| <%! comp=0
int getcomp()
{
return comp++
}
%>
<%
con.setAutoCommit(false);
PreparedStatement ptttttttt = con.prepareStatement("select * from visite where nomprenom=? limit "+getcomp()+",1");
ptttttttt.setString(1,nomprenom);
ResultSet sssssssss = ptttttttt.executeQuery();
con.commit();
ResultSetMetaData rsmmmmmmmm = ptttttttt.getMetaData();
int nbcolonneeeeeeee = rsmmmmmmmm.getColumnCount();
while ( sssssssss.next()) {
for (int i = 1; i <= nbcolonneeeeeeee; i++) {
String nomcolonneeeeeeee = rsmmmmmmmm.getColumnName(i);
session.setAttribute(nomcolonneeeeeeee, sssssssss.getString(i));
}
}
%> |