<%@ page import="java.sql.*" %> <%@ page import="java.net.*" %> <%! String login = "abid"; String pass = "ali12"; String no; String choice; String driver = "org.gjt.mm.mysql.Driver"; String protocol = "jdbc:mysql://localhost:3306/tracking2"; //String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; //String protocol = "jdbc:odbc:tracking2"; public boolean check; Connection c ; ResultSet rs; Statement s; PreparedStatement ps ; String query1; String query2; %> <% choice = request.getParameter("choice"); try{ Class.forName(driver).newInstance(); c = DriverManager.getConnection(protocol, login, pass); }catch(Exception e){ %> <% //out.println("class"+e.toString()); } try{ s=c.createStatement(); query1 = "Select * from schedule where sname = '" + choice + "' and vesselname='-'"; query2 = "Select * from schedule where sname = '" + choice + "' and vesselname<>'-'"; String querycomments = "Select comments from comments where sname = '" + choice + "'"; rs = s.executeQuery(querycomments); %>

Home    Freight Inquiry    Agency Co-operation    Site Map

<% while(rs.next()){ out.println(""); out.println(""); out.println(""); } rs = s.executeQuery(query1); %> "); out.println("" + rs.getString("comments") + ""); out.println(" <% while(rs.next()){ out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } rs = s.executeQuery(query2); while(rs.next()){ out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } }catch(Exception e){out.println(e.toString());} finally{rs.close(); c.close();} %> Vessel Name ETA Karachi ETD Karachi Port Name Mother Vessel ETA ETA ETA ETA ETA ETA ETA "); out.println(rs.getString("vesselname")); out.println(" "); out.println(rs.getString("etakarachi")); out.println(" "); out.println(rs.getString("etdkarachi")); out.println(" "); out.println(rs.getString("etaport1")); out.println(" "); out.println(rs.getString("vesselname2")); out.println(" "); out.println( rs.getString("etaport2")); out.println(" "); out.println( rs.getString("etaport3") ); out.println(" "); out.println( rs.getString("etaport4")); out.println(" "); out.println( rs.getString("etaport5") ); out.println(" "); out.println( rs.getString("etaport6")); out.println(" "); out.println( rs.getString("etaport7") ); out.println(" "); out.println( rs.getString("etaport8")); out.println(" "); out.println(rs.getString("vesselname")); out.println(" "); out.println(rs.getString("etakarachi")); out.println(" "); out.println(rs.getString("etdkarachi")); out.println(" "); out.println(rs.getString("etaport1")); out.println(" "); out.println(rs.getString("vesselname2")); out.println(" "); out.println( rs.getString("etaport2")); out.println(" "); out.println( rs.getString("etaport3") ); out.println(" "); out.println( rs.getString("etaport4")); out.println(" "); out.println( rs.getString("etaport5") ); out.println(" "); out.println( rs.getString("etaport6")); out.println(" "); out.println( rs.getString("etaport7") ); out.println(" "); out.println( rs.getString("etaport8")); out.println("

© Copyright 2003 Consolidation Shipping & Logistics All rights reserved Design & Developed by eLogix. .