help.htm

本图书管理系统具有查询

<p class="MsoNormal"><a name="_Toc14004171"><span lang="EN-US">&nbsp;</span></a></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size: 14.0pt">&nbsp;</span><span style="font-size: 14.0pt; font-family: 宋体">创建数据库</span></b></p>
<p class="MsoNormal" style="text-indent: 28.0pt; line-height: 150%">
<span style="font-size: 14.0pt; line-height: 150%; font-family: 楷体_GB2312">参照<span lang="EN-US">VF自带的数据库，可以很方便地创建了本系统将要使用的本地数据库。</span></span></p>
<p class="MsoNormal" style="text-indent: 13.7pt">
<span style="font-size: 14.0pt; font-family: 楷体_GB2312; color: black">表说明如下：</span></p>
<p class="MsoNormal"><b>
<span style="font-size: 14.0pt; font-family: 宋体; color: navy">　　</span></b><span lang="EN-US" style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">Book_recno.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
借书登记表<br>
　　Book_table.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 图书资料表</span></p>
<p class="MsoNormal">
<span style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">　　<span lang="EN-US">B_table.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
读者类别查询中间表&nbsp;&nbsp;&nbsp; </span></span></p>
<p class="MsoNormal">
<span lang="EN-US" style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">
　Group_table.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 图书类别查询中间表</span></p>
<p class="MsoNormal">
<span style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">　　<span lang="EN-US">Pass_word.dbf　　　　 
管理员ID密码表</span></span></p>
<p class="MsoNormal">
<span style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">　　<span lang="EN-US">User_table.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
读者资料表</span></span></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size: 14.0pt; font-family: 宋体; color: navy">&nbsp;</span></b></p>
<p class="MsoNormal"><b>
<span style="font-size: 14.0pt; font-family: 宋体; color: navy">表结构介绍：</span></b></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size: 14.0pt; font-family: 宋体; color: navy">&nbsp;</span></b><span lang="EN-US" style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">Book_recno.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
借书登记表</span></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border: medium none">
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm; background: #CCFFFF">
    <p class="MsoNormal"><b>
    <span style="font-size: 12.0pt; font-family: 宋体; color: navy">字段名称</span></b></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm; background: #CCFFFF">
    <p class="MsoNormal"><b>
    <span style="font-size: 12.0pt; font-family: 宋体; color: navy">字段类型</span></b></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: 1.0pt solid windowtext; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm; background: #CCFFFF">
    <p class="MsoNormal"><b>
    <span style="font-size: 12.0pt; font-family: 宋体; color: navy">字段说明</span></b></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    TSBH</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(10)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">图书编号</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    TXM</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(10)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">条形码</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    SM</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(20)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">书名</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    BH</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(10)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">编号</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    XM</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(10)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">姓名</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    JSBZ</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    C(4)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">借书标志</span></td>
  </tr>
  <tr>
    <td width="189" valign="top" style="width: 142.0pt; border-left: 1.0pt solid windowtext; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    JSSJ</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span lang="EN-US" style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">
    D(8)</span></td>
    <td width="189" valign="top" style="width: 142.05pt; border-left: medium none; border-right: 1.0pt solid windowtext; border-top: medium none; border-bottom: 1.0pt solid windowtext; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; padding-bottom: 0cm">
    <p class="MsoNormal">
    <span style="font-size: 12.0pt; font-family: 楷体_GB2312; color: black">借书日期</span></td>
  </tr>
</table>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size: 14.0pt; font-family: 宋体; color: navy">&nbsp;</span></b></p>
<p class="MsoNormal"><b>
<span lang="EN-US" style="font-size: 14.0pt; font-family: 宋体; color: navy">&nbsp;</span></b></p>
<p class="MsoNormal">
<span lang="EN-US" style="font-size: 14.0pt; font-family: 楷体_GB2312; color: navy">
Book_table.dbf&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 图书资料表</span></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse; border: medium none">
  <tr>
    <td wid