%@include file="inc/setRegion.jsp" %>
<%@include file="inc/tag.inc" %>
<%
String pageFile = "support";// distinguish page set
sidename = "tech";// distinguish page set
String vid_str = request.getParameter("vendorid");
String sid_str = request.getParameter("seriesid");
String bid_str = request.getParameter("boardid");
// Retrieve all motherboard vendors
LinkedList vendors = MotherboardVendorUtil.getAllMotherboardVendors();
MotherboardVendor mv = null; // motherboard vendor
LinkedHashSet mbsrs = null; // all motherboard series
// MotherboardSeries ms = null; // motherboard series
// LinkedHashSet mbs = null; // all motherboards
Motherboard mb = null; // motherbaord
String title = "SERVER BOARD GUIDES";
// Get Vendor ID , id = 0 if request did not send vendorid
int vid = 0;
if (vid_str != null && vid_str.trim().length() > 0 )
{
try{
vid = Integer.parseInt(vid_str);
} catch (NumberFormatException e ) { e.printStackTrace() ; response.sendRedirect("../../error.jsp");}
}
if (vendors != null && vid > 0)
{
for (Iterator it = vendors.listIterator(); it.hasNext(); )
{
com.cidesign.bean.MotherboardVendor vendor = (com.cidesign.bean.MotherboardVendor) it.next();
if (vendor.getId() == vid){ mv = vendor ; break; }
}
}
if (mv != null)
{
//System.out.println(mv.getMotherboardSeries().getClass());
mbsrs = (java.util.LinkedHashSet) mv.getMotherboardSeries();
title = mv.getName().toUpperCase() + "®" + "SERVER BOARDS";
}
// Get board ID , id = 0 if request did not send motherboard id
int bid = 0;
if (bid_str != null && bid_str.trim().length() > 0)
{
try{
bid = Integer.parseInt(bid_str);
} catch (NumberFormatException e ) { e.printStackTrace() ; response.sendRedirect("error.jsp");}
}
if (bid > 0)
{
mb = com.cidesign.bean.Motherboard.read(bid);
}
String mbName = "";
String mbDesc = "";
String mbUrl = "";
String mbImg = "";
if (mb != null)
{
mbName = mb.getName();
mbDesc = mb.getDescription() == null ? "" : mb.getDescription();
mbUrl = mb.getUrl().replaceAll ("\"", "\\\"").replaceAll ("\'", "\\\'");
mbImg = mb.getImg() == null ? "imgs/no_image.gif" : mb.getImg().replaceAll ("\"", "\\\"").replaceAll ("\'", "\\\'");
title = mv.getName().toUpperCase() + "® " + mbName.toUpperCase() ;
}
//System.out.println(title);
//////////////////////////////////////////////////////////////////////////////////////////
Connection conn = null;
Statement stmt = null;
Statement stmt2 = null;
ResultSet res = null;
try {
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:comp/env");
DataSource ds = (javax.sql.DataSource)envContext.lookup("jdbc/cidesign");
conn = ds.getConnection();
stmt = conn.createStatement();
String referer = request.getHeader("referer");
String currentUrl = request.getServletPath();
String clientIp = request.getRemoteAddr();
currentUrl = currentUrl.substring (1,currentUrl.length());
if (referer == null) referer = currentUrl;
// retrieve product information
String sql = " SELECT * " +
" FROM testing_referer " +
" WHERE url = \'"+ currentUrl +"\' " +
" AND referer = \'"+ referer +"\' " +
" AND clientIp = \'" + clientIp + "\' " ;
//System.out.println("-------------------------------------------------------");
//System.out.println(sql);
stmt.execute(sql);
res = stmt.getResultSet();
if (res != null && res.next())
{
String sqlStmt =
" UPDATE testing_referer SET cnt = cnt + 1 " +
" WHERE url = \'"+ currentUrl +"\' " +
" AND referer = \'"+ referer +"\' " +
" AND clientIp = \'" + clientIp + "\' " ;
//System.out.println(sqlStmt);
stmt.executeUpdate(sqlStmt);
}
else
{
String sqlStmt =
" INSERT INTO testing_referer (url, referer, clientIp, cnt) " +
" VALUES ( \'"+ currentUrl +"\' , \'"+ referer +"\',\'"+ clientIp +"\', 1) ";
//System.out.println(sqlStmt);
stmt.executeUpdate(sqlStmt);
}
} catch(Exception e)
{
e.printStackTrace() ;
} finally {
if (res != null ) {res.close();}
if (stmt != null) {stmt.close();}
if (conn != null) {conn.close();}
}
if (vendors != null)
{
%>
Technical Support / Server Board Compatibility Guide
<%
//If Len(Request("btnDisplay_RackServers")) > 0 Then
if (mb != null)
{
%>
Compatible Chassis
<%
LinkedHashSet chs = (LinkedHashSet) mb.getProducts(); // get compatible chassis
if (chs.size() == 0)
{
%>
No Compatible Chassis Available at this moment.
Please check back later.
<%
}
else
{
%>
<%
int i = 0;
%>
<%
for (Iterator it3 = chs.iterator(); it3.hasNext(); )
{
i++;
if ( i == 1 ) {
%>
<%
} // end if i = 1
//System.out.println((Motherboard) it3.next());
ProductDetail chassis = (ProductDetail) it3.next();
int pid = chassis.getProductID();
String model = chassis.getModel();
String cat = chassis.getCategory().getCategory();
String img = chassis.getImgFilePrefix() == null ?
"imgs/no_image.gif" : "product/" + cat+ "/" + chassis.getImgFilePrefix() + "thumb.jpg" ;
String sdesc = chassis.getSdescription() == null ? "" : chassis.getSdescription();
String sum = chassis.getSummary() == null ? "" : chassis.getSummary();
boolean newRelease = (chassis.getNewRelease() == 1 );
%>
» <%=model%>
<% if (newRelease) { %>
<%}%>
<%=sdesc%>
|
<%
if (i == 3 ){
%>
 |
<%
i = 0;
}
%>
<%
} // end for each chassis
if (i < 3 && i != 0)
{
for (i = i + 1 ; i <= 3 ; i++)
{
%>
|
<%
}
%>
 |
<%
} // end if i < 3
%>
|
<%
}// if has compatible chassis
} // end if server board is retrieved.
%>
<%@include file="rightmenu.jsp"%>
<%@include file="us/usfooter.jsp"%>