org.hibernate.hql.ast.QuerySyntaxException: unexpected token:

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: salary near line 1, column 50 [from cn.kgc.entity.Emp where 1=1and job =:joband salary >:salaryand hireDate >:fromand hireDate <:to]
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
	at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
	at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
	at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:286)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:184)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:345)
	at com.sun.proxy.$Proxy4.createQuery(Unknown Source)
	at cn.kgc.dao.EmpDao.findEmps_sql(EmpDao.java:45)
	at cn.kgc.service.EmpService.findAllEmps_sql(EmpService.java:48)
	at EmpTest.testFindEmp_sql(EmpTest.java:44)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
	at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)

上面是报错的信息：百度了半天也没有找到原因，以下是我的业务逻辑代码

//动态sql查询雇员信息
	public List<Emp> findAllEmps_sql(EmpCondition condition){
		Transaction tx=null;
		List<Emp> result=null;
		try {
			tx=HibernateUtil.getCurrentSession().beginTransaction();
			StringBuilder sql=new StringBuilder("from Emp where 1=1");
			if(condition.getJob()!=null && condition.getJob()!=""){
				sql.append("and job =:job");
			}
			if(condition.getSalary()!=null){
				sql.append("and salary >:salary");
			}
			if(condition.getFrom()!=null){
				sql.append("and hireDate >:from");
			}
			if(condition.getTo()!=null){
				sql.append("and hireDate <:to");
			}
			result=new EmpDao().findEmps_sql(sql.toString(), condition);
			tx.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			if(tx!=null){
				tx.rollback();
			}
		}
		return result;
	}

文件配置的没有问题，仔细观察报错信息

可以看出是因为sql语句前后条件拼接在一起，导致无法识别属性的错误发生，修改业务层代码，and前面加一个空格

//动态sql查询雇员信息
	public List<Emp> findAllEmps_sql(EmpCondition condition){
		Transaction tx=null;
		List<Emp> result=null;
		try {
			tx=HibernateUtil.getCurrentSession().beginTransaction();
			StringBuilder sql=new StringBuilder("from Emp where 1=1");
			if(condition.getJob()!=null && condition.getJob()!=""){
				sql.append(" and job =:job");//引号后面and前面加空格
			}
			if(condition.getSalary()!=null){
				sql.append(" and salary >:salary");
			}
			if(condition.getFrom()!=null){
				sql.append(" and hireDate >:from");
			}
			if(condition.getTo()!=null){
				sql.append(" and hireDate <:to");
			}
			result=new EmpDao().findEmps_sql(sql.toString(), condition);
			tx.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			if(tx!=null){
				tx.rollback();
			}
		}
		return result;
	}

 

问题解决，自己记录一下，以后多加注意