API tools faq
paste
Sajib_Ahmed

project

Sajib_Ahmed
Apr 9th, 2019
255
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 26.12 KB | None | 0 0
raw download clone embed print report
  1.  
  2. import java.sql.Connection;
  3. import java.sql.DriverManager;
  4. import java.sql.PreparedStatement;
  5. import java.sql.ResultSet;
  6. import javax.swing.JOptionPane;
  7.  
  8. /*
  9.  * To change this license header, choose License Headers in Project Properties.
  10.  * To change this template file, choose Tools | Templates
  11.  * and open the template in the editor.
  12.  */
  13.  
  14. /**
  15.  *
  16.  * @author sajib
  17.  */
  18. public class Rail01 extends javax.swing.JFrame {
  19.  
  20.     Connection con=null;
  21.   ResultSet rs=null;
  22.   PreparedStatement pst=null;
  23.     public Rail01() {
  24.         initComponents();
  25.     }
  26.  
  27.     /**
  28.      * This method is called from within the constructor to initialize the form.
  29.      * WARNING: Do NOT modify this code. The content of this method is always
  30.      * regenerated by the Form Editor.
  31.      */
  32.     @SuppressWarnings("unchecked")
  33.     // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
  34.     private void initComponents() {
  35.  
  36.         jLabel1 = new javax.swing.JLabel();
  37.         jTabbedPane1 = new javax.swing.JTabbedPane();
  38.         jPanel1 = new javax.swing.JPanel();
  39.         jLabel2 = new javax.swing.JLabel();
  40.         Name = new javax.swing.JTextField();
  41.         jLabel3 = new javax.swing.JLabel();
  42.         jLabel4 = new javax.swing.JLabel();
  43.         countticket = new javax.swing.JTextField();
  44.         jLabel5 = new javax.swing.JLabel();
  45.         Destination = new javax.swing.JTextField();
  46.         jComboBox1 = new javax.swing.JComboBox<>();
  47.         Insert = new javax.swing.JButton();
  48.         jLabel6 = new javax.swing.JLabel();
  49.         phonenumber = new javax.swing.JTextField();
  50.         jPanel2 = new javax.swing.JPanel();
  51.         jLabel7 = new javax.swing.JLabel();
  52.         jScrollPane2 = new javax.swing.JScrollPane();
  53.         jTable2 = new javax.swing.JTable();
  54.         jPanel3 = new javax.swing.JPanel();
  55.         jScrollPane1 = new javax.swing.JScrollPane();
  56.         jTextArea1 = new javax.swing.JTextArea();
  57.         jButton1 = new javax.swing.JButton();
  58.         jPanel4 = new javax.swing.JPanel();
  59.         jLabel8 = new javax.swing.JLabel();
  60.         Name1 = new javax.swing.JTextField();
  61.         jLabel9 = new javax.swing.JLabel();
  62.         phonenumber1 = new javax.swing.JTextField();
  63.         jLabel10 = new javax.swing.JLabel();
  64.         Destination1 = new javax.swing.JTextField();
  65.         jLabel11 = new javax.swing.JLabel();
  66.         countticket1 = new javax.swing.JTextField();
  67.         Update = new javax.swing.JButton();
  68.         jPanel5 = new javax.swing.JPanel();
  69.         Delete = new javax.swing.JButton();
  70.         jLabel12 = new javax.swing.JLabel();
  71.         jTextField1 = new javax.swing.JTextField();
  72.         jPanel6 = new javax.swing.JPanel();
  73.         jMenuBar1 = new javax.swing.JMenuBar();
  74.         jMenu1 = new javax.swing.JMenu();
  75.         jMenuItem1 = new javax.swing.JMenuItem();
  76.  
  77.         setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
  78.  
  79.         jLabel1.setFont(new java.awt.Font("Tahoma", 1, 18)); // NOI18N
  80.         jLabel1.setText("Railway Management System");
  81.  
  82.         jTabbedPane1.setTabPlacement(javax.swing.JTabbedPane.LEFT);
  83.         jTabbedPane1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
  84.  
  85.         jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
  86.  
  87.         jLabel2.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  88.         jLabel2.setText("Passenger Name");
  89.         jPanel1.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(39, 15, 110, -1));
  90.  
  91.         Name.addActionListener(new java.awt.event.ActionListener() {
  92.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  93.                 NameActionPerformed(evt);
  94.             }
  95.         });
  96.         jPanel1.add(Name, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 10, 137, -1));
  97.         jPanel1.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(79, 72, 47, -1));
  98.  
  99.         jLabel4.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  100.         jLabel4.setText("Number of Ticket");
  101.         jPanel1.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(39, 132, -1, -1));
  102.         jPanel1.add(countticket, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 130, 137, -1));
  103.  
  104.         jLabel5.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  105.         jLabel5.setText("Destination");
  106.         jPanel1.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 90, 87, -1));
  107.  
  108.         Destination.addActionListener(new java.awt.event.ActionListener() {
  109.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  110.                 DestinationActionPerformed(evt);
  111.             }
  112.         });
  113.         jPanel1.add(Destination, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 90, 137, -1));
  114.  
  115.         jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Destination", "Dhaka to Chittagong", "Chittagong to Dhaka", "Dhaka to Noakhali" }));
  116.         jPanel1.add(jComboBox1, new org.netbeans.lib.awtextra.AbsoluteConstraints(310, 90, 109, -1));
  117.  
  118.         Insert.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  119.         Insert.setText("Confirm");
  120.         Insert.addActionListener(new java.awt.event.ActionListener() {
  121.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  122.                 InsertActionPerformed(evt);
  123.             }
  124.         });
  125.         jPanel1.add(Insert, new org.netbeans.lib.awtextra.AbsoluteConstraints(165, 218, -1, -1));
  126.  
  127.         jLabel6.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  128.         jLabel6.setText("Phone Number");
  129.         jPanel1.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(39, 49, 100, -1));
  130.         jPanel1.add(phonenumber, new org.netbeans.lib.awtextra.AbsoluteConstraints(160, 50, 137, -1));
  131.  
  132.         jTabbedPane1.addTab("Buy Ticket", jPanel1);
  133.  
  134.         jTable2.setModel(new javax.swing.table.DefaultTableModel(
  135.             new Object [][] {
  136.                 {"Subarna Express ", "  Chittagong", "      07:00 ", "       Dhaka ", "       12:10", "       450", "      Monday "},
  137.                 {null, null, null, null, null, null, null},
  138.                 {null, null, null, null, null, null, null},
  139.                 {null, null, null, null, null, null, null}
  140.             },
  141.             new String [] {
  142.                 "         Train name", " Starting station", " Departure time ", " Arrival station  ", " Arrival time", " Ticket price", " Off Day"
  143.             }
  144.         ));
  145.         jScrollPane2.setViewportView(jTable2);
  146.  
  147.         javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
  148.         jPanel2.setLayout(jPanel2Layout);
  149.         jPanel2Layout.setHorizontalGroup(
  150.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  151.             .addGroup(jPanel2Layout.createSequentialGroup()
  152.                 .addGap(60, 60, 60)
  153.                 .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 238, javax.swing.GroupLayout.PREFERRED_SIZE)
  154.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  155.             .addGroup(jPanel2Layout.createSequentialGroup()
  156.                 .addContainerGap()
  157.                 .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 658, Short.MAX_VALUE)
  158.                 .addContainerGap())
  159.         );
  160.         jPanel2Layout.setVerticalGroup(
  161.             jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  162.             .addGroup(jPanel2Layout.createSequentialGroup()
  163.                 .addContainerGap()
  164.                 .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 370, javax.swing.GroupLayout.PREFERRED_SIZE)
  165.                 .addGap(52, 52, 52)
  166.                 .addComponent(jLabel7)
  167.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
  168.         );
  169.  
  170.         jTabbedPane1.addTab("Train Rout", jPanel2);
  171.  
  172.         jTextArea1.setColumns(20);
  173.         jTextArea1.setRows(5);
  174.         jScrollPane1.setViewportView(jTextArea1);
  175.  
  176.         jButton1.setText("Click");
  177.         jButton1.addActionListener(new java.awt.event.ActionListener() {
  178.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  179.                 jButton1ActionPerformed(evt);
  180.             }
  181.         });
  182.  
  183.         javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
  184.         jPanel3.setLayout(jPanel3Layout);
  185.         jPanel3Layout.setHorizontalGroup(
  186.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  187.             .addGroup(jPanel3Layout.createSequentialGroup()
  188.                 .addGap(57, 57, 57)
  189.                 .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  190.                     .addComponent(jButton1)
  191.                     .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 391, javax.swing.GroupLayout.PREFERRED_SIZE))
  192.                 .addContainerGap(230, Short.MAX_VALUE))
  193.         );
  194.         jPanel3Layout.setVerticalGroup(
  195.             jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  196.             .addGroup(jPanel3Layout.createSequentialGroup()
  197.                 .addGap(23, 23, 23)
  198.                 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 243, javax.swing.GroupLayout.PREFERRED_SIZE)
  199.                 .addGap(18, 18, 18)
  200.                 .addComponent(jButton1)
  201.                 .addContainerGap(137, Short.MAX_VALUE))
  202.         );
  203.  
  204.         jTabbedPane1.addTab("Show info", jPanel3);
  205.  
  206.         jLabel8.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  207.         jLabel8.setText("Passenger Name");
  208.  
  209.         jLabel9.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  210.         jLabel9.setText("Phone Number");
  211.  
  212.         jLabel10.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  213.         jLabel10.setText("Destination");
  214.  
  215.         Destination1.addActionListener(new java.awt.event.ActionListener() {
  216.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  217.                 Destination1ActionPerformed(evt);
  218.             }
  219.         });
  220.  
  221.         jLabel11.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  222.         jLabel11.setText("Number of Ticket");
  223.  
  224.         Update.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  225.         Update.setText("Update Info");
  226.         Update.addActionListener(new java.awt.event.ActionListener() {
  227.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  228.                 UpdateActionPerformed(evt);
  229.             }
  230.         });
  231.  
  232.         javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
  233.         jPanel4.setLayout(jPanel4Layout);
  234.         jPanel4Layout.setHorizontalGroup(
  235.             jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  236.             .addGroup(jPanel4Layout.createSequentialGroup()
  237.                 .addGap(45, 45, 45)
  238.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
  239.                     .addGroup(jPanel4Layout.createSequentialGroup()
  240.                         .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)
  241.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  242.                         .addComponent(Destination1, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))
  243.                     .addGroup(jPanel4Layout.createSequentialGroup()
  244.                         .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)
  245.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  246.                         .addComponent(phonenumber1, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))
  247.                     .addGroup(jPanel4Layout.createSequentialGroup()
  248.                         .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
  249.                         .addGap(18, 18, 18)
  250.                         .addComponent(Name1, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))
  251.                     .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel4Layout.createSequentialGroup()
  252.                         .addComponent(jLabel11)
  253.                         .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  254.                         .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  255.                             .addComponent(Update)
  256.                             .addComponent(countticket1, javax.swing.GroupLayout.PREFERRED_SIZE, 137, javax.swing.GroupLayout.PREFERRED_SIZE))))
  257.                 .addContainerGap(368, Short.MAX_VALUE))
  258.         );
  259.         jPanel4Layout.setVerticalGroup(
  260.             jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  261.             .addGroup(jPanel4Layout.createSequentialGroup()
  262.                 .addGap(25, 25, 25)
  263.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  264.                     .addComponent(jLabel8)
  265.                     .addComponent(Name1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  266.                 .addGap(18, 18, 18)
  267.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  268.                     .addComponent(jLabel9)
  269.                     .addComponent(phonenumber1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  270.                 .addGap(18, 18, 18)
  271.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  272.                     .addComponent(jLabel10)
  273.                     .addComponent(Destination1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  274.                 .addGap(18, 18, 18)
  275.                 .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  276.                     .addComponent(jLabel11)
  277.                     .addComponent(countticket1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  278.                 .addGap(82, 82, 82)
  279.                 .addComponent(Update)
  280.                 .addContainerGap(180, Short.MAX_VALUE))
  281.         );
  282.  
  283.         jTabbedPane1.addTab("Update Info", jPanel4);
  284.  
  285.         Delete.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
  286.         Delete.setText("Delete");
  287.         Delete.addActionListener(new java.awt.event.ActionListener() {
  288.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  289.                 DeleteActionPerformed(evt);
  290.             }
  291.         });
  292.  
  293.         jLabel12.setFont(new java.awt.Font("Tahoma", 1, 12)); // NOI18N
  294.         jLabel12.setText("Phone Number");
  295.  
  296.         javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
  297.         jPanel5.setLayout(jPanel5Layout);
  298.         jPanel5Layout.setHorizontalGroup(
  299.             jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  300.             .addGroup(jPanel5Layout.createSequentialGroup()
  301.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  302.                     .addGroup(jPanel5Layout.createSequentialGroup()
  303.                         .addGap(78, 78, 78)
  304.                         .addComponent(jLabel12, javax.swing.GroupLayout.PREFERRED_SIZE, 100, javax.swing.GroupLayout.PREFERRED_SIZE)
  305.                         .addGap(55, 55, 55)
  306.                         .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 130, javax.swing.GroupLayout.PREFERRED_SIZE))
  307.                     .addGroup(jPanel5Layout.createSequentialGroup()
  308.                         .addGap(167, 167, 167)
  309.                         .addComponent(Delete)))
  310.                 .addContainerGap(315, Short.MAX_VALUE))
  311.         );
  312.         jPanel5Layout.setVerticalGroup(
  313.             jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  314.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel5Layout.createSequentialGroup()
  315.                 .addGap(44, 44, 44)
  316.                 .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
  317.                     .addComponent(jLabel12)
  318.                     .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
  319.                 .addGap(56, 56, 56)
  320.                 .addComponent(Delete)
  321.                 .addContainerGap(301, Short.MAX_VALUE))
  322.         );
  323.  
  324.         jTabbedPane1.addTab("Cancel Ticket", jPanel5);
  325.  
  326.         javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
  327.         jPanel6.setLayout(jPanel6Layout);
  328.         jPanel6Layout.setHorizontalGroup(
  329.             jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  330.             .addGap(0, 678, Short.MAX_VALUE)
  331.         );
  332.         jPanel6Layout.setVerticalGroup(
  333.             jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  334.             .addGap(0, 444, Short.MAX_VALUE)
  335.         );
  336.  
  337.         jTabbedPane1.addTab("Admin Panel", jPanel6);
  338.  
  339.         jMenu1.setText("File");
  340.  
  341.         jMenuItem1.setText("Exit");
  342.         jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
  343.             public void actionPerformed(java.awt.event.ActionEvent evt) {
  344.                 jMenuItem1ActionPerformed(evt);
  345.             }
  346.         });
  347.         jMenu1.add(jMenuItem1);
  348.  
  349.         jMenuBar1.add(jMenu1);
  350.  
  351.         setJMenuBar(jMenuBar1);
  352.  
  353.         javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
  354.         getContentPane().setLayout(layout);
  355.         layout.setHorizontalGroup(
  356.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  357.             .addComponent(jTabbedPane1)
  358.             .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
  359.                 .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
  360.                 .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 318, javax.swing.GroupLayout.PREFERRED_SIZE)
  361.                 .addGap(101, 101, 101))
  362.         );
  363.         layout.setVerticalGroup(
  364.             layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
  365.             .addGroup(layout.createSequentialGroup()
  366.                 .addContainerGap()
  367.                 .addComponent(jLabel1)
  368.                 .addGap(18, 18, 18)
  369.                 .addComponent(jTabbedPane1))
  370.         );
  371.  
  372.         pack();
  373.         setLocationRelativeTo(null);
  374.     }// </editor-fold>                        
  375.  
  376.     private void DestinationActionPerformed(java.awt.event.ActionEvent evt) {                                            
  377.         // TODO add your handling code here:
  378.     }                                          
  379.  
  380.     private void InsertActionPerformed(java.awt.event.ActionEvent evt) {                                      
  381.         try{
  382.           //class.forname("com.mysql.jdbc.Driver");
  383.            con=DriverManager.getConnection("jdbc:mysql://localhost/railwaymanagement","root","");
  384.           String sql="INSERT INTO RailwayManagement"
  385.                   + "(phone_Number,name,count_ticket,Destination) "
  386.                   + "VALUES (?,?,?,?)";
  387.      
  388.           pst=con.prepareStatement(sql);
  389.          
  390.           pst.setString(1,phonenumber.getText());
  391.           pst.setString(2,Name.getText());
  392.           pst.setString(3,countticket.getText());
  393.           pst.setString(4,Destination.getText());
  394.           pst.executeUpdate();
  395.           JOptionPane.showMessageDialog(this, "insert Successfully");
  396.       }
  397.       catch(Exception e)
  398.       {
  399.           JOptionPane.showMessageDialog(this, e.getMessage());
  400.       }
  401.     }                                      
  402.  
  403.     private void Destination1ActionPerformed(java.awt.event.ActionEvent evt) {                                            
  404.         // TODO add your handling code here:
  405.     }                                            
  406.  
  407.     private void UpdateActionPerformed(java.awt.event.ActionEvent evt) {                                      
  408.         try{
  409.         con=DriverManager.getConnection("jdbc:mysql://localhost/railwaymanagement","root","");
  410.           String sql="UPDATE RailwayManagement  SET  Name=?,count_ticket=?,Destination=? WHERE Phone_Number=?";
  411.          
  412.           pst=con.prepareStatement(sql);
  413.          
  414.          
  415.           pst.setString(1,Name.getText());
  416.           pst.setString(2,countticket.getText());
  417.           pst.setString(3,Destination.getText());
  418.           pst.setString(4,phonenumber.getText());
  419.           pst.executeUpdate();
  420.           JOptionPane.showMessageDialog(this, "Update Successfully");
  421.       }
  422.       catch(Exception e)
  423.       {
  424.           JOptionPane.showMessageDialog(this, e.getMessage());
  425.       }
  426.     }                                      
  427.  
  428.     private void DeleteActionPerformed(java.awt.event.ActionEvent evt) {                                      
  429.         try{
  430.             //class.forname("com.mysql.jdbc.Driver");
  431.             con=DriverManager.getConnection("jdbc:mysql://localhost/railwaymanagement","root","");
  432.             String sql="DELETE FROM RailwayManagement  WHERE Phone_Number=?";
  433.  
  434.             pst=con.prepareStatement(sql);
  435.  
  436.             pst.setString(1,jTextField1.getText());
  437.             pst.executeUpdate();
  438.             JOptionPane.showMessageDialog(this, "DELETE Successfully");
  439.         }
  440.         catch(Exception e)
  441.         {
  442.             JOptionPane.showMessageDialog(this, e.getMessage());
  443.         }
  444.     }                                      
  445.  
  446.     private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                          
  447.         JOptionPane.showMessageDialog(this,"Are you sure?");
  448.        System.exit(0);
  449.     }                                          
  450.  
  451.     private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
  452.        
  453.     }                                        
  454.  
  455.     private void NameActionPerformed(java.awt.event.ActionEvent evt) {                                    
  456.         // TODO add your handling code here:
  457.     }                                    
  458.  
  459.     /**
  460.      * @param args the command line arguments
  461.      */
  462.     public static void main(String args[]) {
  463.         /* Set the Nimbus look and feel */
  464.         //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
  465.         /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
  466.          * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
  467.          */
  468.         try {
  469.             for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
  470.                 if ("Nimbus".equals(info.getName())) {
  471.                     javax.swing.UIManager.setLookAndFeel(info.getClassName());
  472.                     break;
  473.                 }
  474.             }
  475.         } catch (ClassNotFoundException ex) {
  476.             java.util.logging.Logger.getLogger(Rail01.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  477.         } catch (InstantiationException ex) {
  478.             java.util.logging.Logger.getLogger(Rail01.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  479.         } catch (IllegalAccessException ex) {
  480.             java.util.logging.Logger.getLogger(Rail01.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  481.         } catch (javax.swing.UnsupportedLookAndFeelException ex) {
  482.             java.util.logging.Logger.getLogger(Rail01.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
  483.         }
  484.         //</editor-fold>
  485.  
  486.         /* Create and display the form */
  487.         java.awt.EventQueue.invokeLater(new Runnable() {
  488.             public void run() {
  489.                 new Rail01().setVisible(true);
  490.             }
  491.         });
  492.     }
  493.  
  494.     // Variables declaration - do not modify                    
  495.     private javax.swing.JButton Delete;
  496.     private javax.swing.JTextField Destination;
  497.     private javax.swing.JTextField Destination1;
  498.     private javax.swing.JButton Insert;
  499.     private javax.swing.JTextField Name;
  500.     private javax.swing.JTextField Name1;
  501.     private javax.swing.JButton Update;
  502.     private javax.swing.JTextField countticket;
  503.     private javax.swing.JTextField countticket1;
  504.     private javax.swing.JButton jButton1;
  505.     private javax.swing.JComboBox<String> jComboBox1;
  506.     private javax.swing.JLabel jLabel1;
  507.     private javax.swing.JLabel jLabel10;
  508.     private javax.swing.JLabel jLabel11;
  509.     private javax.swing.JLabel jLabel12;
  510.     private javax.swing.JLabel jLabel2;
  511.     private javax.swing.JLabel jLabel3;
  512.     private javax.swing.JLabel jLabel4;
  513.     private javax.swing.JLabel jLabel5;
  514.     private javax.swing.JLabel jLabel6;
  515.     private javax.swing.JLabel jLabel7;
  516.     private javax.swing.JLabel jLabel8;
  517.     private javax.swing.JLabel jLabel9;
  518.     private javax.swing.JMenu jMenu1;
  519.     private javax.swing.JMenuBar jMenuBar1;
  520.     private javax.swing.JMenuItem jMenuItem1;
  521.     private javax.swing.JPanel jPanel1;
  522.     private javax.swing.JPanel jPanel2;
  523.     private javax.swing.JPanel jPanel3;
  524.     private javax.swing.JPanel jPanel4;
  525.     private javax.swing.JPanel jPanel5;
  526.     private javax.swing.JPanel jPanel6;
  527.     private javax.swing.JScrollPane jScrollPane1;
  528.     private javax.swing.JScrollPane jScrollPane2;
  529.     private javax.swing.JTabbedPane jTabbedPane1;
  530.     private javax.swing.JTable jTable2;
  531.     private javax.swing.JTextArea jTextArea1;
  532.     private javax.swing.JTextField jTextField1;
  533.     private javax.swing.JTextField phonenumber;
  534.     private javax.swing.JTextField phonenumber1;
  535.     // End of variables declaration                  
  536. }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!