Mybatis增删改查语法

 


 


   select * from Demo where id=#{id} 


  
    update Demo set name=#{0},pwd=#{1},age=#{2} where id=#{3} 
  


  
    delete Demo where id=#{id} 
  


   
   
     select seq1.nextval from dual 
    insert into Demo(id,name,pwd,age,roleid) values(#{id},#{name},#{pwd},#{age},#{roleid}) 
  


   select * from Demo where name=#{name} 


   select * from Demo