MyBatis中SQL语句问题

在使用MyBatis的项目中,SQL语句如下就无法正常发布到Tomcat7.0

 <select id="queryEntrustUnit" resultType="String">
  select distinct entrustUnit from baseTable where (not entrustUnit is null) and entrustUnit<>'' Order by entrustUnit
 </select>


在下面的位置就卡住不动了:

信息: No Spring WebApplicationInitializer types detected on classpath
九月 16, 2015 1:30:31 下午 org.apache.catalina.core.ApplicationContext log
信息: Initializing Spring root WebApplicationContext
[INFO ] Root WebApplicationContext: initialization started
  [INFO ] Refreshing Root WebApplicationContext: startup date [Wed Sep 16 13:30:31 CST 2015]; root of context hierarchy
  [INFO ] Loading XML bean definitions from class path resource [applicationContext.xml]
  [INFO ] JSR-250 'javax.annotation.ManagedBean' found and supported for component scanning
  [INFO ] Loading XML bean definitions from class path resource [spring-cxf.xml]
  [INFO ] Loading XML bean definitions from class path resource [META-INF/cxf/cxf.xml]
  [INFO ] Loading XML bean definitions from class path resource [META-INF/cxf/cxf-servlet.xml]
  [INFO ] Loading properties file from class path resource [sqlServer.properties]
  [INFO ] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@386f2f22: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,actAccountDataRight,actAccountEmployeeCompany,actAccountModuleRight,actAccountTable,actAppLogin,actAppRegister,actAuthItemSet,actAuthItemSubScoreSet,actAuthItemSubSet,actBackAuthCarList,actCarTable,actCarInfoNet,actChargeItem,actCheckitemCoordinate,actCompanyRegister,actCompanyRegisterApply,actCompanyTable,actEmployee,actEncode,actFeeRecorder,actGradeSet,actKilometreScoreSet,actLevelSet,actMapSet,actMapZoneItemSet,actMapZoneSet,actPCLogin,actPicDataTable,actQueryByAccountID,actQueryByCompanyName,actReceptionDataCarTable,actReportCheck,actRoleModuleRight,actRoleTable,actStarLevelSet,actSystemModule,actUploadCarInfoNet,srvAppRegisterManage,appSrvAccount,appSrvApplyTid,appSrvAuthItemSet,appSrvAuthItemSubSet,appSrvAuthParentItemSet,appSrvAuthPicSet,appSrvBaseTable,appSrvCarTable,appSrvLogin,appSrvMapZoneItemSet,appSrvTobeAuthCarList,appSrvUploadData,appSrvUploadEnd,appSrvUploadPicture,netCarDetail,srvAccountDataRight,srvAccountEmployee,srvAccountEmployeeCompany,srvAccountModuleRight,srvAccountTable,srvAppLogin,srvAppRegister,srvAuthItemSet,srvAuthItemSubScoreSet,srvAuthItemSubSet,srvAuthPicSet,srvBackAuthCarList,srvBaseCar,srvBaseTable,srvBodyDataTable,srvCarInfoNet,srvCarTable,srvChargeItem,srvCheckitemCoordinate,srvCheckitemCoordinateSet,srvCompanyRegister,srvComoanyRegisterApply,srvCompanyTable,srvDataTable,srvElectricDataTable,srvEmployee,srvEncode,srvFeeChargeItem,srvFeeRecorder,srvFrameDataTable,srvGradeSet,srvKilometreScoreSet,srvLevelSet,srvMapSet,srvMapZoneItemSet,srvMapZoneSet,srvOtherDataTable,srvPCLogin,srvPicDataTable,srvPowerDataTable,srvQueryByAccountID,srvQueryByCompanyName,srvQueryCarInfo,srvReceptionData,srvReceptionDataCarTable,srvRoleModuleRight,srvRoleTable,srvStarLevelSet,srvSuspensionDataTable,srvSystemModule,srvTobeAuthCarList,srv_page,act_test,srv_test,org.springframework.aop.config.internalAutoProxyCreator,propertyConfigurer,dataSource,transactionManager,sqlSessionFactory,org.mybatis.spring.mapper.MapperScannerConfigurer#0,cxf,org.apache.cxf.bus.spring.BusWiringBeanFactoryPostProcessor,org.apache.cxf.bus.spring.Jsr250BeanPostProcessor,org.apache.cxf.bus.spring.BusExtensionPostProcessor,mobileServiceImpl,org.springframework.context.annotation.ConfigurationClassPostProcessor$ImportAwareBeanPostProcessor#0,IAppRegisterManage,IAppSrvAccount,IAppSrvApplyTid,IAppSrvAuthItemSet,IAppSrvAuthItemSubSet,IAppSrvAuthParentItemSet,IAppSrvAuthPicSet,IAppSrvBaseTable,IAppSrvCarTable,IAppSrvLogin,IAppSrvMapZoneItemSet,IAppSrvTobeAuthCarList,IAppSrvUploadData,IAppSrvUploadEnd,IAppSrvUploadPicture,daoAccount,daoAccountDataRight,daoAccountEmployee,daoAccountEmployeeCompany,daoAccountModuleRight,daoAppLogin,daoAppRegister,daoAuthItemSet,daoAuthItemSubScoreSet,daoAuthItemSubSet,daoAuthParentItemSet,daoAuthPicSet,daoBackAuthCarList,daoBaseCar,daoBaseTable,daoBodyDataTable,daoCarInfoNet,daoCarTable,daoCarTableCache,daoChargeItem,daoCheckitemCoordinate,daoCompanyRegisterApply,daoCompanyTable,daoDataTable,daoElectricDataTable,daoEmployee,daoEncode,daoFeeChargeItem,daoFeeRecorder,daoFrameDataTable,daoGradeSet,daoKilometreScoreSet,daoLevelSet,daoMapSet,daoMapZoneItemSet,daoMapZoneSet,daoOtherDataTable,daoPCLogin,daoPicDataTable,daoPowerDataTable,daoQueryByAccountID,daoQueryByCompanyName,daoReceptionData,daoReceptionDataCarTable,IDaoReportCheck,daoRoleModuleRight,daoRoleTable,daoStarLevelSet,daoSuspensionDataTable,daoSystemModule,daoTobeAuthCarList,ISrvAccountDataRight,ISrvAccountEmployee,ISrvAccountEmployeeCompany,ISrvAccountModuleRight,ISrvAccountTable,ISrvAppLogin,ISrvAppRegister,ISrvAuthItemSet,ISrvAuthItemSubScoreSet,ISrvAuthItemSubSet,ISrvAuthPicSet,ISrvBackAuthCarList,ISrvBaseCar,ISrvBaseTable,ISrvBodyDataTable,ISrvCarInfoNet,ISrvCarTable,ISrvChargeItem,ISrvCheckitemCoordinate,ISrvCompanyRegister,ISrvCompanyRegisterApply,ISrvCompanyTable,ISrvDataTable,ISrvElectricDataTable,ISrvEmployee,ISrvEncode,ISrvFeeChargeItem,ISrvFeeRecorder,ISrvFrameDataTable,ISrvGradeSet,ISrvKilometreScoreSet,ISrvLevelSet,ISrvMapSet,ISrvMapZoneItemSet,ISrvMapZoneSet,ISrvOtherDataTable,ISrvPCLogin,ISrvPicDataTable,ISrvPowerDataTable,ISrvQueryByAccountID,ISrvQueryByCompanyName,ISrvQueryCarInfo,ISrvReceptionData,ISrvReceptionDataCarTable,ISrvRoleModuleRight,ISrvRoleTable,ISrvStarLevelSet,ISrvSuspensionDataTable,ISrvSystemModule,ISrvTobeAuthCarList,dao_page,dao_test,IMobileService]; root of factory hierarchy
  [INFO ] Loaded JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
 

把SQL修改成如下就没有问题了:

 <select id="queryEntrustUnit" resultType="String">
  select distinct entrustUnit from baseTable Order by entrustUnit
 </select>


终于知道原因了,<>要使用转义字符


MyBatis SQL xml处理小于号与大于号

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值