<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" %> <%@ include file="../Connections/con_ro_mnsl.jsp" %> <% String rv__MMnid = "%"; if (request.getParameter("id") !=null) {rv__MMnid = delim((String)request.getParameter("id"));} %> <% String vessel="$$"; String rv__MMid = "%"; if (request.getParameter("vid") !=null) {rv__MMid = delim((String)request.getParameter("vid"));} %> <% Driver Driverrv = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrv = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrv = Connrv.prepareStatement("SELECT * FROM dbo.view_notice WHERE id like '"+rv__MMnid+"' and zz=1 and vid LIKE '" + rv__MMid + "' ORDER BY vid ASC",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrv.setFetchSize(0); Statementrv.setQueryTimeout(0); ResultSet rv = Statementrv.executeQuery(); boolean rv_isEmpty = !rv.next(); boolean rv_hasData = !rv_isEmpty; Object rv_data; int rv_numRows = 0; %> <% Driver Driverrt = (Driver)Class.forName(MM_con_ro_mnsl_DRIVER).newInstance(); Connection Connrt = DriverManager.getConnection(MM_con_ro_mnsl_STRING,MM_con_ro_mnsl_USERNAME,MM_con_ro_mnsl_PASSWORD); PreparedStatement Statementrt = Connrt.prepareStatement("SELECT * FROM dbo.view_vessels WHERE zz=1 ORDER BY cn ASC",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); Statementrt.setFetchSize(0); Statementrt.setQueryTimeout(0); ResultSet rt = Statementrt.executeQuery(); boolean rt_isEmpty = !rt.next(); boolean rt_hasData = !rt_isEmpty; Object rt_data; int rt_numRows = 0; %> <%! public String DoDateTime(java.lang.Object aObject,int nNamedFormat,java.util.Locale aLocale) throws Exception{ if ((aObject != null) && (aObject instanceof java.util.Date)){ if (aLocale!=null){ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat,aLocale); return df.format(aObject); } else{ java.text.DateFormat df = java.text.DateFormat.getDateInstance(nNamedFormat); return df.format(aObject); } } return ""; } %> MNSL - Vessel Position - <%=(rv_hasData&&request.getParameter("vid") !=null)?(((rv_data = rv.getObject("vn"))==null || rv.wasNull())?"":rv_data):""%>
<%@ include file="../pagenav.jsp" %>
Arrival Notice

 
 
<% if (!rv_isEmpty ) { %> <% } /* end !rv_isEmpty */ %> <% while (rv_hasData) { %> <%if(!vessel.equals((String)(((rv_data = rv.getObject("vn"))==null || rv.wasNull())?"":rv_data))){ vessel=(String)(((rv_data = rv.getObject("vn"))==null || rv.wasNull())?"":rv_data); %> <%}%> <% rv_hasData = rv.next(); } %>
<% if (!rv_isEmpty ) { %> <% } /* end !rv_isEmpty */ %> <% if (rv_isEmpty ) { %> Search returned no notices <% } /* end rv_isEmpty */ %>
Arrival Notice Update
<%=(((rv_data = rv.getObject("vn"))==null || rv.wasNull())?"":rv_data)%>
   ">schedule
<%=(((rv_data = rv.getObject("mn"))==null || rv.wasNull())?"":rv_data)%> :: <%=(((rv_data = rv.getObject("rn"))==null || rv.wasNull())?"":rv_data)%>
<%=Wrap(sString((String)(((rv.getObject("rm"))==null || rv.wasNull())?"":rv.getString("rm"))))%>		   <%= DoDateTime((((rv_data = rv.getObject("ed"))==null || rv.wasNull())?"":rv_data), java.text.DateFormat.SHORT, java.util.Locale.US) %>
   
 

 

 

 

 

 

 

 

 

 

 
<%@include file="../footer.jsp"%>
<%@ include file="../_notice.jsp" %> <% rv.close(); Statementrv.close(); Connrv.close(); %> <% rt.close(); Statementrt.close(); Connrt.close(); %>