addbook.jsp

来自「一个用JSP编写的在线图书购物网,很方便很方便很方便」· JSP 代码 · 共 21 行

<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="connDbBean" scope="page" class="bookshop.conn"/>
<%
  request.setCharacterEncoding("GBK");
  String name = request.getParameter("bookname");
  int time=Integer.parseInt(request.getParameter("time"));
        String author=request.getParameter("author");	 
	int price=Integer.parseInt(request.getParameter("price"));
	String press=request.getParameter("press");
  if(name != null && name.length() >0&& String.valueOf(time)!=null && author!=null&&author.length()>0 && String.valueOf(price)!=null&&press!=null&&press.length()>0 ) {
	 ResultSet tmpRs = connDbBean.executeQuery("select max(id) As maxid from name");
    tmpRs.next();
    int max_id = tmpRs.getInt("maxid") + 1;
    tmpRs.close();
    String sql = "insert into bookshop values ('"+max_id+"','"+name+"','"+time+"','"+author+"','"+press+"','"+price+"')";  
	 
	 connDbBean.executeUpdate(sql);
  }
%>
<jsp:forward page="admin.jsp"/>