(1)createUser!input.jsp
用户名 | (*) |
---|---|
密码 | (*) |
重输密码 | (*) |
(2)
createUserAction.jsp
select * from tb_user where username=?
insert into tb_user(username,password) values(?,?)
(3)
editUser!input.jsp
select * from tb_user where id = ?
用户名 | (*必填) |
---|---|
旧密码 | (*必填) |
新密码 | (*必填) |
重输新密码 | (*两次密码必须相同) |
(4)
editUserAction.jsp
select password from tb_user where id = ?
select * from tb_user where id <> ? and username = ? ?? <> 不等于
update tb_user set username = ?,password = ? where id = ?
(5)
deleteUserAction.jsp
delete from tb_user where id = ?