publish_menu.jsp

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

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="beitian.db.*,java.sql.*,java.io.*" %>
<%@ include file="checkLogin.jsp" %>
<%
	    
      StringBuffer rsb = new StringBuffer(); 
			StringBuffer rsb_sub = new StringBuffer(); 
				
			int menu_id[] = new int[30];
	    String menu_name[] = new String[30];
   		int iRecord=0;
			
			String sql_menu = "select * from view_www_menu_root";
			
	 		DBOperation theDBOperation = null;
			ResultSet rs_menu = null;
			ResultSet rs_submenu = null;
								
			try {
			    theDBOperation = new DBOperation();
			}
      catch (Exception ex) {
        System.out.println("建立连接失败:" + ex.toString());
        ex.printStackTrace();
     }
  
			try {
			    rs_menu = theDBOperation.getResultSet(sql_menu);
			
	  	    while (rs_menu.next()) {
					    menu_id[iRecord] = rs_menu.getInt("menu_id");
					    menu_name[iRecord] = rs_menu.getString("menu_name");
		        	iRecord++;
			        rsb.append("<td>"); 
	            rsb.append("<div align=\"center\"id=\"menubar_"+iRecord+"\" class=\"menubar\" onmouseover=\"menuControl(1)\" onmouseout=\"menuControl(0)\">"); 
	            rsb.append(menu_name[iRecord-1]);
	            rsb.append("</div>");
	            rsb.append("</td>");
			    }
			    if(rs_menu != null) rs_menu.close();
      }
      catch (Exception ex) {
        System.out.println("查询一级菜单失败:" + ex.toString());
        ex.printStackTrace();
     }      	
     
     
		 String sTopMenuTable = rsb.toString();
		 rsb.delete(0,rsb.length()); 
           
     for (int MainMenuID=0;MainMenuID<iRecord;MainMenuID++) {  
         	      
         	      String sql_submenu = "select * from view_www_menu_sub where parent_id =" + menu_id[MainMenuID];
         	      System.out.println(sql_submenu);
								try{
									
										rs_submenu =theDBOperation.getResultSet(sql_submenu);
							    	
							    	rsb_sub.append("<td>");
                    rsb_sub.append("<div align=\"left\"id=\"menu_"+(MainMenuID+1)+"\" class=\"menu\" onmouseover=\"keepMenu(this)\" onmouseout=\"hideMenu(this)\">"); 
                    rsb_sub.append("<table><tr>");
				             
								    while(rs_submenu.next()) {
										 //  rsb_sub.append("<tr><td><a href=\""+rs_submenu.getString("url")+"\">"+rs_submenu.getString("menu_name")+"</a></td></tr>");
                      rsb_sub.append("<td><a href=\""+rs_submenu.getString("url")+"\">"+rs_submenu.getString("menu_name")+"</a></td>");
                    }
									  
									 rsb_sub.append("</tr></table>");
                   rsb_sub.append("</div>"); 
                   rsb_sub.append("</td>"); 
                   //if(rs_submenu != null) rs_submenu.close();
							 } catch (Exception ex) {
      					    System.out.println("查询广告商信息失败:" + ex.toString());
               }
	  	        
		}			
		
     	
			FileReader fr=new FileReader("D:\\www\\eng.chncup.com\\2008.chncup.com\\template\\menu.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\\menu.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("<!--#menu_root//-->");
			    if (find!=-1){
				   flag_string="<!--#menu_root//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTopMenuTable+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#menu_sub//-->");
			    if (find!=-1){
				   flag_string="<!--#menu_sub//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+rsb_sub.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 = "/menu.html";
      String message = "发布成功!";
  
%>
<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>