managergbook.java

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

package myshop.gbook_sys;

import myshop.*;
import java.sql.*;
import java.util.*;
import javax.servlet.http.*;

public class  ManagerGbook {
	Handle handle;
	DBconn dbconn;

	public ManagerGbook() throws Exception {
		dbconn = new DBconn();
		handle = new Handle();
	}

	//--- 插入留言数据 --- 
	public void AddWords(String tb_gbook_info,HttpServletRequest request) throws Exception {
		String author = handle.GBK2ISO(request.getParameter("author"));
		String content = handle.GBK2ISO(request.getParameter("content"));
		int Pid = handle.getInt(request,"Pid");
		int level = handle.getInt(request,"level");

		String SqlStr = "INSERT INTO " + tb_gbook_info + "(product_id,author,content,level,date_time) VALUES(" + Pid + ",'" + author + "','" + content + "'," + level + ",sysdate())";
		dbconn.ExeUpdate(SqlStr);
		dbconn.CloseConn();
	}

	//--- 显示评论内容 ---
	public String ShowWords(String tb_gbook_info,HttpServletRequest request,int rows) throws Exception {
		String SqlStr;
		String TableStr = "";
		ResultSet rs;
		int i = 0;

		int Pid = handle.getInt(request,"Pid");
		try {
			SqlStr = "SELECT * FROM " + tb_gbook_info + " WHERE product_id=" + Pid + " ORDER BY id DESC";
			rs = dbconn.ExeQuery(SqlStr);
			while(rs.next()) {
				i++;
				TableStr += "<table width=100% border=0 cellspacing=1 cellpadding=3>";
				TableStr += "	<tr bgcolor=#FFFFFF> ";
				TableStr += "		<td width=4% align=center valign=middle>" + i + "</td>";
				TableStr += "		<td width=8% align=center bgcolor=eeeeee>作者：</td>";
				TableStr += "		<td width=29%>" + rs.getString("author") + "</td>";
				TableStr += "		<td width=13% align=center valign=middle bgcolor=eeeeee>发表时间：</td>";
				TableStr += "		<td width=24% align=center valign=middle>" + rs.getString("date_time") + "</td>";
				TableStr += "		<td width=8% align=center valign=middle bgcolor=eeeeee>评分：</td>";
				TableStr += "		<td width=14% align=center valign=middle><font color=#FF0000>" + Num2Star(rs.getInt("level")) + "</font></td>";
				TableStr += "	</tr>";
				TableStr += "	<tr bgcolor=#FFFFFF> ";
				TableStr += "		<td colspan=7>评论：" + rs.getString("content") + "</td>";
				TableStr += "	</tr>";
				TableStr += "</table>";
				if (i == rows) break;
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return(TableStr);
	}

	//--- 星星翻译器 ---
	public String Num2Star(int num) {
		int i;
		String StarStr = "";

		for (i=0; i<num; i++) StarStr += "★";
		return(StarStr);
	}


	//--- 分页读取留言数据 ---
	public Hashtable ReadDataAdmin(String page,int pagesize,String SelfPage,String keywords,String type,String tb_name,String tb_shop_product_info) throws Exception {
		String qry_string;
		String HtmlStr="";
		String str_rows_count;
		int rows_count = 0;
		float i=0;
		int z;
		int ii=0;
		Statement stmt;
		ResultSet rs;
		Hashtable APageParam = new Hashtable();
		Hashtable AOutParam = new Hashtable();

		try {
			keywords = handle.GBK2ISO(keywords);

			if (type.equals("author")) qry_string = "SELECT * FROM " + tb_name + " WHERE author LIKE '%" + keywords + "%' ORDER BY id DESC";
			else if (type.equals("content")) qry_string = "SELECT * FROM " + tb_name + " WHERE content LIKE '%" + keywords + "%' ORDER BY id DESC";
			else qry_string = "SELECT * FROM " + tb_name + " 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++) {
				i++;
				int id = rs.getInt("id");
				String td_bg_color;
				if ((i / 2) == (int)(i / 2))  td_bg_color = "f1f1f1";
				else  td_bg_color = "ffffff";

				HtmlStr += "  <tr align=center valign=middle bgcolor=" + td_bg_color + "> ";
				HtmlStr += "    <td>" + (int)i + "-" + id + "</td>";
				HtmlStr += "    <td>" + rs.getString("author") + "</td>";
				HtmlStr += "    <td>" + rs.getString("content") + "</td>";
				HtmlStr += "    <td><font color=red>" + Num2Star(rs.getInt("level")) + "</font></td>";
				HtmlStr += "    <td>" + Id2Name(tb_shop_product_info,rs.getInt("product_id")) + "</td>";
				HtmlStr += "    <td>" + rs.getString("date_time") + "</td>";
				HtmlStr += "    <td><a href=Control.jsp?action=del&Gid=" + id + " onclick=\"return (AlertDel('" + rs.getString("author") + "'));\"><font color=red>删除</font></a></td>";
				HtmlStr += "  </tr>";

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

		String turnpage_str = search_turn(APageParam, SelfPage, keywords, type);
		
		AOutParam.put("RecordCount",java.lang.String.valueOf(rows_count));
		AOutParam.put("HtmlStr",HtmlStr);
		AOutParam.put("TurpageStr",turnpage_str);

		return(AOutParam);
	}

	//--- 翻页函数 ---
	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=author>作 者</option>";
		turnpage_str += "  <option value=content>评 价</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);
	}

	//--- ID转换为名称 ---
	public String Id2Name(String tb_shop_product_info,int product_id) throws Exception {
		String SqlStr;
		String product_name = "";
		ResultSet rs;

		try {
			SqlStr = "SELECT * FROM " + tb_shop_product_info + " WHERE id=" + product_id;
			rs = dbconn.ExeQuery(SqlStr);
			rs.next();
			product_name = rs.getString("name");
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return(product_name);
	}

	//--- 删除留言 ---
	public void DelWord(String tb_gbook_info,HttpServletRequest request) throws Exception {
		int Gid = handle.getInt(request,"Gid");
		
		if (Gid != 0) {
			String SqlStr = "DELETE FROM " + tb_gbook_info + " WHERE id=" + Gid;
			dbconn.ExeUpdate(SqlStr);
			dbconn.CloseConn();
		}
	}

}