public void increasePrice(Product prod, int pct) {
        logger.info("Increasing price by " + pct + "%");
        SqlUpdate su = new SqlUpdate(ds, "update products set price = price * (100 + ?) / 100 where id = ?");
        su.declareParameter(new SqlParameter("increase", Types.INTEGER));
        su.declareParameter(new SqlParameter("ID", Types.INTEGER));
       
        su.compile();
       
        Object[] oa = new Object[2];
        oa[0] = new Integer(pct);
        oa[1] = new Integer(prod.getId());
       
        int count = su.update(oa);
        logger.info("Rows affected: " + count);
    }

    public void increasePrice(Product prod, int pct) {
        logger.info("Increasing price by with Hibernate " + pct + "%");
        prod.setPrice(new Double(prod.getPrice().doubleValue() * (100.0 + pct)/100));
        this.getHibernateTemplate().saveOrUpdate(prod);
    }

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
   <class name="bus.Product" table="products">
      <id name="id" column="id" unsaved-value="0">
         <generator class="increment"/>
      </id>
      <property name="description" column="description"/>
      <property name="price" column="price"/>
   </class>
</hibernate-mapping>