purchase.java

来自「JSP的电子商务系统（源代码) 基于JSP的网上拍卖系统的分析与设计」· Java 代码 · 共 637 行 · 第 1/2 页

				return false;
			}
		}

		purchaselist = (Vector)session.getAttribute("shopcar");
		if (purchaselist==null || purchaselist.size()<0)
		{
			//System.out.println("标记4");
			return false;
		}
		String Content = request.getParameter("content");
		if (Content==null)
		{
			Content="";
		}
		Content = getGbk(Content);
		String IP = request.getRemoteAddr();
		String TotalPrice = request.getParameter("totalprice");
		indentlist iList;
		int intendId = 0;
		try
		{
			rs =  stmt.executeQuery("select max(id) from My_indent");
			if(rs.next())
			{
				intendId = rs.getInt(1)+1;
				IndentNo = "ORDER" + userid + "" + Integer.toString(intendId);
			}
			else
			{
				intendId = 0;
				IndentNo =  "ORDER" + userid + "0";
			}
		}catch(SQLException e)
		{
		}
		rs.close();
        int ispayoff = 1;
        int issales = 1;
        String str1 = new Date().toLocaleString();
        String str2 = new Date().toLocaleString()+"+7";
        System.out.println(intendId);
        System.out.println(userid);
        System.out.println(str1);
        System.out.println(str2);
        System.out.println(TotalPrice);
        System.out.println(Content);
        System.out.println(IP);
        System.out.println(ispayoff);
        System.out.println(issales);
        
        sqlStr = "insert into My_indent values('"+intendId+"','"+IndentNo+"','"+userid+"','"+str1+"','"+str2+"','"+TotalPrice+"','"+Content+"','"+IP+"','"+ispayoff+"','"+issales+"')";
		try
		{			
			stmt.execute(sqlStr);
			sqlStr= "select max(id) from My_indent where UserId = " + userid;
			//System.out.println("标记5");
			rs = stmt.executeQuery(sqlStr);
			long indentid = 0;
			while (rs.next())
			{
				indentid = rs.getLong(1);
			}
			rs.close();
			int intentListId = 0;
			for (int i=0; i<purchaselist.size() ;i++ )
			{
				iList = (indentlist) purchaselist.elementAt(i);
				try
				{
					//System.out.println("标记6");
					rs =  stmt.executeQuery("select max(id) from My_indentList");
					if(rs.next())
					{
						intentListId = rs.getInt(1)+1;
						iList.setId(intentListId);
					}
					else
					{
						intendId = 0;
						iList.setId(intentListId);
					}
				}catch(SQLException e)
				{
				}
				iList.setIndentNo(intendId);
			/*	System.out.println(iList.getId());
				System.out.println(iList.getIndentNo());
				System.out.println(iList.getBookNo());
				System.out.println(iList.getAmount());*/
				sqlStr = "insert into My_indentlist values('"+iList.getId()+"','"+iList.getIndentNo()+"','"+iList.getBookNo()+"','"+iList.getAmount()+"')";
				//System.out.println("标记7");
				stmt.execute(sqlStr);
			/*	sqlStr = "insert into My_indentlist (IndentNo,BookNo,Amount) values (";
				sqlStr = sqlStr + indentid + ",'";
				sqlStr = sqlStr + iList.getBookNo() + "','";
				sqlStr = sqlStr + iList.getAmount() + "')";
				sqlStr = "insert into my_indentlist values('"+intendId+"'+'"+IndentNo+"')";
				stmt.execute(sqlStr);*/
				//System.out.println("标记8");
				sqlStr = "update My_book set leav_number=leav_number - " + iList.getAmount() + " where id = " + iList.getBookNo();
				stmt.execute(sqlStr);
			}
			return true;
		}
		catch (SQLException e)
		{
			//System.out.println("标记9");
			return false;
		}
				
	}

	public boolean getIndent(long userid) {
		sqlStr = "select * from My_indent where userid = '" +userid+ "' order by id desc";
		try
		{
			rs = stmt.executeQuery(sqlStr);
			my_indent = new Vector();
			while (rs.next())
			{
				indent ind = new indent();
				ind.setId(rs.getLong("id"));
				ind.setIndentNo(rs.getString("indentNo"));
				ind.setUserId(rs.getLong("userid"));
				ind.setSubmitTime(rs.getString("submitTime"));
				ind.setConsignmentTime(rs.getString("ConsignmentTime"));
				ind.setTotalPrice(rs.getFloat("TotalPrice"));
				ind.setContent(rs.getString("content"));
				ind.setIPAddress(rs.getString("IpAddress"));
				if (rs.getInt("IsPayoff")==1)
					ind.setIsPayoff(false);
				else 
					ind.setIsPayoff(true);
				if (rs.getInt("IsSales")==1)
					ind.setIsSales(false);
				else
					ind.setIsSales(true);
				my_indent.addElement(ind);
			}
			rs.close();
			return true;			
		}
		catch (SQLException e)
		{
			return false;
		}		
	}

	public boolean getOneIndent(long iid) {
		sqlStr = "select * from My_indent where id = '" +iid+ "' order by id desc";
		try
		{
			rs = stmt.executeQuery(sqlStr);
			my_indent = new Vector();
			while (rs.next())
			{
				indent ind = new indent();
				ind.setId(rs.getLong("id"));
				ind.setIndentNo(rs.getString("indentNo"));
				ind.setUserId(rs.getLong("userid"));
				ind.setSubmitTime(rs.getString("submitTime"));
				ind.setConsignmentTime(rs.getString("ConsignmentTime"));
				ind.setTotalPrice(rs.getFloat("TotalPrice"));
				ind.setContent(rs.getString("content"));
				ind.setIPAddress(rs.getString("IpAddress"));
				if (rs.getInt("IsPayoff")==1)
					ind.setIsPayoff(false);
				else 
					ind.setIsPayoff(true);
				if (rs.getInt("IsSales")==1)
					ind.setIsSales(false);
				else
					ind.setIsSales(true);
				my_indent.addElement(ind);
			}
			rs.close();
			return true;			
		}
		catch (SQLException e)
		{
			return false;
		}		
	}

	public boolean getIndent(HttpServletRequest request) throws Exception {
		this.request = request;
		String PAGE = request.getParameter("page");
		if(PAGE != null)
		{
			page = Integer.parseInt(PAGE);
			System.out.println("page11111111:"+page);
		}
		else
		{
			page = 1;
		}
		sqlStr = "select count(*) from My_indent";
		try
		{
			rs = stmt.executeQuery(sqlStr);
			while(rs.next())
			{
				recordCount = rs.getInt(1);
			}
			pageCount = (recordCount+pageSize-1)/pageSize;//页数
		    rs.close();
		}
		catch(SQLException e)
		{
			return false;
		}
		sqlStr = "select * from my_indent";
		try
		{
			rs = stmt.executeQuery(sqlStr);
			my_indent = new Vector();
			my_indent.removeAllElements();
			while (rs.next())
			{
				int intTemp1 = (page-1)*pageSize;
				int intTemp2 = page*pageSize;
				if(intTemp1 < (rs.getRow()+1)&& rs.getRow() <= intTemp2)
				{
					indent ind = new indent();
					ind.setId(rs.getLong(1));
					ind.setIndentNo(rs.getString(2));
					ind.setUserId(rs.getLong(3));
					ind.setSubmitTime(rs.getString(4));
					ind.setConsignmentTime(rs.getString(5));
					ind.setTotalPrice(rs.getFloat(6));
					ind.setContent(rs.getString(7));
					ind.setIPAddress(rs.getString(8));
					if (rs.getInt(9)==1)
						ind.setIsPayoff(false);
					else 
						ind.setIsPayoff(true);
					if (rs.getInt(10)==1)
						ind.setIsSales(false);
					else
						ind.setIsSales(true);
					my_indent.addElement(ind);
					//System.out.println(my_indent.elementAt(0));
				}
			}
			rs.close();
			return true;			
		}
		catch (SQLException e)
		{
			System.out.println(e);
			return false;
		}
	}

	
	public boolean getIndentList(long nid) {
		sqlStr = "select * from my_indentlist where IndentNo = '" + nid + "'";
		try
		{	
			rs = stmt.executeQuery(sqlStr);
			indent_list = new Vector();
			while (rs.next())
			{				
				indentlist identlist = new indentlist();
				identlist.setId(rs.getLong("id"));
				identlist.setIndentNo(rs.getLong("IndentNo"));
				identlist.setBookNo(rs.getLong("BookNo"));
				identlist.setAmount(rs.getInt("Amount"));
				indent_list.addElement(identlist);
			}
			rs.close();
			return true;
		}
		catch (SQLException e)
		{
			return false;
		}		
	}

	public boolean update(HttpServletRequest res) {
		request = res;
		int payoff = 1;
		int sales = 1;
		long indentid =0;
		try
		{
			payoff = Integer.parseInt(request.getParameter("payoff"));
			sales = Integer.parseInt(request.getParameter("sales"));
			indentid = Long.parseLong(request.getParameter("indentid"));
			sqlStr = "update My_indent set IsPayoff = '" + payoff + "',IsSales='"+ sales +"' where id =" + indentid;
			stmt.execute(sqlStr);
			return true;
		}
		catch (Exception e)
		{
			return false;
		}		
	}

	public boolean delete(long id) {
		try
		{
			sqlStr = "delete from My_indentlist where indentNo =" + id;
			stmt.execute(sqlStr);
			sqlStr = "delete from My_indent where id= " + id ;
			stmt.execute(sqlStr);
			return true;
		}
		catch (SQLException e)
		{
			return false;
		}
	}

};