Untitled

0001: <%@ Language="VBScript" %>
0002: <?xml version="1.0" encoding="UTF-8"?>
0003: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
0004:   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
0005:
0006: <html xmlns="http://www.w3.org/1999/xhtml">
0007: <% set conn = server.createobject("ADODB.connection")
0008: conn.open "warehouse", "IWSDStudent", "assign2"
0009: sql = "select * from orderInfo
0010: set rs = conn.execute(sql)%>
0011: <head>
0012: <title>task 6</title>
0013: </head>
0014: <body>
0015:
0016:
0017: <h1 style="text-align:center">Order Info Table</h1>
0018: <table border="1" summary="Orderinfo Details">
0019: <tr>
0020: <th>Order Number</th>
0021: <th>Line item ID</th>
0022: <th>Product Code</th>
0023: <th>Quantity Ordered</th>
0024:
0025: </tr>
0026: <% do while not rs.eof %>
0027: <tr>
0028: <td><%= rs("orderNumber")%></td>
0029: <td><%= rs("lineItemID")%></td>
0030: <td><%= rs("productCode")%></td>
0031: <td><%= rs("quantityOrdered")%></td>
0032:
0033:
0034: </tr>
0035: <% rs.movenext
0036: loop%>
0037: </table>
0038: <% set conn = server.createobject("ADODB.connection")
0039: conn.open "warehouse", "IWSDStudent", "assign2"
0040: sql = "select * from orders"
0041: set rs = conn.execute(sql)%>
0042: <h1 style="text-align:center">Order Table</h1>
0043: <table border="1" summary="Orderinfo Details">
0044: <tr>
0045: <% set conn = server.createobject("ADODB.connection")
0046: conn.open "warehouse", "IWSDStudent", "assign2"
0047: sql = "select * from orders"
0048: set rs = conn.execute(sql)%>
0049: <table border="1" summary="Orders Details">
0050: <tr>
0051: <th>Order Number</th>
0052: <th>Customer ID</th>
0053: <th>Order Date</th>
0054: <th>Shipping date</th>
0055: <th> Shipped </th>
0056: <th> Staff ID </th>
0057:
0058: </tr>
0059: <% do while not rs.eof %>
0060: <tr>
0061: <td><%= rs("orderNumber")%></td>
0062: <td><%= rs("customerID")%></td>
0063: <td><%= rs("orderDate")%></td>
0064: <td><%= rs("shippingDate")%></td>
0065: <td><%= rs("shipped")%></td>
0066: <td><%= rs("staffID")%></td>
0067:
0068: </tr>
0069: <% rs.movenext
0070: loop%>
0071: </table>
0072: <% set conn = server.createobject("ADODB.connection")
0073: conn.open "warehouse", "IWSDStudent", "assign2"
0074: sql = "select * from product"
0075: set rs = conn.execute(sql)%>
0076: <h1 style="text-align:center">Product Table</h1>
0077: <table border="1" summary="Product Details">
0078: <tr>
0079: <th>Prodcut Code</th>
0080: <th>Name</th>
0081: <th>Quantity On hand</th>
0082: <th>Price</th>
0083:
0084:
0085: </tr>
0086: <% do while not rs.eof %>
0087: <tr>
0088: <td><%= rs("productCode")%></td>
0089: <td><%= rs("name")%></td>
0090: <td><%= rs("quantityOnHand")%></td>
0091: <td><%= rs("price")%></td>
0092:
0093: </tr>
0094: <% rs.movenext
0095: loop%>
0096: </table>
0097:
0098: <% set conn = server.createobject("ADODB.connection")
0099: conn.open "warehouse", "IWSDStudent", "assign2"
0100: sql = "select * from staff"
0101: set rs = conn.execute(sql)%>
0102: <h1 style="text-align:center">Staff Table</h1>
0103: <table border="1" summary="Staff Details">
0104: <tr>
0105: <th>Staff ID</th>
0106: <th>Name</th>
0107:
0108:
0109: </tr>
0110: <% do while not rs.eof %>
0111: <tr>
0112: <td><%= rs("staffID")%></td>
0113: <td><%= rs("name")%></td>
0114:
0115: </tr>
0116: <% rs.movenext
0117: loop%>
0118: </table>
0119:
0120: </body>
0121: </html>