HibernateSQL命令

大于>：cr.add(Restrictions.gt(propertyName,value));

 

大于等于>=：cr.add(Restrictions.ge(propertyName,value));

 

小于<：cr.add(Restrictions.lt(propertyName,value));

 

小于等于<=：cr.add(Restrictions.le(propertyName,value));

 

不等于!=：cr.add(Restrictions.ne(propertyName,value));

 

匹配查询：cr.add(Restrictions.and(Restrictions.eq(propertyName, value),Restrictions.eq(propertyName, value)));

 

以value为结尾的模糊查询：cr.add(Restrictions.like(propertyName,value,MatchMode.END));

 

字符中任意位置为low的模糊查询：cr.add(Restrictions.like("ename", low,MatchMode.ANYWHERE));

 

字符中任意位置为low(且忽略大小写)的模糊查询：cr.add(Restrictions.ilike("ename", low,MatchMode.ANYWHERE));

 

查询lo到hi区间：cr.add(Restrictions.between(propertyName,lo, hi));

 

 

protected void doPost(HttpServletRequest req, HttpServletResponse resp)

            throws ServletException,IOException {

        // TODO Auto-generated method stub

        String low =req.getParameter("lowsal");

        String high =req.getParameter("highsal");

     

        Session session =HibernateSessionFactory.getSession();

 

        Criteria cr = session.createCriteria(Empmike.class);

        /*查询区间:

          cr.add(Restrictions.between("sal",Double.parseDouble(low),

                Double.parseDouble(high)));*/

       

        /*匹配查询：

        cr.add(Restrictions.and(Restrictions.eq("ename",low), Restrictions.eq(

                "sal", Double.parseDouble(high))));*/

       

//      以low为开头的模糊查询：cr.add(Restrictions.like("ename", low,MatchMode.START));

        /*以low为结尾的模糊查询：忽略大小写.ilike(propertyName, value)

        cr.add(Restrictions.like("ename",low,MatchMode.END));

        cr.add(Restrictions.like(propertyName,value));*/

       

        cr.add(Restrictions.gt("sal", Double.parseDouble(low)));

       

       

        List<Empmike> list= cr.list();

 

        Iterator ite = list.iterator();

        while (ite.hasNext()) {

            Empmike emp = (Empmike) ite.next();

            System.out.println(emp.getEname() + " " + emp.getEmpno() + " "

                    + emp.getSal());

        }

 

    }