【JSP开源代码栏目提醒】:网学会员,鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“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();
%>
上一篇:
class_list.jsp
下一篇:
asp论文:浅论ASP在多媒体网页课件制作中的应用