Javaweb注册登录

/*建库*/ drop database mvcdb; create database mvcdb; use mvcdb; /*建表*/ create table tb_user ( id int primary key auto_increment, uname varchar(20) not null, upass varchar(20) not null, usex varchar(2) not null ) default charset=utf8; /*插入数据*/ insert into tb_user values(default,'张三','zs1111','男'); insert into tb_user values(default,'张果老','zgl222','男'); insert into tb_user values(default,'张学友','zxy333','男'); insert into tb_user values(default,'李四','ls4444','男'); insert into tb_user values(default,'嫦娥','ce5555','女'); insert into tb_user values(default,'周慧敏','zhm6666','女'); select * from tb_user; /*登录的sql*/ select * from tb_user where uname='张三' and upass='zs1111' /*根据id删除*/ delete from tb_user where id=1 /*根据id更新*/ update tb_user set uname=? ,upass=?,usex=? where id=? insert into tb_user values(default,'张学友','zxy6666','男');