📄 bookupdate.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@ page language="java"import="java.sql.*" %><%@page import="java.util.*" %><%@page import="java.text .*" %><%@page import="java.lang .*" %><jsp:useBean id="bookupdate" class="czm.BookBean" scope="page"/><html> <head> <%@ include file="head2.txt" %> </head> <script language="JavaScript" src="student_left.js"></script> <% if(session.getAttribute("admin_ID")==null) { response.sendRedirect("AdminWindow.jsp"); } %> <% request.setCharacterEncoding("GB2312"); String change=request.getParameter("bookupdate"); String bookISBN=request.getParameter("bookISBN"); String bookName=request.getParameter("bookName"); String bookAuthor=request.getParameter("bookAuthor"); String publisher=request.getParameter("publisher"); String price=request.getParameter("price"); String introduce=request.getParameter("introduce"); String book_type=request.getParameter("book_type"); String ppage=request.getParameter("ppage"); String printdate=request.getParameter("printdate"); String infodate=request.getParameter("infodate"); String booknum=request.getParameter("booknum"); String sailnum=request.getParameter("sailnum"); if(change!=null){ String sql=null; int bnum=0; int snum=0; float nprice=0; boolean go=true; try { bnum=Integer.parseInt(booknum); snum=Integer.parseInt(sailnum); nprice=Float.parseFloat(price); }catch(NumberFormatException e) { go=false; %> <script language="javascript"> alert("单价,库存,已销售量必须为数字!"); </script> <% } try{ java.text.DateFormat.getDateInstance().parse(printdate); java.text.DateFormat.getDateInstance().parse(infodate); sql="Update bookInfo set bookName='"+bookName+"',bookAuthor='"+bookAuthor+"',publisher='"+publisher+"',price="+price+",introduce='"+introduce+"',book_type='"+book_type+"',page='"+ppage+"',printdate=#"+printdate+"# where bookISBN='"+bookISBN+"'"; }catch(Exception De){ go=false; %> <script language="javascript"> alert("日期格式不正确!"); </script> <% } int s=0; int ss=0; if(go) s=bookupdate.executeUpdate(sql); if(s>0){ sql="Update Bookstate set infodate=#"+infodate+"#,booknum="+bnum+",sailnum="+sailnum+" where bookISBN='"+bookISBN+"'"; ss=bookupdate.executeUpdate(sql); if(ss>0){%> <script language="javascript"> alert("修改成功!"); </script> <% } else{ %> <script language="javascript"> alert("修改失败1!"); </script> <% } } else{ %> <script language="javascript"> alert("修改失败2!"); </script> <% }} %> <body bgcolor="#C0DFFD"><form action="bookupdate.jsp" method="post"> <% request.setCharacterEncoding("gb2312"); %> <% String ISBN=request.getParameter("ISBN"); String ssql="Select * from bookInfo,Bookstate where bookInfo.bookISBN=Bookstate.bookISBN and bookInfo.bookISBN='"+ISBN+"'"; ResultSet rs=bookupdate.executeQuery(ssql); if(rs.next()){ bookISBN=rs.getString(1); bookName=rs.getString(2); bookAuthor=rs.getString(3); publisher=rs.getString(4); price=rs.getString(5); introduce=rs.getString(6); book_type=rs.getString(7); ppage=rs.getString(8); printdate=rs.getString(9); printdate=printdate.substring(0,10); infodate=rs.getString(11); infodate=infodate.substring(0,10); booknum=rs.getString(12); sailnum=rs.getString(13); } %> <%@ include file="head.txt"%> <td colspan="6" valign="top"><img src="mm_spacer.gif" alt="" width="50" height="1" border="0" > <table align="left"> <tr> <td align="right" width="200">书籍ISBN:</td><td><input type="text" name="bookISBN" value="<%=bookISBN%>" readonly /></td> </tr> <tr> <td align="right" width="200">书 名:</td><td><input type="text" name="bookName" value="<%=bookName%>" /></td> </tr> <tr> <td align="right" width="200">作 者:</td><td><input type="text" name="bookAuthor" value="<%=bookAuthor%>" /></td> </tr> <tr> <td align="right" width="200">出版社:</td><td><input type="text" name="publisher" value="<%=publisher%>" /></td> </tr> <tr> <td align="right" width="200">单 价:</td><td><input type="text" name="price" value="<%=price%>" /></td> </tr> <tr> <td align="right" width="200">简 介:</td><td><textarea name="introduce" rows="4" cols="20"> <%=introduce%> </textarea></td> </tr> <tr> <td align="right" width="200">类 别:</td><td><input type="text" name="book_type" value="<%=book_type%>" /></td> </tr> <tr> <td align="right" width="200">页 数:</td><td><input type="text" name="ppage" value="<%=ppage%>" /></td> </tr> <tr> <td align="right" width="200">出版日期:</td><td><input type="text" name="printdate" value="<%=printdate%>" />(年-月-日)</td> </tr> <tr> <td align="right" width="200">入库日期:</td><td><input type="text" name="infodate" value="<%=infodate%>" />(年-月-日)</td> </tr> <tr> <td align="right" width="200">库存数量:</td><td><input type="text" name="booknum" value="<%=booknum%>" /></td> </tr> <tr> <td align="right" width="200">已销售数量:</td><td><input type="text" name="sailnum" value="<%=sailnum%>" /></td> </tr> <tr > <td align="right" width="200"></td> <td> <input type="submit" value="确定" name="ok" /> <input type="hidden" name="bookupdate" value="change" /> <input type="reset" value="重填" name="reset" onclick="javascript:location.reload()" /> <a href="bookchange.jsp">修改其它书籍信息</a> </td> </tr> </table> </td> <tr> <td width="165"> </td> <td width="50"> </td> <td width="167"> </td> <td width="138"> </td> <td width="50"> </td> <td width="190"> </td> <td width="100%"> </td> </tr></table> </form> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -