managermember.java

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

	}

	//--- 翻页函数 ---
	public Hashtable turn_page(String page,int pagesize,int rows_count) {
		//int APageParam[] = new int[10];
		int pagecount;
		int pagecount2;
		int page1=0;
		int page2;
		int pt_st;
		int pt_en;
		int nextpage;
		int prevpage;
		int out_page;
		Hashtable APageParam = new Hashtable();

		if (!page.equals("")) page1 = Integer.parseInt(page);
		pagecount = rows_count / pagesize;
		if (pagesize * pagecount < rows_count) pagecount++;
		if (Integer.parseInt(page) > pagecount) page1 = pagecount - 1;
		else if (Integer.parseInt(page) < 0) page1 = 0;
		pagecount2 = pagecount - 1;
		page2 = page1 + 1;
		pt_st = page1 * pagesize;
		pt_en = pt_st + pagesize;
		nextpage = page1 + 1;
		prevpage = page1 - 1;

		APageParam.put("pt_st",new Integer(pt_st));
		APageParam.put("pt_en",new Integer(pt_en));
		APageParam.put("nextpage",new Integer(nextpage));
		APageParam.put("prevpage",new Integer(prevpage));
		APageParam.put("pagesize",new Integer(pagesize));
		APageParam.put("pagecount",new Integer(pagecount));
		APageParam.put("pagecount2",new Integer(pagecount2));
		APageParam.put("page1",new Integer(page1));
		APageParam.put("page2",new Integer(page2));
		

		return(APageParam);
	}

	public String search_turn(Hashtable APageParam,String SelfPage,String keywords,String type) throws Exception {
		String turnpage_str="";
		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 selected>选择类别</option>";
		turnpage_str += "  <option value=name>帐 号</option>";
		turnpage_str += "  <option value=address>地 址</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 getModifyInfo(HttpServletRequest request,String tb_member_info) throws Exception {
		ResultSet rs;
		String SqlStr = "",name="",tel="",address="",email="";
		int sex=0,age=0;
		Hashtable resultHashtable = new Hashtable();

		HttpSession session = request.getSession(true);
		String account = (String)session.getAttribute("LoginUser");

		try {
			SqlStr = "SELECT * FROM " + tb_member_info + " WHERE account='" + account + "'";
			rs = dbconn.ExeQuery(SqlStr);
			if (rs.next()) {
				name = rs.getString("name");
				tel = rs.getString("tel");
				address = rs.getString("address");
				email = rs.getString("email");
				sex = rs.getInt("sex");
				age = rs.getInt("age");
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		resultHashtable.put("name",name);
		resultHashtable.put("tel",tel);
		resultHashtable.put("address",address);
		resultHashtable.put("email",email);
		resultHashtable.put("sex",new Integer(sex));
		resultHashtable.put("age",new Integer(age));

		return(resultHashtable);
	}

	//--- 修改资料 ---
	public void modifyInfo(HttpServletRequest request,String tb_member_info) throws Exception {
		String SqlStr="";

		HttpSession session = request.getSession(true);
		String account = (String)session.getAttribute("LoginUser");
		String pwd = handle.getString(request,"pwd");
		String name = handle.getString(request,"name");
		name = handle.GBK2ISO(name);
		String tel = handle.getString(request,"tel");
		String address = handle.getString(request,"address");
		address = handle.GBK2ISO(address);
		String email = handle.getString(request,"email");
		int sex = handle.getInt(request,"sex");
		int age = handle.getInt(request,"age");

		if (pwd.equals("")) SqlStr = "UPDATE " + tb_member_info + " SET name='" + name + "',tel='" + tel + "',address='" + address + "',email='" + email + "',sex=" + sex + ",age=" + age + " WHERE account='" + account + "'";
		else SqlStr = "UPDATE " + tb_member_info + " SET name='" + name + "',tel='" + tel + "',address='" + address + "',email='" + email + "',sex=" + sex + ",age=" + age + ",pwd='" + md5.getMD5ofStr(pwd) + "' WHERE account='" + account + "'";
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 转向登陆 ---
	public void gotoLogin(HttpServletRequest request,HttpServletResponse response) throws Exception {
		HttpSession session = request.getSession(true);
		administratorBean administratorBean = (administratorBean)session.getAttribute("administratorBean");

		if (session.getAttribute("administratorBean") == null) response.sendRedirect("/" + config.systemFolder + "admin/member_sys/adminlogin.jsp");
		else if (administratorBean.getLevel() == 0) response.sendRedirect("purchase_sys/onlyorder.jsp");
	}

	public void gotoLogin2(HttpServletRequest request,HttpServletResponse response) throws Exception {
		HttpSession session = request.getSession(true);
		if (session.getAttribute("administratorBean") == null) response.sendRedirect("../index.jsp");
	}

	//--- 管理登陆 ---
	public boolean adminLogin(HttpServletRequest request,String tb_shop_admin) throws Exception {
		String SqlStr;
		ResultSet rs;
		boolean flag = false;

		HttpSession session = request.getSession(true);
		String name = handle.getString(request,"name");
		String pwd = handle.getString(request,"pwd");
		pwd = md5.getMD5ofStr(pwd.trim());

		try {
			SqlStr = "SELECT * FROM " + tb_shop_admin + " WHERE name='" + name + "' AND pwd='" + pwd + "'";
			rs = dbconn.ExeQuery(SqlStr);
			if (rs.next()) {
				administratorBean administratorBean = new administratorBean();
				administratorBean.setId(rs.getInt("aid"));
				administratorBean.setName(rs.getString("name"));
				administratorBean.setPwd(rs.getString("pwd"));
				administratorBean.setLevel(rs.getInt("level"));
				session.setAttribute("administratorBean",administratorBean);
				flag = true;
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return(flag);
	}

	//--- 退出管理 ---
	public void loginOut(HttpServletRequest request) {
		HttpSession session = request.getSession(true);
		session.removeAttribute("administratorBean");
	}

	//--- 创建用户 ---
	public void createAdmin(HttpServletRequest request,String tb_shop_admin) {
		String sqlStr;
		HttpSession ses = request.getSession(true);
		if ( ses.getAttribute("administratorBean") != null )
		{
			String name = handle.getString(request,"name");
			String pwd = handle.getString(request,"pwd");
			pwd = md5.getMD5ofStr(pwd.trim());
			int level = handle.getInt(request,"level");

			sqlStr = "INSERT INTO " + tb_shop_admin + "(name,pwd,level) VALUES('" + name + "','" + pwd + "'," + level + ")";
			dbconn.ExeUpdate(sqlStr);
		}
	}

	public Vector getAdministratorBeanVector(String tb_shop_admin) throws Exception {
		String SqlStr;
		ResultSet rs;
		Vector administratorBeanVector = new Vector();

		try {
			SqlStr = "SELECT * FROM " + tb_shop_admin + " ORDER BY aid DESC";
			rs = dbconn.ExeQuery(SqlStr);
			while (rs.next()) {
				administratorBean administratorBean = new administratorBean();
				administratorBean.setId(rs.getInt("aid"));
				administratorBean.setName(rs.getString("name"));
				administratorBean.setLevel(rs.getInt("level"));
				administratorBeanVector.addElement(administratorBean);
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}
		return(administratorBeanVector);
	}

	public void modifyAdmin(HttpServletRequest request,String tb_shop_admin) throws Exception {
		HttpSession ses = request.getSession(true);
		if ( ses.getAttribute("administratorBean") != null )
		{
			int aid = handle.getInt(request,"aid");
			int level = handle.getInt(request,"level");
			String name = handle.getString(request,"name");
			String pwd = handle.getString(request,"pwd");
			pwd = md5.getMD5ofStr(pwd.trim());
	
			String sqlStr,strC="";
	
			if (!name.equals("")) strC += "name='" + name + "',";
			if (!pwd.equals("")) strC += "pwd='" + pwd + "',";
			strC += "level=" + level;
	
			sqlStr = "UPDATE " + tb_shop_admin + " SET " + strC + " WHERE aid=" + aid;
			dbconn.ExeUpdate(sqlStr);
			dbconn.CloseConn();
		}
	}

	public void delAdmin(HttpServletRequest request,String tb_shop_admin) throws Exception {
		String sqlStr;
		int aid = handle.getInt(request,"aid");

		sqlStr = "DELETE FROM " + tb_shop_admin + " WHERE aid=" + aid;
		dbconn.ExeUpdate(sqlStr);
		dbconn.CloseConn();
	}
}