mmedit.jsp

来自「网络自动化办公系统」· JSP 代码 · 共 28 行

<%@ page contentType="text/html;charset=gb2312" %><%@ include file="check.jsp" %>

<script language=javascript src="mouse.js"></script>

<%
if(String.valueOf(session.getAttribute("Urule")).compareTo("a")!=0){
	response.sendRedirect ("error.jsp?id=admin");
}

String sql = "";
String op = "9";
if( request.getParameter("op")!=null){
	op = request.getParameter("op");
}

if( op.compareTo("3")==0){
	sql="DELETE from bumen where ID="+request.getParameter("id");
}else if( op.compareTo("2")==0){
	sql = "update bumen set type='"+sqlbean.to_8859_1(request.getParameter("type"))+"' where ID="+request.getParameter("id");
}else if( op.compareTo("1")==0){
    sql="insert into bumen (type) values('"+sqlbean.to_8859_1(request.getParameter("type"))+"')"; 
}
sqlbean.executeUpdate(sql);
sqlbean.close();
//out.println(sql);
response.sendRedirect("mm.jsp");
%>