import java.awt.*; import java.awt.event.*; import java.util.*; import java.text.*; import java.sql.*; import java.lang.*; public class citytime extends Frame implements ActionListener,ItemListener,FocusListener,MouseListener { public Toolkit tk; public Image img; public TextField tf_date; public flightdetails fd; public Panel Panel1; public Label lbl_citycode; public TextField tf_citycode; public Button but_retrieve; public Panel Panel2; public Label lbl_1; public Label lbl_2; public Label lbl_3; public Label lbl_4; public Label lbl_5; public Label lbl_6; public Label lbl_7; public Label lbl_8; public Label lbl_9; public Label lbl_10; public Label lbl_11; public Label lbl_12; public Label lbl_13; public Label lbl_14; public Choice ch_routecode; public TextField tf_routecode; public TextField tf_flightno; public TextField tf_acrnumber; public TextField tf_class; public TextField tf_source; public TextField tf_destination; public TextField tf_via; public TextField tf_fromdate; public TextField tf_todate; public TextField tf_mon; public TextField tf_tue; public TextField tf_wed; public TextField tf_thu; public TextField tf_fri; public TextField tf_sat; public TextField tf_sun; public TextField tf_city1; public TextField tf_city2; public TextField tf_city3; public TextField tf_city4; public TextField tf_city5; public TextField tf_deptime1; public TextField tf_deptime2; public TextField tf_deptime3; public TextField tf_deptime4; public TextField tf_arrtime2; public TextField tf_arrtime3; public TextField tf_arrtime4; public TextField tf_arrtime5; public TextField tf_changeofflight; public Button but_first; public Button but_previous; public Button but_next; public Button but_last; public Label lbl_message; public TextArea ta_message; public Button but_reset; public Button but_add; public Button but_delete; public Button but_update; public Button but_help; public Button but_exit; // public Connection con; public String sf,s1,s2,s3,s4,s5,s6,s7,s8,s9,s10,s11,s12,s13,s14,s15,s16,s17,s18,s19,s20,s21,s22,s23,s24,s25,s26,s27,s28,s29,s30,sqlstmt; public int i,i2,ret; public String code ; public citytime(Connection c) { con = c; setResizable(false); setForeground(Color.black); // setBackground(Color.lightGray); setBackground(new Color(255,255,210)); setTitle("City Time Information"); setLayout(null); tk = getToolkit(); img = tk.getImage("air.gif"); tf_date = new TextField(""); Panel1 = new Panel(); Panel1.setLayout(null); Panel1.setForeground(Color.black); Panel1.setBackground(Color.gray); lbl_citycode = new Label("City code",Label.LEFT); tf_citycode = new TextField(""); but_retrieve = new Button("Retrieve"); Panel2 = new Panel(); Panel2.setLayout(null); Panel2.setForeground(Color.black); Panel2.setBackground(Color.gray); lbl_1 = new Label("Route code" ,Label.LEFT); lbl_2 = new Label("Flight No" ,Label.LEFT); lbl_3 = new Label("A/C Type" ,Label.LEFT); lbl_4 = new Label("Class" ,Label.LEFT); lbl_5 = new Label("From Country" ,Label.LEFT); lbl_6 = new Label("To Country",Label.LEFT); lbl_7 = new Label("Thru'Country" ,Label.LEFT); lbl_8 = new Label("Validity From" ,Label.LEFT); lbl_9 = new Label("Validity To" ,Label.LEFT); lbl_10 = new Label("M T W T F S S" ,Label.LEFT); lbl_11 = new Label("T-City" ,Label.LEFT); lbl_12 = new Label("Dep.Time" ,Label.LEFT); lbl_13 = new Label("Arr.Time" ,Label.LEFT); lbl_14 = new Label("Change of flight" ,Label.LEFT); ch_routecode = new Choice(); tf_routecode = new TextField(""); tf_flightno = new TextField(""); tf_acrnumber = new TextField(""); tf_class = new TextField(""); tf_source = new TextField(""); tf_destination = new TextField(""); tf_via = new TextField(""); tf_fromdate = new TextField(""); tf_todate = new TextField(""); tf_mon = new TextField(""); tf_tue = new TextField(""); tf_wed = new TextField(""); tf_thu = new TextField(""); tf_fri = new TextField(""); tf_sat = new TextField(""); tf_sun = new TextField(""); tf_city1 = new TextField(""); tf_city2 = new TextField(""); tf_city3 = new TextField(""); tf_city4 = new TextField(""); tf_city5 = new TextField(""); tf_deptime1 = new TextField(""); tf_deptime2 = new TextField(""); tf_deptime3 = new TextField(""); tf_deptime4 = new TextField(""); tf_arrtime2 = new TextField(""); tf_arrtime3 = new TextField(""); tf_arrtime4 = new TextField(""); tf_arrtime5 = new TextField(""); tf_changeofflight = new TextField(""); but_first = new Button("First"); but_previous = new Button("Previous"); but_next = new Button("Next"); but_last = new Button("Last"); but_reset = new Button("Reset"); but_add = new Button("Add"); but_delete = new Button("Delete"); but_update = new Button("Update"); but_help = new Button("Help"); but_exit = new Button("Exit"); lbl_message = new Label("MESSAGE / ACTION / ERROR",Label.LEFT); ta_message = new TextArea(""); // set date tf_date.setText( Validate.getDate() ); // Add()s add(tf_date); add(Panel1); Panel1.add(lbl_citycode); Panel1.add(tf_citycode); Panel1.add(but_retrieve); add(Panel2); Panel2.add(lbl_1); Panel2.add(lbl_5); Panel2.add(lbl_9); Panel2.add(lbl_13); Panel2.add(lbl_2); Panel2.add(lbl_6); Panel2.add(lbl_10); Panel2.add(lbl_14); Panel2.add(lbl_3); Panel2.add(lbl_7); Panel2.add(lbl_11); Panel2.add(lbl_4); Panel2.add(lbl_8); Panel2.add(lbl_12); Panel2.add(ch_routecode); Panel2.add(tf_routecode); Panel2.add(tf_flightno); Panel2.add(tf_acrnumber); Panel2.add(tf_class); Panel2.add(tf_source); Panel2.add(tf_destination); Panel2.add(tf_via); Panel2.add(tf_fromdate); Panel2.add(tf_todate); Panel2.add(tf_mon); Panel2.add(tf_tue); Panel2.add(tf_wed); Panel2.add(tf_thu); Panel2.add(tf_fri); Panel2.add(tf_sat); Panel2.add(tf_sun); Panel2.add(tf_city1); Panel2.add(tf_city2); Panel2.add(tf_city3); Panel2.add(tf_city4); Panel2.add(tf_city5); Panel2.add(tf_deptime1); Panel2.add(tf_deptime2); Panel2.add(tf_deptime3); Panel2.add(tf_deptime4); Panel2.add(tf_arrtime2); Panel2.add(tf_arrtime3); Panel2.add(tf_arrtime4); Panel2.add(tf_arrtime5); Panel2.add(tf_changeofflight); add(but_first); add(but_previous); add(but_next); add(but_last); add(lbl_message); add(ta_message); add(but_reset); add(but_add); add(but_delete); add(but_update); add(but_help); add(but_exit); // Events add Panel1 .addMouseListener(this); ch_routecode .addItemListener(this); tf_routecode .addFocusListener(this); tf_flightno .addFocusListener(this); but_retrieve .addActionListener(this); but_first .addActionListener(this); but_previous .addActionListener(this); but_next .addActionListener(this); but_last .addActionListener(this); but_reset .addActionListener(this); but_add .addActionListener(this); but_delete .addActionListener(this); but_update .addActionListener(this); but_help .addActionListener(this); but_exit .addActionListener(this); // InitialPosition setBounds(0,0,800,600); tf_date.setBounds (580,100,215,25); Panel1.setBounds (150,140,500,50); lbl_citycode.setBounds (150, 02, 70,20); tf_citycode.setBounds (150, 22, 70,20); but_retrieve.setBounds (330, 22, 75,25); Panel2.setBounds ( 60,200,680,235); ch_routecode.setBounds (145, 5,180, 20); lbl_1.setBounds ( 5, 5, 70, 20); tf_routecode.setBounds ( 75, 5, 70, 20); lbl_2.setBounds ( 5, 30, 70, 20); tf_flightno.setBounds ( 75, 30, 70, 20); lbl_3.setBounds ( 5, 55, 70, 20); tf_acrnumber.setBounds ( 75, 55,140, 20); lbl_4.setBounds ( 5, 80, 70, 20); tf_class.setBounds ( 75, 80, 70, 20); lbl_5.setBounds (220, 5, 75, 20); tf_source.setBounds (300, 5,140, 20); lbl_6.setBounds (220, 30, 75, 20); tf_destination.setBounds (300, 30,140, 20); lbl_7.setBounds (220, 55, 75, 20); tf_via.setBounds (300, 55,140, 20); lbl_8.setBounds (470, 5, 70, 20); tf_fromdate.setBounds (545, 5, 70, 20); lbl_9.setBounds (470, 30, 70, 20); tf_todate.setBounds (545, 30, 70, 20); lbl_10.setBounds (300, 80,200, 20); tf_mon.setBounds (300,100, 30, 20); tf_tue.setBounds (330,100, 30, 20); tf_wed.setBounds (360,100, 30, 20); tf_thu.setBounds (390,100, 30, 20); tf_fri.setBounds (420,100, 30, 20); tf_sat.setBounds (450,100, 30, 20); tf_sun.setBounds (480,100, 30, 20); lbl_11.setBounds ( 5,105, 60, 20); lbl_12.setBounds ( 65,105, 70, 20); lbl_13.setBounds (145,105, 70, 20); tf_city1.setBounds ( 5,125, 50, 20); tf_city2.setBounds ( 5,145, 50, 20); tf_city3.setBounds ( 5,165, 50, 20); tf_city4.setBounds ( 5,185, 50, 20); tf_city5.setBounds ( 5,205, 50, 20); tf_deptime1.setBounds ( 65,125, 70, 20); tf_deptime2.setBounds ( 65,145, 70, 20); tf_deptime3.setBounds ( 65,165, 70, 20); tf_deptime4.setBounds ( 65,185, 70, 20); tf_arrtime2.setBounds (140,145, 70, 20); tf_arrtime3.setBounds (140,165, 70, 20); tf_arrtime4.setBounds (140,185, 70, 20); tf_arrtime5.setBounds (140,205, 70, 20); lbl_14.setBounds (300,205, 95, 20); tf_changeofflight.setBounds (395,205, 30, 20); but_first.setBounds (90,440,75,25); but_previous.setBounds (90,470,75,25); but_next.setBounds (90,500,75,25); but_last.setBounds (90,530,75,25); lbl_message.setBounds (210,440,200,20); ta_message.setBounds (210,460,385,100); but_reset.setBounds (645,440,75,25); but_add.setBounds (645,470,75,25); but_delete.setBounds (645,500,75,25); but_update.setBounds (645,530,75,25); but_help.setBounds (320,564,75,25); but_exit.setBounds (400,564,75,25); // enable/disable buttons but_help.setVisible(false); tf_date.setEnabled(false); ch_routecode.setVisible(false); tf_acrnumber.setEnabled(false); tf_class.setEnabled(false); tf_source.setEnabled(false); tf_destination.setEnabled(false); tf_via.setEnabled(false); tf_city1.setEnabled(false); tf_city2.setEnabled(false); tf_city3.setEnabled(false); tf_city4.setEnabled(false); tf_city5.setEnabled(false); tf_mon.setEnabled(false); tf_tue.setEnabled(false); tf_wed.setEnabled(false); tf_thu.setEnabled(false); tf_fri.setEnabled(false); tf_sat.setEnabled(false); tf_sun.setEnabled(false); ta_message.setEditable(false); // retrieve entire route i.e. fd_code from flightdetails try { Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery("select fd_code,route_code,flight_no,mon,tue,wed,thu,fri,sat,sun from flightdetails"); while (rs.next()) { code = ""; code = rs.getString(1); code = code + " " + rs.getString(2); code = code + " " + rs.getString(3); code = code + " " + rs.getString(4); code = code + " " + rs.getString(5); code = code + " " + rs.getString(6); code = code + " " + rs.getString(7); code = code + " " + rs.getString(8); code = code + " " + rs.getString(9); code = code + " " + rs.getString(10); ch_routecode.addItem(code); } } catch(Exception er) { ta_message.setText ("ERROR: Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } //end of entire route i.e. fd_code retrieve // focus this.requestFocus(); } //end of constructor public void paint(Graphics g) { g.drawImage(img,0,45,this); } // end of paint public void mouseClicked(MouseEvent e) {} public void mousePressed(MouseEvent e) {} public void mouseReleased(MouseEvent e) {} public void mouseEntered(MouseEvent e) {} public void mouseExited(MouseEvent e) {} public void focusLost(FocusEvent e) {} public void focusGained(FocusEvent e) { if (e.getSource() == tf_routecode) { ch_routecode.setVisible(true); } } // focus gained public void itemStateChanged(ItemEvent e) { if (e.getSource() == ch_routecode) { try { ta_message.setText("ACTION: Retrieving record ..."); i = Integer.parseInt( ch_routecode.getSelectedItem().substring(0,1) ); CallableStatement cstmt = con.prepareCall( "{call retrieve2_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.setInt(20,i); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s10= cstmt.getString(8 ); s11= cstmt.getString(9 ); s12= cstmt.getString(10); s13= cstmt.getString(11); s14= cstmt.getString(12); s15= cstmt.getString(13); s16= cstmt.getString(14); s17= cstmt.getString(15); s18= cstmt.getString(16); s19= cstmt.getString(17); s20= cstmt.getString(18); s21= cstmt.getString(19); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); ch_routecode.setVisible(false); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_acrnumber.setEnabled(false); tf_class.setEnabled(false); tf_source.setEnabled(false); tf_destination.setEnabled(false); tf_via.setEnabled(false); tf_mon.setEnabled(false); tf_tue.setEnabled(false); tf_wed.setEnabled(false); tf_thu.setEnabled(false); tf_fri.setEnabled(false); tf_sat.setEnabled(false); tf_sun.setEnabled(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } } //end of ch_routecode } // end of itemstatechanged public void actionPerformed(ActionEvent e) { if(e.getSource()==but_exit) { this.dispose(); } // end of exit if(e.getSource()==but_retrieve) { try { ta_message.setText("ACTION: Retrieving record ..."); i2 = Validate.stringToInt( tf_citycode.getText() ); CallableStatement cstmt = con.prepareCall( "{call retrieve_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.registerOutParameter(20,12); cstmt.registerOutParameter(21,12); cstmt.registerOutParameter(22,12); cstmt.registerOutParameter(23,12); cstmt.registerOutParameter(24,12); cstmt.registerOutParameter(25,12); cstmt.registerOutParameter(26,12); cstmt.registerOutParameter(27,12); cstmt.registerOutParameter(28,12); cstmt.registerOutParameter(29,12); cstmt.registerOutParameter(30,12); cstmt.registerOutParameter(31,4); cstmt.registerOutParameter(32,4); cstmt.setInt(33,i2); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s8 = cstmt.getString(8 ); s9 = cstmt.getString(9 ); s10= cstmt.getString(10); s11= cstmt.getString(11); s12= cstmt.getString(12); s13= cstmt.getString(13); s14= cstmt.getString(14); s15= cstmt.getString(15); s16= cstmt.getString(16); s17= cstmt.getString(17); s18= cstmt.getString(18); s19= cstmt.getString(19); s20= cstmt.getString(20); s21= cstmt.getString(21); s22= cstmt.getString(22); s23= cstmt.getString(23); s24= cstmt.getString(24); s25= cstmt.getString(25); s26= cstmt.getString(26); s27= cstmt.getString(27); s28= cstmt.getString(28); s29= cstmt.getString(29); s30= cstmt.getString(30); i = cstmt.getInt(31); i2 = cstmt.getInt(32); s8 = Validate.stringSQLDateToString(s8); s9 = Validate.stringSQLDateToString(s9); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_fromdate.setText(s8); tf_todate.setText(s9); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); tf_deptime1.setText(s22); tf_deptime2.setText(s23); tf_deptime3.setText(s24); tf_deptime4.setText(s25); tf_arrtime2.setText(s26); tf_arrtime3.setText(s27); tf_arrtime4.setText(s28); tf_arrtime5.setText(s29); tf_changeofflight.setText(s30); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_fromdate.setEnabled(false); tf_todate.setEnabled(false); ch_routecode.setVisible(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } }// end of but_retrieve if(e.getSource()==but_add) { try { ta_message.setText("ACTION: Adding new record ..."); getInput(); CallableStatement cstmt = con.prepareCall( "{call insert_citytime(?,?,?,?,?,?,?,?,?,?,?,?)}" ); //set IN parameter cstmt.setInt(1,i); cstmt.setString(2 , s8); cstmt.setString(3 , s9); cstmt.setString(4 ,s22); cstmt.setString(5 ,s23); cstmt.setString(6 ,s24); cstmt.setString(7 ,s25); cstmt.setString(8 ,s26); cstmt.setString(9 ,s27); cstmt.setString(10,s28); cstmt.setString(11,s29); cstmt.setString(12,s30); cstmt.executeUpdate(); ta_message.setText("ACTION: Record Added."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } } // end of but_add if(e.getSource()==but_update) { try { ta_message.setText("ACTION: Updating record..."); getInput(); CallableStatement cstmt = con.prepareCall( "{call update_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.setInt(1 ,i2 ); cstmt.setInt(2 ,i ); cstmt.setString(3 ,s8 ); cstmt.setString(4 ,s9 ); cstmt.setString(5 ,s22); cstmt.setString(6 ,s23); cstmt.setString(7 ,s24); cstmt.setString(8 ,s25); cstmt.setString(9 ,s26); cstmt.setString(10,s27); cstmt.setString(11,s28); cstmt.setString(12,s29); cstmt.setString(13,s30); cstmt.executeUpdate(); ta_message.setText("ACTION: Record updated."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); } }// end of but_update if(e.getSource()==but_delete) { try { ta_message.setText("ACTION: Deleting record ..."); getInput(); CallableStatement cstmt = con.prepareCall( "{call delete_citytime(?)}" ); cstmt.setInt(1,i2); cstmt.executeUpdate(); ta_message.setText("ACTION: Record deleted."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } } // end of but_delete if(e.getSource()==but_reset) { i = 0; i2 = 0; tf_routecode .setEnabled(true); tf_flightno .setEnabled(true); tf_fromdate .setEnabled(true); tf_todate .setEnabled(true); tf_citycode .setText(""); tf_routecode .setText(""); tf_flightno .setText(""); tf_acrnumber .setText(""); tf_class .setText(""); tf_source .setText(""); tf_destination .setText(""); tf_via .setText(""); tf_fromdate .setText(""); tf_todate .setText(""); tf_city1 .setText(""); tf_city2 .setText(""); tf_city3 .setText(""); tf_city4 .setText(""); tf_city5 .setText(""); tf_mon .setText(""); tf_tue .setText(""); tf_wed .setText(""); tf_thu .setText(""); tf_fri .setText(""); tf_sat .setText(""); tf_sun .setText(""); tf_deptime1 .setText(""); tf_deptime2 .setText(""); tf_deptime3 .setText(""); tf_deptime4 .setText(""); tf_arrtime2 .setText(""); tf_arrtime3 .setText(""); tf_arrtime4 .setText(""); tf_arrtime5 .setText(""); tf_changeofflight.setText(""); ta_message .setText(""); tf_routecode .requestFocus(); } // end of reset if(e.getSource()==but_first) { try { ta_message.setText("ACTION: Retrieving record ..."); CallableStatement cstmt = con.prepareCall( "{call first_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.registerOutParameter(20,12); cstmt.registerOutParameter(21,12); cstmt.registerOutParameter(22,12); cstmt.registerOutParameter(23,12); cstmt.registerOutParameter(24,12); cstmt.registerOutParameter(25,12); cstmt.registerOutParameter(26,12); cstmt.registerOutParameter(27,12); cstmt.registerOutParameter(28,12); cstmt.registerOutParameter(29,12); cstmt.registerOutParameter(30,12); cstmt.registerOutParameter(31,4); cstmt.registerOutParameter(32,4); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s8 = cstmt.getString(8 ); s9 = cstmt.getString(9 ); s10= cstmt.getString(10); s11= cstmt.getString(11); s12= cstmt.getString(12); s13= cstmt.getString(13); s14= cstmt.getString(14); s15= cstmt.getString(15); s16= cstmt.getString(16); s17= cstmt.getString(17); s18= cstmt.getString(18); s19= cstmt.getString(19); s20= cstmt.getString(20); s21= cstmt.getString(21); s22= cstmt.getString(22); s23= cstmt.getString(23); s24= cstmt.getString(24); s25= cstmt.getString(25); s26= cstmt.getString(26); s27= cstmt.getString(27); s28= cstmt.getString(28); s29= cstmt.getString(29); s30= cstmt.getString(30); i = cstmt.getInt(31); i2 = cstmt.getInt(32); s8 = Validate.stringSQLDateToString(s8); s9 = Validate.stringSQLDateToString(s9); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_fromdate.setText(s8); tf_todate.setText(s9); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); tf_deptime1.setText(s22); tf_deptime2.setText(s23); tf_deptime3.setText(s24); tf_deptime4.setText(s25); tf_arrtime2.setText(s26); tf_arrtime3.setText(s27); tf_arrtime4.setText(s28); tf_arrtime5.setText(s29); tf_changeofflight.setText(s30); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_fromdate.setEnabled(false); tf_todate.setEnabled(false); ch_routecode.setVisible(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } }// end of but_first if(e.getSource()==but_last) { try { ta_message.setText("ACTION: Retrieving record ..."); CallableStatement cstmt = con.prepareCall( "{call last_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.registerOutParameter(20,12); cstmt.registerOutParameter(21,12); cstmt.registerOutParameter(22,12); cstmt.registerOutParameter(23,12); cstmt.registerOutParameter(24,12); cstmt.registerOutParameter(25,12); cstmt.registerOutParameter(26,12); cstmt.registerOutParameter(27,12); cstmt.registerOutParameter(28,12); cstmt.registerOutParameter(29,12); cstmt.registerOutParameter(30,12); cstmt.registerOutParameter(31,4); cstmt.registerOutParameter(32,4); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s8 = cstmt.getString(8 ); s9 = cstmt.getString(9 ); s10= cstmt.getString(10); s11= cstmt.getString(11); s12= cstmt.getString(12); s13= cstmt.getString(13); s14= cstmt.getString(14); s15= cstmt.getString(15); s16= cstmt.getString(16); s17= cstmt.getString(17); s18= cstmt.getString(18); s19= cstmt.getString(19); s20= cstmt.getString(20); s21= cstmt.getString(21); s22= cstmt.getString(22); s23= cstmt.getString(23); s24= cstmt.getString(24); s25= cstmt.getString(25); s26= cstmt.getString(26); s27= cstmt.getString(27); s28= cstmt.getString(28); s29= cstmt.getString(29); s30= cstmt.getString(30); i = cstmt.getInt(31); i2 = cstmt.getInt(32); s8 = Validate.stringSQLDateToString(s8); s9 = Validate.stringSQLDateToString(s9); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_fromdate.setText(s8); tf_todate.setText(s9); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); tf_deptime1.setText(s22); tf_deptime2.setText(s23); tf_deptime3.setText(s24); tf_deptime4.setText(s25); tf_arrtime2.setText(s26); tf_arrtime3.setText(s27); tf_arrtime4.setText(s28); tf_arrtime5.setText(s29); tf_changeofflight.setText(s30); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_fromdate.setEnabled(false); tf_todate.setEnabled(false); ch_routecode.setVisible(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } }// end of but_last if(e.getSource()==but_previous) { try { ta_message.setText("ACTION: Retrieving record ..."); CallableStatement cstmt = con.prepareCall( "{call previous_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.registerOutParameter(20,12); cstmt.registerOutParameter(21,12); cstmt.registerOutParameter(22,12); cstmt.registerOutParameter(23,12); cstmt.registerOutParameter(24,12); cstmt.registerOutParameter(25,12); cstmt.registerOutParameter(26,12); cstmt.registerOutParameter(27,12); cstmt.registerOutParameter(28,12); cstmt.registerOutParameter(29,12); cstmt.registerOutParameter(30,12); cstmt.registerOutParameter(31,4); cstmt.registerOutParameter(32,4); cstmt.setInt(33,i2); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s8 = cstmt.getString(8 ); s9 = cstmt.getString(9 ); s10= cstmt.getString(10); s11= cstmt.getString(11); s12= cstmt.getString(12); s13= cstmt.getString(13); s14= cstmt.getString(14); s15= cstmt.getString(15); s16= cstmt.getString(16); s17= cstmt.getString(17); s18= cstmt.getString(18); s19= cstmt.getString(19); s20= cstmt.getString(20); s21= cstmt.getString(21); s22= cstmt.getString(22); s23= cstmt.getString(23); s24= cstmt.getString(24); s25= cstmt.getString(25); s26= cstmt.getString(26); s27= cstmt.getString(27); s28= cstmt.getString(28); s29= cstmt.getString(29); s30= cstmt.getString(30); i = cstmt.getInt(31); i2 = cstmt.getInt(32); s8 = Validate.stringSQLDateToString(s8); s9 = Validate.stringSQLDateToString(s9); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_fromdate.setText(s8); tf_todate.setText(s9); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); tf_deptime1.setText(s22); tf_deptime2.setText(s23); tf_deptime3.setText(s24); tf_deptime4.setText(s25); tf_arrtime2.setText(s26); tf_arrtime3.setText(s27); tf_arrtime4.setText(s28); tf_arrtime5.setText(s29); tf_changeofflight.setText(s30); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_fromdate.setEnabled(false); tf_todate.setEnabled(false); ch_routecode.setVisible(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } }// end of but_previous if(e.getSource()==but_next) { try { ta_message.setText("ACTION: Retrieving record ..."); CallableStatement cstmt = con.prepareCall( "{call next_citytime(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}" ); cstmt.registerOutParameter(1 ,12); cstmt.registerOutParameter(2 ,12); cstmt.registerOutParameter(3 ,12); cstmt.registerOutParameter(4 ,12); cstmt.registerOutParameter(5 ,12); cstmt.registerOutParameter(6 ,12); cstmt.registerOutParameter(7 ,12); cstmt.registerOutParameter(8 ,12); cstmt.registerOutParameter(9 ,12); cstmt.registerOutParameter(10,12); cstmt.registerOutParameter(11,12); cstmt.registerOutParameter(12,12); cstmt.registerOutParameter(13,12); cstmt.registerOutParameter(14,12); cstmt.registerOutParameter(15,12); cstmt.registerOutParameter(16,12); cstmt.registerOutParameter(17,12); cstmt.registerOutParameter(18,12); cstmt.registerOutParameter(19,12); cstmt.registerOutParameter(20,12); cstmt.registerOutParameter(21,12); cstmt.registerOutParameter(22,12); cstmt.registerOutParameter(23,12); cstmt.registerOutParameter(24,12); cstmt.registerOutParameter(25,12); cstmt.registerOutParameter(26,12); cstmt.registerOutParameter(27,12); cstmt.registerOutParameter(28,12); cstmt.registerOutParameter(29,12); cstmt.registerOutParameter(30,12); cstmt.registerOutParameter(31,4); cstmt.registerOutParameter(32,4); cstmt.setInt(33,i2); cstmt.executeUpdate(); s1 = cstmt.getString(1 ); s2 = cstmt.getString(2 ); s3 = cstmt.getString(3 ); s4 = cstmt.getString(4 ); s5 = cstmt.getString(5 ); s6 = cstmt.getString(6 ); s7 = cstmt.getString(7 ); s8 = cstmt.getString(8 ); s9 = cstmt.getString(9 ); s10= cstmt.getString(10); s11= cstmt.getString(11); s12= cstmt.getString(12); s13= cstmt.getString(13); s14= cstmt.getString(14); s15= cstmt.getString(15); s16= cstmt.getString(16); s17= cstmt.getString(17); s18= cstmt.getString(18); s19= cstmt.getString(19); s20= cstmt.getString(20); s21= cstmt.getString(21); s22= cstmt.getString(22); s23= cstmt.getString(23); s24= cstmt.getString(24); s25= cstmt.getString(25); s26= cstmt.getString(26); s27= cstmt.getString(27); s28= cstmt.getString(28); s29= cstmt.getString(29); s30= cstmt.getString(30); i = cstmt.getInt(31); i2 = cstmt.getInt(32); s8 = Validate.stringSQLDateToString(s8); s9 = Validate.stringSQLDateToString(s9); tf_routecode.setText(s1); tf_flightno.setText(s2); tf_acrnumber.setText(s3); tf_class.setText(s4); tf_source.setText(s5); tf_destination.setText(s6); tf_via.setText(s7); tf_fromdate.setText(s8); tf_todate.setText(s9); tf_city1.setText(s10); tf_city2.setText(s11); tf_city3.setText(s12); tf_city4.setText(s13); tf_city5.setText(s14); tf_mon.setText(s15); tf_tue.setText(s16); tf_wed.setText(s17); tf_thu.setText(s18); tf_fri.setText(s19); tf_sat.setText(s20); tf_sun.setText(s21); tf_deptime1.setText(s22); tf_deptime2.setText(s23); tf_deptime3.setText(s24); tf_deptime4.setText(s25); tf_arrtime2.setText(s26); tf_arrtime3.setText(s27); tf_arrtime4.setText(s28); tf_arrtime5.setText(s29); tf_changeofflight.setText(s30); tf_routecode.setEnabled(false); tf_flightno.setEnabled(false); tf_fromdate.setEnabled(false); tf_todate.setEnabled(false); ch_routecode.setVisible(false); ta_message.setText("ACTION: Record retrieved."); } catch(Exception er) { ta_message.setText ("ERROR: Incorrect data entered / Row does not exist / Database error \n"); ta_message.append ("EXCEPTION:" + "[" + er + "]" + "\n"); ta_message.append ("SOLUTION: " + "For more details kindly refer Help "); return; } }// end of but_next }// action performed public static void main(String args[]) { } // end main public boolean getInput() throws Exception { s1 = tf_routecode.getText(); sf = s8 = tf_fromdate.getText(); s9 = tf_todate.getText(); s22= tf_deptime1.getText(); s23= tf_deptime2.getText(); s24= tf_deptime3.getText(); s25= tf_deptime4.getText(); s26= tf_arrtime2.getText(); s27= tf_arrtime3.getText(); s28= tf_arrtime4.getText(); s29= tf_arrtime5.getText(); s30= tf_changeofflight.getText(); if ( (s1 == "") | (sf == "") | (s8 == "") | (s9 == "") ) { return false; } else { s8 = Validate.stringToSQLDateString(s8); s9 = Validate.stringToSQLDateString(s9); return true; } }// end of getInput } // end class