browbook.jsp

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

<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="inc/conn1.jsp"%>
<link href="css.css" rel="stylesheet" type="text/css">
<%
int bookid=Integer.parseInt(request.getParameter("id"));
sql="select * from tushumingxi where shuid="+bookid;
rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
<style type="text/css">
<!--
.style8 {font-size: 12pt; font-weight: bold; }
-->
</style>
<table width="368" height="533" border="1" cellpadding="0" cellspacing="0" bordercolor="#efefef">
<!--DWLayoutTable-->
<%String bookshu=rs.getString("shu_name");%>
  <tr>
    <td width="364" height="31" align="center" valign="middle" bgcolor="#efefef"><span class="style8">
    <%out.print(bookshu);%></span></td>
  </tr>
  <tr>
    <td height="161" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
        <!--DWLayoutTable-->
        <tr>
          <td width="11" height="4"></td>
          <td width="120"></td>
          <td width="15"></td>
          <td width="217" rowspan="2" valign="middle">图书名称：<%out.print(bookshu);%></td>
        </tr>
        <tr>
          <td height="15"></td>
          <td rowspan="8" valign="top"><img src=<%=rs.getString("fengmian")%> width="120" height="150"></img></td>
          <td></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle" bgcolor="#FBEEE1">作　　者：<%=rs.getString("zhuozhe")%></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle">出 版 社：<%=rs.getString("banshe")%></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle" bgcolor="#FBEEE1">I S B N：<%=rs.getString("ISBN")%></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle">开　　本：<%=rs.getString("kaiben")%></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle" bgcolor="#FBEEE1">页　　数：<%=rs.getString("yeshu")%></td>
        </tr>
        <tr>
          <td height="20"></td>
          <td></td>
          <td valign="middle">定　　价：￥<%=rs.getString("dingjia")%>元</td>
        </tr>
        <tr>
          <td height="15"></td>
          <td></td>
          <td rowspan="2" valign="middle" bgcolor="#FBEEE1">会 员 价：￥<%=rs.getString("huiyuanjia")%>元</td>
        </tr>
        <tr>
          <td height="5"></td>
          <td></td>
          <td></td>
        </tr>
                        </table></td>
  </tr>
  <tr>
    <td height="26" valign="middle" bgcolor="#efefef"><span class="style8">图 书 目 录</span></td>
  </tr>
  <tr>
    <td height="109" valign="top"><textarea name="textarea" cols="50" rows="7"><%=rs.getString("shu_mu")%></textarea></td>
  </tr>
  <tr>
    <td height="30" valign="middle" bgcolor="#efefef"><span class="style8">图 书 简 介</span></td>
  </tr>
  <tr>
    <td height="152" valign="top"><%=rs.getString("shu_jian")%></td>
  </tr>
  <tr>
    <td height="22" align="right" valign="middle"><a href="Javascript:window.close()">关闭本页</a></td>
  </tr>
</table>

<%
}
%>