📄 main.jsp

📁 sql server 2005书中11到16章的全部代码

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="../incoming/common.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="../incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center">
<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
    <tr> 
      <td height="87" align="center"><br>
      <img src="../images/bookhead.jpg" width="700" height="110"> </td>
    </tr>
</table>
<p>
  <a class="title"> 管理图书</a> 
</p>
  <p><a href="addbook.jsp">添加图书</a> <a href="../index.jsp">主页</a></p>
  <%
		DBSQLManager dbsm = new DBSQLManager();
		String sql="SELECT * FROM bookinfo ";
		dbsm.setSqlStr(sql);
		dbsm.executeQuery();
		ResultSet rs=dbsm.getRs();
%>  
  <table width="700" border="1" cellpadding="0" cellspacing="0">
        <tr>
          <td width="96" height="30"><div align="center">ISBN</div></td>
          <td width="235"><div align="center">书名</div></td>
          <td width="137"><div align="center">作者</div></td>
          <td width="121"><div align="center">出版社</div></td>
          <td colspan="2"><div align="center"></div>            
            <div align="center">操作</div></td>
        </tr>
<%     while(rs.next()) 
		{
%>
        <tr>
          <td height="30"><div align="center"><%=rs.getString("ISBN")%></div></td>
          <td><div align="center"><%=rs.getString("TITLE")%></div></td>
          <td><div align="center"><%=rs.getString("AUTHOR")%></div></td>
          <td><div align="center"><%=rs.getString("PUBLISHER")%></div></td>
          <td width="43"><div align="center"><a href="modifybook.jsp?isbn=<%=rs.getString("ISBN")%>">修改</a></div></td>
          <td width="54"><div align="center"><a href="delbook.jsp?isbn=<%=rs.getString("ISBN")%>">删除</a></div></td>
        </tr>
<%}%>
      </table>
    <br>
</div>
<hr width="700">
<table width="700" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td align="center">峰杰工作技术中心<br>
        CopyRight@2006<br>
      Email:<a href="mailto:zfno1@163.com">zfno1@163.com</a></td>
    </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -