mybatis的动态sql实现

 


 

 

  
	
   
    
    
    
    
    
     
     
    
  

	
  
	
  
    u.*,r.id as "rinfo.id",r.name as "rinfo.name" 
  
	
  
	
  
	
  
	
  
	
   select  from userinfo u,roles r where u.rolesid=r.id 
	
	
   select * from userinfo where id=#{id} 
	
	
  
	
   select * from userinfo where name=#{a} and pwd=#{pwd} 
	
	
  
	
  
	
   
   
     select seq2.nextval from dual 
    insert into userinfo values(#{id},#{name},#{pwd},#{rolesid}) 
  
	
	
	
   select * from userinfo 
	
	
  
    update userinfo
    
    
      name=#{name}, 
     
    
      pwd=#{pwd}, 
     
    
      roleid=#{roleid}, 
     
    where id=0