dealupdateorder.jsp

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

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%@ include file="checkadmin.jsp"%>
<center>
<%
	String orderid="0";
	String orderstate="";
	String bookid="";
	if(request.getParameter("orderid")!=null)
		orderid=request.getParameter("orderid");
	String sql="select * from orderinfo where orderid='"+orderid+"'";
	ResultSet rs=conn.executeQuery(sql);
	if(rs.next())
	{
		orderstate=rs.getString("orderstate");
		bookid=rs.getString("bookid");
	}
	rs.close();
	if(orderstate.equals("未交货"))
		orderstate="已交货";
	else
		orderstate="未交货";
	sql="update orderinfo set orderstate='"+orderstate+"' where orderid='"+orderid+"'";
	conn.executeUpdate(sql);
	conn.close();
	int len=0;
	for(int i=0;i<bookid.length();i++)
	{
		if(bookid.charAt(i)==',')
			len++;
	}
	String[] bid=new String[len];
	for(int i=0;i<bid.length;i++)
		bid[i]="";
	int j=0;
	for(int i=0;i<bookid.length();i++)
	{
		if(bookid.charAt(i)!=',')
			bid[j]+=bookid.substring(i,i+1);
		else
			j++;
	}
	if(orderstate.equals("已交货"))
	{
		for(int i=0;i<bid.length;i++)
		{
			sql="update book set salenum=salenum+1 where bookid="+bid[i];
			conn.executeUpdate(sql);
		}
	}
	else
	{
		for(int i=0;i<bid.length;i++)
		{
			sql="update book set salenum=salenum-1 where bookid="+bid[i];
			conn.executeUpdate(sql);
		}
	}
	conn.close();
	response.sendRedirect("listorder.jsp");
%>