servlet学生信息管理系统demo

mysql语句 创建数据库 create database studentmanager DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; 创建表 create table s ( sno char(10) primary key, sn varchar(20), ss varchar(10), sa int(10), sd varchar(20) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table user ( UserID varchar(10) primary key, UserName varchar(20), UserPasswd varchar(20), UserLevel varchar(10) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table student ( StuID varchar(10) primary key, StuName varchar(20), StuPasswd varchar(20), StuSex varchar(10), StuClass varchar(20) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table c ( cno varchar(10) primary key, cn varchar(30), pcno varchar(10) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table sc ( sno char(10), cno varchar(10), g int, primary key(sno,cno) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table unpw ( un varchar(20) primary key, pw varchar(20), qx int )ENGINE=InnoDB DEFAULT CHARSET=utf8; insert unpw values('admin','admin',0); insert s values('1310122660','黎明','男',24,'软件学院'); insert s values('1310122661','刘阳','男',23,'软件学院'); insert s values('1310122662','邓紫棋','女',24,'通信工程学院'); insert user values('1','jby','jby','1'); insert user values('13','zj','zj','1'); insert user values('2','test2','test2','2'); insert user values('3','test3','test3','2'); insert user values('4','test4','test4','2'); insert user values('5','test5','test5','2'); insert user values('6','test6','test6','2'); insert user values('7','test7','test7','2'); insert user values('8','test8','test8','2'); insert user values('9','test9','test9','2'); insert user values('10','test10','test10','2'); insert user values('11','test11','test11','2'); insert user values('12','test12','test12','2'); insert student values('1310122001','zjl','zjl','男','1310122'); insert student values('1310122002','Test2','Test2','男','1310122'); insert student values('1310122003','Test3','Test3','女','1310122'); insert student values('1310122004','Test4','Test4','男','1310122'); insert student values('1310122005','Test5','Test5','女','1310122'); insert student values('1310122006','Test6','Test6','男','1310122'); insert student values('1310123001','Test7','Test7','男','1310123'); insert student values('1310123002','Test8','Test8','女','1310123'); insert student values('1310123003','Test9','Test9','男','1310123'); insert student values('1310123004','Test10','Test10','女','1310123'); insert student values('1310123005','Test11','Test11','男','1310123'); create table client ( cliID varchar(10) primary key, name varchar(20), address varchar(20) )ENGINE=InnoDB DEFAULT CHARSET=utf8; create table pb ( pid varchar(10), bid varchar(20), primary key(pid,pid) )ENGINE=InnoDB DEFAULT CHARSET=utf8;