publish_adinfo_index.jsp

急着下个东西即然还要开通帐号

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="beitian.db.*,java.sql.*,java.io.*" %>
<%
	    
      StringBuffer rsb = new StringBuffer(); 
				
			int type_id[] = new int[100];
	    String type_name[] = new String[100];
   		int iRecord=0;
			
			String sql_type = "select * from ad_type";
			
	 		DBOperation theDBOperation = null;
			ResultSet rs_type = null;
			try {
			    theDBOperation = new DBOperation();
			}
      catch (Exception ex) {
        System.out.println("建立连接失败:" + ex.toString());
        ex.printStackTrace();
     }
     
			try {
			    rs_type = theDBOperation.getResultSet(sql_type);
			
	  	    while (rs_type.next()) {
					    type_id[iRecord] = rs_type.getInt("type_id");
					    type_name[iRecord] = rs_type.getString("type_name");
		        	iRecord++;
			    }
  	  }
      catch (Exception ex) {
        System.out.println("查询广告商类型失败:" + ex.toString());
        ex.printStackTrace();
     }      	
     if(rs_type != null) rs_type.close(); 
		       
     for (int typeid=0;typeid<iRecord;typeid++) {  
         	      
         	      String sql_ad = "select * from ad_info where type_id ="+type_id[typeid];
								ResultSet rs_ad = null;
								try{
									
										rs_ad =theDBOperation.getResultSet(sql_ad);
							    	int iAD=0;
		
		                System.out.println(sql_ad);
		            
								    while(rs_ad.next()) {
										    if (iAD%8==0) {
											    rsb.append("<tr>\r\n");
											    rsb.append("<td width=\"12%\" height=\"50\" align=\"center\" valign=\"middle\" class=\"textS1\"><strong>"+type_name[typeid]+"</strong></td>\r\n");
											  	rsb.append("<td width=\"11%\" align=\"center\" valign=\"middle\"><a href=\""+rs_ad.getString("url")+"\" target=\"_blank\"><img src=\"../admin/ad_images/"+rs_ad.getString("ad_logo")+"\" width=\"97\" height=\"36\" border=\"0\" class=\"boxline2\" /></a></td>\r\n");
											  } else {
											  	rsb.append("<td width=\"11%\" align=\"center\" valign=\"middle\"><a href=\""+rs_ad.getString("url")+"\" target=\"_blank\"><img src=\"../admin/ad_images/"+rs_ad.getString("ad_logo")+"\" width=\"97\" height=\"36\" border=\"0\" class=\"boxline2\" /></a></td>\r\n");
											  }
											  if (iAD==7 || iAD==14 || iAD==21 || iAD==28) {
											    rsb.append("</tr>\r\n");
											  }
											  iAD++;
										}
										
										for (int iAppend=iAD%8;iAppend<8;iAppend++) {
										  	rsb.append("<td width=\"11%\" align=\"center\" valign=\"middle\">&nbsp;</td>\r\n");
										}
										if (iAD%8>0) {
										  	rsb.append("</tr>\r\n");
										}
							    	if(rs_ad != null) rs_ad.close();
								
							 } catch (Exception ex) {
      					    System.out.println("查询广告商信息失败:" + ex.toString());
               }
	  	 
					}			
								
	  
     	
			FileReader fr=new FileReader("D:\\www\\eng.chncup.com\\2008.chncup.com\\template\\bottom_index.html");
			BufferedReader br=new BufferedReader(fr);
	
			String path_htm="D:\\www\\eng.chncup.com\\2008.chncup.com\\";
			File d=new File(path_htm);
		  if(!d.exists()) {
			   d.mkdir();
		  }
			FileWriter fw = new FileWriter("D:\\www\\eng.chncup.com\\2008.chncup.com\\bottom_index.html");
		
  
	    int find=-1;
	    int replen=0;
	    int jump=0;
	    String sTemp="";
	    String sTempAll="";

			String flag_string="";
			String Line=br.readLine();
  
			while(Line!=null)
			{
				find=Line.indexOf("<!--#ad_info//-->");
			    if (find!=-1){
				   flag_string="<!--#ad_info//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+rsb.toString()+Line.substring(find+jump+replen);
				}
				fw.write(Line);
				Line=br.readLine();
			}

			fr.close();
			fw.close();
			//out.println("<a href=\"/bottom.html\">页尾</a>");
     	//生成文件结束 
     	
     	//out.println(rsb.toString());
      rsb.delete(0,rsb.length()); 
      rsb = null;
      String url = "/bottom_index.html";
      String message = "发布成功!";
  
%>
<!--<br><br><input onclick="javascript:window.history.back()" name=submit type=button value="返 回">-->
<script language="javascript">
	function process ( message,url){
		alert(message);
		self.location = url;
	}
</script>
<SCRIPT language="JavaScript" src="../scripts/util.js"></SCRIPT>
<HTML>
<HEAD>
<TITLE>页尾内容发布</TITLE>
</HEAD>
	<body onload="javascript: process('<%=message%>','<%=url%>');">
</body>
</html>