📄 clear.jsp
字号:
<%@ 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();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -