purchase.java

jsp开发常用信息管理系统适合初学者学习 网上购物

		}
		String Userid = (String) session.getAttribute("userid");   //取得用户ID号
		long userid=0;
		if (Userid==null || Userid.equals(""))
		{
			isLogin = false;
			return false;
		}else {
			try
			{
				userid = Long.parseLong(Userid);
			}
			catch (NumberFormatException e)
			{
				return false;
			}
		}

		purchaselist = (Vector)session.getAttribute("shopcar");
		if (purchaselist==null || purchaselist.size()<0)
		{
			return false;
		}
		String Content = request.getParameter("content");
		if (Content==null)
		{
			Content="";
		}
		Content = getGbk(Content);
		String IP = request.getRemoteAddr();
		String TotalPrice = request.getParameter("totalprice");

		sqlStr = "select max(id) from indent";
		rs = stmt.executeQuery(sqlStr);
		if (rs.next())
		{
			IndentNo = "HYD" + userid + "" + rs.getString(1);
		} else {
			IndentNo =  "HYD" + userid + "0";
		}
		rs.close();

		sqlStr = "insert into indent (IndentNo,UserId,SubmitTime,ConsignmentTime,TotalPrice,content,IPAddress,IsPayoff,IsSales) values ('";
		sqlStr = sqlStr + IndentNo + "','";
		sqlStr = sqlStr + userid + "',getdate(),getdate()+7,'";
		sqlStr = sqlStr + TotalPrice + "','";
		sqlStr = sqlStr + strFormat.formatSql(Content) + "','";
		sqlStr = sqlStr + IP + "',1,1)";
		try
		{
			stmt.execute(sqlStr);
			sqlStr= "select max(id) from indent where UserId = " + userid;
			rs = stmt.executeQuery(sqlStr);
			long indentid = 0;
			while (rs.next())
			{
				indentid = rs.getLong(1);
			}
			rs.close();
			for (int i=0; i<purchaselist.size() ;i++ )
			{
				indentlist iList = (indentlist) purchaselist.elementAt(i);
				sqlStr = "insert into indentlist (IndentNo,BookNo,Amount) values (";
				sqlStr = sqlStr + indentid + ",'";
				sqlStr = sqlStr + iList.getBookNo() + "','";
				sqlStr = sqlStr + iList.getAmount() + "')";
				stmt.execute(sqlStr);
				sqlStr = "update book set leav_number=leav_number - " + iList.getAmount() + " where id = " + iList.getBookNo();
				stmt.execute(sqlStr);
			}
			return true;
		}
		catch (SQLException e)
		{
			return false;
		}
				
	}

	/**
	 * 获取自己的订单列表
	 * @param userid
	 * @return
	 */
	public boolean getIndent(long userid) {
		sqlStr = "select * from indent where userid = ? order by id desc";
		try
		{
		    prepstmt = conn.prepareStatement(sqlStr);
		    prepstmt.setLong(1, userid);
			rs = prepstmt.executeQuery();
			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;
		}		
	}

	/**
	 * 从数据库中获取一条订单记录
	 * @param iid
	 * @return
	 */
	public boolean getOneIndent(long iid) {
		sqlStr = "select * from 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;
		}
	}

	/**
	 * 获取全部订单记录
	 * @return
	 */
	public boolean getIndent() {
		sqlStr = "select count(*) from indent";    //取出记录数
		int rscount = pageSize;
		try
		{
			ResultSet rs1 = stmt.executeQuery(sqlStr);
			if (rs1.next()) recordCount = rs1.getInt(1);				
			rs1.close();
		}
		catch (SQLException e)
		{
			return false;
		}
		//设定有多少pageCount
		if (recordCount < 1)
            pageCount = 0;
        else
            pageCount = (int)(recordCount - 1) / pageSize + 1;
		//检查查看的页面数是否在范围内
		if (page < 1)
            page = 1;
        else if (page > pageCount)
            page = pageCount;
		
		rscount = (int) recordCount % pageSize;	 // 最后一页记录数        

		//sql为倒序取值
		sqlStr = "select TOP " + pageSize + " * from indent ";
		if (page == 1)
		{
			sqlStr = sqlStr + " order by Id desc";
		}else {
			sqlStr = sqlStr + " where Id not in ( select TOP " + (recordCount-pageSize * page ) + " Id from indent order by Id ) and Id in " +
			"(select TOP " + (recordCount - pageSize * (page-1)) + " Id from indent order by Id ) " + " 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)
		{
			System.out.println(e);
			return false;
		}		
	}
	
	/**
	 * 获取订单列表
	 * @param nid 订单ID
	 * @return
	 */
	public boolean getIndentList(long nid) {
		sqlStr = "select * from indentlist where IndentNo = ?";
		try
		{	
		    prepstmt = conn.prepareStatement(sqlStr);
		    prepstmt.setLong(1, nid);
			rs = prepstmt.executeQuery();
			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;
		}		
	}

	/**
	 * 更新订单
	 * @param res
	 * @return
	 */
	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 indent set IsPayoff = ?,IsSales=? where id =?";
			prepstmt = conn.prepareStatement(sqlStr);
			prepstmt.setInt(1, payoff);
			prepstmt.setInt(2, sales);
			prepstmt.setLong(3, indentid);
			prepstmt.execute();
			return true;
		}
		catch (Exception e)
		{
			return false;
		}	
	}

	/**
	 * 删除用户订单记录
	 * @param id
	 * @return
	 */
	public boolean delete(long id) {
		try
		{
			sqlStr = "delete from indentlist where indentNo =" + id;
			stmt.execute(sqlStr);
			sqlStr = "delete from indent where id= " + id ;
			stmt.execute(sqlStr);
			return true;
		}
		catch (SQLException e)
		{
			return false;
		}
	}

}