publish_index.jsp

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

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="beitian.db.*,java.sql.*" %>
<%@ include file="checkLogin.jsp" %>
<%@ page import="java.io.*" %>

<% 
      StringBuffer rsb = new StringBuffer(); 
				
			int position_id[] = new int[30];
	    String sTableContent[] = new String[30];
  		 Connection conn=null;
       Statement stm=null;
       
  		 
	 		/*DBOperation theDBOperation = null;
			DBConnection dbConnection = null;
			try{
           dbConnection = new DBConnection();
           conn = dbConnection.getConnection();
           stm = conn.createStatement();
      }catch(Exception ex){
          System.out.println("建立连接失败:" + ex.toString());
          ex.printStackTrace();
      }
      */
								
DBOperation theDBOperation = new DBOperation();
String sql = "select * from web_index";
ResultSet rs =theDBOperation.getResultSet(sql);
					
								
		/*	try {
			    theDBOperation = new DBOperation();
			}
      catch (Exception ex) {
        System.out.println("建立连接失败:" + ex.toString());
        ex.printStackTrace();
     }
     */
  	  String sql_position = "";
  	  int iRecord=1;
			try {
			    
			//for (int iRecord=1;iRecord<4;iRecord++) {    // for_start
			    
				    rsb.delete(0,rsb.length()); 
	  		    sql_position = "select * from web_index where position_id = "+ iRecord; 
				    //rs = theDBOperation.getResultSet(sql_position);
	          
	          //rs = stm.executeQuery(sql_position);
	          //System.out.println(sql_position);
	          
	          String url = "\""+rs.getString("url")+"\"";
					  if (rs.getString("target").equals("1")) {
						   url = url +" target=\"_blank\"";
						}
						
	      while (rs.next()) {
							     
	          switch (iRecord)  //  switch_start
				  	{   
				  	   case 1:        //1区左边图片
				      		rsb.append("<table width=\"146\" height=\"58\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">");
							    rsb.append("<tr>");
							    rsb.append("  <td><a href="+url+"><img src=\"/admin/index/images/"+rs.getString("pic")+"\" width=\"146\" height=\"58\" border=\"0\" class=\"boxline1\" /></a></td>");
							    rsb.append("</tr>");
							    rsb.append("</table>"); 								       
						      break;
					     
					     case 2:        //1区中间新闻标题
					        rsb.append("<a href="+url+" class=\"c-f\">"+rs.getString("name")+"</a>");
						      break;
					     
					     case 3:        //1区中间新闻
					       rsb.append("<tr>");
                  rsb.append("<td height=\"22\" align=\"left\" valign=\"middle\"><span class=\"textC_01\">·</span><a href="+url+" class=\"c-f\">"+rs.getString("name")+"</a></td>");
                  rsb.append("<td align=\"right\" valign=\"middle\" class=\"textC_01\">"+rs.getString("publish_date").substring(2,9)+"</td>");
                  rsb.append("</tr>");    
					        break;
					        
				
					      
					     }  //switch_end
					 }      //while_end
					 
					 sTableContent[iRecord] = rsb.toString();					     
			     //if(rs != null) rs.close();
			        
					   
			  // } // for_end  
      }
      catch (Exception ex) {
        System.out.println("查询一级菜单失败:" + ex.toString()+ " sql = "+sql);
        ex.printStackTrace();
     }      	
     
     	
			FileReader fr=new FileReader("f:\\wwwchncupcom\\template\\index.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\\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("<!--#position_1//-->");
			  if (find!=-1){
				   flag_string="<!--#position_1//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[1]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_2//-->");
			    if (find!=-1){
				   flag_string="<!--#position_2//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[2]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_3//-->");
			  if (find!=-1){
				   flag_string="<!--#position_3//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[3]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_4//-->");
			    if (find!=-1){
				   flag_string="<!--#position_4//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[4]+Line.substring(find+jump+replen);
				}
			
				
				find=Line.indexOf("<!--#position_5//-->");
			  if (find!=-1){
				   flag_string="<!--#position_5//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[5]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_6//-->");
			    if (find!=-1){
				   flag_string="<!--#position_6//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[6]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_7//-->");
			  if (find!=-1){
				   flag_string="<!--#position_7//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[7]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_8//-->");
			    if (find!=-1){
				   flag_string="<!--#position_8//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[8]+Line.substring(find+jump+replen);
				}
				
				
				find=Line.indexOf("<!--#position_9//-->");
			  if (find!=-1){
				   flag_string="<!--#position_9//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[9]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_10//-->");
			    if (find!=-1){
				   flag_string="<!--#position_10//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[10]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_11//-->");
			  if (find!=-1){
				   flag_string="<!--#position_11//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[11]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_12//-->");
			    if (find!=-1){
				   flag_string="<!--#position_12//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[12]+Line.substring(find+jump+replen);
				}
			
				
				find=Line.indexOf("<!--#position_13//-->");
			  if (find!=-1){
				   flag_string="<!--#position_13//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[13]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_14//-->");
			    if (find!=-1){
				   flag_string="<!--#position_14//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[14]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_15//-->");
			  if (find!=-1){
				   flag_string="<!--#position_15//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[15]+Line.substring(find+jump+replen);
				}
				
				find=Line.indexOf("<!--#position_16//-->");
			    if (find!=-1){
				   flag_string="<!--#position_16//-->";
				   jump=flag_string.length();
				   Line=Line.substring(0,find)+sTableContent[16]+Line.substring(find+jump+replen);
				}
				
				fw.write(Line);
				fw.write("\n\r");
				Line=br.readLine();
			}

			fr.close();
			fw.close();
			//out.println("<a href=\"/index.html\">页尾</a>");
     	//生成文件结束 
     	
     	//out.println(rsb.toString());
      rsb.delete(0,rsb.length()); 
      rsb = null;
      String url = "/index.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>