//使用sql进行查询

    public  static void queryEmployee(){

        session=getSession();

        try{

             transaction=session.beginTransaction();

             String sql="select first_name,salary from Employee where first_name='lin'";

             NativeQuery query=session.createNativeQuery(sql);

             List<Object[]> workers=query.getResultList();

             for(Object[] worker:workers) {

                 String firstName=(String) worker[0];

                 int salary=(int)worker[1];

                 System.out.println("first_name:"+firstName+"  salary:"+salary);

             }

        }catch (Exception e) {

            if(transaction!=null) {

                transaction.rollback();

            }

            e.printStackTrace();

        }finally {

            session.close();

        }

    }