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

📄 a_memberqueryshow.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" align="center" cellpadding="0" cellspacing="0" bordercolor="#B98631">
  <tr>
    <th align="left" bgcolor="#B98631" scope="col">&nbsp;后台 会员信息查询显示</th>
  </tr>
  <tr>
    <td>
<% String p=request.getParameter("p");
   if(p==null)
   {p="";
   } 
   String name=request.getParameter("name");
   if(name==null)
   {name="";
   }
   byte c[]=name.getBytes("ISO-8859-1");
   name=new String(c);
     
   Connection con;
   Statement sql;
   ResultSet rs;
   try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       }
   catch(ClassNotFoundException event){}
   try{
           con=DriverManager.getConnection("jdbc:odbc:lzyHotel");
           sql=con.createStatement();
           String condition="";
           if(p.equals("1"))
           {
           condition="SELECT * FROM member where id='"+name+"'";
           }
           else if(p.equals("2"))
           {	
           condition="SELECT * FROM member where name='"+name+"'";
           }            
%>
             <P>&nbsp;您查询的信息为：
<% 
           rs=sql.executeQuery(condition);
           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("</TR>");
             while(rs.next())
             {   
                 out.print("<TR>");
                       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 + -