{ results.put("train_id",rs.getString("train_id")); results.put("train_tt_id",Integer.parseInt(rs.getString("train_tt_id"))); results.put("train_name",rs.getString("train_name")); results.put("train_no",rs.getString("train_no")); results.put("train_from",Integer.parseInt(rs.getString("train_from"))); results.put("train_to",Integer.parseInt(rs.getString("train_to"))); results.put("train_deaprture",rs.getString("train_deaprture")); results.put("train_arrival",rs.getString("train_arrival")); results.put("train_travel_time",rs.getString("train_travel_time")); results.put("train_total_distance",rs.getString("train_total_distance")); count++; } if(count==0) { results.put("train_id",""); results.put("train_tt_id",0); results.put("train_name",""); results.put("train_no",""); results.put("train_from",0); results.put("train_to",0); results.put("train_deaprture",""); results.put("train_arrival","");
Page - 109
results.put("train_travel_time",""); results.put("train_total_distance",""); } } catch(Exception e) {System.out.println("Error is: "+ e); }
return results; }
/// Update the Train ////
public String updateTrain(HashMap trainData) {
String SQL = "UPDATE train SET train_tt_id = ?, train_name = ?, train_no = ?, train_from = ?, train_to = ?,train_deaprture = ?,train_arrival = ?,train_travel_time = ?,train_total_distance = ? WHERE train_id = ?;"; String error = ""; int record=0; try { pstmt = connection.prepareStatement(SQL); pstmt.setString(1,(String) trainData.get("train_tt_id")); pstmt.setString(2,(String) trainData.get("train_name")); pstmt.setString(3,(String) trainData.get("train_no"));
Page - 110
pstmt.setString(4,(String) trainData.get("train_from")); pstmt.setString(5,(String) trainData.get("train_to")); pstmt.setString(6,(String) trainData.get("train_deaprture")); pstmt.setString(7,(String) trainData.get("train_arrival")); pstmt.setString(8,(String) trainData.get("train_travel_time")); pstmt.setString(9,(String) trainData.get("train_total_distance")); pstmt.setString(10,(String) trainData.get("train_id")); record = pstmt.executeUpdate(); pstmt.close(); connection.close(); } catch(Exception e) {StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer ); e.printStackTrace( printWriter );
printWriter.flush();
String stackTrace = writer.toString(); error+="Error : "+stackTrace;
System.out.println(" Error : "+ e.toString()); }
return error; }
Page - 111
public ArrayList getAllTrain() {
String SQL = "SELECT * FROM `train`,`city`,`train_type` WHERE train_tt_id = tt_id AND train_from = city_id";
int count=0;
ArrayList resultArray = new ArrayList(); try { statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next()) {
HashMap results = new HashMap();
results.put("train_id",rs.getString("train_id")); results.put("train_tt_id",Integer.parseInt(rs.getString("train_tt_id"))); results.put("train_name",rs.getString("train_name")); results.put("train_from_city",rs.getString("city_name")); results.put("train_no",rs.getString("train_no")); results.put("train_type",rs.getString("tt_name")); results.put("train_from",Integer.parseInt(rs.getString("train_from"))); results.put("train_to",Integer.parseInt(rs.getString("train_to"))); count++; resultArray.add(results); } } catch(Exception e)
Page - 112
{
System.out.println("Error is: "+ e); }
return resultArray; }
////////////////Function for getting all the Trains for the Route//////////////////// public ArrayList filterTrain(String fromStation, String toStation)
{
String SQL = "SELECT * FROM `train_type`,`train_route`,`train`,`city` WHERE tr_from_station = city_id AND train_tt_id = tt_id AND train_id = tr_train_no AND tr_from_station = "+fromStation+" AND tr_to_station = "+toStation;
int count=0; String error = "";
ArrayList resultArray = new ArrayList(); try { statement = connection.createStatement(); rs = statement.executeQuery(SQL); while(rs.next()) {
HashMap results = new HashMap();
results.put("tr_train_no",rs.getString("tr_train_no"));
results.put("tr_from_station",rs.getString("tr_from_station"));
results.put("tr_to_station",Integer.parseInt(rs.getString("tr_to_station")));
Page - 113
results.put("tr_ac3_fare",rs.getString("tr_ac3_fare")); results.put("tr_ac2_fare",rs.getString("tr_ac2_fare")); results.put("tr_ac1_fare",rs.getString("tr_ac1_fare")); results.put("tr_distance",rs.getString("tr_distance")); results.put("train_no",rs.getString("train_no")); results.put("train_name",rs.getString("train_name")); results.put("train_from_city",rs.getString("city_name")); results.put("tr_id",rs.getString("tr_id")); results.put("train_id",rs.getString("train_id")); results.put("train_type",rs.getString("tt_name")); results.put("tr_from_arrival",rs.getString("tr_from_arrival")); results.put("tr_from_departure",rs.getString("tr_from_departure")); count++; resultArray.add(results); } } catch(Exception e) {HashMap results = new HashMap(); StringWriter writer = new StringWriter();
PrintWriter printWriter = new PrintWriter( writer ); e.printStackTrace( printWriter );
printWriter.flush();
Page - 114
error+="Error : "+stackTrace; results.put("error",e.toString()); resultArray.add(results); } return resultArray; }/////Function for Getting the List of Train Types//////////// public String getTrainTypeOption(Integer SelID)
{
int selectedID = SelID.intValue();
return Connect.getOptionList("train_type","tt_id","tt_name","tt_id,tt_name",selectedID,"1"); }
/////Function for Getting the List of Cities//////////// public String getCityOption(Integer SelID) {
int selectedID = SelID.intValue();
return Connect.getOptionList("city","city_id","city_name","city_id,city_name",selectedID,"1"); }
/////Function for Getting the List of Trains//////////// public String getTrainOption(Integer SelID)
{
int selectedID = SelID.intValue();
return Connect.getOptionList("train","train_id","train_no","train_id,train_no",selectedID,"1"); }
Page - 115
Coding for Contact-Us.jsp<%@ include file="includes/header.jsp" %> <div class="wrapper row3">
<div class="rounded">
<main class="container clear"> <!-- main body -->
<div id="comments" style="width: 70%; float:left; margin-`right:30px"> <h2>Contact Us Form</h2>
<form action="contact-confirmation.jsp" method="post"> <div>
<label for="email">Name <span>*</span></label>
<input type="text" name="email" id="email" value="" size="22" required> </div>
<div>
<label for="email">Email<span>*</span></label>
<input type="text" name="email" id="email" value="" size="22" required> </div>
<div>
<label for="email">Phone<span>*</span></label>
<input type="text" name="email" id="email" value="" size="22" required> </div>
<div>
<label for="email">Subject<span>*</span></label>
Page - 116
</div> <div>
<label for="email">Message<span>*</span></label>
<textarea name="comment" id="comment" cols="25" rows="5" required></textarea> </div>
<div class="block clear"></div> <div>
<input name="submit" type="submit" value="Submit">
<input name="reset" type="reset" value="Reset Form"> </div>
</form> </div>
<div style="float: left">
<div><img src="images/save_1.jpg" style="width: 250px"></div><br> <div><img src="images/save_2.jpg" style="width: 250px"></div> </div> <div class="clear"></div> </main> </div> </div> <%@ include file="includes/footer.jsp" %> Coding for Employee.jsp
Page - 117
<%@ page import= "java.util.*" %> <%@ page import= "Model.*" %> <%
Employee employeeDetails = new Employee();
int employee_id = Integer.parseInt(request.getParameter ("employee_id")); String male = "";
String female = "";
HashMap Values = employeeDetails.getEmployeeDetails(employee_id); if(Values.get("employee_gender").equals("Male")) { male = "Selected"; } else if(Values.get("employee_gender").equals("Female")) { female = "Selected"; } %> <script> jQuery(function() {
jQuery( "#employee_dob" ).datepicker({ changeMonth: true,
changeYear: true, yearRange: "-50:-18", dateFormat: 'd MM,yy' });
Page - 118
}); </script>
<div class="wrapper row3"> <div class="rounded">
<main class="container clear"> <!-- main body -->
<div id="comments" style="width: 70%; float:left; margin-right:30px"> <h2>Registration Form</h2>
<% if(request.getParameter("msg") != null) { %>
<div class="msg"><%=request.getParameter("msg") %></div> <% } %>
<form action="model/employee.jsp" method="post"> <div class="one_third first">
<label for="email">Salution <span>*</span></label>
<select style="height: 40px; width:200px" name="employee_sal" required>
<% out.print(employeeDetails.getSalutionOption((Integer) Values.get("employee_sal"))); %> </select>
</div>
<div class="one_third">
<label for="email">Employee Status<span>*</span></label>
<select style="height: 40px; width:200px" name= "employee_status" id = "employee_status" required>
<% out.print(employeeDetails.getStatusOption((Integer) Values.get("employee_status"))); %>
</select> </div>
Page - 119
<div class="one_third">
<label for="email">Department<span>*</span></label>
<select style="height: 40px; width:200px" name = "employee_deparment" id = "employee_deparment" required>
<% out.print(employeeDetails.getDepartmentOption((Integer) Values.get("employee_deparment"))); %>
</select> </div>
<div class="one_third first">
<label for="email">First Name <span>*</span></label>
<input type="text" name="employee_first_name" id="employee_first_name" value="<% out.print(Values.get("employee_first_name")); %>" size="22" required>
</div>
<div class="one_third">
<label for="email">Middle Name <span>*</span></label>
<input type="text" name="employee_middle_name" id="employee_middle_name" value="<% out.print(Values.get("employee_middle_name")); %>" size="22" required>
</div>
<div class="one_third">
<label for="url">Last Name</label>
<input type="text" name="employee_last_name" id="employee_last_name" value="<% out.print(Values.get("employee_last_name")); %>" size="22" required>
</div>
<div class="one_third first"> <label for="url">Gender</label>
<select style="height: 40px; width:200px" name="employee_gender" required> <option value="0">Please Select</option>
Page - 120
<option value="Male" <% out.print(male); %>>Male</option> <option value="Female" <% out.print(female); %>>Female</option> </select>
</div>
<div class="one_third">
<label for="url">Date of Birth</label>
<input type="text" name="employee_dob" id="employee_dob" value="<% out.print(Values.get("employee_dob")); %>" size="22" required>
</div>
<div class="one_third">
<label for="url">Nationality</label>
<input type="text" name="employee_nationalty" id="employee_nationalty" value="<% out.print(Values.get("employee_nationalty")); %>" size="22" required>
</div>
<div class="one_third first"> <label for="url">E-mail</label>
<input type="text" name="employee_email" id="employee_email" value="<% out.print(Values.get("employee_email")); %>" size="22" required>
</div>
<div class="one_third"> <label for="url">Landline</label>
<input type="text" name="employee_landline" id="employee_landline" value="<% out.print(Values.get("employee_landline")); %>" size="22" required>
</div>
Page - 121
<label for="url">Mobile</label>
<input type="text" name="employee_mobile" id="employee_mobile" value="<% out.print(Values.get("employee_mobile")); %>" size="22" required>
</div>
<div style="clear:both"></div> <h4>Employee Address Details</h4> <div class="one_third first">
<label for="url">Address</label>
<input type="text" name="employee_address" id="employee_address" value="<% out.print(Values.get("employee_address")); %>" size="22" required>
</div>
<div class="one_third">
<label for="url">Village/City/Town</label>
<input type="text" name="employee_village" id="employee_village" value="<% out.print(Values.get("employee_village")); %>" size="22" required>
</div>
<div class="one_third"> <label for="url">State</label>
<select style="height: 40px; width:200px" name="employee_state" required> <% out.print(employeeDetails.getStateOption((Integer) Values.get("employee_state"))); %>
</select> </div>
<div class="one_third first"> <label for="url">Country</label>
Page - 122
<% out.print(employeeDetails.getCountryOption((Integer) Values.get("employee_country"))); %>
</select> </div>
<% if(session.getAttribute("login_level") != null && session.getAttribute("login_level").equals("1")) { %>
<div class="block clear"></div>
<h4>Employee Role & Manager</h4> <div class="one_third first">
<label for="email">Employee Role<span>*</span></label>
<select style="height: 40px; width:200px" name= "employee_role" id = "employee_role" required> <% out.print(employeeDetails.getRoleOption((Integer) Values.get("employee_role"))); %> </select> </div> <div class="one_third">
<label for="email">Employee Manager Code<span>*</span></label>
<select style="height: 40px; width:200px" name = "employee_manager_id" id = "employee_manager_id" required> <% out.print(employeeDetails.getEmployeeOption((Integer) Values.get("employee_manager_id"))); %> </select> </div> <% } %>
<div class="block clear"></div>
<% if(employee_id == 0) { %> <h4>Employee Login Details</h4>
Page - 123
<div class="one_third first">
<label for="url">Username</label>
<input type="text" name="employee_user" id="employee_user" value="<% out.print(Values.get("employee_user")); %>" size="22">
</div>
<div class="one_third">
<label for="url">Password</label>
<input type="password" name="employee_password" id="employee_password" value="" size="22">
</div>
<div class="one_third ">
<label for="url">Confirm Password</label>
<input type="password" name="employee_confirm_password" id="employee_confirm_password" value="" size="22">
</div>
<% } %>
<div class="block clear"></div> <div>
<input name="submit" type="submit" value="Save Form">
<input name="reset" type="reset" value="Reset Form"> </div>
<input type="hidden" name="act" value="Save" /> <input type="hidden" name="employee_id" value="<% out.print(Values.get("employee_id")); %>"/>
Page - 124
</form> </div>
<div style="float: left">
<div><img src="images/save_1.jpg" style="width: 250px"></div><br> <div><img src="images/save_2.jpg" style="width: 250px"></div><br>
<div><img src="images/save_3.jpg" style="width: 250px"></div> </div> <div class="clear"></div> </main> </div> </div> <%@ include file="includes/footer.jsp" %>
Page - 125
Coding for Passenger.jsp<%@ include file="includes/header.jsp" %> <%@ page import= "java.util.*" %>
<%@ page import= "Model.*" %> <%
//// Getting the train details ///// Train trainDetails = new Train();
int train_id = Integer.parseInt(request.getParameter ("train_id")); HashMap TrainValues = trainDetails.getTrainDetails(train_id);
//// Getting the train route details /////
TrainRoute trainRouteDetails = new TrainRoute();
int tr_id = Integer.parseInt(request.getParameter ("tr_id"));
HashMap RouteValues = trainRouteDetails.getTrainRouteDetails(tr_id); %>
<style> table {
margin-bottom:0px; }
#comments input, #comments textarea { padding:5px;
}
.my_button {