ibatis 动态查询条件 ibatis的调试相对困难,出错的时候主要依据是log4生成的log文件和出错提示,这方面要能比较熟练的看懂
下面这个配置基本上包含了最复杂的功能:分页\搜索\排序\缓存\传值 Hash表\返回 hash表\动态sql 如果对下面这段配置能信手粘来的话,那开发速度将会大大的提升
SELECT $TopNum$ * FROM (select a
[iXinxiID],a
[sXinxiTitle],a
[iXinxiClassId],b
[sClassName], a
[dXinxiDate],a
[dXinxiYxq],a
[iXinxiHits],a
[sXinxiUser],a
[sRedirectUrl], ROW_NUMBER() OVER( a
iXinxiID desc a
iXinxiID asc a
iXinxiHits desc a
iXinxiHits asc ) as row FROM [dbo]
[XinxiTable] as a,[dbo]
[XinxiClass] as b a
[iXinxiState]= $XinxiType$ a
[iXinxiClassID]= $XinxiClass$ a
[sXinxiTitle] LIKE '%$Keyword$%' (a
[sXinxiTitle] LIKE '%$Keyword$%' or a
[sXinxiContent] LIKE '%$Keyword$%') and a
iXinxiClassId=b
iClassId )a
