员工表 .xml

SQL的应用

<?xml version="1.0" standalone="yes"?>  <DATAPACKET Version="2.0"><METADATA><FIELDS><FIELD attrname="UserIndex" fieldtype="string" SUBTYPE="FixedChar" WIDTH="4"/><FIELD attrname="UserName" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="UserPwd" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="Power" fieldtype="i4"/><FIELD attrname="Interpret" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="Name" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="Age" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="Dep" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="Email" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/><FIELD attrname="QQ" fieldtype="string" SUBTYPE="FixedChar" WIDTH="10"/></FIELDS><PARAMS/></METADATA><ROWDATA><ROW UserIndex="1   " UserName="endo      " UserPwd="endo      " Power="1" Interpret="man       "/><ROW UserIndex="2   " UserName="admin     " UserPwd="admin     " Power="1" Interpret="man       "/><ROW UserIndex="3   " UserName="a         " UserPwd="a         " Power="2" Interpret="boss      "/><ROW UserIndex="4   " UserName="b         " UserPwd="b         " Power="2" Interpret="boss      "/><ROW UserIndex="5   " UserName="c         " UserPwd="c         " Power="3" Interpret="user      "/><ROW UserIndex="6   " UserName="d         " UserPwd="d         " Power="3" Interpret="user      "/><ROW UserIndex="7   " UserName="燕国      " UserPwd="燕国      " Power="2"/><ROW UserIndex="8   " UserName="e         " UserPwd="e         " Power="1" Interpret="Guest     "/><ROW UserIndex="9   " UserName="a         " UserPwd="a         " Power="4" Interpret="普通用户  " Name="a         " Age="45        " Dep="sdf       " Email="asd@.     " QQ="3245345   "/><ROW UserIndex="10  " UserName="asdf      " UserPwd="a         " Power="4" Interpret="普通用户  " Name="sdf       " Age="4         " Dep="asdf      " Email="4@.       " QQ="345       "/><ROW UserIndex="11  " UserName="aa        " UserPwd="aaaaa     " Power="4" Interpret="普通用户  " Name="sdf       " Age="4         " Dep="sdf       " Email="asdfsd@.  " QQ="344       "/><ROW UserIndex="12  " UserName="dfghfgh   " UserPwd="yyyy      " Power="4" Interpret="普通用户  " Name="yyyy      " Age="45        " Dep="y4        " Email="rurtuy@.. " QQ="45        "/><ROW UserIndex="13  " UserName="tt        " UserPwd="tttt      " Power="4" Interpret="普通用户  " Name="yyyy      " Age="45        " Dep="y4        " Email="rurtuy@.. " QQ="45        "/><ROW UserIndex="14  " UserName="wwww      " UserPwd="wwww      " Power="4" Interpret="普通用户  " Name="www       " Age="343       " Dep="www       " Email="@.        " QQ="23        "/><ROW UserIndex="15  " UserName="ee        " UserPwd="eeee      " Power="4" Interpret="普通用户  " Name="ee        " Age="3         " Dep="eeee      " Email="          " QQ="          "/><ROW UserIndex="16  " UserName="er        " UserPwd="333333    " Power="4" Interpret="普通用户  " Name="          " Age="          " Dep="          " Email="          " QQ="          "/><ROW UserIndex="17  " UserName="1         " UserPwd="111111    " Power="4" Interpret="普通用户  " Name="xxx       " Age="          " Dep="xxx       " Email="[e-mail]   " QQ="231       "/></ROWDATA></DATAPACKET>