📄 search.jsp
字号:
<%@ page language="java" import="java.util.*"%>
<%@ page import="java.sql.*,java.util.*,java.io.*" %>
<%@ include file="conn.jsp"%>
<%@ include file="util.jsp"%>
<%
String value=(String)request.getParameter("value");
String sql = null;
java.sql.ResultSet rs = null;
sql="select count(*) from txl_view t where t.company_name like '%"+value+"%' or t.unit_name like '%"+value+"%' or t.depart_name like '%"+value+"%' or t.name like '%"+value+"%' or t.post like '"+value+"' or t.phone like '%"+value+"%' or t.email like '%"+value+"%' or t.mobile like '%"+value+"%' or t.address like '%"+value+"%' or t.remark like '%"+value+"%'";
rs = st.executeQuery(sql);
rs.next();
int row = rs.getInt(1);
sql="select * from txl_view t where t.company_name like '%"+value+"%' or t.unit_name like '%"+value+"%' or t.depart_name like '%"+value+"%' or t.name like '%"+value+"%' or t.post like '"+value+"' or t.phone like '%"+value+"%' or t.email like '%"+value+"%' or t.mobile like '%"+value+"%' or t.address like '%"+value+"%' or t.remark like '%"+value+"%'";
rs = st.executeQuery(sql);
%>
<html>
<head>
<title>检索结果</title><head>
<style type="text/css"><!-- .font9pt{font-family:"宋体";font-size:9pt;font-style:normal;line-height:15pt;color:#000000} a:hover{color:red;text-decoration:underline}a:link{text-decoration:none} --> </style>
</head>
</head>
<body text="#000000">
<table align="center" boder=1 width="95%" class="font9pt"><tr><td><table align="left" width="50%" class="font9pt"><tr><td>共有<font color=#880000> <b><%=row%></b></font>个符合条件的文档<br></td>
</tr></table></td><td><table align="right" width="50%" class="font9pt"><td><a href="index.jsp">返回</td></tr></table></td></tr><tr bgcolor="#CCCCCC"><td COLSPAN=2 height="2" ></td></tr></table>
<table width="95%" border="0" bgcolor="white" align="center" class="font9pt"></table><table width="95%" border="0" bgcolor="white" align="center" class="font9pt">
<!--ddd-->
<%
if(row<60){
while(rs.next()){
%>
<TR vAlign=top Width="100%"><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("CODE"))%> </TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("UNIT_NAME"))%> </TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("DEPART_NAME"))%> </TD><TD bgColor="#f7f7e0"></TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("NAME"))%> </TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("POST"))%> </TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("MOBILE"))%> </TD><TD bgColor="#f7f7e0"></TD><TD bgColor="#f7f7e0"><%=NullToBlank(rs.getString("PHONE"))%> </TD><TD bgColor="#f7f7e0"></TD><TD bgColor="#f7f7e0"><a href='mailto:zhangligui@chinamobile.com'><%=NullToBlank(rs.getString("EMAIL"))%> </TD><TD width=38 bgColor="#f7f7e0"><A HREF="userdetail.jsp?id=<%=NullToBlank(rs.getString("ID"))%>" TARGET="_blank">[查看]</TD></TR>
<%}}%>
<!--ddd-->
<TR bgcolor="#CCCCCC"><TD colSpan=19 height="1"></TD></TR></TABLE>
</TABLE></div>
</body>
</html>
<%
rs.close();
st.close();
con.close();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -