1.查询所有 select
select * from user
2.增加 insert
insert into user (userName,userPwd) values (#{userName},#{userPwd})
mybatis 插入乱码
jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8
http://blog.csdn.net/zht666/article/details/8955952
注意提交sesssion.commit();
3.修改 update
update user set userName=#{userName},userPwd=#{userPwd} where id=#{id}
4.删除 delete
delete from user where id=#{id}