如何通过mybatis实现动态SQL编写？

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

sql查询用户及其角色信息：SELECT u.*, r.id AS rinfo.id, r.name AS rinfo.nameFROM userinfo u, roles rWHERE u.rolesid=r.id;

查询指定ID的用户信息：SELECT * FROM userinfo WHERE id=?

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