📄 booknew.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="utf-8"%><%@ page language="java"import="java.sql.*" %><%@page import="java.util.*" %><%@page import="java.text .*" %><%@page import="java.lang .*" %><jsp:useBean id="newbook" 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("utf-8"); String bookISBN=request.getParameter("bookISBN"); if(bookISBN!=null&&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"); 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="Insert into bookInfo values('"+bookISBN+"','"+bookName+"','"+bookAuthor+"','"+publisher+"',"+nprice+",'"+introduce+"','"+book_type+"','"+ppage+"',#"+printdate+"#)"; }catch(Exception De){ go=false; %> <script language="javascript"> alert("日期格式不正确!"); </script> <% } int s=0; int ss=0; if(go) s=newbook.executeUpdate(sql); if(s>0){ sql="Insert into Bookstate values('"+bookISBN+"',#"+infodate+"#,"+bnum+","+snum+")"; ss=newbook.executeUpdate(sql); if(ss>0){%> <script language="javascript"> alert("增加成功!"); </script> <% } else{ %> <script language="javascript"> alert("增加失败!"); </script> <% } } else{ %> <script language="javascript"> alert("增加失败!"); </script> <% }} %> <body bgcolor="#C0DFFD"><form action="booknew.jsp" method="post"> <% request.setCharacterEncoding("gb2312"); %> <%@ 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="" />(不能为空!)</td> </tr> <tr> <td align="right" width="200">书 名:</td><td><input type="text" name="bookName" value="" /></td> </tr> <tr> <td align="right" width="200">作 者:</td><td><input type="text" name="bookAuthor" value="" /></td> </tr> <tr> <td align="right" width="200">出版社:</td><td><input type="text" name="publisher" value="" /></td> </tr> <tr> <td align="right" width="200">单 价:</td><td><input type="text" name="price" value="" /></td> </tr> <tr> <td align="right" width="200">简 介:</td><td><textarea name="introduce" rows="4" cols="20"> </textarea></td> </tr> <tr> <td align="right" width="200">类 别:</td><td><input type="text" name="book_type" value="" /></td> </tr> <tr> <td align="right" width="200">页 数:</td><td><input type="text" name="ppage" value="" /></td> </tr> <tr> <td align="right" width="200">出版日期:</td><td><input type="text" name="printdate" value="" />(年-月-日)</td> </tr> <tr> <td align="right" width="200">入库日期:</td><td><input type="text" name="infodate" value="" />(年-月-日)</td> </tr> <tr> <td align="right" width="200">库存数量:</td><td><input type="text" name="booknum" value="" /></td> </tr> <tr> <td align="right" width="200">已销售数量:</td><td><input type="text" name="sailnum" value="0" /></td> </tr> <tr > <td align="right" width="200"></td> <td> <input type="submit" value="确定" name="ok" /> <input type="reset" value="重填" name="reset" onclick="javascript:location.reload()" /> <a href="Adminguanli.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 + -