商务搜索：公司版图、品牌搜索、产品搜索、商人搜索

<%@page language="java" contentType="text/html; charset=gb2312" %> <%@ page import="java.sql.*, javax.sql.*, javax.naming.*,com.icxo.userinfo.loginUserBean"%> <% Context ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("java:comp/env/jdbc/bizsearch"); Connection conn = ds.getConnection(); try { Statement stmt1 = conn.createStatement(); String sql1 = "select top 10 id,name from company where id<>0 order by creationDate desc"; ResultSet Recordset1 = stmt1.executeQuery(sql1); boolean Recordset1_isEmpty = !Recordset1.next(); boolean Recordset1_hasData = !Recordset1_isEmpty; Object Recordset1_data; int Recordset1_numRows = 0; int Repeat1__numRows = 10; int Repeat1__index = 0; Recordset1_numRows += Repeat1__numRows; Statement stmt2 = conn.createStatement(); String sql2 = "select top 10 id,name from brand order by creationDate desc"; ResultSet Recordset2 = stmt2.executeQuery(sql2); boolean Recordset2_isEmpty = !Recordset2.next(); boolean Recordset2_hasData = !Recordset2_isEmpty; Object Recordset2_data; int Recordset2_numRows = 0; int Repeat2__numRows = 10; int Repeat2__index = 0; Recordset2_numRows += Repeat2__numRows; Statement stmt3 = conn.createStatement(); String sql3 = "select top 10 id,name from product order by creationDate desc"; ResultSet Recordset3 = stmt3.executeQuery(sql3); boolean Recordset3_isEmpty = !Recordset3.next(); boolean Recordset3_hasData = !Recordset3_isEmpty; Object Recordset3_data; int Recordset3_numRows = 0; int Repeat3__numRows = 10; int Repeat3__index = 0; Recordset3_numRows += Repeat3__numRows; Statement stmt4 = conn.createStatement(); String sql4 = "select top 10 id,firstname+lastname from manager order by creationDate desc"; ResultSet Recordset4 = stmt4.executeQuery(sql4); boolean Recordset4_isEmpty = !Recordset4.next(); boolean Recordset4_hasData = !Recordset4_isEmpty; Object Recordset4_data; int Recordset4_numRows = 0; int Repeat4__numRows = 10; int Repeat4__index = 0; Recordset4_numRows += Repeat4__numRows; %> 商务搜索：公司版图、品牌搜索、产品搜索、商人搜索

公司
品牌
产品
商人

世界公司版图

世界品牌搜索

世界产品搜索

世界商人搜索

<% while ((Recordset1_hasData)&&(Repeat1__numRows-- != 0)) { %> &obj=company"> <%=(((Recordset1_data = Recordset1.getObject("name"))==null || Recordset1.wasNull())?"":(((String)Recordset1_data).length()>13?((String)Recordset1_data).substring(0,10)+"...":Recordset1_data))%>
<% Repeat1__index++; Recordset1_hasData = Recordset1.next(); } %>

<% while ((Recordset2_hasData)&&(Repeat2__numRows-- != 0)) { %> &obj=brand"> <%=(((Recordset2_data = Recordset2.getObject("name"))==null || Recordset2.wasNull())?"":(((String)Recordset2_data).length()>13?((String)Recordset2_data).substring(0,10)+"...":Recordset2_data))%>
<% Repeat2__index++; Recordset2_hasData = Recordset2.next(); } %>

<% while ((Recordset3_hasData)&&(Repeat3__numRows-- != 0)) { %> &obj=product"> <%=(((Recordset3_data = Recordset3.getObject("name"))==null || Recordset3.wasNull())?"":(((String)Recordset3_data).length()>13?((String)Recordset3_data).substring(0,10)+"...":Recordset3_data))%>
<% Repeat3__index++; Recordset3_hasData = Recordset3.next(); } %>

<% while ((Recordset4_hasData)&&(Repeat4__numRows-- != 0)) { %> &obj=manager"> <%=(((Recordset4_data = Recordset4.getObject(2))==null || Recordset4.wasNull())?"":(((String)Recordset4_data).length()>13?((String)Recordset4_data).substring(0,10)+"...":Recordset4_data))%>
<% Repeat4__index++; Recordset4_hasData = Recordset4.next(); } %>

<% Recordset1.close(); Recordset1=null; Recordset2.close(); Recordset2=null; Recordset3.close(); Recordset3=null; Recordset4.close(); Recordset4=null; stmt1.close(); stmt1=null; stmt2.close(); stmt2=null; stmt3.close(); stmt3=null; stmt4.close(); stmt4=null; } catch (SQLException e) { System.out.println("index.html@error:"+e.getMessage()); } finally { conn.close(); conn=null; } %>