managerproduct.java

用jsp实现的大型商城源代码

		int i,j;

		int nextpage = Integer.parseInt(java.lang.String.valueOf(APageParam.get("nextpage")));
		int prevpage = Integer.parseInt(java.lang.String.valueOf(APageParam.get("prevpage")));
		int pagesize = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagesize")));
		int pagecount = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagecount")));
		int pagecount2 = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pagecount2")));
		int page_inside = Integer.parseInt(java.lang.String.valueOf(APageParam.get("page1")));
		int page2 = Integer.parseInt(java.lang.String.valueOf(APageParam.get("page2")));

		keywords = handle.ISO2GBK(keywords);

		//--- 显示搜索引擎 ---
		turnpage_str += "<form name=form1 method=post action=" + SelfPage + ">";
		turnpage_str += "<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>";
		turnpage_str += "  <tr> ";
		turnpage_str += "    <td bgcolor=#999999> ";
		turnpage_str += "    <table width=100% border=0 cellspacing=1 cellpadding=3>";
		turnpage_str += "  <tr bgcolor=f1f1f1>";
		turnpage_str += "	  <td align=center valign=middle width=50%>关键词： ";
		turnpage_str += "      <input type=text name=keywords value=" + keywords + ">";
		turnpage_str += " ";
		turnpage_str += "<select name=type>";
		turnpage_str += "  <option value=name>名 称</option>";
		turnpage_str += "  <option value=description>简 介</option>";
		turnpage_str += "</select>";
		turnpage_str += "      <input type=submit name=Submit value=搜索>";
		turnpage_str += "    </td>";
		turnpage_str += "	  <td align=center valign=middle width=50%>";	
		turnpage_str += "      <table><tr><td align=center valign=middle width=30%>";
		turnpage_str += "        <SELECT onchange=\"var jmpURL1=this.options[this.selectedIndex].value; if(jmpURL1!='') {self.location=jmpURL1;} else {this.selectedIndex=0;}\" size=1 name=select>";
		turnpage_str += "          <option value=''>选择翻页</option>";

		for (i=0; i<pagecount; i++) {
			j = i + 1;
			turnpage_str += "         <option value=" + SelfPage + "?CurrentPage=" + i + "&keywords=" + keywords + "&type=" + type + ">第 " + j + " 页</option>";
		}
		turnpage_str += "        </select>";
		turnpage_str += "     </td>";
		turnpage_str += "     <td align=center valign=middle width=20%>";
		turnpage_str += "       当前页：" + page2 + "/" + pagecount;
		turnpage_str += "      </td>";

		//--- 显示翻页按钮 ---
		turnpage_str = turnpage_str + "     <td align=center valign=middle width=40% style='font-family:Webdings'>";
		if (pagecount != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=0&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">7</a>&nbsp;&nbsp;";
		else turnpage_str = turnpage_str + "7&nbsp;&nbsp;";
		if (page_inside != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=" + prevpage + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">3</a>";
		else turnpage_str += "3";
		if (page_inside != pagecount2 && pagecount != 0) turnpage_str = turnpage_str + "&nbsp;&nbsp;&nbsp;&nbsp;<a href=" + SelfPage + "?CurrentPage=" + nextpage + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">4</a>&nbsp;&nbsp;";
		else turnpage_str = turnpage_str + "&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;";
		int t_pagecount = pagecount-1;
		if (pagecount != 0) turnpage_str = turnpage_str + "<a href=" + SelfPage + "?CurrentPage=" + t_pagecount + "&keywords=" + keywords + "&type=" + type + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">8</a>";
		else turnpage_str = turnpage_str + "8";
		turnpage_str += "</td></tr></table>";
		turnpage_str += "	  </td>";
		turnpage_str += "        </tr>";
		turnpage_str += "      </table>";
		turnpage_str += "    </td>";
		turnpage_str += "  </tr>";
		turnpage_str += "</table>";
	
		return(turnpage_str);
	}

	//--- 详细商品信息 ---
	public Hashtable DetailProInfo(String tb_shop_catalog,String tb_shop_product_info,int id) throws Exception {
		Hashtable ProductInfo = new Hashtable();
		String SqlStr;
		ResultSet rs;
		
		try {
			SqlStr = "SELECT * FROM " + tb_shop_product_info + " WHERE id=" + id;
			rs = dbconn.ExeQuery(SqlStr);
			rs.next();

			ProductInfo.put("name",rs.getString("name"));
			ProductInfo.put("description",rs.getString("description"));
			ProductInfo.put("description_txt",handle.ReturnTxt(rs.getString("description")));
			if (rs.getString("img_path").indexOf(".") != -1) ProductInfo.put("img_path",rs.getString("img_path"));
			else ProductInfo.put("img_path","img/que.gif");
			ProductInfo.put("price",rs.getString("price"));
			ProductInfo.put("member_price",rs.getString("member_price"));
			ProductInfo.put("date_time",rs.getString("date_time"));
			ProductInfo.put("catalog",InTheCatalog(tb_shop_catalog,rs.getInt("catalog_id")));
			ProductInfo.put("catalog_id",new Integer(rs.getInt("catalog_id")));
			ProductInfo.put("keywords",rs.getString("keywords"));
			ProductInfo.put("absence",rs.getString("absence"));

			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return (ProductInfo);
	}

	//--- 设置为“精彩推介” ---
	public void ShowOut(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET show_out=1 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 还原正常商品 ---
	public void UnShowOut(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET show_out=0 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 标记缺货 ---
	public void MarkAbsence(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET absence=1 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 标记有货 ---
	public void UnMarkAbsence(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET absence=0 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 重点推荐 ---
	public void importanceShow(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET importance_show=1 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 撤消推荐 ---
	public void unImportanceShow(HttpServletRequest request,String tb_shop_product_info) throws Exception {
		int Pid = handle.getInt(request,"Pid");

		String SqlStr = "UPDATE " + tb_shop_product_info + " SET importance_show=0 WHERE id=" + Pid;
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 批量转移商品到其它货架 ---
	public void MoveProducts(String tb_shop_product_info,HttpServletRequest request) throws Exception {
		HttpSession ses = request.getSession(true);
		if ( ses.getAttribute("administratorBean") != null )
		{
			int i;
			String SqlStr;
			String ParameterNames[] = request.getParameterValues("checkbox");
			int catalog_id = handle.getInt(request,"catalog_id");
	
			for (i=0; i<ParameterNames.length; i++) {
				SqlStr = "UPDATE " + tb_shop_product_info + " SET catalog_id=" + catalog_id + " WHERE id=" + Integer.parseInt(ParameterNames[i]);
				dbconn.ExeUpdate(SqlStr);
				dbconn.CloseConn();
			}
		}
	}

	//--- 显示相关新闻 ---
	public String ShowCorrelationProduct(String tb_shop_product_info,HttpServletRequest request) throws Exception {
		int Pid = handle.getInt(request,"Pid");
		int i;
		float j = 0;
		String SqlStr= "";
		String TableStr = "";
		String keywords = "",current_name = "",Correlation_name = "";
		String CondictionStr = "";
		ResultSet rs;

		try {
			SqlStr = "SELECT name,keywords FROM " + tb_shop_product_info + " WHERE id=" + Pid;
			rs = dbconn.ExeQuery(SqlStr);
			rs.next();
			keywords = rs.getString("keywords");
			current_name = rs.getString("name");
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}
		//--- 重组条件语句 ---
		keywords = handle.GBK2ISO(keywords);				//不转换中文，得不到正确的搜索结果！！
		String ArrayKeywords[] = handle.Split(",",keywords);
		if (ArrayKeywords.length == 1) CondictionStr += "keywords LIKE '%" + ArrayKeywords[0] + "%'";
		else {
			for (i=0; i<ArrayKeywords.length-1; i++) {
				CondictionStr += "keywords LIKE '%" + ArrayKeywords[i] + "%' OR ";
			}
			CondictionStr += "keywords LIKE '%" + ArrayKeywords[i] + "%'";
		}
		try {
			SqlStr = "SELECT * FROM " + tb_shop_product_info + " WHERE "+ CondictionStr;
			rs = dbconn.ExeQuery(SqlStr);
			TableStr += "<table width=100% border=0 cellspacing=0 cellpadding=3>";
			while (rs.next()) {
				Correlation_name = rs.getString("name");
				if (current_name.equals(Correlation_name)) continue;
				if (j/2 == (int)j/2) TableStr += "    <tr bgcolor=white>";
				else TableStr += "    <tr>";
                TableStr += "      <td><a href=" + SystemURL + "DetailProInfo.jsp?Pid=" + rs.getInt("id") + ">" + Correlation_name + "</a></td><td width=38%>市场价：<font color=red>￥<span class=xiexian>" + rs.getString("price") + "</span></font>&nbsp;&nbsp; 会员价：<font color=red>￥" + rs.getString("member_price") + "</font></td>";
                TableStr += "    </tr>";
				j++;
			}
            TableStr += "</table>";
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return(TableStr);
	}

	//--- 输出某货架下的商品列表 ---
	public Hashtable UnderCatalogPro(HttpServletRequest request,int pagesize,String SelfPage,String tb_name) throws Exception {
		String qry_string;
		String HtmlStr="";
		String str_rows_count;
		String img_path,name,description;
		int rows_count = 0;
		int ii=0;
		int Pid;
		float price;
		Statement stmt;
		ResultSet rs;
		Hashtable APageParam = new Hashtable();
		Hashtable AOutParam = new Hashtable();

		String page = handle.getString(request,"CurrentPage","0");
		String Catalog_f = handle.getString(request,"Catalog_f");
		String Catalog_s = handle.getString(request,"Catalog_s");
		int Cid = handle.getInt(request,"Cid");

		try {
			qry_string = "SELECT * FROM " + tb_name + " WHERE catalog_id=" + Cid + " ORDER BY id DESC";

			rs = dbconn.ExeQuery(qry_string);
			rs.last();
			rows_count = rs.getRow();

			APageParam = turn_page(page, pagesize, rows_count);

			int pt_st = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pt_st"))) + 1;
			int pt_en = Integer.parseInt(java.lang.String.valueOf(APageParam.get("pt_en"))) + 1;

			rs.absolute(pt_st);
			for (ii=pt_st; ii<pt_en; ii++) {
				Pid = rs.getInt("id");
				img_path = rs.getString("img_path");
				name = rs.getString("name");
				description = rs.getString("description");
				if (description.length() > 150) {
					description = description.substring(0,150);
					description += "......";
				}
				price = rs.getFloat("price");

				HtmlStr += "<table width=571 height=100 border=0 cellpadding=0 cellspacing=0>";
				HtmlStr += "<tr>";
				HtmlStr += "<td width=138 align=center valign=middle><a href=../../DetailProInfo.jsp?Pid=" + Pid + "><img src=../../" + img_path + " width=80 height=80 border=1></a></td>";
				HtmlStr += "<td width=433 align=center valign=top><table width=100% height=78 border=0 cellpadding=3 cellspacing=0>";
				HtmlStr += "<tr> ";
				HtmlStr += "<td><font color=#0000FF>商品名称：</font>" + name + "</td>";
				HtmlStr += "</tr>";
				HtmlStr += "<tr> ";
				HtmlStr += "<td height=18><font color=#0000FF>市场价格：<font color=red> ￥<span class=xiexian>" + price + "</span></font></font></td>";
				HtmlStr += "</tr>";
				HtmlStr += "<tr> ";
				HtmlStr += "<td height=18><font color=#0000FF>会员价格：<font color=red> ￥" + rs.getFloat("member_price") + "</font></font></td>";
				HtmlStr += "</tr>";
				HtmlStr += "<tr> ";
				HtmlStr += "<td height=25><font color=#0000FF>商品简介：</font><br>" + description + "</td>";
				HtmlStr += "</tr>";
				HtmlStr += "</table></td>";
				HtmlStr += "</tr>";
				HtmlStr += "</table>";
				HtmlStr += "<table width=571 height=1 border=0 cellpadding=0 cellspacing=0>";
				HtmlStr += "<tr>";
				HtmlStr += "<td width=601 bgcolor=#000000></td>";
				HtmlStr += "</tr>";
				HtmlStr += "</table>";
				if (!rs.next()) break;
			}
			dbconn.CloseConn();
		}
		catch(SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		String turnpage_str = SearchTurn_UnderCatalogPro(APageParam, SelfPage, Cid, Catalog_f, Catalog_s);
		
		AOutParam.put("RecordCount",java.lang.String.valueOf(rows_count));
		AOutParam.put("HtmlStr",HtmlStr);
		AOutParam.put("TurpageStr",turnpage_str);

		return(AOutParam);
	}