Mybatis中如何编写增删改查的SQL语句？

本文共计126个文字，预计阅读时间需要1分钟。

Mybatis中实现增删查改，使用SELECT * FROM Demo WHERE id=...语句。

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