MyBatis的动态SQL语句实现

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 
 select * from user where 1=1
 
  and username like #{username}
 
 
  and address like #{address}
 
 

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 
 select * from user
 
  
  and username like #{username}
  
  
  and address like #{address}
  
 
 

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 
 
 select * from user
 
  
  
   #{uid}
  
  
 
 

<&＃63;xml version="1.0" encoding="UTF-8"&＃63;>


 
 
 
 select * from user
 

 
 
 
 
 
 
 where id = #{uid}