clear.jsp

来自「网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询」· JSP 代码 · 共 36 行

<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ include file="inc/conn1.jsp"%>
<%!
 int Cint(String cint)
   {
    try {
	  int n;
      n= Integer.parseInt(cint);
	  return n;
        }
       catch (NumberFormatException e) {
                 return 0;
        }
}
%>
<%
if(session.getAttribute("user_name")==null){
    out.print("你尚未登录或不是本站会员<br>请登录后再来订购本站货物！");
}else{
	 String user_name=(String)session.getValue("user_name");
	  if(request.getParameter("basket_id")==null){
	  sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
	  rs=stmt.executeQuery(sql);
                  while(rs.next()){
				 String sql1="delete * from basket where user_name='"+user_name+"' and basket_check=false";
				 stmt.executeUpdate(sql1);
				 }
		    }
				out.print("您的所有数据已删除!");
}

stmt.close();

%>