sheng.jsp

jsp+access开发的网上销售手机网站 1.进入“控制面板”-->管理工具”--->“数据源(ODBC)” 2.选择“用户DNS” 3.点击“添加”---〉选择驱动器“Mic

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

%>
<%@ include file="conn.jsp"%>
<%
if(request.getParameter("action").equals("up")){

int user_id=Integer.parseInt(request.getParameter("user_id"));
    sql="select user_type from member where user_id="+user_id+"";
    rs=mdb.executeQuery(sql);
	 if(!rs.next())
        out.print("<center>没有此用户信息!");
    else{
sql="update member set user_type='VIP' where user_id="+user_id+"";
mdb.executeUpdate(sql);
out.print("用户升级为VIP会员成功!");
	}
}
mdb.Close();
	}
%>