managernews.java

cwc 源码 非常好的代码 大家可以学习学习

	//--- 删除栏目 ---
	public void DelType(HttpServletRequest request,String tb_news_type,String tb_news_info,String tb_news_imgs,String UploadFolder2) throws Exception {
		int type_id = handle.getInt(request,"type_id");
		ResultSet rs;

		String SqlStr = "DELETE FROM " + tb_news_type + " WHERE id=" + type_id;
		dbconn.ExeUpdate(SqlStr);

		try {
			SqlStr = "SELECT * FROM " + tb_news_info + " WHERE type_id=" + type_id;
			rs = dbconn.ExeQuery(SqlStr);
			while (rs.next()) {
				DelNews(request,tb_news_info,tb_news_imgs,UploadFolder2,rs.getInt("id"));
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

	}

	//--- 显示所有新闻类别和其中的新闻 ---
	public String ShowAllType(String tb_news_type,String tb_news_info) throws Exception {
		ResultSet rs1,rs2;
		String SqlStr1,SqlStr2,HtmlStr="",pre_topic="";
		String ArrayResult[] = new String[3];

		try {
			SqlStr1 = "SELECT * FROM " + tb_news_type + " WHERE id != 9 ORDER BY id DESC";
			rs1 = dbconn.ExeQuery(SqlStr1);
			while (rs1.next()) {
				HtmlStr += "<table width=97% border=0 align=center cellpadding=3 cellspacing=0>\n";
				HtmlStr += "<tr>\n";
				HtmlStr += "<td colspan=2 align=left valign=middle bgcolor=#0099CC class=line1><font color=#FFFFFF>■ " + rs1.getString("title") + "</font></td>\n";
				HtmlStr += "</tr>\n";
				
				SqlStr2 = "SELECT * FROM " + tb_news_info + " WHERE type_id = " + rs1.getInt("id") + " ORDER BY id DESC";
				rs2 = dbconn.ExeQuery(SqlStr2);
				while (rs2.next()) {
					ArrayResult = CheckSplit(tb_news_info,rs2.getString("pagination"),rs2.getString("id"),rs2.getString("topic"),rs2.getString("date_time"));		//--- 处理分页 ---
					if (ArrayResult[1].equals(pre_topic)) continue;
					String path = handle.Convert2Path(Integer.parseInt(ArrayResult[0]),ArrayResult[2]);
					HtmlStr += "<tr>\n";
					HtmlStr += "<td width=82% align=left valign=middle bgcolor=eeeeee>·<a href=../" + path + ">" + ArrayResult[1] + "</a></td>\n";
					HtmlStr += "<td width=18% align=center valign=middle bgcolor=eeeeee>" + handle.Split(" ",ArrayResult[2])[0] + "</td>\n";
					HtmlStr += "</tr>\n";
					pre_topic = ArrayResult[1];
				}

				HtmlStr += "</table>\n";
				HtmlStr += "<br>\n";
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}
		return(HtmlStr);
	}

	//--- 人气新闻 ---
	public String HotNews(String tb_news_info,int n) throws Exception {
		ResultSet rs;
		String HtmlStr="";
		String pre_topic="";
		String ArrayResult[] = new String[3];
		int i=0;

		try {
			String SqlStr = "SELECT * FROM " + tb_news_info + " ORDER BY click DESC";
			rs = dbconn.ExeQuery(SqlStr);
			while (rs.next()) {
				if (i == n) break;
				ArrayResult = CheckSplit(tb_news_info,rs.getString("pagination"),rs.getString("id"),rs.getString("topic"),rs.getString("date_time"));		//--- 处理分页 ---
				if (ArrayResult[1].equals(pre_topic)) continue;
				String path = handle.Convert2Path(Integer.parseInt(ArrayResult[0]),ArrayResult[2]);
				HtmlStr += "<tr>\n";
				HtmlStr += "<td bgcolor=eeeeee><a href=admin/" + path + ">" + ArrayResult[1] + "</a></td>\n";
				HtmlStr += "</tr>\n";
				pre_topic = ArrayResult[1];
				i++;
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}

		return(HtmlStr);
	}

	//--- 分页读取新闻数据 ---
	public Hashtable ReadDataAdmin(String page,int pagesize,String SelfPage,String keywords,String type,String tb_news_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("topic")) qry_string = "SELECT * FROM " + tb_news_info + " WHERE topic LIKE '%" + keywords + "%' ORDER BY id DESC";
			else if (type.equals("content")) qry_string = "SELECT * FROM " + tb_news_info + " WHERE content LIKE '%" + keywords + "%' ORDER BY id DESC";
			else if (type.equals("source")) qry_string = "SELECT * FROM " + tb_news_info + " WHERE source LIKE '%" + keywords + "%' ORDER BY id DESC";
			else qry_string = "SELECT * FROM " + tb_news_info + " 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("topic") + "</td>";
				HtmlStr += "    <td>" + rs.getString("keywords") + "</td>";
				HtmlStr += "    <td>" + rs.getInt("click") + "</td>";
				HtmlStr += "    <td>" + rs.getString("source") + "</td>";
				HtmlStr += "    <td>" + rs.getString("date_time") + "</td>";
				HtmlStr += "    <td><a href=ModifyNews.jsp?Nid=" + id + ">修改</a> <a href=DealWithCenter.jsp?action=del&Nid=" + id + " onclick=\"return (AlertDel('" + rs.getString("topic") + "'));\"><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 value=topic>主 题</option>";
		turnpage_str += "  <option value=content>内 容</option>";
		turnpage_str += "  <option value=source>来 源</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);
	}


}