<%
    String returnvalue = request.getParameter("Trains");
    String args[] = returnvalue.split(",");
    int Train = Integer.parseInt(args[0]);
    String Trainname = args[1];
    String Source = args[2];
    String Dest = args[3];
    Date Dat = Date.valueOf(args[4]);
    int Distance = Integer.parseInt(args[5]);
    String tclass = args[6];
    int Fare;
    if (tclass.equals("SL")) {
        Fare = (int) (0.4 * Distance);
    } else if (tclass.equals("1A")) {
        Fare = (int) (2.1 * Distance);
    } else if (tclass.equals("2A")) {
        Fare = (int) (1.4 * Distance);
    } else if (tclass.equals("3A")) {
        Fare = (int) (0.9 * Distance);
    } else {
        Fare = (int) (2.2 * Distance);
    }
%>
<br>
<table style="font-size:10pt" width=600>
    <tr>
        <td><b>Train no     :</b></td>
        <td><%=Train%></td>
        <td><b>Train name   :</b></td>
        <td><%=Trainname%></td>
    </tr>
    <tr>
        <td><b>From         :</b></td>
        <td><%=Source%></td>
        <td><b>To           :</b></td>
        <td><%=Dest%></td>
    </tr>
    <tr>
        <td><b>Date         :</b></td>
        <td><%=Dat%></div></td>
        <td><b>Class        :</b></td>
        <td><%=tclass%></td>
    </tr>
    <tr>
        <td><b>Distance     :</b></td>
        <td><%=Distance%></div></td>
        <td><b>Fare         :</b></td>
        <td><%=Fare%></td>
    </tr>
</table>
<%
    try {
        Class.forName("oracle.jdbc.driver.OracleDriver"); // Oracle Driver
    } catch (java.lang.ClassNotFoundException e) {
        System.out.println("ClassNotFoundException: " + e.getMessage());
    }
    Connection con;
    PreparedStatement ps;
    ResultSet rs;
    int seats = 0;
    con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521/XE", "system", "hr");
    String insertStmt;
    if (tclass.equals("SL")) {
        insertStmt = "SELECT "SL" FROM SEATS WHERE trainno= ? AND dat = ?";
    } else if (tclass.equals("1A")) {
        insertStmt = "SELECT "1A" FROM SEATS WHERE trainno= ? AND dat = ?";
    } else if (tclass.equals("2A")) {
        insertStmt = "SELECT "2A" FROM SEATS WHERE trainno= ? AND dat = ?";
    } else if (tclass.equals("3A")) {
        insertStmt = "SELECT "3A" FROM SEATS WHERE trainno= ? AND dat = ?";
    } else {
        insertStmt = "SELECT "1C" FROM SEATS WHERE trainno= ? AND dat = ?";
    }
    ps = con.prepareStatement(insertStmt);
    ps.setInt(1, Train);
    ps.setDate(2, Dat);
    rs = ps.executeQuery();
    if (rs.next()) {
        seats = rs.getInt(1);
    }
    rs.close();
    ps.close();
    con.close();
%>
<br>
<b> Enter Passenger details : </b>
<form action="BookHandler23.jsp"/>
Name : <input type="text" name="pname" value="" size="30" />
Age  : <input type="text" name="age" value="" size="2" />
Sex  : <select name="sex">
    <option value="M">Male</option>
    <option value="F">Female</option>
</select>
<input type=text name="info" value="<%=Train + "," + Trainname + "," + Dat + "," + tclass + "," + Source + "," + Dest + "," + Distance + "," + Fare + "," + seats%>"/>

</td>