delmail.jsp

一个Java网络OA办公系统。安装非常方便

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ include file="../conn/conn.jsp"%>
<%@ include file="checksession.jsp"%>
<%
	String[] ids =  request.getParameterValues("id");
	if(ids==null || ids.length==0 ){
%>
		<script language=JavaScript>{window.alert('请选择信息再操作!');window.history.go(-1);}</script>
<%
	}else{

		String Sql = "delete from mail where id ";

		StringBuffer idstr=new StringBuffer();
		for(int i=0;i<ids.length;i++){
			if(i!=0) idstr.append(",");
				idstr.append(ids[i]);
		}
		if(ids.length==1){
			Sql+="="+ids[0];
		}else{
			Sql+=" in ("+idstr.toString()+")";
		}
		//out.println(Sql);
		stmt = con.createStatement() ;
		stmt.executeUpdate( Sql );
	response.sendRedirect("mysendmail.jsp?space=9.0");
	}

%>