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

📄 a_memberdeleteshow.jsp

📁 酒店前台的JAVA
💻 JSP
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>后台 删除会员信息显示页面</title>
<STYLE>
    #Layer1 {
        Z-INDEX: 1;
        WIDTH: 118px;
        POSITION: absolute;
        HEIGHT: 28px
    }
    body {
	
    }
</STYLE>
</head>

<body>
<table style="FONT-SIZE: 14px; COLOR: #323229" width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#B98631">
  <tr>
    <th bgcolor="#B98631" scope="col">删除会员信息显示</th>
  </tr>
  <tr>
    <td>
	&nbsp;
	<% 
     String ID=request.getParameter("ID");
     if(ID==null)
     {  ID="";
     }
     byte b[]=ID.getBytes("ISO-8859-1");
     ID=new String(b); 
    
     Connection con=null;
     Statement sql=null;
     ResultSet rs=null;
     try{
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
         }
     catch(ClassNotFoundException event){}
     try{
             con=DriverManager.getConnection("jdbc:odbc:lzyHotel");
             sql=con.createStatement();
             
             rs=sql.executeQuery("SELECT * FROM member where ID='"+ID+"'");
             if(!rs.next())
             { 
               out.println("<script language='JavaScript'>");   
               out.println("alert('无此信息表!')");   
               out.println("history.go(-1)");   
               out.println("</script>");
             } 
             else{
             String deleteAll="DELETE FROM member where ID="+"'"+ID+"'";
             sql.executeUpdate(deleteAll);}
%>
         <span class="STYLE9">删除后的表</span>：
		 
<%           rs=sql.executeQuery("SELECT * from member");
             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("<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(rs.next())
             {   
                 out.print("<TR>");
                       out.print("<TD>"+rs.getString(1)+"</TD>");
                       out.print("<TD>"+rs.getString(2)+"</TD>");
                       out.print("<TD>"+rs.getString(3)+"</TD>");
                       out.print("<TD>"+rs.getString(4)+"</TD>");
                       out.print("<TD>"+rs.getString(5)+"</TD>");
                       out.print("<TD>"+rs.getString(6)+"</TD>");
					   out.print("<TD>"+rs.getString(7)+"</TD>");
                       out.print("<TD>"+rs.getString(8)+"</TD>");
                       out.print("<TD>"+rs.getString(9)+"</TD>");
                       out.print("<TD>"+rs.getString(10)+"</TD>");
                       out.print("<TD>"+rs.getString(11)+"</TD>");
                       out.print("<TD>"+rs.getString(12)+"</TD>");
                 out.print("</TR>");
              }
             out.print("</Table>");
             con.close();
        }
     catch(SQLException e1){out.print(e1);}
%></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -