jsp search

来源：互联网发布：淘宝试衣服软件叫什么编辑：程序博客网时间：2024/05/29 09:29

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import = "java.sql.*" %>
<%request.setCharacterEncoding("UTF-8");%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <LINK rel=stylesheet type=text/css href="pattern/login.css">
 <title>查询结果</title>
 </head>

<body bgcolor="#3C3C3C">

<img src="pattern/banner_result.jpg">
 您选择的查询条件为：
<%
String[] re = request.getParameterValues("re");
String sqlplus="";
if(re != null) {
for(int i = 0;i<re.length;i++) {
request.setCharacterEncoding("UTF-8");
 if(re[i].equals("PersonID")) {
 out.println(" 会员ID为 "+(String)request.getParameter("PersonID"));
 sqlplus+=" AND dbo.person.PersonID="+"'"+(String)request.getParameter("PersonID")+"'";
 }
 if(re[i].equals("PersonName")) {
 out.println(" 会员姓名为 "+(String)request.getParameter("PersonName"));
 sqlplus+=" AND dbo.person.PersonName="+"'"+(String)request.getParameter("PersonName")+"'";
 }
 if(re[i].equals("Sex")) {
 out.println(" 会员性别为 "+(String)request.getParameter("Sex"));
 sqlplus+=" AND dbo.person.Sex="+"'"+(String)request.getParameter("Sex")+"'";
 }
 if(re[i].equals("Mobile")) {
 out.println(" 会员电话为 "+(String)request.getParameter("Mobile"));
 sqlplus+=" AND dbo.person.Mobile="+"'"+(String)request.getParameter("Mobile")+"'";
 }
 if(re[i].equals("Level")) {
 out.println(" 会员等级为 "+(String)request.getParameter("Level"));
 sqlplus+=" AND dbo.person.Rank="+"'"+(String)request.getParameter("Level")+"'";
 }
 if(re[i].equals("Date")) {
 out.println(" 发卡日期为 "+(String)request.getParameter("Date"));
 sqlplus+=" AND dbo.person.RegDate="+"'"+(String)request.getParameter("Date")+"'";
 }
 if(re[i].equals("Remain")) {
 out.println(" 卡内余额为 "+(String)request.getParameter("Remain"));
 sqlplus+=" AND dbo.work.Remain="+"'"+(String)request.getParameter("Remain")+"'";
 }
}
}
%>
的会员。
 查询结果如下： 
<%
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=CRC";
String userName = "admin";
String password = "123";
Connection conn = null;
Statement stm = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}catch(Exception e) {
out.println("加载驱动器类出现异常");
}
try {
conn = DriverManager.getConnection(url, userName, password);
//创建statement语句
stm = conn.createStatement();
String sql = "SELECT dbo.person.PersonID, dbo.person.PersonName, dbo.person.Sex, dbo.person.Birthday, dbo.person.Mail, dbo.person.RegDate, dbo.person.Rank, dbo.person.Interest, dbo.person.Mobile, dbo.work.Charge, dbo.work.Spend, dbo.work.Remain FROM dbo.person,dbo.work WHERE dbo.person.PersonID=dbo.work.PersonID"+sqlplus;

//使用executeQuery执行SQL查询语句
ResultSet rs = stm.executeQuery(sql);
%>
<table border="1" cellspacing="0" cellpadding="6">
<tr>
<td width="120" align="center" valign="middle">ID</td>
<td width="200" align="center">姓名</td>
<td width="120" align="center">性别</td>
<td width="253" align="center">出生日期</td>
<td width="253" align="center">电子邮箱</td>
<td width="253" align="center">发卡日期</td>
<td width="120" align="center">等级</td>
<td width="253" align="center">爱好</td>
<td width="253" align="center">联系电话</td>
<td width="120" align="center">充值</td>
<td width="120" align="center">消费</td>
<td width="120" align="center">余额</td>
</tr>
<%
//显示返回结果集
while(rs.next()) {
String id = rs.getString(1);
String name = rs.getString(2);
String sex = rs.getString(3);
String born=rs.getString(4);
String mail=rs.getString(5);
String date=rs.getString(6);
String rank=rs.getString(7);
String inter=rs.getString(8);
String mob=rs.getString(9);
String charge=rs.getString(10);
String spend=rs.getString(11);
String remain=rs.getString(12);

%>
<tr>
<td height="40" align="center" valign="middle"><%=id%></td>
<td align="center" valign="middle"><%=name%></td>
<td align="center" valign="middle"><%=sex%></td>
<td align="center" valign="middle"><%=born%></td>
<td align="center" valign="middle"><%=mail%></td>
<td align="center" valign="middle"><%=date%></td>
<td align="center" valign="middle"><%=rank%></td>
<td align="center" valign="middle"><%=inter%></td>
<td align="center" valign="middle"><%=mob%></td>
<td align="center" valign="middle"><%=charge%></td>
<td align="center" valign="middle"><%=spend%></td>
<td align="center" valign="middle"><%=remain%></td>
</tr>
<%
}
rs.close();
stm.close();
%>
</table>
<%
}catch(Exception e) {
out.println("出现SQL异常");
}finally {
//关闭语句和数据库连接
try {
 if(conn != null) {
 conn.close();
 }
}catch(Exception e) {
 out.println("关闭数据库连接异常");
}
}
%>
 
<div class=login-btn align="center">
<form method="get" >
<input type="submit" value="ToExcel" name="submit">
</form>
<input type="button" value="继续查询" onClick="javascript:location.href='chaxun.jsp'">
</div>

<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

String str = request.getParameter("submit");
if(str == null) {
str = "";
}
if(str.equals("ToExcel")) {
response.setContentType("application/vnd.ms-excel;charset=UTF-8");//设置输出数据的类型
}
%>
</body>
</html>