sql.txt

一个简单的JSP学会管理系统

********建库hua**********
IF EXISTS (SELECT * 
	   FROM   master..sysdatabases 
	   WHERE  name = 'tengfei')
	DROP DATABASE tengfei
GO

CREATE DATABASE tengfei
GO


create database tengfei
   on
      (name='tengfei_data',
       filename='d:\tengfei.mdf',
       size=5MB,
       maxsize=100MB,
       filegrowth=10%)

   log on
       (name='tengfei_log1',
        filename='d:\tengfei_log1.ldf',
        size=5MB,
        maxsize=20MB,
        filegrowth=20%),

       (name='tengfei_log2',
        filename='d:\tengfei_log2.ldf',
        size=5MB,
        maxsize=20MB,
        filegrowth=20%)
    go


************CJ表***********
USE  tengfei
CREATE TABLE CJ
(学号 char(12) NOT NULL PRIMARY KEY,
 姓名 char(12) NULL,
 高等数学成绩 int NULL ,
 英语成绩 int  NULL, 
 法律成绩     int   NULL,
 
)
GO
USE  tengfei
INSERT INTO CJ

  VALUES('200501','吴腾飞',90,70,96)
INSERT INTO CJ

  VALUES('200502','陈应名',69,76,60)
INSERT INTO CJ

  VALUES('200503','陈名',75,32,69)
INSERT INTO CJ

  VALUES('200504','程程',69,56,96)
INSERT INTO CJ

  VALUES('200505','郭伟',85,89,86)
INSERT INTO CJ

  VALUES('200506','王丽霞',91,92,93)
INSERT INTO CJ

  VALUES('200507','郭德玲',12,13,16)
INSERT INTO CJ

  VALUES('200508','罗毕霞',96,97,98)
INSERT INTO CJ

  VALUES('200509','陈凯',73,76,99)
INSERT INTO CJ

  VALUES('200510','胡伶俐',69,66,66)
GO