建表语句1.txt

java程序五子棋源代码。 java程序五子棋源代码。

--用户资料表
Create table User_info(
		Userid     varchar(20)   primary key,
		nickname   varchar(30)   not null,
		password   varchar(20)   not null,
		picture	   varchar(4)   default('00'),
		sex	   varchar(1),
		usertype   varchar(2),
		age 	   integer,
		status     varchar(2) default('2'),
		gamemoney  varchar(20) default('0'),
		phonenum   varchar(20),
    		regdate    date   default(sysdate),
		logoutdate date,
		logoutreason varchar(2)
);

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('102','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('103','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('104','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('105','各个感','aaa','01','1',30,1,'10000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('106','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('107','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('108','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('109','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('110','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('111','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('112','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('113','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('114','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('115','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('116','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('117','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('118','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('119','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('120','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('121','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('122','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('123','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('124','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('125','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('126','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('127','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('128','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('129','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('130','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('131','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('132','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('133','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('134','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('135','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('136','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('137','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('138','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('139','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('140','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('141','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('142','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('143','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('144','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('145','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('146','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('147','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('148','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('149','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('150','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('151','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('152','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('153','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('154','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('155','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('156','各个感','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('157','达到','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('158','达到的的','aaa','01','1',30,1,'10000','1451581111');
insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('159','方法法','aaa','01','1',19,1,'1000','1451581111');

insert into user_info(userid,nickname,password,picture,sex,usertype,age,gamemoney,phonenum) values('160','各个感','aaa','01','1',30,1,'10000','1451581111');


--用户状态表
Create table User_status(
		Userid     varchar(20)   primary key,
		status     varchar(2) default('00'),
		phonenum   varchar(20),
		gametype   varchar(3),
		queuenum  number,
		ctrlmsg   varchar(20),
		logindate  date		
);


--用户id的序列
Create sequence useridseq increment by 1 start with 10000;