public boolean delProduct(int id) {
// TODO Auto-generated method stub
Transaction tx=null;
Session s=super.getSession();
try {
sql="delete from AuctionBid a where a.auctionProduct.apProdId=?";
Query query=s.createQuery(sql);
query.setInteger(0, id);
query.executeUpdate();
tx=s.beginTransaction();
AuctionProduct product=(AuctionProduct)s.get(AuctionProduct.class, id);
s.delete(product);
tx.commit();
return true;
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
s.close();
}
return false;
}
// TODO Auto-generated method stub
Transaction tx=null;
Session s=super.getSession();
try {
sql="delete from AuctionBid a where a.auctionProduct.apProdId=?";
Query query=s.createQuery(sql);
query.setInteger(0, id);
query.executeUpdate();
tx=s.beginTransaction();
AuctionProduct product=(AuctionProduct)s.get(AuctionProduct.class, id);
s.delete(product);
tx.commit();
return true;
} catch (HibernateException e) {
// TODO Auto-generated catch block
if(tx!=null){
tx.rollback();
}
e.printStackTrace();
}finally{
s.close();
}
return false;
}