📄 slide061.html

📁 《Big C++ 》Third Edition电子书和代码全集-Part1

💻 HTML

字号:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
	<meta content="blendTrans(Duration=2)" http-equiv="Page-Enter">
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
	<script language="JavaScript" src="./config.js"></script>
	<script language="JavaScript" src="./pageFormat.js"></script>
	<script><!-- // Set title on page
		title()
	//--></script>
</head>


<body>
<div onclick="document.location='slide062.html'">
<h2><font color="#009999">28.5 Case Study: Accessing an Invoice Database
	(cont.)</font></h2>
<font size="+1">

<ul>
	<li>Compute amt due:
		<blockquote><tt>
			string query = "SELECT SUM(Item.Quantity * Product.Unit_Price) "<br>
			&nbsp;&nbsp;&nbsp;"FROM Item, Product WHERE Item.Invoice_Number = '"<br>
			&nbsp;&nbsp;&nbsp;+ invnum + "' AND Item.Product_Code
				= Product.Product_Code";
		</tt></blockquote>
		<p>Yields a single row w/a single field</p>
	</li>
	<li>Extract value, convert:
		<blockquote><tt>
			MYSQL_ROW row = mysql_fetch_row(result);
			double amount_due = string_to_double(row[0]);
		</tt></blockquote>
	</li>
</ul>

</font>

<hr>
<center><small>
	<a href='slide060.html'>prev</a>
	|<a href='slide001.html'>top</a>
	|<a href='slide062.html'>next</a>
</small></center>
</div>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -