dealupdatebook.jsp

此为一个网上购书系统的JSP代码,包括填加图书,定单等功能.

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="checkadmin.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	String bookname="";
	String author="不详";
	String pubdate="";
	String pubhouse="不详";
	String isbn="不详";
	String type="";
	String cover="抱歉，暂时无该书封面图片！";
	String profile="不详";
	String price="0";
	String updateid="0";
	ResultSet rs=null;
	request.setCharacterEncoding("gb2312");
	if(request.getParameter("updateid")!=null)
		updateid=request.getParameter("updateid");
	if(request.getParameter("bookname")!=null)
		bookname=request.getParameter("bookname");
	if(request.getParameter("author")!=null&&!request.getParameter("author").equals(""))
		author=request.getParameter("author");
	if(request.getParameter("pubdate")!=null)
		pubdate=request.getParameter("pubdate");
	if(request.getParameter("pubhouse")!=null&&!request.getParameter("pubhouse").equals(""))
		pubhouse=request.getParameter("pubhouse");
	if(request.getParameter("isbn")!=null&&!request.getParameter("isbn").equals(""))
		isbn=request.getParameter("isbn");
	if(request.getParameter("type")!=null)
		type=request.getParameter("type");
	if(request.getParameter("cover")!=null&&!request.getParameter("cover").equals(""))
		cover=request.getParameter("cover");
	if(request.getParameter("profile")!=null&&!request.getParameter("profile").equals(""))
		profile=request.getParameter("profile");
	if(request.getParameter("price")!=null&&!request.getParameter("price").equals(""))
		price=request.getParameter("price");
	String sql="update book set bookname='"+bookname+"',author='"+author+"',pubdate=#"+pubdate+"#,pubhouse='"+pubhouse+"',isbn='"+isbn+"',type='"+type+"',cover='"+cover+"',profile='"+profile+"',price="+price+" where bookid="+updateid;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("list.jsp");
%>