My Opera is closing 1st of March

QUANG HOANG'S BLOG

Welcome to everybody !

Subscribe to RSS feed

Giải bài tập Member + Role

,

Download XML.rar

Cán bạn download file XML.rar về giải nén ra xem. Bên trong có 3 file film hướng dẫn sử dụng XML Spy.





Bai 1

1. Cach tao file XSD dung XML Spy

- Ta thay the Member va Role nam trong Members, bay gio ta se tao 2 the nay truoc.
- Trong the Member, co 3 the: FirtName, LastName, NickName va 2 thuoc tinh ID va IDREF.
- Thiet lap kieu du lieu cho FirstName, LastName, NickName
- Tuong tu cho the Roles
- Bay gio ta se tao cac thuoc tinh cho the Member va the Role.
- Tiep theo ta se khai bao cac khoa chinh va khoa ngoai cho Member va Role.
(chu y khi khai bao khoa phai chon vao the LIST)

Bay gio ta da tao xong file XSD.


2. Sau khi da tao duoc file XSD, bay gio ta se test thu xem file XSD tao nhu tren da dung chua ?
- Sau khi da nhap du lieu xong, ta chon vao dau check (mau vang) tren thanh cong cu de check Well-Formed, chon vao dau check mau xanh de kiem tra rang buoc du lieu.

<List xmlns:xsi="htttp://www.w3.org/2001/XMLSchema_instance"xsi:noNamesspaceSchemaLocation="cau1.xsd"
<Members>
<Member ID="11" IDREF="1">
<Fisrtname>Le thi kim</Fisrtname>
<Lastname>THUY</Lastname>
<Nickname>cho con</Nickname>
</Member>
<Member ID="22" IDREF="2">
<Fisrtname>ngyen van</Fisrtname>
<Lastname>B</Lastname>
<Nickname>co</Nickname>
</Member>
<Member ID="33" IDREF="3">
<Fisrtname>huynh</Fisrtname>
<Lastname>dang khoa</Lastname>
<Nickname>cun</Nickname>
</Member>
<Roles>
<Role ID="1">Admin</Role>
<Role ID="2">Modorator</Role>
<Role ID="3">User</Role>
</Roles>
</Members>
</List>



------------------------------------------------------------------
FILE Member_Role.xsd
------------------------------------------------------------------


<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="LIST">
<xs:annotation>
<xs:documentation>Comment describing your root element</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="Members">
<xs:complexType>
<xs:sequence>
<xs:element name="Member" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="FirstName" type="xs:string"/>
<xs:element name="LastName" type="xs:string"/>
<xs:element name="NickName" type="xs:string"/>
</xs:sequence>
<xs:attribute name="ID" type="xs:int" use="required"/>
<xs:attribute name="IDREF" type="xs:int" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="Roles">
<xs:complexType>
<xs:sequence>
<xs:element name="Role" maxOccurs="unbounded">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="ID" type="xs:int" use="required"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
<xs:key name="pk_Member">
<xs:selector xpath="Members/Member"/>
<xs:field xpath="@ID"/>
</xs:key>
<xs:key name="pk_Role">
<xs:selector xpath="Members/Roles/Role"/>
<xs:field xpath="@ID"/>
</xs:key>
<xs:keyref name="fk_Member_Role" refer="pk_Role">
<xs:selector xpath="Members/Member"/>
<xs:field xpath="@IDREF"/>
</xs:keyref>
</xs:element>
</xs:schema>



----------------------------------------------------------------------
FILE Test_Member_Role.xml
----------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<LIST xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="C:\Documents and Settings\Hoang Dang Quang\Desktop\XML\Member_Role.xsd">
<Members>
<Member ID="1" IDREF="1">
<FirstName>Quang</FirstName>
<LastName>Hoang</LastName>
<NickName>hodawa</NickName>
</Member>
<Member ID="2" IDREF="2">
<FirstName>Kim</FirstName>
<LastName>Le Thi</LastName>
<NickName>chocon</NickName>
</Member>
<Roles>
<Role ID="1">Admin</Role>
<Role ID="2">Moderator</Role>
<Role ID="3">User</Role>
</Roles>
</Members>
</LIST>
February 2014
S M T W T F S
January 2014March 2014
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28