⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 del.jsp

📁 是一个客户管理系统
💻 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)
{%>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<span lang="zh-cn"><a href="check.jsp">返回首页</a></span><FORM action="deldata.jsp" method=post name=form>
&nbsp;<span lang="zh-cn">输入要删除的用户帐号</span>:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" name="id" size="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" value="提交" name="sumbit"></p>
　</p>

<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</p>
<p>　</p>
   </FORM> 



<%  

    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();
         rs1=sql1.executeQuery("SELECT * FROM customer");
         out.print("<Table Border>");
         out.print("<TR>");
            out.print("<TH width=100>"+"用户帐号"); 
            out.print("<TH width=100>"+"用户姓名");
            out.print("<TH width=100>"+"家庭住址");
            out.print("<TH width=100>"+"家庭电话");
            out.print("<TH width=100>"+"传真号码");
            out.print("<TH width=100>"+"电子油箱");
            out.print("<TH width=100>"+"备注");
         out.print("</TR>");
       while(rs1.next())
       { out.print("<TR>");
             out.print("<TD >"+rs1.getInt("custid")+"</TD>");
             out.print("<TD >"+rs1.getString(2)+"</TD>");
             out.print("<TD >"+rs1.getString(3)+"</TD>"); 
             out.print("<TD >"+rs1.getString(4)+"</TD>");
             out.print("<TD >"+rs1.getString(5)+"</TD>");
             out.print("<TD >"+rs1.getString(6)+"</TD>");
             out.print("<TD >"+rs1.getString(7)+"</TD>");     
        out.print("</TR>") ; 
        }
        out.print("</Table>");
        con1.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 + -