JSF分页实现，内含建表语句

create database student; use student; create table admin ( id nchar(20) not null primary key, name nchar(20) not null , pass nchar(20) not null ); desc admin; create table student( id nchar(20) not null primary key, name nchar(20) not null, gender set('male','female') not null, age int not null, birthDate date not null, introduction nchar(255) ); insert into admin (id,name,pass) values ('1000','admin','admin'); select * from admin; update admin set name='root',pass='root' where name='admin'; insert into student (id,name,gender,age,birthDate, introduction) values ('2010001','陈新杰','male','20','1988-01-02',"No introduction"); insert into student (id,name,gender,age,birthDate, introduction) values ('2010002','陈新文','male','21','1988-01-02',"No introduction"); insert into student (id,name,gender,age,birthDate, introduction) values ('2010003','陈新涛','male','15','1988-01-02',"No introduction"); insert into student (id,name,gender,age,birthDate, introduction) values ('2010004','陈小妹','female','21','1988-01-02',"No introduction"); insert into student (id,name,gender,age,birthDate, introduction) values ('2010005','陈小霞','female','21','1988-01-02',"No introduction"); select * from student; alter table student add birthDate date; alter table student modify birthDate date not null;