saveac.jsp

来自「叮当购物系统(ACCESS版): 主要功能: 客户在线购物, 管理员可发送」· JSP 代码 · 共 49 行

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="conn.jsp"%>
<%
if(session.getAttribute("admin_name")==null){
	;}else{

String action=request.getParameter("action");
int ac=0;
if(action.equals("add"))
ac=1;
if(action.equals("edit"))
ac=2;
if(action.equals("del"))
ac=3;

int link_id=Cint(request.getParameter("id"));
//int bs=Cint(request.getParameter("bs"));

switch(ac){
case 1:

String rg1=request.getParameter("passwordone");
String rg2=request.getParameter("passwordtwo");

sql="insert into admin (admin_name,admin_pass) values('"+getStr(request.getParameter("admin_name"))+"','"+rg1+"')";
mdb.executeInsert(sql);
//out.print("after operater!");
response.sendRedirect("ac.jsp");
//}

break;
//----------------------------------------
case 2:

sql="update admin set admin_name='"+getStr(request.getParameter("admin_name"))+"',admin_pass='"+getStr(request.getParameter("admin_pass"))+"' where admin_id="+link_id+"";
mdb.executeUpdate(sql);
response.sendRedirect("ac.jsp");
break;
//--------------------------------

case 3:
	sql="delete from admin where admin_id="+link_id+"";
mdb.executeDelete(sql);
response.sendRedirect("ac.jsp");

break;
}

	}%>