<%    
    Set rc = Server.CreateObject("ADODB.Recordset")
    switch (request("action")){  
    case:"办公家具"
    sql = "select * from produce where News_Class = '办公家具' "
    case:"宾馆客房家具"
    sql = "select * from produce where News_Class = '宾馆客房家具' "
    case:"酒店家具"
    sql = "select * from produce where News_Class = '酒店家具' "
    case:"民用家具"
    sql = "select * from produce where News_Class = '民用家具' "
    case:"其他产品"
    sql = "select * from produce where News_Class = '其他产品' "
    default:
    sql = "select * from produce "
    }
    set rc = conn.Execute(sql)
%>