* @param userid ID of the user for which we want a featured image
* @return A random image from the database as bean
**/
private ImageBean getFeatured(int userid)
throws ServletException {
ImageBean temp=null;
synchronized(this) {
try {
//select random image from DB
PreparedStatement stmt=DBInterface.doQuery("SELECT id,title " +
"FROM image " +
"WHERE owner=?" +
"ORDER BY RANDOM() LIMIT 1;");
stmt.setInt(1,userid);
ResultSet result=stmt.executeQuery();
if (result.next()) {
temp=new ImageBean();
temp.setId(result.getInt(1));
temp.setTitle(result.getString(2));
}
result.close();
stmt.close();
DBInterface.close();