note.txt

本系统采用jsp编写,数据库采用的是MYSQL,使用JDBC驱动

create database note;
use note
CREATE TABLE admin (
  admin_name char(20) NOT NULL,
  admin_password char(20) NOT NULL,
  PRIMARY KEY(admin_name)
) TYPE=MyISAM;

create table guest(id int NOT NULL auto_increment,
			username char(20) NOT NULL,
			sex char(2) NOT NUll,
			email char(20),
			QQ char(9),
			url char(24),
			title text NOT NULL,
			content text NOT NULL,
			time datetime NOT NULL,
			images text,
			primary key(id)
			)
TYPE=MyISAM;

CREATE TABLE reply (
  replyid int(11) NOT NULL,
  content text,
  time datetime
) TYPE=MyISAM;
insert into admin(admin_name,admin_password) values('admin','admin');