_add_0content__jsp.java

JSP聊天系统

/*
 * JSP generated by Resin 2.1.2 (built Tue Jun 11 08:26:56 PDT 2002)
 */

package _admin._guestbook;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.sql.*;
import org.ehotsoft.yekki.sql.SQLFacade;
import org.ehotsoft.yekki.util.*;
import org.ehotsoft.yekki.sql.Pager;

public class _add_0content__jsp extends com.caucho.jsp.JavaPage{
  private boolean _caucho_isDead;
  
  public void
  _jspService(javax.servlet.http.HttpServletRequest request,
              javax.servlet.http.HttpServletResponse response)
    throws java.io.IOException, javax.servlet.ServletException
  {
    com.caucho.jsp.QPageContext pageContext = (com.caucho.jsp.QPageContext) com.caucho.jsp.QJspFactory.create().getPageContext(this, request, response, null, true, 8192, true);
    javax.servlet.jsp.JspWriter out = (javax.servlet.jsp.JspWriter) pageContext.getOut();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    javax.servlet.http.HttpSession session = pageContext.getSession();
    javax.servlet.ServletContext application = pageContext.getServletContext();
    response.setContentType("text/html;charset=gb2312");
    request.setCharacterEncoding("GB2312");
    try {
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
      pageContext.write(_jsp_string0, 0, _jsp_string0.length);
                   
	String act =  ParamUtil.getStringParameter( request , "action" );
	SQLFacade sqlOper = new SQLFacade();
    String htm_script = "";

	try{
		if( act.equals("")){
			htm_script= "<script>history.back();</script>";
			out.print( htm_script );
		}
		if( act.equals("addnew") ){
		
			String content = request.getParameter("content");
			String guest_name = request.getParameter("guest_name");
			content = StringUtil.replace( content , "'","‘" );
			content = StringUtil.replace( content , " ","&nbsp;" );
			content = StringUtil.replace( content , "\r\n","<p>" );
			content = StringUtil.replace( content , "\n","<br>" );
			guest_name = StringUtil.replace( guest_name , "'","‘" );
	    	
			String sql = "insert into tbl_appeal_message ( id , nickname,ask,answer,is_valid )"+
	             " values( seq_appeal.nextVal , '"+guest_name+"','"+content+"','',3 )";
			// is_valid--3, means that no-display in index.jsp or show.jsp 
			sqlOper.executeUpdate( sql );				 
			out.print( "<script>window.location='add_finish.jsp'</script>" );
    	}
		
		if( act.equals("showtitle") ){
		    //used for index.jsp page , -- home page 
			StringBuffer sb = new StringBuffer();
			sb.append( "<table width=\"100%\" border=\"0\" cellspacing=\"1\">" );
			String sql = "select id,ask,answer from tbl_appeal_message where is_valid in ( 1,2 ) ";
			// is_valid = 1 means that it can be displayed on homepage( index.jsp )
			
			ResultSet rs = sqlOper.executeQuery( sql );
			
			String ask="",ask_bak="",answer="";
			int id=0;
			int counter = 0 ;
			while( rs.next() && counter< 10 ){
				ask = rs.getString( "ask" );
				ask_bak = ask ;
				
				if( ask.length() > 20 ){
					ask = ask.substring( 0,20 );
				}else{
					for( int i =0 ; i< 20-ask_bak.length();i=i+2){
						ask = ask+".";
						
					}
				}
				//complete the list title style
				answer = rs.getString( "answer" );
				ask_bak = ask+"《＝》"+StringUtil.nullToString(answer) ;
				id = rs.getInt( "id" );
				sb.append( "<tr><td><a href=\"/guestbook/showContent.jsp?id="+id+"\" title="+
                           ask_bak+" target=\"_blank\">"+ask+"</a></td><tr>"); 
				counter++;
			}
			
			sb.append( "</table>");
			out.print( "document.write(' "+sb.toString()+"');" );
		}
		if( act.equals("show") ){
		//used for show guest book page
			StringBuffer sb = new StringBuffer();
			//String page_num = request.getParameter("page_no");
			String sql = "select * from tbl_appeal_message where is_valid in( 0,2 ) ",temp="";
			// is_valid =0 , means that display on the show.jsp 
			// 2 means that display on both show.jsp and index.jsp
			Pager mypage = sqlOper.executePage( request, sql,5 );
			ResultSet rs = mypage.getResultSet();
			sb.append( "<table border=\"0\" cellspacing=\"1\">" ) ;
			while( rs.next() ){
				sb.append( "<tr><td>"+StringUtil.nullToString(rs.getString("ask"))+"</td></tr>" );
				sb.append( "<tr><td>"+ StringUtil.nullToString(rs.getString("answer"))+
				           "</td></tr>" );
				temp = StringUtil.nullToString( rs.getString( "nickname" ));
				if(  temp.equals( "" ) ){
					temp = "匿名";
				}
				sb.append( "<tr><td align=\"right\">---"+temp+"</td></tr>");
			}
			sb.append( "<tr><td>共计&nbsp;"+mypage.getPageCount()+"&nbsp;" );
			sb.append( "&nbsp;<a href=show.jsp?action="+act+"&page_no=1 >开始</a>&nbsp;" );
			if( mypage.getAbsolutePage() > 1 ){
				sb.append( "&nbsp;<a href=\"show.jsp?action="+act+"&page_no="+
                          (mypage.getAbsolutePage()-1)+"\">上一页</a>&nbsp;" );
			}
			sb.append( "&nbsp;当前页:"+mypage.getAbsolutePage()+"/"+mypage.getPageCount()
                       +"&nbsp;" );
			if( mypage.getAbsolutePage() < mypage.getPageCount() ){
				sb.append( "&nbsp;<a href=\"show.jsp?action="+act+"&page_no="+
                          (mypage.getAbsolutePage()+1)+"\">下一页</a>&nbsp;" );
			}
			sb.append( "&nbsp;<a href=show.jsp?action="+act+"&page_no="+
			           mypage.getPageCount()+ " >结束</a>&nbsp;" );
			out.print( "document.write( '" + sb.toString()+ "');");
		}
			if( act.equals("manage_center") ){
		//used for show guest book page
			String show_level[] ={"二级页面","首页","全显","不显示"}; 
			StringBuffer sb = new StringBuffer();
			//String page_num = request.getParameter("page_no");
			String sql = "select * from tbl_appeal_message",temp="";
			Pager mypage = sqlOper.executePage( request, sql,5 );
			ResultSet rs = mypage.getResultSet();
			sb.append( "<table border=\"0\" cellspacing=\"0\">" ) ;
			while( rs.next() ){
				sb.append( "<tr><td>提问：</td><td>"+
                           StringUtil.nullToString(rs.getString("ask"))+"</td></tr>" );
				sb.append( "<tr><td>答复：</td><td>"+ StringUtil.nullToString(rs.getString("answer"))+
				           "</td></tr>" );
				sb.append( "<tr><td align=\"left\">显示范围：</td><td>"+show_level[ rs.getInt("is_valid") ]+"</td></tr>");
				temp = StringUtil.nullToString( rs.getString( "nickname" ));
				if(  temp.equals( "" ) ){
					temp = "匿名";
				}
				sb.append( "<tr><td>笔名:</td><td>"+temp+"</td></tr>");
				sb.append( "<tr><td></td><td><a href=show.jsp?action=manage_center&page_no="+
                       mypage.getAbsolutePage()+"&todo=answer&sid="+rs.getInt("id")
					   +" >回复</a>&nbsp;<a href=show.jsp?action=manage_center&page_no="+
					   mypage.getAbsolutePage()+"&todo=del&sid="+rs.getInt("id")
                       +">删除</a>&nbsp;<a href=show.jsp?action=manage_center&page_no="+
                       mypage.getAbsolutePage()+"&todo=showModel&sid="+rs.getInt("id")
					   +">修改</td></tr>" );
				sb.append( "<tr ><td bgcolor=\"#000000\" height=\"1\"></td><td bgcolor=\""+
                           "#000000\" height=\"1\"></td></tr>" );
			}
			sb.append( "<tr><td>共计&nbsp;"+mypage.getPageCount()+"&nbsp;" );
			sb.append( "&nbsp;<a href=show.jsp?action="+act+"&page_no=1 >开始</a>&nbsp;" );
			if( mypage.getAbsolutePage() > 1 ){
				sb.append( "&nbsp;<a href=\"show.jsp?action="+act+"&page_no="+
                          (mypage.getAbsolutePage()-1)+"\">上一页</a>&nbsp;</td>" );
			}
			sb.append( "<td>&nbsp;当前页:"+mypage.getAbsolutePage()+"/"+mypage.getPageCount()
                       +"&nbsp;" );
			if( mypage.getAbsolutePage() < mypage.getPageCount() ){
				sb.append( "&nbsp;<a href=\"show.jsp?action="+act+"&page_no="+
                          (mypage.getAbsolutePage()+1)+"\">下一页</a>&nbsp;" );
			}
			sb.append( "&nbsp;<a href=show.jsp?action="+act+"&page_no="+
			           mypage.getPageCount()+ " >结束</a>&nbsp;</td></tr>" );
			out.print( "document.write( '" + sb.toString()+ "');");
		}
	
	}
	finally{
		sqlOper.close();
	}

      pageContext.write(_jsp_string1, 0, _jsp_string1.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
    }
  }

  private com.caucho.java.LineMap _caucho_line_map;
  private java.util.ArrayList _caucho_depends = new java.util.ArrayList();

  public boolean _caucho_isModified()
  {
    if (_caucho_isDead)
      return true;
    if (com.caucho.util.CauchoSystem.getVersionId() != 2057024144)
      return true;
    for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
      com.caucho.vfs.Depend depend;
      depend = (com.caucho.vfs.Depend) _caucho_depends.get(i);
      if (depend.isModified())
        return true;
    }
    return false;
  }

  public long _caucho_lastModified()
  {
    return 0;
  }

  public com.caucho.java.LineMap _caucho_getLineMap()
  {
    return _caucho_line_map;
  }

  public void destroy()
  {
      _caucho_isDead = true;
      super.destroy();
  }

  public void init(com.caucho.java.LineMap lineMap,
                   com.caucho.vfs.Path appDir)
    throws javax.servlet.ServletException
  {
    com.caucho.vfs.Path resinHome = com.caucho.util.CauchoSystem.getResinHome();
    com.caucho.vfs.MergePath mergePath = new com.caucho.vfs.MergePath();
    mergePath.addMergePath(appDir);
    mergePath.addMergePath(resinHome);
    mergePath.addClassPath(getClass().getClassLoader());
    _caucho_line_map = new com.caucho.java.LineMap("_add_0content__jsp.java", "/test/admin/guestbook/add_content.jsp");
    _caucho_line_map.add(6, 1);
    _caucho_line_map.add(2, 32);
    com.caucho.vfs.Depend depend;
    depend = new com.caucho.vfs.Depend(appDir.lookup("admin/guestbook/add_content.jsp"), 1029485543649L, 7025L);
    _caucho_depends.add(depend);
  }

  private static byte []_jsp_string1;
  private static byte []_jsp_string0;
  static {
    try {
      _jsp_string1 = "\r\n\r\n\r\n".getBytes("GB2312");
      _jsp_string0 = "\r\n".getBytes("GB2312");
    } catch (java.io.UnsupportedEncodingException e) {
      e.printStackTrace();
    }
  }
}