📄 publish_ad_info.jsp

📁 急着下个东西即然还要开通帐号
💻 JSP
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="beitian.db.*,java.sql.*,java.io.*" %>
<%@ include file="checkLogin.jsp" %>
<SCRIPT language="JavaScript" src="../scripts/util.js"></SCRIPT>
<HTML>
<HEAD>
<TITLE>页尾内容发布</TITLE>
</HEAD>
<BODY>
<%
	    
      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;
					theDBOperation = new DBOperation();
  				ResultSet 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");
			        	
         	      String sql_ad = "select * from ad_info where type_id ="+type_id[iRecord];
								ResultSet rs_ad = null;
								try{
										rs_ad =theDBOperation.getResultSet(sql_ad);
								} catch (Exception ex) {
      					}finally{
      					}
	  	
								int iAD=0;
		
		            System.out.println(sql_ad);
		            
								while(rs_ad.next()) {
										    if (iAD%9==0) {
											    rsb.append("<tr>\r\n");
											    rsb.append("<td width=\"12%\" height=\"50\" align=\"center\" valign=\"middle\" class=\"textS1\"><strong>"+type_name[iRecord]+"</strong></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==8 || iAD==16 || iAD==24 || iAD==32) {
											    rsb.append("</tr>\r\n");
											  }
											  iAD++;
										}
										
										for (int iAppend=iAD%9;iAppend<9;iAppend++) {
										  	rsb.append("<td width=\"11%\" align=\"center\" valign=\"middle\">&nbsp;</td>\r\n");
										}
										if (iAD%9>0) {
										  	rsb.append("</tr>\r\n");
										}
								}
								
								if(rs_ad != null) rs_ad.close(); 
		            iRecord++;
			      
				}   //while rs_type		
  	
	  
     	
			FileReader fr=new FileReader("f:\\wwwchncupcom\\template\\bottom.html");
			BufferedReader br=new BufferedReader(fr);
	
			String path_htm="f:\\wwwchncupcom\\";
			File d=new File(path_htm);
		  if(!d.exists()) {
			   d.mkdir();
		  }
			FileWriter fw = new FileWriter("f:\\wwwchncupcom\\bottom.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;
      
       
%>
<br><br><input onclick="javascript:window.history.back()" name=submit type=button value="返 回">
</BODY>
</HTML>
💿 文件大小 24 K
👤 上传用户 dtlyzx
📂 所属分类 Internet/网络编程
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -