?? clear.jsp
字號:
<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="mdb" class="ckstudio.db.faq" scope="page"/>
<%!
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){
String sql="select * from basket where user_name='"+user_name+"' and basket_check=false";
ResultSet rs=mdb.executeQuery(sql);
if(!rs.next()){
;
}
else{
rs.previous();
while(rs.next()){
String sql1="delete from basket where user_name='"+user_name+"' and basket_check=false";
mdb.executeDelete(sql1);
}
}
}else{
int basket_id=Cint(request.getParameter("basket_id"));
String sql2="select * from basket where basket_id="+basket_id+"";
ResultSet rs1=mdb.executeQuery(sql2);
if(!rs1.next()){
;
}else{
rs1.previous();
while(rs1.next()){
String sql1="delete from basket where basket_id="+basket_id+"";
mdb.executeDelete(sql1);
}
}
}
response.sendRedirect("buy.jsp");
mdb.Close();
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -