userid,loginname,loginpass,username,upower,birthday,sex select from userinfo loginname=#{loginname} and loginpass=#{loginpass} select from userinfo select from userinfo userid=#{userid} update userinfo set loginname=#{loginname},loginpass=#{loginpass},username=#{username}, upower=#{upower},birthday=#{birthday},sex=#{sex} where userid=#{userid} insert into userinfo() values (#{userid},#{loginname},#{loginpass},#{username},#{upower},#{birthday},#{sex}) delete from userinfo where userid=#{userid} select from userinfo and 1=1 and username LIKE '%${username}%' and upower=#{upower}