<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %> <%@ include file="Connections/cnbxdb.jsp" %> <% String Recordset1__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset1__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset1 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset1 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset1__MMColParam + "10%' ORDER BY goodstop ASC"); ResultSet Recordset1 = StatementRecordset1.executeQuery(); boolean Recordset1_isEmpty = !Recordset1.next(); boolean Recordset1_hasData = !Recordset1_isEmpty; Object Recordset1_data; int Recordset1_numRows = 0; %> <% String Recordset2__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset2__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset2 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset2 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset2 = ConnRecordset2.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset2__MMColParam + "20%' ORDER BY goodstop ASC"); ResultSet Recordset2 = StatementRecordset2.executeQuery(); boolean Recordset2_isEmpty = !Recordset2.next(); boolean Recordset2_hasData = !Recordset2_isEmpty; Object Recordset2_data; int Recordset2_numRows = 0; %> <% String Recordset3__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset3__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset3 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset3 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset3 = ConnRecordset3.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset3__MMColParam + "30%' ORDER BY goodstop ASC"); ResultSet Recordset3 = StatementRecordset3.executeQuery(); boolean Recordset3_isEmpty = !Recordset3.next(); boolean Recordset3_hasData = !Recordset3_isEmpty; Object Recordset3_data; int Recordset3_numRows = 0; %> <% String Recordset4__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset4__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset4 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset4 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset4 = ConnRecordset4.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset4__MMColParam + "40%' ORDER BY goodstop ASC"); ResultSet Recordset4 = StatementRecordset4.executeQuery(); boolean Recordset4_isEmpty = !Recordset4.next(); boolean Recordset4_hasData = !Recordset4_isEmpty; Object Recordset4_data; int Recordset4_numRows = 0; %> <% String Recordset5__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset5__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset5 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset5 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset5 = ConnRecordset5.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset5__MMColParam + "50%' ORDER BY goodstop ASC"); ResultSet Recordset5 = StatementRecordset5.executeQuery(); boolean Recordset5_isEmpty = !Recordset5.next(); boolean Recordset5_hasData = !Recordset5_isEmpty; Object Recordset5_data; int Recordset5_numRows = 0; %> <% String Recordset6__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset6__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset6 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset6 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset6 = ConnRecordset6.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset6__MMColParam + "6%' ORDER BY goodstop ASC"); ResultSet Recordset6 = StatementRecordset6.executeQuery(); boolean Recordset6_isEmpty = !Recordset6.next(); boolean Recordset6_hasData = !Recordset6_isEmpty; Object Recordset6_data; int Recordset6_numRows = 0; %> <% String Recordset7__MMColParam = "10"; if (request.getParameter("id") !=null) {Recordset7__MMColParam = (String)request.getParameter("id");} %> <% Driver DriverRecordset7 = (Driver)Class.forName(MM_cnbxdb_DRIVER).newInstance(); Connection ConnRecordset7 = DriverManager.getConnection(MM_cnbxdb_STRING,MM_cnbxdb_USERNAME,MM_cnbxdb_PASSWORD); PreparedStatement StatementRecordset7 = ConnRecordset7.prepareStatement("SELECT * FROM goodsinfo WHERE goodsid LIKE '" + Recordset7__MMColParam + "70%' ORDER BY goodstop ASC"); ResultSet Recordset7 = StatementRecordset7.executeQuery(); boolean Recordset7_isEmpty = !Recordset7.next(); boolean Recordset7_hasData = !Recordset7_isEmpty; Object Recordset7_data; int Recordset7_numRows = 0; %> <% int Repeat1__numRows = 50; int Repeat1__index = 0; Recordset1_numRows += Repeat1__numRows; %> <% int Repeat2__numRows = 20; int Repeat2__index = 0; Recordset2_numRows += Repeat2__numRows; %> 中国人寿，中国人寿保险公司，中国人寿保险，保险公司，人寿保险，中国人寿保险股份有限公司,中国人寿保险保险公司北京市分公司，中国人寿保险公司北京分公司，中国人寿保险北京分公司，寿险，人寿，保险，保险法，服务，信息，养老险，养老保险，健康险，健康保险，分红险，分红保险，意外险，意外保险，团险，企业保险，中国人寿股份有限公司，招聘，求职，在线投保，保险咨询，保险业务，北京保险网，北京保险-投保热线:010-51661760 <%@include file="header.jsp" %>
<%@ include file="js/ind-2.jsp" %>
.gif"> <% if (!Recordset1_isEmpty ) { %>
保险公司: <%=(((Recordset1_data = Recordset1.getObject("goodsfirchar"))==null || Recordset1.wasNull())?"":Recordset1_data)%> 　　保险类别：保障保险
保 障 保 险您要负担的责任实在太多，让保障类保险为您承担那些无法完成的任务吧！
 <% while ((Recordset1_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset1_hasData = Recordset1.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset1_data = Recordset1.getObject("goodsname"))==null || Recordset1.wasNull())?"":Recordset1_data)%>
<% } /* end !Recordset1_isEmpty */ %> <% if (!Recordset2_isEmpty ) { %>
保险公司：<%=(((Recordset2_data = Recordset2.getObject("goodsfirchar"))==null || Recordset2.wasNull())?"":Recordset2_data)%> 　　保险类别：健康保险
健 康 保 险要想生病少花钱，健康保险来帮忙。生病、住院甚至出院疗养，保险公司都有可能给你经济补偿。
 <% while ((Recordset2_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset2_hasData = Recordset2.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset2_data = Recordset2.getObject("goodsname"))==null || Recordset2.wasNull())?"":Recordset2_data)%>
<% } /* end !Recordset2_isEmpty */ %> <% if (!Recordset3_isEmpty ) { %>
保险公司：<%=(((Recordset3_data = Recordset3.getObject("goodsfirchar"))==null || Recordset3.wasNull())?"":Recordset3_data)%>　　保险类别：意外保险
意 外 保 险意外天天有，风险处处在！有了意外险，出事不怕没人管！
 <% while ((Recordset3_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset3_hasData = Recordset3.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset3_data = Recordset3.getObject("goodsname"))==null || Recordset3.wasNull())?"":Recordset3_data)%>
<% } /* end !Recordset3_isEmpty */ %> <% if (!Recordset4_isEmpty ) { %>
保险公司：<%=(((Recordset4_data = Recordset4.getObject("goodsfirchar"))==null || Recordset4.wasNull())?"":Recordset4_data)%>　　保险类别：养老保险
养 老 保 险“退休后我要周游世界！”这个愿望不再是梦，因为有了养老保险，让你退休后还有稳定的生活来源。
 <% while ((Recordset4_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset4_hasData = Recordset4.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset4_data = Recordset4.getObject("goodsname"))==null || Recordset4.wasNull())?"":Recordset4_data)%>
<% } /* end !Recordset4_isEmpty */ %> <% if (!Recordset5_isEmpty ) { %>
保险公司：<%=(((Recordset5_data = Recordset5.getObject("goodsfirchar"))==null || Recordset5.wasNull())?"":Recordset5_data)%>　　保险类别：少儿保险
少 儿 保 险孩子是家长的梦，如何让他健康成长并接受良好的教育，少儿保险为你解决这个问题。
 <% while ((Recordset5_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset5_hasData = Recordset5.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset5_data = Recordset5.getObject("goodsname"))==null || Recordset5.wasNull())?"":Recordset5_data)%>
<% } /* end !Recordset5_isEmpty */ %> <% if (!Recordset6_isEmpty ) { %>
保险公司：<%=(((Recordset6_data = Recordset6.getObject("goodsfirchar"))==null || Recordset6.wasNull())?"":Recordset6_data)%>　　保险类别：投资型保险
投 资 型 保 险请个专业理财顾问到自己家里，享受投资获利的喜悦，同时还能拥有充足的保障，你还等什么呢？
 <% while ((Recordset6_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset6_hasData = Recordset6.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset6_data = Recordset6.getObject("goodsname"))==null || Recordset6.wasNull())?"":Recordset6_data)%>
<% } /* end !Recordset6_isEmpty */ %>
<% if (!Recordset7_isEmpty ) { %>
保险公司：<%=(((Recordset7_data = Recordset7.getObject("goodsfirchar"))==null || Recordset7.wasNull())?"":Recordset7_data)%>　　保险类别：女性保险
女 性 保 险当代新女性，需要健康的体魄！享受愉快人生，女性保险，防患于未然。
 <% while ((Recordset7_hasData)&&(Repeat1__numRows-- != 0)) { %> <% Repeat1__index++; Recordset7_hasData = Recordset7.next(); } %>
商 品 名 称
操 作
"><%=(((Recordset7_data = Recordset7.getObject("goodsname"))==null || Recordset7.wasNull())?"":Recordset7_data)%>
<% } /* end !Recordset7_isEmpty */ %>
<%@include file="bottom.jsp" %> <% Recordset1.close(); StatementRecordset1.close(); ConnRecordset1.close(); %> <% Recordset2.close(); StatementRecordset2.close(); ConnRecordset2.close(); %> <% Recordset3.close(); StatementRecordset3.close(); ConnRecordset3.close(); %> <% Recordset4.close(); StatementRecordset4.close(); ConnRecordset4.close(); %> <% Recordset5.close(); StatementRecordset5.close(); ConnRecordset5.close(); %> <% Recordset6.close(); StatementRecordset6.close(); ConnRecordset6.close(); %> <% Recordset7.close(); StatementRecordset7.close(); ConnRecordset7.close(); %>