While you can certainly define both member and class variables in a Servlet implementation class, there are J2EE constructs that do that and generally should be used instead
The use of the SingleThreadModel interface guarantees that only one thread at a
time will execute in a given servlet instance’s service method. It is important to
note that this guarantee only applies to each servlet instance, since the container
may choose to pool such objects
The same SELECT query may return results in different order each time it is called.
I understand that unless there is some change the rows will be retrieved in the order they were inserted, am i correct ?
I was always told it would be fine, unless the dba had to play with the database in the night, recreating tables, that was why you should never rely on column or row order.