📄 dcdeldata.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<HTML>
<BODY bgcolor=white><Font size=3>
<p>
<%!//处理字符串的一个常用方法：
public String getString(String s)
{ if(s==null) s="";
try {byte a[]=s.getBytes("ISO-8859-1");
s=new String(a);
}
catch(Exception e)
{ }
return s;
}
%>
<% String s1=response.encodeRedirectURL("check.jsp");
String s2=response.encodeRedirectURL("admin.jsp");
%>
<% //为了防止客户直接进入该页面，首先从session对象获取密码和帐号信息：
String name="",password="";
if(session.isNew())
{//如果直接进入该页面就再连接到登录页面：
response.sendRedirect("admin.jsp");
}
else
{ name=(String)session.getAttribute("name");
password=(String)session.getAttribute("password");
password=getString(password);
name=getString(name);
}
Connection con4=null;
Statement sql4=null;
ResultSet rs4=null;
boolean boo=false;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event){}
try { con4=DriverManager.getConnection("jdbc:odbc:mis");
sql4=con4.createStatement();
String condition9="SELECT * FROM admin WHERE adminname = "+"'"+name+"'";
rs4 =sql4.executeQuery(condition9);
while(rs4.next())
{ String n=rs4.getString("adminname");
String s=rs4.getString("adminpwd");
if(name.equals(n)&&password.equals(s))
{boo=true; break;
}
}
con4.close();
}
catch(SQLException e1) {}
%>
<%
if(boo)
{
String newid=request.getParameter("id");
if(newid==null)
{newid="";
}
int x=0;
int flag=1;
String temp=newid;
try{ x=Integer.valueOf(temp).intValue();
}
catch(NumberFormatException e)
{
flag=0;
out.print("用户id必须为数字字符，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=dcdel.jsp>");
}
String newpcode=request.getParameter("pid");
if(newpcode==null)
{newpcode="";
}
byte a[]=newpcode.getBytes("ISO-8859-1");
newpcode=new String(a);
String newcid=request.getParameter("cid");
if(newcid==null)
{newcid="";
}
byte b[]=newcid.getBytes("ISO-8859-1");
newcid=new String(b);
%>
<%
if(flag==1)
{
Connection con1=null;
Statement sql1=null;
ResultSet rs1=null;
int flag1=1;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con1=DriverManager.getConnection("jdbc:odbc:mis");
sql1=con1.createStatement();
String condition="SELECT price FROM pdiscount WHERE custid = "+x+"AND pcode='"+newpcode+"'AND colorid='"+newcid+"'";
rs1=sql1.executeQuery(condition);
if(!rs1.next())
{
out.print("该折扣不存在，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=dcdel.jsp>");
flag1=0;
}
con1.close();
}
catch(SQLException e1) {}
%>
<%
if(flag1==1)
{
Connection con=null;
Statement sql=null;
ResultSet rs=null;
boolean isEqual;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e2){}
try {
con=DriverManager.getConnection("jdbc:odbc:mis");
sql=con.createStatement();
String condition=
"DELETE FROM pdiscount WHERE custid="+x+"AND pcode='"+newpcode+"'AND colorid='"+newcid+"'";
sql.executeUpdate(condition);
out.print("客户折扣删除完成，2秒后返回折扣管理页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=discount.jsp>");
con.close();
}
catch(SQLException e1)
{ }
}
}
}
else
{
out.print("请先登陆，系统将于2秒钟后自动返回登陆页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=admin.jsp>");
}
%>
</FONT>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -