jsp文章内容管理与删除代码

jsp文章内容管理与删除代码


  需求信息管理

---

<%
String op;
String delID = request.getParameter("ID");
op = request.getParameter("op");
if(op==null){
 op = "my";
}

if (request.getParameter("submitedit") !=null){
 String namea=new String(request.getParameter("name").getBytes("iso-8859-1"));
 String notea=new String(request.getParameter("note").getBytes("iso-8859-1"));
 String linka=new String(request.getParameter("link").getBytes("iso-8859-1"));
 String pica=new String(request.getParameter("img").getBytes("iso-8859-1"));
 Statement stmt_ADD=conn.createStatement();
 stmt_ADD.executeUpdate("Update hl_links Set Name='"+namea+"',Noten='"+notea+"',Link='"+linka+"',pic='"+pica+"' where ID="+delID);
 stmt_ADD.close();
 out.print(""); 
return ;
}
if (op.equals("del") && delID!=null){

 Statement stmt_ChannelDEL=conn.createStatement();
 String Sql="delete from hl_msg where ID="+delID;
 int shan=stmt_ChannelDEL.executeUpdate(Sql);
  if (shan>0){
   out.print(""); 
  }
 stmt_ChannelDEL.close();

 return ;
}
if (op.equals("look") && delID!=null){
 Statement stmte=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
 String Sqle="Select * from hl_msg where ID="+delID;
 ResultSet Rse=stmte.executeQuery(Sqle);
 if(Rse.next()) {
%>

                   
                     
                     
                   
                   
                     
                     
                   
                   
                     
                     
                   
                   
                     
                     
                   
                   
                     
                     
                   
                   
                     
                     
                   
                  
                     
                       
                     

               

需求产品：	<%=Rse.getString("ssname")%> —                       <%=Rse.getString("product")%>
需求量：	<%=Rse.getString("xq")%>
联系人：	<%=Rse.getString("name")%>
联系电话：	<%=Rse.getString("tel")%>
联系地址：	<%=Rse.getString("address")%>
简要说明：	<%=Rse.getString("resumes")%>
返回  &op=del">删除

<%
 }
 Rse.close();
 stmte.close();
 return ;
}
if (op.equals("add")){
%>

           
               
                 
                 
               
               
                 
                 
               
               
                 
                 
               
             
           
           
           
             
             
               
                 
               
             

网站名称
网站介绍
连接地址
相关图片：

   

<%
 return ;
}
%>

<%
RsF.close();
stmt3.close();
conn.close();
%>