htmlnews.java

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

package myshop.news_sys;

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

public class HtmlNews {
	Handle handle;
	DBconn dbconn;

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

	//--- 产生所有新闻html页面 ---
	public void CreateAll(HttpServletRequest request,String tb_news_info) throws Exception {
		String SqlStr,HtmlContent;
		String date_time;
		String pathStr,pathStr2;
		ResultSet rs;
		int id;
		
		try {
			SqlStr = "SELECT * FROM " + tb_news_info + " ORDER BY id DESC";
			rs = dbconn.ExeQuery(SqlStr);
			while (rs.next()) {
				id = rs.getInt("id");
				date_time = rs.getString("date_time");

				pathStr = handle.Convert2Path(id,date_time);
				pathStr2 = "../" + handle.Split("/",pathStr)[0];
				pathStr = "../" + pathStr;
				
				HtmlContent = handle.ReadUrl("http://leobasic:8080/new_web/myshop/admin/news_sys/DetailNews.jsp?Nid=" + id);
				HtmlContent = handle.Replace("images/","../news_sys/images/",HtmlContent);			//替换更正图片路径

				handle.MkDir(request,pathStr2);
				handle.WriteFile(request,pathStr,HtmlContent);
			}
			dbconn.CloseConn();
		}
		catch (SQLException ex) {
			System.err.println("aq.executeQuery:"+ex.getMessage());
		}
	}

	//--- 产生单个html页面 ---
	public void CreateOne(HttpServletRequest request,String path,String Inputurl) throws Exception {
		String HtmlContent = handle.ReadUrl(Inputurl);
		handle.WriteFile(request,path,HtmlContent);
	}

}