📄 updatebook.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>
<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>
<br>
<%
		String isbn = new String(request.getParameter("isbn").trim().getBytes("ISO-8859-1"));
		String title = new String(request.getParameter("title").trim().getBytes("ISO-8859-1"));
		String author = new String(request.getParameter("author").trim().getBytes("ISO-8859-1"));
		String publisher = new String(request.getParameter("publisher").trim().getBytes("ISO-8859-1"));
		String publishdate = new String(request.getParameter("publishdate").trim().getBytes("ISO-8859-1"));
		String price = new String(request.getParameter("price").trim().getBytes("ISO-8859-1"));
		String introduce = new String(request.getParameter("introduce").trim().getBytes("ISO-8859-1"));

		DBSQLManager dbsm = new DBSQLManager();
		String sql="UPDATE bookinfo SET TITLE='"+title+"',AUTHOR='"+author+"',PUBLISHER='"+publisher+"',PUBLISH_DATE='"+publishdate+"',PRICE="+Float.parseFloat(price)+" ,INTRODUCE='"+introduce+"' WHERE ISBN='"+isbn+"'";
		dbsm.setSqlStr(sql);
		dbsm.executeUpdate();
		dbsm.close();  
%>
    <a class="title">图书修改成功！</a><br><br>
  <a href="main.jsp">返回管理图书页面</a></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 + -