baidyanath.txt

railway managemet project used for railway system

                        .add(jScrollPane7, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                .add(17, 17, 17)
                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel18)
                    .add(jLabel19)
                    .add(jLabel20))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jScrollPane10, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jScrollPane11, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jpanelLayout.createSequentialGroup()
                        .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jpanelLayout.createSequentialGroup()
                                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                                    .add(FATHEROCUUPATIOn, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                    .add(jLabel7)
                                    .add(jLabel13))
                                .add(17, 17, 17)
                                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                                    .add(jLabel8)
                                    .add(MOTHEROCUUPATIOn1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))
                            .add(jScrollPane9, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jpanelLayout.createSequentialGroup()
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                                    .add(jScrollPane8, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                                    .add(jLabel11)))
                            .add(jpanelLayout.createSequentialGroup()
                                .add(26, 26, 26)
                                .add(jpanelLayout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                                    .add(back)
                                    .add(done))))))
                .addContainerGap(46, Short.MAX_VALUE))
        );

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(jpanel, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(jpanel, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        pack();
    }// </editor-fold>                        

    private void doneMouseClicked(java.awt.event.MouseEvent evt) {                                  
 try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
        }
        catch (ClassNotFoundException  e)
        {
            System.out.println("Could not load driver");
        }
 try
 {
 Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:manoj1","system","manoj");
PreparedStatement pstmt=conn.prepareStatement("insert into student1 values(?,?,?,?,?,?)");
pstmt.setString(1,name.getText());
pstmt.setString(2,CLASS.getText());
pstmt.setString(3,section.getText());
pstmt.setString(4,AGE.getText());

/*String da=new String();
String mo=new String();
String ye=new String();
da=da.valueOf(day.getModel());
mo=mo.valueOf(month.getModel());
ye=ye.valueOf(year.getModel());
int day=Integer.parseInt(da);
int mon=Integer.parseInt(mo);
int yea=Integer.parseInt(ye);
//long l=10121252;
/*Date d=new Date(l);//=new  Date();
d.setDate(day);
d.setMonth(mon);
d.setYear(yea);
//Date d=new Date(yea,mon,day);*/
Date d=new Date(1988,5,14);
pstmt.setDate(5,d);
pstmt.setString(6,ROLLNO.getText());
pstmt.executeUpdate();
pstmt.close();

 }
 catch(Exception e)
 {
 e.printStackTrace();
 }

  
 
 this.dispose();
// TODO add your handling code here:
    }                                 
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new studentadd().setVisible(true);
            }
        });
    }
    
    // Variables declaration - do not modify                     
    private javax.swing.JEditorPane AGE;
    private javax.swing.JEditorPane CLASS;
    private javax.swing.JEditorPane FATHERNAME;
    private javax.swing.JComboBox FATHEROCUUPATIOn;
    private javax.swing.JEditorPane MOTHERNAME;
    private javax.swing.JComboBox MOTHEROCUUPATIOn1;
    private javax.swing.JEditorPane ROLLNO;
    private javax.swing.JButton back;
    private javax.swing.JEditorPane city;
    private javax.swing.JComboBox day;
    private javax.swing.JButton done;
    private javax.swing.JLabel fatheredu;
    private javax.swing.JComboBox fathereducation;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane10;
    private javax.swing.JScrollPane jScrollPane11;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JScrollPane jScrollPane7;
    private javax.swing.JScrollPane jScrollPane8;
    private javax.swing.JScrollPane jScrollPane9;
    private javax.swing.JPanel jpanel;
    private javax.swing.JComboBox month;
    private javax.swing.JComboBox mothereducation;
    private javax.swing.JEditorPane name;
    private javax.swing.JEditorPane pincode;
    private javax.swing.JEditorPane plot;
    private javax.swing.JEditorPane previousschool;
    private javax.swing.JEditorPane section;
    private javax.swing.JComboBox year;
    // End of variables declaration                   
    
}