<%@ page import="com.mypm.utilities.*" %> <%@ page import="java.util.*" %> <%@ page import="com.ftz.database.*" %> <%@ page import="java.sql.Connection" %> <%@ page import="java.sql.Statement" %> <%@ page import="java.sql.ResultSet" %> <%@ page import="com.ftz.utilities.HTMLUtility" %> <% //System.out.println(request.getServerName() + " " + request.getHeader("Referer") ); %> <% String page1 = request.getParameter("page1"); if( page1 == null ) page1 = "1"; %> <% String page2 = request.getParameter("page2"); if( page2 == null ) page2 = "1"; page2="1"; %> <% String pageDetail1 = request.getParameter("pagedetail1"); if( pageDetail1 == null ) pageDetail1 = page1; %> <% String pageDetail2 = request.getParameter("pagedetail2"); if( pageDetail2 == null ) pageDetail2 = page2; %> <% int pd1 = 0; int pd2 = 1; try { pd1 = Integer.parseInt(pageDetail1); } catch (NumberFormatException nfe) { System.out.println("pageview.jsp NumberFormatException pageDetail1="+pageDetail1); } try { pd2 = Integer.parseInt(pageDetail2); } catch (NumberFormatException nfe) { System.out.println("pageview.jsp NumberFormatException pageDetail2="+pageDetail2); } Vector catg = new Vector(); int displayPage1 = pd1 % 50; int displayPage2 = pd2; %> <% boolean isPowell = false; if( pd1 >= 8000 ) isPowell = true; %> <% String refer = request.getHeader ("Referer"); //refer = "http://www.google.as/search?test=0&q=lm11cn&utf=10"; String url = "http://www.freetradezone.com/servlet/Login?iqformat=html&iqdtdtype=0"; String searchPart = ""; int amp= -1; //System.out.println("\n\nstep1 refer --->" + refer + "\n"); if( refer != null ) { if( refer.indexOf("google") > 0 || refer.indexOf("altavista") > 0 || refer.indexOf("msn") > 0 ) { int startPart = refer.indexOf("&q="); if(startPart < 0) startPart = refer.indexOf("?q="); if(startPart > 0) { searchPart = refer.substring(startPart+3,refer.length()); if(searchPart != null) { amp = searchPart.indexOf("&"); if(amp > 0) { searchPart = searchPart.substring(0,amp); } } } } if( refer.indexOf("yahoo") > 0 ) { int startPart = refer.indexOf("&p="); if(startPart < 0) startPart = refer.indexOf("?p="); if(startPart > 0) { searchPart = refer.substring(startPart+3,refer.length()); if(searchPart != null) { amp = searchPart.indexOf("&"); if(amp > 0) { searchPart = searchPart.substring(0,amp); } } } } if( refer.indexOf("hotbot") > 0 || refer.indexOf("netscape") > 0 || refer.indexOf("lycos") > 0 ) { int startPart = refer.indexOf("&query="); if(startPart < 0) startPart = refer.indexOf("?query="); if(startPart > 0) { searchPart = refer.substring(startPart+7,refer.length()); if(searchPart != null) { amp = searchPart.indexOf("&"); if(amp > 0) { searchPart = searchPart.substring(0,amp); } } } } } if ("thomasB2B".equals(request.getParameter("referer"))) { searchPart = request.getParameter("searchpart"); if (searchPart == null || searchPart.length() <= 0) { searchPart = ""; } } //System.out.println("\n\nsearchpart--->" + searchPart + "\n"); %> <% if( !isPowell ){ %> <% } %>

<% } %> <% if( !isPowell ){ %> <% //if(searchPart.length() >3) { //if (searchPart == null || searchPart.length() <= 0) //{ /// searchPart = "111"; //} if(searchPart != null) { searchPart = searchPart.toUpperCase(); searchPart=java.net.URLDecoder.decode(searchPart); } if(!isPowell){ %> <% } else { if (searchPart == null || searchPart.length() <= 0) { searchPart = ""; //searchPart = searchPart.toUpperCase(); } if(searchPart != null && searchPart.trim().length() > 0) { %> <% } } %>   <% if( isPowell ){ %> Welcome to Powell.com Your Source for Electronic Component and Interconnect Knowledge, Inventory & Service. <% }else{ %> PartMiner, Inc Click here for Local Sales Offices Phone +1.800.969.2000 in North America. Phone +1.631.501.2800 outside North America <% }%>   Parts Catalog Home   <% int pageDis = 1; for (int kndex = 1; kndex < 5; kndex++) { %> <% for (int i=1;i<=10;i++) { %> <% pageDis++; } %> <% } %> page<%=pageDis %> <% Connection connection = null; Statement statement = null; ResultSet rs = null; try { if(request.getRemoteAddr() != null && request.getRemoteAddr().startsWith("216.185.59") ) { System.out.println(request.getRemoteAddr() + " -- Theif caught"); } else { Vector parts = new Vector(); connection = DBServer.getInstance().getConnection(); statement = connection.createStatement(); String sql = ""; if( pd1 < 5000) { sql = "SELECT * FROM CAPSPARTLIST WHERE ID >=" ; int lower = pd1 * 40000; int upper = pd2 * 1000 + lower; //int upper = displayPage2 * 500 + lower; sql = sql +(upper-1000) + " AND ID < " + upper; } else if( pd1 >= 8000) { int lower; int upper; if( pd1 < 8052 ){ sql = "SELECT * FROM POWELL_LIST WHERE ID >=" ; lower = (pd1-8000) * 40000; upper = pd2 * 1000 + lower; //int upper = displayPage2 * 500 + lower; }else{ sql = "SELECT RAW_PARTNUM as PARTNUM FROM POWELL_LIST WHERE ID >=" ; lower = (pd1-8052) * 40000; upper = pd2 * 1000 + lower; //int upper = displayPage2 * 500 + lower; } sql = sql +(upper-1000) + " AND ID < " + upper; }else if(pd1 < 8000 && pd1 >= 7000){ int lower; int upper; sql = "SELECT PARTNUM FROM EXCESSPARTLIST WHERE ID >=" ; lower = (pd1-7000) * 20000; upper = pd2 * 500 + lower; sql = sql +(upper-500) + " AND ID < " + upper; } else { if(pd1 > 5683) { sql = "SELECT * FROM SNDPARTLIST WHERE ID >=" ; int lower = (pd1 - 5000) * 40000; int upper = pd2 * 1000 + lower; sql = sql +(upper-1000) + " AND ID < " + upper; } else{ sql = "SELECT * FROM SNDPARTLIST_G WHERE ID >="; int lower = (pd1 - 5000) * 25800; int upper = pd2 * 645 + lower; sql = sql +(upper-645) + " AND ID < " + upper; } } //System.out.println(request.getRemoteAddr() + " " + refer+ " *****************"+ sql + "********************"); rs = statement.executeQuery(sql); int q = 0; int qq = 5; //System.out.println("sarchpart " + searchPart + "\n"); while(rs.next()) { String partnumber = rs.getString("PARTNUM"); if(partnumber != null && partnumber.trim().length() >= 5) { if (partnumber.trim().length() > 30 ) partnumber = partnumber.substring(0,30); if(searchPart != null && searchPart.trim().length() > 0) { %> <% } else { %> <% } } if(q == qq) { qq = qq + 5; %> <% } q++; } try {rs.close();} catch (Exception ignore) {} rs = null; //get the categories to be displayed for every 50 main pages if (displayPage1 == 0) { if (displayPage2 > 0 && displayPage2 < 10) { sql = "SELECT * FROM CATEGORY_LIST WHERE ID >=" ; int upper = displayPage2 * 50 + 1; int lower = upper - 50; sql = sql + lower + " AND ID < " + upper; rs = statement.executeQuery(sql); while(rs.next()) { catg.add( (String) rs.getString("CATEGORY_NAME") ); } try {rs.close();} catch (Exception ignore) {} rs = null; } } } } catch(Exception e) { System.out.println("Exception from pageview.jsp while getting results \n"); e.printStackTrace(System.out); } finally { try { if(rs != null) { rs.close(); rs = null; } } catch(Exception e) { //Ignore } try { if(statement != null) { statement.close(); statement = null; } } catch(Exception e) { //Ignore } try { if(connection != null) DBServer.releaseConnection(connection); } catch(Exception e) { System.out.println("Exception while releasing DB connection (Google pageview categories)" ); e.printStackTrace(System.out); } } %> <%= partnumber %> <%= partnumber %> <%= partnumber %> <%= partnumber %> <%= partnumber %> <%= partnumber %> <% if (catg.size() > 0 && !isPowell) { %> <% for (int i=0; i < catg.size(); i=i+6) //display categories in first 7 sub-pages { %> <% for(int j=i, k=0; j < catg.size() && k < 6; k++, j++) { %> <% } %> <% } %> <%= (String) catg.get(j)%> <% } %> <% //System.out.println("**** isPowell = " + isPowell + "****"); if( isPowell ){ %> <% connection = null; statement = null; rs = null; try { String powellKeyword = null; connection = DBServer.getInstance().getConnection(); statement = connection.createStatement(); int lower = ( pd2 % 11 ) * 200; int upper = lower + 200; String sql = "SELECT * FROM POWELL_KEYWORDS WHERE ID > " + lower + " AND ID <= " + upper; //System.out.println("**** lower = " + lower + "****"); //System.out.println("**** upper = " + upper + "****"); //System.out.println("**** sql = " + sql + "****"); rs = statement.executeQuery(sql); int q = 0; boolean closed = false; while(rs.next()) { powellKeyword = rs.getString("KEYWORD"); if( q%5 == 0 ){ closed = false; %> <% } %> <% if(q%5 == 4) { closed = true; %> <% } q++; } if( !closed ){ %> <% } try {rs.close();} catch (Exception ignore) {} rs = null; } catch(Exception e) { System.out.println("Exception from pageview.jsp while getting results \n"); e.printStackTrace(System.out); } finally { try { if(rs != null) { rs.close(); rs = null; } } catch(Exception e) { //Ignore } try { if(statement != null) { statement.close(); statement = null; } } catch(Exception e) { //Ignore } try { if(connection != null) DBServer.releaseConnection(connection); } catch(Exception e) { System.out.println("Exception while releasing DB connection (Google pageview powell keywords)" ); e.printStackTrace(System.out); } } %>   <%= powellKeyword %> <% } %> <% //} %> <% if (pd1 % 24 == 0 && !isPowell){ //display this message for every 24 main pages %> PartMiner, Inc. is a leading global supplier of electronic components and a cutting-edge online provider of component information needed by engineers and purchasers in the electronics industry and also a world-class provider of excess inventory management services and enterprise solutions. Partminer,electronic components, sourcing, electronic parts, chips,online services, obsolete, hard to find electronic components, Obsolescence, components, replacement parts, BOM Manager, Lifecycle forecast, electronic design, XML de livery of component inofrmation, obsolescence management, EOL, PCN, end of life, product change notice, datasheets, datasheet, param etric information, parametric search, manufacturer information electronic components, components, chips, partminer, hard to find parts, sourcing, electronic parts, Material Content, Lead free, Leadfree, ROHS, WEEE, ROHS COMPLIANCE, ROHS 2006, WEEE 2006. ROHS2006, weee2006, chips,online services, obsolete, hard to find electronic components, Obsolescence, components, replacement parts, BOM Manager, Lifecycle forecast, electronic design, XML delivery of component information, obsolescence management, EOL, PCN, end of life, product cha nge notice, datasheets, datasheet, parametric information, parametric search, manufacturer information, Distribution, ecommerce, E- commerce, Parts, Purchasing, Quote, RFQ, Sales, parts, distributor, semiconductors, components, military, government, chips, logisti cs, warehouse, ISO 9002, packaging, shipping, inventory, stocking distributor, modules, excess, excess management, purchasing, int ernational, partminer china, UK, united kingdom, germany, swedan, china, hongkong, israel,download datasheets, obsolete components, components, component, semiconductor distributors, electronic components, semiconductor distributors, integrated circuits, circuit board, transistor, capacitor, electronic components distributor, stocking distributors, chip brokers, semiconductors, components, re ctifier, ic's, PCB, printed circuit board, battery, circuitos integrados, DRAM, memory, CAPS,obsolete datasheets, part status, activ e datasheets, cross references, parametric search of electronic components, datasheet locator, electronic component datasheets, semi conductor datasheets, datasheet search engine, component engineer, electronic engineer, electronic engineering tools, supply managem ent tools, BOM management, forecasting information about electronic components. ROHS2006 ROHS COMPLIANCE WEEE2006 WEEE COMPLIANCE <% } %>