📄 sd.htm
字号:
<HTML><HEAD><TITLE>JSP中使用数据库</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<style type="text/css">
<!--
.style12 {font-size: 14px}
.style20 {
color: #FF0000;
font-size: 18px;
font-weight: bold;
}
.style27 {font-size: 14px; color: #990000; }
.style28 {color: #990000}
-->
</style>
</HEAD>
<BODY>
<TABLE height=335 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<tr>
<th height="1" colspan="3" align="center" background="images/yh_szzn1_blank.gif" scope="col"></th>
</tr>
<TR>
<TD width="26%" height="333" vAlign=top >
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="90%" height="1" align="center" background="images/yh_szzn1_blank.gif" scope="col"></th>
</tr>
<tr>
<th align="left" >
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<th height="35" colspan="2" scope="row"><TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR align=middle>
<TD height=25 align="center" bgColor=#ebe1d6 class=ab><span class="style20">网上购书</span> </TD>
</TR>
<TR>
<TD background=images/top_bgline.gif height=12></TD>
</TR></TBODY></TABLE></th>
</tr>
<tr >
<th width="371" height="35" scope="row"> <table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#EDFBFE">
<tr align="left">
<th width="10" height="45" scope="row"> </th>
<th height="45" colspan="3" scope="row">一、数据库info--数据表product，<br>
其结构如下：</th>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style12">字段名称</span></th>
<td><span class="style12">数据类型</span></td>
<td><span class="style12">说明</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style27">ID</span></th>
<td><span class="style27">自动编号</span></td>
<td><span class="style27">产品编号</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_name</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style27">产品名称</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">s_price</span></th>
<td><span class="style27">int</span></td>
<td><span class="style28">市场价</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_price</span></th>
<td><span class="style28">int</span></td>
<td><span class="style28">会员价</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_note</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style27">产品说明</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_tu</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style27">产品图片</span></td>
</tr>
</table></th>
<td width="372" align="right" valign="top"><table width="98%" border="0" cellpadding="0" cellspacing="0" bgcolor="#EDFBFE">
<tr align="left">
<th width="10" height="45" scope="row"> </th>
<th height="45" colspan="3" scope="row">二、数据库info--数据表orderuser，<br>
其结构如下：</th>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style12">字段名称</span></th>
<td><span class="style12">数据类型</span></td>
<td><span class="style12">说明</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style27">ID</span></th>
<td><span class="style27">自动编号</span></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">username</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style27">会员名字</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">password</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style28">密码</span></td>
</tr>
</table></td>
</tr>
<tr>
<th height="1" colspan="2" background="images/yh_szzn1_blank.gif" scope="col"></th>
</tr>
</table></th>
</tr>
</table><table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<th width="50%" scope="col"><table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#EDFBFE">
<tr align="left">
<th width="10" height="45" scope="row"> </th>
<th height="45" colspan="3" scope="row">三、数据库info--数据表order_item，<br>
其结构如下：</th>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style12">字段名称</span></th>
<td><span class="style12">数据类型</span></td>
<td><span class="style12">说明</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style27">ID</span></th>
<td><span class="style27">自动编号</span></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_id</span></th>
<td><span class="style28">int</span></td>
<td><span class="style27">产品编号</span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">product_num</span></th>
<td><span class="style28">int</span></td>
<td><span class="style28">产品数量<span class="style27"></span></span></td>
</tr>
<tr>
<th scope="row"> </th>
<th height="25" scope="row"><span class="style28">username</span></th>
<td><span class="style27">文本</span></td>
<td><span class="style27">会员名字</span></td>
</tr>
</table></th>
<th width="50%" scope="col"> </th>
</tr>
</table>
</TD>
</TR></TBODY></TABLE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -