HP 5991-5565 manual

public void showData(JspWriter out,List list)

{

Iterator it = list.iterator(); try{

out.print("<table width='100%' border='1' cellspacing='0' cellpadding='0'><tr>"); out.print("<tr><td bgcolor='E2E6F1'><div align='center'>UserID<br></div></td>"); out.print("<td bgcolor='E2E6F1'><div align='center'>FirstName<br></div></td>"); out.print("<td bgcolor='E2E6F1'><div align='center'>LastName<br></div></td></tr>"); while(it.hasNext())

{ Users users = (Users)it.next(); out.print("<tr><td><div + align='center'>"+users.getUserId()

+ "<br></div></td>");

out.print("<td><div align='center'>"+users.getFirstName() + "<br></div></td>");

out.print("<td><div align='center'>"+users.getLastName()

+"<br></div></td></tr>");

}

out.print("</tr></table>"); }catch(Exception e){e.printStackTrace();}

}

%>

<%!

org.hibernate.Session hbsession = null; void initSession()

{hbsession = HibernateSessionFactory.getSession();} public List queryAll()//query table users from database

List list = null; try{

String hsql = "from Users";

org.hibernate.Query query = hbsession.createQuery(hsql); list = query.list();

return list; }catch(HibernateException he)

{he.printStackTrace(); return list; }

}

public Long insert()

{

try{ Transaction tx = hbsession.beginTransaction(); Users users= new Users(); users.setFirstName("Smith"); users.setLastName("Barney");

hbsession.save(users);

hbsession.flush();

tx.commit();

return users.getUserId(); }catch(HibernateException he){ he.printStackTrace(); return null;}

}

public void update(Long userID)

{

try{ Transaction tx = hbsession.beginTransaction(); Users users = (Users)hbsession.get(Users.class,userID); users.setLastName("root");

hbsession.save(users);

hbsession.flush();

tx.commit();

}catch(HibernateException he){ he.printStackTrace();}

}

public void delete(Long userID)

{

try{Transaction tx = hbsession.beginTransaction(); String hsql = "delete Users where user_id="+userID; Query query = hbsession.createQuery(hsql); query.executeUpdate();

tx.commit();

}catch(HibernateException he){ he.printStackTrace();}

}

public void clean()

56