<%@ page contentType="text/html;charset=GB2312" language="java" %>
<%@ page import="java.sql.*"%>
<html>
<head><title>展示商品信息</title></head>
<%
Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.JDBC.SQLServerDriver");
String
strConn="JDBC:sqlserver://LIUZC\SQLEXPRESS:1433;DatabaseName=ShopSystem";
String strUser="sa";
String strPassword="liuzc518";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
Statement stmt=conn.createStatement();
String strSql="SELECT TOP 5 p_id,p_type,p_name,p_price,p_quantity FROM
product order by p_time desc";
ResultSet rs=stmt.executeQuery(strSql);
%>
<center><h2>最新前 5 位商品信息</h2></center>
<table border="1" align="center">
<tr>
<th>产品编号</th>