String?sql="select?top?10?isbn,title,author,publish,PublishData,price?from?book?order?by?PublishData?desc";
?ResultSet?rs=dbConnect.select(sql);
?try{
?while(rs.next()){
?
??%>
??<tr?class="style1"align="left">
?????<td><%=rs.getString("isbn")?%></td>
?????<td><a?href="bookContent.jsp?isbn=<%=rs.getString("isbn")?%>"target="blank"><%=rs.getString("title")?%></a></td>
??????<td><%=rs.getString("author")?%></td>
???????<td><%=rs.getString("publish")?%></td>
????????<td><%=rs.getString("PublishDate")?%></td>
????????<td?align="center"><%=rs.getFloat("price")?%></td>
????????<td><div?align="center"><a?href="bookOrder.jsp?isbn=<%=rs.getObject(1)%>"><img?src="images/sy_img/1.jpg"width="45"height="16"border="0"></a></div></td>
</tr>
<%}
dbConnect.close();}catch?(SQLException?e)?{
????????????????e.printStackTrace();}
%>public?ResultSet?select(String?sql)?{
try?{
stmt?=?conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs?=?stmt.executeQuery(sql);
}?catch?(Exception?e)?{
e.printStackTrace();
}
return?rs;
}
執行下面這條語句，什么也顯示不出來
qq_馬踏紫陌_0
2016-02-25 11:31:16
