SSM框架中的Mapper.xml文件中的增、删、改、查等操作
文章目录
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}
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论