关于用JSP显示数据库中商品详细信息的有关问题，求各位高人指点，不胜感激
日期：2014-05-18 浏览次数：20733 次
关于用JSP显示数据库中商品详细信息的问题，急求各位高人指点，不胜感激
我做了个商品浏览页面，第一个页面列表显示数据库里面商品列表信息，然后在每条的缩略图上设置链接到另一个页面，显示该商品的详细信息。连数据库的时候不知道应该怎么办，显示商品详细信息的页面只出了个空表格，没有数据库里的东西。我的代码如下，希望各位指点一下：
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " "http://www.w3.org/TR/html4/loose.dtd ">
<jsp:useBean id= "databean " scope= "session " class= "com.conndb "/>
<jsp:useBean id= "list " class= "com.WaresList " scope= "session " />
<jsp:useBean id= "pagebean " scope= "session " class= "com.pagebean "/>
<html>
<head>
<title> 商品详细信息 </title>
<style type= "text/css ">
</style>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 "> </head>
<script language= "javascript ">
</script>
<body>
<div align= "center " class= "b9b "> 商品详细信息
<p>
<form action= "shopcart.jsp " method= "post " name= "form1 ">
<%
databean.getConnection();
ResultSet rs;
String sql= "SELECT * FROM wares ";
rs=databean.executeQuery(sql); //执行sql语句，使用了javabean conndb中的executeQuery
%>
<input type=hidden name= "id " value= " <%=list.WaresId%> " >
<table width= "300 " border= "1 " cellspacing= "1 " cellpadding= "1 " bordercolordark= "#6699ff " bordercolorlight= "#FFFFFF ">
<tr>
<th colspan= "2 " scope= "col "> <img src= "image/BigImg/ <%= list.BigImg %> "> </th>
</tr>
<tr>
<th width= "65 " scope= "row "> 商品名称 </th>
<th width= "222 " scope= "row "> <%=list.Name %> </th>
</tr>
<tr>
<th scope= "row "> 所属种类 </th>
<th scope= "row "> <%=list.Sort%> </th>
</tr>
<tr>
<th scope= "row "> 市场价 </th>
<th scope= "row "> <%if(list.MarketPrice!=0) {
我做了个商品浏览页面，第一个页面列表显示数据库里面商品列表信息，然后在每条的缩略图上设置链接到另一个页面，显示该商品的详细信息。连数据库的时候不知道应该怎么办，显示商品详细信息的页面只出了个空表格，没有数据库里的东西。我的代码如下，希望各位指点一下：
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " "http://www.w3.org/TR/html4/loose.dtd ">
<jsp:useBean id= "databean " scope= "session " class= "com.conndb "/>
<jsp:useBean id= "list " class= "com.WaresList " scope= "session " />
<jsp:useBean id= "pagebean " scope= "session " class= "com.pagebean "/>
<html>
<head>
<title> 商品详细信息 </title>
<style type= "text/css ">
</style>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 "> </head>
<script language= "javascript ">
</script>
<body>
<div align= "center " class= "b9b "> 商品详细信息
<p>
<form action= "shopcart.jsp " method= "post " name= "form1 ">
<%
databean.getConnection();
ResultSet rs;
String sql= "SELECT * FROM wares ";
rs=databean.executeQuery(sql); //执行sql语句，使用了javabean conndb中的executeQuery
%>
<input type=hidden name= "id " value= " <%=list.WaresId%> " >
<table width= "300 " border= "1 " cellspacing= "1 " cellpadding= "1 " bordercolordark= "#6699ff " bordercolorlight= "#FFFFFF ">
<tr>
<th colspan= "2 " scope= "col "> <img src= "image/BigImg/ <%= list.BigImg %> "> </th>
</tr>
<tr>
<th width= "65 " scope= "row "> 商品名称 </th>
<th width= "222 " scope= "row "> <%=list.Name %> </th>
</tr>
<tr>
<th scope= "row "> 所属种类 </th>
<th scope= "row "> <%=list.Sort%> </th>
</tr>
<tr>
<th scope= "row "> 市场价 </th>
<th scope= "row "> <%if(list.MarketPrice!=0) {
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
