infolist.jsp

JSP图书管理系统 包括会员管理 图书管理 借阅管理 等等 是非常好的图书管理软件

  <script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
  <%
  int bookid=Integer.parseInt(request.getParameter("id"));
   sql="select * from tushumingxi where shuid="+bookid;
rs=stmt.executeQuery(sql);
while(rs.next()){
%><%
int shu_id=rs.getInt("shuID");%>
<style type="text/css">
<!--
.style1 {
	font-family: "幼圆";
	font-size: medium;
}
-->
</style>


<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr>
    <td width="960" height="199" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
        <!--DWLayoutTable-->
        <tr>
          <td height="35" colspan="5" valign="middle" bgcolor="#efefef">	
	        <span class="style1">
	    <% String bkname=rs.getString("shu_name");
	out.print(bkname);%>
          </span></td>
      </tr>
        <tr>
          <td width="135" rowspan="8" align="center" valign="bottom"><img src=<%=rs.getString("fengmian")%> width=80 height=120></img>
          <br>          <a href=# onClick="MM_openBrWindow('browpic.jsp?pid=<%=shu_id%>','','width=500,height=600')">查看放大图</a></td>
    <td height="18" colspan="4" valign="middle">图书名称：
      <%out.print(bkname);%></td>
    </tr>
        <tr>
          <td height="18" colspan="4" valign="middle" bgcolor="#FBEEE1">作者：<%=rs.getString("zhuozhe")%></td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle">出 版 社：<%=rs.getString("banshe")%></td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle" bgcolor="#FBEEE1"> ISBN：<%=rs.getString("ISBN")%></td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle">开本：<%=rs.getString("kaiben")%></td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle" bgcolor="#FBEEE1">页数：<%=rs.getString("yeshu")%></td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle">定 　价：￥<%=rs.getString("dingjia")%>元</td>
      </tr>
        <tr>
          <td height="18" colspan="4" valign="middle" bgcolor="#FBEEE1"><span class="style2">会员价：￥<%=rs.getString("huiyuanjia")%>元</span></td>
      </tr>
        <tr valign="middle" bgcolor="#efefef">
          <td height="26" colspan="2" valign="top"><span class="style1">图书目录</span></td>
  <td colspan="3" align="right"><a href="javascript:MM_openBrWindow('basket.jsp?id=<%=shu_id%>','','scrollbars=yes,width=480,height=350')"><img src="image/buy_ico.gif" width="60" height="26" border="0"></a></td>
        </tr>
        <tr>
          <td height="0"></td>
          <td></td>
          <td width="9"></td>
          <td width="60"></td>
          <td width="162"></td>
        </tr>
        <tr>
          <td height="1"></td>
          <td width="148"></td>
          <td></td>
          <td></td>
          <td></td>
        </tr>
            </table></td>
  </tr>
</table>
<table align="center">
 <tr>
 <td width="103" height="276">&nbsp;</td>
   <td colspan="3" valign="top"><textarea name="textarea" cols="50" rows="20"><%=rs.getString("shu_mu")%></textarea></td>
  </tr>
</table>

<% }
%>