book_show.jsp

用JSP实现的 满好的 大家支持哦 大家多多支持

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB2312"%>


<%
    String book_Loginmessage=(String)session.getValue("book_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(book_Loginmessage!="OK")
    {
	response.sendRedirect("../index.html");
    }
%>
<jsp:useBean class="manage_sys.manage_sys" id="admin_book_show" scope="page"></jsp:useBean>
<%
    String ID=new String(request.getParameter("ID").getBytes("8859_1"));
    String sql="select * from my_book where ID='"+ID+"'";
    ResultSet rs=admin_book_show.executeQuery(sql);
	//定义数据类型并初始化
	String BookName="";    //图书名
	String Author="";        //作者
	String Publish="";     //出版社
	String BookNo="";        //图书编号
	String Content="";     //图书内容
	String Price="";        //书价
	String Amount="";   //图书数量
	String RegTime="";        //出版日期
	
	if(rs.next())
	{
	    BookName=rs.getString("BookName");
		Author=rs.getString("Author");
		Publish=rs.getString("Publish");
		BookNo=rs.getString("BookNo");
		Content=rs.getString("Content");
		Price=rs.getString("Price");
		Amount=rs.getString("Amount");
		RegTime=rs.getString("RegTime");
		
		rs.close();
        admin_book_show.closeStmt();
        admin_book_show.closeConn();
	}
%>
<%@include file="book_head.jsp"%>
  <table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr> 
      <td bgcolor="#000099"> 
        <table width="778" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td height="30"> 
            <div align="center"><font color="#FFFFFF" size="5">图书详细信息</font></div></td>
          </tr>
        </table>
        <table width="778" border="0" cellspacing="1" cellpadding="0" height="120">
          <tr> 
            <td height="179" bgcolor="#FFFFFF"> 
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td height="5">&nbsp;</td>
                </tr>
              </table>
              <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" height="151">
                <tr> 
                  <td bgcolor="#999999"> 
                    <table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
                      <tr> 
                        <td colspan="2" bgcolor="#d9d8dc">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td width="25%" height="25" align="center" bgcolor="#d9d8dc"><font color="#000099"> 图书名</font></td>
                        <td width="75%" bgcolor="#FFFFFF"><font color="#000099"><%=BookName%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">作者</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=Author%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">出版社</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=Publish%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">图书编号</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=BookNo%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099"> 书价</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=Price%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">馆藏数量</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=Amount%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">出版时间</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=RegTime%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><font color="#000099">内容简介</font></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=Content%></font> </td>
                      </tr>
                      <tr> 
                        <td bgcolor="#d9d8dc" align="center">&nbsp;</td>
                        <td width="75%" bgcolor="#FFFFFF">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="#d9d8dc">&nbsp;</td>
                        <td bgcolor="#d9d8dc">&nbsp;</td>
                      </tr>
                      <tr align="center"> 
                        <td bgcolor="#d9d8dc" colspan="2">[ <a href="/"onclick=javascript:window.close();retun false">关闭窗口</a> ]</td>

                      </tr>
                    </table>
                  </td>
                </tr>
              </table>
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>&nbsp;</td>
                </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
</table>
<%@include file="book_tail.jsp"%>