ibatis动态SQL标签用法.docx

《ibatis动态SQL标签用法.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、iBatis动态SQL标签用法1、动态SQL片段通过SQL片段达到代码复用                                  selectcount(*)                                   select*                                   fromicp                 

2、amic prepend="where">                                                          namelike'%$name$%'                                                                                   pat

3、hlike'%path$%'                                                                                   area_id=#area_id#                                                    

4、                               hided=#hided#                                                                                                                                        

5、                      limit#_start#,#_size#                                                                                                              

6、="sql_count"/>                                                                               2、数字范围查询所

7、传参数名称是捏造所得，非数据库字段，比如_img_size_ge、_img_size_lt字段                                                         =#_img_size_ge#                         ]]>                         

8、Empty>