String hql = "select * from Commodity where commodityName like :commodityname";
            Query q = sessionFactory.getCurrentSession().createSQLQuery(hql).addEntity(Commodity.class);
            q.setParameter("commodityname", "%"+commodityName+"%",Hibernate.STRING);
//            q.setString(0,commodityName);
//            q.executeUpdate();
            List<Commodity> res = q.list();
            System.out.print(res.get(0).getCommodityName());

    @Resource
    private SessionFactory sessionFactory;
 public List<Commodity> getAllCommodity() {

        try {

            return sessionFactory.getCurrentSession().createQuery(

                    "from Commodity order by soldNumbers desc").list();

        } catch (Exception e) {

            System.out.print(e.getMessage());

            return null;

        }

    }