📄 deldata.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="10000";
}
int z=0;
int flag=0;
String temp=newid;
try{ z=Integer.valueOf(temp).intValue();
flag=1;
}
catch(NumberFormatException e)
{
flag=0;
}
%>
<%
Connection con1=null;
Statement sql1=null;
ResultSet rs1=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con1=DriverManager.getConnection("jdbc:odbc:mis");
sql1=con1.createStatement();
String condition="SELECT cname FROM customer WHERE custid = "+z;
rs1=sql1.executeQuery(condition);
if(!rs1.next())
{
out.print("该用户不存在，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=del.jsp>");
flag=0;
}
con1.close();
}
catch(SQLException e1) {}
%>
<%
Connection con2=null;
Statement sql2=null;
ResultSet rs2=null;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try { con2=DriverManager.getConnection("jdbc:odbc:mis");
sql2=con2.createStatement();
String condition2="SELECT pso FROM orderhead WHERE custid = "+z;
rs2=sql2.executeQuery(condition2);
if(rs2.next())
{
out.print("该用户存在定单，2秒后返回重新操作");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=del.jsp>");
flag=0;
}
con2.close();
}
catch(SQLException e1) {}
%>
<%
if(flag==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 condition1=
"DELETE FROM customer WHERE custid="+z;
sql.executeUpdate(condition1);
out.print("删除资料完成，2秒后返回管理页面");
out.print("<META HTTP-EQUIV=REFRESH CONTENT=2;url=check.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 + -