Filter
Top Products
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