数据库代码如下:
USE jsp_db;
CREATE TABLE banji (
username varchar(120) NOT NULL,
password varchar(120) DEFAULT NULL,
name varchar(30) DEFAULT NULL,
sex varchar(1) DEFAULT NULL,
age varchar(3) DEFAULT NULL,
banji varchar(30) DEFAULT NULL,
photo varchar(120) DEFAULT NULL,
PRIMARY KEY (username),
UNIQUE KEY name (name)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;