我学习网页设计不久 基本只到MVC的设计 但是对于数据库的查询 我基本都是用以下类似代码做法:
<html> <body>
<jsp:useBean class="com.db.DatabaseConnection" id="db" />
<%
String sql = "select bookinfo.isbn,bookname,orderinfo.number,saleprice from bookinfo,orderinfo where bookinfo.isbn=orderinfo.isbn and orderid="+request.getParameter("orderid");
ArrayList orderscontent = db.getSearch(sql);
sql = "select sum(number),sum(saleprice) from orderinfo where orderid="+request.getParameter("orderid");
ArrayList sumcontent = db.getSearch(sql);
%>
<table width="88%" border="0" align="center" cellspacing="0">
<tr align="center" valign="middle" bgcolor="#006699">
<td>
<font color="#FFFFFF">ISBN</font>
</td>
<td>
<font color="#FFFFFF">����</font>
</td>
<td>
<font color="#FFFFFF">��������</font>
</td>
<td>
<font color="#FFFFFF">��</font>
</td>
</tr> <%
Iterator contentdata = orderscontent.iterator();
while (contentdata.hasNext()) {
String[] str = (String[]) contentdata.next();
%>
<tr align="center">
<td height="26"><%=str[0]%></td>
<td height="26"><%=str[1]%></td>
<td height="26"><%=str[2]%></td>
<td height="26"><%=str[3]%></td>
</tr>
<%
}
%>
</table>
<%
contentdata = sumcontent.iterator();
if(contentdata.hasNext()){
String[] str=(String[]) contentdata.next();
%>
<br><br><br>
<center>�ܼƣ�<%=str[0]%>����<%=str[1] %>Ԫ</center>
<%
}
%> </body>
问问那位大侠 可以不在网页中出现有数据库查询的代码 上面的代码该怎么改?
<html> <body>
<jsp:useBean class="com.db.DatabaseConnection" id="db" />
<%
String sql = "select bookinfo.isbn,bookname,orderinfo.number,saleprice from bookinfo,orderinfo where bookinfo.isbn=orderinfo.isbn and orderid="+request.getParameter("orderid");
ArrayList orderscontent = db.getSearch(sql);
sql = "select sum(number),sum(saleprice) from orderinfo where orderid="+request.getParameter("orderid");
ArrayList sumcontent = db.getSearch(sql);
%>
<table width="88%" border="0" align="center" cellspacing="0">
<tr align="center" valign="middle" bgcolor="#006699">
<td>
<font color="#FFFFFF">ISBN</font>
</td>
<td>
<font color="#FFFFFF">����</font>
</td>
<td>
<font color="#FFFFFF">��������</font>
</td>
<td>
<font color="#FFFFFF">��</font>
</td>
</tr> <%
Iterator contentdata = orderscontent.iterator();
while (contentdata.hasNext()) {
String[] str = (String[]) contentdata.next();
%>
<tr align="center">
<td height="26"><%=str[0]%></td>
<td height="26"><%=str[1]%></td>
<td height="26"><%=str[2]%></td>
<td height="26"><%=str[3]%></td>
</tr>
<%
}
%>
</table>
<%
contentdata = sumcontent.iterator();
if(contentdata.hasNext()){
String[] str=(String[]) contentdata.next();
%>
<br><br><br>
<center>�ܼƣ�<%=str[0]%>����<%=str[1] %>Ԫ</center>
<%
}
%> </body>
问问那位大侠 可以不在网页中出现有数据库查询的代码 上面的代码该怎么改?
ArrayList orderscontent = db.getSearch(sql);
sql = "select sum(number),sum(saleprice) from orderinfo where orderid="+request.getParameter("orderid");
ArrayList sumcontent = db.getSearch(sql);request.setAttribute("sumcontent",sumcontent);
request.setAttribute("orderscontent",orderscontent );
上面这些放到servlet里,servlet跳转到你显示内容页面,
List list =(List)request.getAttribute("sumcontent")取值循环