ibatis动态sql条件查询中如何写入静态的条件？（急）

Question

这样写不行吗？select * from stock
where
stocktype="1"
<dynamic  prepend="and">  
            <isNotEmpty  prepend=""  property="fromcolorno">  
....
楼主一定太累了，晕了！哈哈good luck

Answer 1

略微改一下select * from stock 
where 
stocktype='1' 
<dynamic>  
    <isNotEmpty  prepend="and"  property="fromcolorno">
....

Answer 2

我觉得是:
select  *  from  stock  
  where stocktype="1"
            <isNotEmpty  prepend=""  property="fromcolorno">  
  <isNotEmpty  prepend="and"  property="tocolorno">  
            (    colorno  between  #fromcolorno#  and  #tocolorno#)  
  </isNotEmpty>  
  </isNotEmpty>  
          <isNotEmpty  prepend="and"  property="fromlotno">  
  <isNotEmpty  prepend=""  property="tolotno">  
            (colorno  between  #fromlotno#  and  #tolotno#)  
  </isNotEmpty>  
  </isNotEmpty>  不知道lz的代码能运行吗?