ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Code Snippets  >>  Programming Code  >>  Programming Code AllOther
 
 


 

 
 C Code interview questions  C Code Interview Questions
 C++ Code interview questions  C++ Code Interview Questions
 VC++ Code interview questions  VC++ Code Interview Questions
 Java Code interview questions  Java Code Interview Questions
 Dot Net Code interview questions  Dot Net Code Interview Questions
 Visual Basic Code interview questions  Visual Basic Code Interview Questions
 Programming Code AllOther interview questions  Programming Code AllOther Interview Questions
plzzzzzzzzz xplain this code 

import java.awt.*;
import java.util.Date;
import java.awt.event.*;
import java.awt.MenuItem.*;
import java.sql.*;
import sun.jdbc.odbc.*;
import java.io.*;
public class NewConnection extends Frame implements 
ActionListener
{

       Label l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13;
       Button exit,save,bnext,top,prev,botm,ad,edit;
       TextField 
txtSvNo,txtConsNo,txtSvDt,txtConsName,txtAddr1,txtPhNo,txtCy
lQty,txtCylDep,txtRegDep,txtRegQty,adr2,adr3,tot,stnry,rmrk;
       Date date=new Date();
	   String ConsName;
	   String Addr1;


     public static void main(String sr[])
     {
         new NewConnection().setVisible(true);
     }

     public NewConnection()
     {
		        super("New Connection");
		        Statement stmt;
		 		ResultSet rs;
		 		//PreparedStatement pst;
		 		Connection con;
		 		try
		 		{

		 		 Class.forName
("sun.jdbc.odbc.JdbcOdbcDriver");
		 		  
con=DriverManager.getConnection("jdbc:odbc:Agency");
		 		 if (con!=null);
		 		 System.out.println
("connected");
		 		 stmt =con.createStatement
();



		 		}
		 		catch(Exception e1)
		 		{
					System.out.println
(e1);
		        }


         setSize(1280,800);
         setBackground(Color.lightGray);
         setLayout(null);

         l1=new Label("SV NO");
		 l1.setBounds(260,60,90,30);
		 l1.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l1.setAlignment(Label.CENTER);
         add(l1);

         l2=new Label("CONSMR NO");
         l2.setBounds(30,60,90,30);
         l2.setFont(new Font("TimesRoman",Font.PLAIN,15));
         l2.setAlignment(Label.CENTER);
         add(l2);

         l3=new Label("SV DATE");
	     l3.setBounds(520,60,90,30);
		 l3.setFont(new Font
("TimesRoman",Font.PLAIN,15));
	     l3.setAlignment(Label.CENTER);
         add(l3);

	     l4=new Label("NAME");
		 l4.setBounds(30,150,45,30);
		 l4.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l4.setAlignment(Label.CENTER);
         add(l4);

         l5=new Label("ADRS");
		 l5.setBounds(30,220,45,30);
		 l5.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l5.setAlignment(Label.CENTER);
         add(l5);

         l6=new Label("PH NO");
		 l6.setBounds(500,150,45,30);
		 l6.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l6.setAlignment(Label.CENTER);
         add(l6);


		 l7=new Label("CYLDR");
		 l7.setBounds(30,390,55,30);
		 l7.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l7.setAlignment(Label.CENTER);
         add(l7);

         l8=new Label("DEPOSIT");
         l8.setBounds(320,390,65,30);
         l8.setFont(new Font("TimesRoman",Font.PLAIN,15));
         l8.setAlignment(Label.CENTER);
         add(l8);

         l9=new Label("DEPOSIT");
		 l9.setBounds(320,440,65,30);
		 l9.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l9.setAlignment(Label.CENTER);
         add(l9);

         l10=new Label("RGLTR");
		 l10.setBounds(30,440,55,30);
		 l10.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l10.setAlignment(Label.CENTER);
         add(l10);

         l11=new Label("TOTAL");
		 l11.setBounds(320,480,55,30);
		 l11.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l11.setAlignment(Label.CENTER);
         add(l11);

         l12=new Label("Cur.Statn.NO.");
		 l12.setBounds(290,550,85,30);
		 l12.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l12.setAlignment(Label.CENTER);
	     add(l12);

         l13=new Label("REMARKS");
		 		 l13.setBounds
(30,630,85,30);
		 		 l13.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 		 l13.setAlignment
(Label.CENTER);
	     add(l13);

         txtSvNo=new TextField();
         txtSvNo.setBounds(375,60,80,30);
         txtSvNo.setBackground(Color.white);
         add(txtSvNo);

         txtConsNo=new TextField();
		 txtConsNo.setBounds(130,60,80,30);
         txtConsNo.setBackground(Color.white);
	     add(txtConsNo);

         txtSvDt=new TextField();
         txtSvDt.setBounds(635,60,80,30);
		 txtSvDt.setBackground(Color.white);
		 add(txtSvDt);

         txtConsName=new TextField();
		 txtConsName.setBounds(100,150,200,30);
		 txtConsName.setBackground(Color.white);
         add(txtConsName);

         txtAddr1=new TextField();
		 txtAddr1.setBounds(100,220,350,30);
     	 txtAddr1.setBackground(Color.white);
	     add(txtAddr1);

	     adr2=new TextField();
	     adr2.setBounds(100,250,350,30);
	     adr2.setBackground(Color.white);
	     add(adr2);

	     adr3=new TextField();
		 adr3.setBounds(100,280,350,30);
		 adr3.setBackground(Color.white);
	     add(adr3);

	     txtPhNo=new TextField();
		 txtPhNo.setBounds(570,150,150,30);
		 txtPhNo.setBackground(Color.white);
	     add(txtPhNo);

         txtCylQty=new TextField();
	     txtCylQty.setBounds(100,390,60,30);
	     txtCylQty.setBackground(Color.white);
	     add(txtCylQty);

	     txtCylDep=new TextField();
		 txtCylDep.setBounds(410,390,60,30);
		 txtCylDep.setBackground(Color.white);
		 add(txtCylDep);

		 txtRegDep=new TextField();
		 txtRegDep.setBounds(410,440,60,30);
    	 txtRegDep.setBackground(Color.white);
		 add(txtRegDep);

		 txtRegQty=new TextField();
		 txtRegQty.setBounds(100,440,60,30);
		 txtRegQty.setBackground(Color.white);
		 add(txtRegQty);

		 tot=new TextField();
		 tot.setBounds(410,490,60,30);
		 tot.setBackground(Color.white);
		 add(tot);

         stnry=new TextField();
		 stnry.setBounds(410,550,60,30);
		 stnry.setBackground(Color.white);
		 add(stnry);

         rmrk=new TextField();
		 rmrk.setBounds(140,630,600,30);
		 rmrk.setBackground(Color.white);
		 add(rmrk);

         exit=new Button("EXIT");
         exit.setBackground(Color.orange);
         exit.setBounds(760,700,40,40);
         exit.addActionListener(this);
         add(exit);

         save=new Button("SAVE");
		 save.setBackground(Color.orange);
		 save.setBounds(715,700,40,40);
		 save.addActionListener(this);
         add(save);

         bnext=new Button("NEXT");
	     bnext.setBackground(Color.orange);
		 bnext.setBounds(90,700,40,40);
		 bnext.addActionListener(this);
         add(bnext);

         top=new Button("TOP");
         top.setBackground(Color.orange);
         top.setBounds(0,700,40,40);
         top.addActionListener(this);
         add(top);

         prev=new Button("PREV");
		          prev.setBackground(Color.orange);
		          prev.setBounds(45,700,40,40);
		          prev.addActionListener(this);
         add(prev);


		 botm=new Button("BOTM");
		 		  botm.setBackground
(Color.orange);
		 		  botm.setBounds
(135,700,40,40);
		 		  botm.addActionListener
(this);
         add(botm);

         ad=new Button("ADD");
		 		  ad.setBackground
(Color.orange);
		 		  ad.setBounds
(300,700,40,40);
		 		  ad.addActionListener
(this);
         add(ad);

         edit=new Button("EDIT");
		 		  edit.setBackground
(Color.orange);
		 		  edit.setBounds
(345,700,40,40);
		 		  edit.addActionListener
(this);
         add(edit);

	   }

       public void actionPerformed(ActionEvent e)
	   {
           if(e.getSource()==exit)
           {
		   		this.dispose();
		   		System.exit(0);
	       }



			  if(e.getSource()==save)
			   {
				   try
				   {
					   Connection 
con=DriverManager.getConnection("jdbc:odbc:Agency");
					   
PreparedStatement pst=con.prepareStatement("INSERT INTO 
NewCon values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
					   pst.setInt
(1,Integer.parseInt(txtConsNo.getText()));
					   pst.setInt
(2,Integer.parseInt(txtSvNo.getText()));
					   pst.setString
(3,txtSvDt.getText());
					   pst.setString
(4,txtConsName.getText());
                       pst.setInt(5,Integer.parseInt
(txtPhNo.getText()));
                       pst.setString(6,txtAddr1.getText());
                       pst.setString(7,adr2.getText());
                       pst.setString(8,adr3.getText());
                       pst.setInt(9,Integer.parseInt
(txtCylQty.getText()));
                       pst.setInt(10,Integer.parseInt
(txtCylDep.getText()));
                       pst.setInt(11,Integer.parseInt
(txtRegQty.getText()));
                       pst.setInt(12,Integer.parseInt
(txtRegDep.getText()));
                       pst.setInt(13,Integer.parseInt
(tot.getText()));
                       pst.setInt(14,Integer.parseInt
(stnry.getText()));
                       pst.setString(15,rmrk.getText());
					   pst.executeUpdate
();
					   con.close();
				   }
				   catch(Exception e2)
				   {System.out.println(e2);}

			   }




		   if(e.getSource()==ad)
		   {
			   int newcono=60000,newsvno=10000;
			   System.out.println("entered if 
body");
			try
			{

				System.out.println("entered 
the try:");
				Connection 
con1=DriverManager.getConnection("jdbc:odbc:Agency");
		 		Statement 
stmt1=con1.createStatement();
				ResultSet 
rs1=stmt1.executeQuery("SELECT Cons_No,Sv_No FROM NewCon ");

                while(rs1.next())
                {
				
	 //System.out.println(rs1.getInt("Cons_No"));
                     txtConsNo.setText(""+rs1.getInt(1));
                     txtSvNo.setText(""+rs1.getInt(2));
                     //newcono=rs1.getInt("Cons_No");



				}

                //rs1.last();
                 newcono=Integer.parseInt(txtConsNo.getText
());
                  newsvno=Integer.parseInt(txtSvNo.getText
());

                //newcono=rs1.getInt("Cons_No");
                 System.out.println(newcono);

				newcono=newcono+1;
                newsvno=newsvno+1;
				txtConsNo.setText
(""+newcono);

				txtSvNo.setText(""+newsvno);
				txtSvDt.setText(""+ date);
				txtConsName.setText("");
				txtAddr1.setText("");
				txtPhNo.setText("");
				txtCylQty.setText("");
				txtCylDep.setText("");
				txtRegDep.setText("");
				txtRegQty.setText("");
				adr2.setText("");
				adr3.setText("");
				tot.setText("");
				stnry.setText("");
				rmrk.setText("");
				con1.close();
		    }
		    catch(Exception e4){System.out.println
(e4);}

		 }
		 if(e.getSource()==bnext)
		 {
		    try{
                 Connection con2=DriverManager.getConnection
("jdbc:odbc:Agency");
                   	Statement stmt2=con2.createStatement
();
				ResultSet 
rs2=stmt2.executeQuery("SELECT * FROM NewCon ");
                  rs2.next();
                 {
                    txtConsNo.setText(rs2.getInt(1)+"");

				    txtSvNo.setText
(rs2.getInt(2)+"");
				    txtSvDt.setText
(rs2.getString(3)+"");
			        txtConsName.setText
(rs2.getString(4)+"");
				     txtPhNo.setText
(rs2.getInt(5)+"");
                    txtAddr1.setText(rs2.getString(6)+"");

				     adr2.setText
(rs2.getString("Address2")+"");
				    adr3.setText
(rs2.getString("Address3")+"");
				    txtCylQty.setText
(rs2.getInt(9)+"");
				    txtCylDep.setText
(rs2.getInt(10)+"");
				    txtRegDep.setText
(rs2.getInt(11)+"");
				    txtRegQty.setText
(rs2.getInt(12)+"");

				    tot.setText(rs2.getInt
(13)+"");
			     	stnry.setText(rs2.getInt(14)
+"");
			    	rmrk.setText(rs2.getString
(15)+"");
				  }

               }
               catch(Exception e5){}
         }
	   }



}


No Answer is Posted For this Question

Be the First to Post Answer

 
 
 
Other Programming Code AllOther Interview Questions
 
  Question Asked @ Answers
 
i wrote from two tables (employee and department) 1.select * from employee,department; (it is cartesian product) but 2.select * from employee department; (?????????????????) by default it displays the employee table,what is the reason it is not taking department ??? mail @ mak2786@gmail.com Arunkumar  1
DAL in oracle  1
Write a sql query to find n'th maximum in the database table. Oracle3
 
For more Programming Code AllOther Interview Questions Click Here 
         
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com