有关XML的问题_教程

上面有错误的地方很多我就不一一指出来了，还有就是你问题中第一部分程序和最后一部分是一模一样的。下面是我修改后的内容（我已经用IE打开验证过了，已经没有语法错误）：

<?xml version="1.0" encoding="gb2312" ?>

<BOOK>

<book>

<chapter>XML入门简介

<para>什么是HTML</para>信卖

<para>什么是XML</para>

</chapter>

</book>

<book>

<chapter>XML语法

<para>XML元素必须有结束标记</para>

<para>XML元素必须正确的嵌套</para>

</chapter>

</book>

</BOOK>

test2.dtd

<!ELEMENT spml (spnm*)>

<!ELEMENT spnm ANY>

<!ELEMENT spmc (#PCDATA)>余坦简

<!ELEMENT sptm (#PCDATA)>

<!ELEMENT jldw (#PCDATA)>

<!ELEMENT dj (#PCDATA)>

<?xml version="1.0" encoding="gb2312"?>

<!DOCTYPE spml SYSTEM "test2.dtd">

<spml>

<spnm>

05011402

<spmc>数码相机竖裤</spmc>

<jldw/>

</spnm>

<spnm>

05011432

<jldw/>

</spnm>

</spml>

安装好数据库，以DBA用户搭启登入返虚SQL*PLUS或PL/SQL的命令窗口，直接粘贴下面语句。

-- Create the user

create user mytest

identified by mytest

default tablespace USERS

temporary tablespace TEMP

profile DEFAULT

-- Grant/Revoke role privileges

grant connect to mytest

grant resource to mytest

conn mytest/mytest@orcl

create table COU

(

cno CHAR(10) not null,

cname CHAR(20),

ccredit INTEGER,

semster INTEGER

)

alter table COU

add primary key (CNO)

create table STU

(

sno CHAR(7) not null,

sname CHAR(10),

ssex CHAR(2),

sage INTEGER,

sdept CHAR(20)

)

alter table STU

add primary key (SNO)

create table SC

(

sno CHAR(7) not null,

cno CHAR(10) not null,

grade INTEGER,

xklb CHAR(4)

)

alter table SC add primary key (SNO, CNO)

alter table SC add foreign key (SNO) references STU (SNO)

alter table SC add foreign key (CNO) references COU (CNO)

create table T_GHSML

(

dwbm CHAR(6) not null,

dwmc VARCHAR2(24),

lxr VARCHAR2(8),

lxdh VARCHAR2(14),

kkbl NUMBER(2)

)

alter table T_GHSML add primary key (DWBM)

grant insert on T_GHSML to SCOTT

create table T_KCMX

(

spbm CHAR(7) not null,

ghdw CHAR(6) not null,

rkdh VARCHAR2(8) not null,

hsjg NUMBER(10,4),

kcsl NUMBER(6),

xssl NUMBER(6)

)

create table T_SPML

(

spbm CHAR(7) not null,

spmc VARCHAR2(20),

spgg VARCHAR2(15),

spcd VARCHAR2(10),

ghdw CHAR(6) not null,

xsjg NUMBER(8,2) not null

)

grant select, index on T_SPML to PUBLIC

alter table COU disable all triggers

alter table STU disable all triggers

alter table SC disable all triggers

alter table T_GHSML disable all triggers

alter table T_KCMX disable all triggers

alter table T_SPML disable all triggers

insert into COU (cno, cname, ccredit, semster)

values ('C01 ', '计算机文化基础 ', 3, 1)

insert into COU (cno, cname, ccredit, semster)

values ('C02 ', '知世如VB ', 2, 3)

insert into COU (cno, cname, ccredit, semster)

values ('C03 ', '计算机网络 ', 4, 7)

insert into COU (cno, cname, ccredit, semster)

values ('C04 ', '数据库基础 ', 6, 6)

insert into COU (cno, cname, ccredit, semster)

values ('C05 ', '高等数学', 8, 2)

insert into COU (cno, cname, ccredit, semster)

values ('C06 ', '数据结构', 5, 4)

commit

insert into STU (sno, sname, ssex, sage, sdept)

values ('9512101', '李勇 ', '男', 19, '计算机系')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9512102', '刘晨 ', '男', 20, '计算机系')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9512103', '王敏 ', '女', 20, '计算机系')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9521101', '张立 ', '男', 22, '信息系 ')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9521102', '吴宾 ', '女', 21, '信息系 ')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9521103', '张海 ', '男', 20, '信息系 ')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9531101', '钱小平', '女', 18, '数学系 ')

insert into STU (sno, sname, ssex, sage, sdept)

values ('9531102', '王大力', '男', 19, '数学系 ')

commit