create.sql

ESQL包 PostgreSQL jsp servlet javaBean 数据库访问 存取数据

drop table member;

create table member
(
	member_no		char(10),
	password		char(20),
	gender			char(1)		default '男',
	name			varchar(40),
	address			varchar(255),
	phone_number	varchar(20),
	
	check (gender in ('男','女')),
	primary key(member_no)
);