post1.jsp

关于论坛的用jsp开发具有删除回复

<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<%
String title,strAuthor,content,picture,sj,sql,sign,sqlCalu;
String strAreaid="",strSignshow="";
int icons=0,intAreaid=0;
sign="";
picture=null;
strAuthor="";
content="";
title="";

strAreaid=(String)session.getValue("area_id");
if(strAreaid!=null&&!strAreaid.equals("0")){
  intAreaid=java.lang.Integer.parseInt(strAreaid); 
  }else{intAreaid=0;
       }

if(request.getParameter("task")!=null){
    strAuthor=(String)session.getValue("user");  
    String sqlSign="SELECT STR_SIGN FROM LOGIN WHERE STR_USER='"+strAuthor+"' ";
	ResultSet rs=DB.executeQuery(sqlSign);
	 if(rs.next()){
	   strSignshow=rs.getString("STR_SIGN");
	 }
	if(strSignshow==null){strSignshow="";} 
	rs.close();


  if(request.getParameter("title")!=null){ 
        title=(String)request.getParameter("title");
        title=doit.replace(title,true);
		
	     
			
              if(request.getParameter("content")!=null) {
                 content=(String)request.getParameter("content");
				 if (request.getParameter("htmltag")==null){
                     content=doit.replace(content,false);
				  } 
		        } else{
                       content="";
		               }
		 

      if (request.getParameter("R1")!=null){
          switch (java.lang.Integer.parseInt(request.getParameter("R1"))) {
              case 1:
	            icons=1;
	            break;
              case 2:
	            icons=2;
         	    break;
	          case 3:
         	    icons=3;
	            break;
              case 4:
        	    icons=4;
	            break;
              default:
        	    icons=5;
	            break;
	             }
            } else{ icons=5; 
             }

	    
 sql="INSERT INTO DATA (STR_IP,STR_TITLE,STR_AUTHOR,STR_DATE,TXT_CONTENT,INT_ICON,STR_SIGN,INT_AREAID,INT_ROOTID,INT_TXTLEN) VALUES ('"+ request.getRemoteAddr();
 sql=sql+"','"+title;
 sql=sql+"','" +strAuthor;
 sql=sql+"','"+doit.strNowtime();
 sql=sql+"','"+content;
 sql=sql+"',"+icons;
 sql=sql+",'"+strSignshow;
 sql=sql+"',"+intAreaid;
 sql=sql+",0";
 sql=sql+","+content.length()+")";
 DB.executeUpdate(sql);
 sqlCalu="UPDATE LOGIN SET INT_POSTNUMB=INT_POSTNUMB+1 WHERE STR_USER='"+strAuthor+"'";
 DB.executeUpdate(sqlCalu);
 String sqlArea="UPDATE AREA SET INT_ARTICLENUMB=INT_ARTICLENUMB+1 WHERE INT_AREAID="+intAreaid;
 DB.executeUpdate(sqlArea);
 
 if(strAuthor.equals("admin")){    
  response.sendRedirect("admin.jsp");  
 }else{response.sendRedirect("board.jsp");  
    }
 } 			
   else {out.print("Please Input A Title!!");
    } 
   
 }

%>