bookupdate.jsp

来自「自己写的基于JSP+servlet+Javabean的bookshop源代码」· JSP 代码 · 共 30 行

JSP
30
字号
<%@ page contentType="text/html; charset=gb2312" %>
<%@ include file="../common.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="../incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center"><br>
<%
		String id = new String(request.getParameter("id").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 bookconcern = new String(request.getParameter("bookconcern").trim().getBytes("ISO-8859-1"));
		String publish_date = new String(request.getParameter("publish_date").trim().getBytes("ISO-8859-1"));
		String price = new String(request.getParameter("price").trim().getBytes("ISO-8859-1"));
		String amount = new String(request.getParameter("amount").trim().getBytes("ISO-8859-1"));
		String remark = new String(request.getParameter("remark").trim().getBytes("ISO-8859-1"));

		DBSQLManager dbsm = new DBSQLManager();
		String sql="UPDATE bookinfo SET title='"+title+"',author='"+author+"',bookconcern='"+bookconcern+"',publish_date='"+publish_date+"',price="+Float.parseFloat(price)+" ,amount="+Integer.parseInt(amount)+" ,remark='"+remark+"' WHERE id='"+id+"'";
		dbsm.setSqlStr(sql);
		dbsm.executeUpdate();
		dbsm.close();  
%>
    <a class="title">图书修改成功!</a><br><br>
  <a href="main.jsp">返回管理图书页面</a></div>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?