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                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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.awt.event.*;
import java.awt.MenuItem.*;
import java.sql.*;
import sun.jdbc.odbc.*;
import java.io.*;
public class ShopDelivery extends Frame implements 
ActionListener
{

       Label l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12,l13;
       Button exit,save,next,top,prev,botm,ad,show;
       TextField 
txtCMemoNo,txtConsNo,txtCMemoDt,txtConsName,txtAddr1,txtPhNo
,txtBookDtold,txtPrintDt,txtOldCMemNo,txtOldDlryDt,adr2,adr3
,tot,stnry,rmrk;


	   String ConsName;
	   String Addr1;


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

     public ShopDelivery()
     {
		        super("Shop Delivery");
		        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.CYAN);
         setLayout(null);

         l1=new Label("Cashmemo 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("Book 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("OldBkDt");
		 l7.setBounds(30,390,55,30);
		 l7.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l7.setAlignment(Label.CENTER);
         add(l7);

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

         l9=new Label("CMemo No");
		 l9.setBounds(700,390,65,30);
		 l9.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l9.setAlignment(Label.CENTER);
         add(l9);

         l10=new Label("Del Date");
		 l10.setBounds(550,390,55,30);
		 l10.setFont(new Font
("TimesRoman",Font.PLAIN,15));
		 l10.setAlignment(Label.CENTER);
         add(l10);




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

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

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

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

         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);

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

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

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

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




         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);

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

         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);

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

	   }

       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(txtCMemoNo.getText()));
					   pst.setString
(3,txtCMemoDt.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
(txtBookDtold.getText()));
                        pst.setInt(10,Integer.parseInt
(txtPrintDt.getText()));
                        pst.setInt(11,Integer.parseInt
(txtOldDlryDt.getText()));
                        pst.setInt(12,Integer.parseInt
(txtCMemoNo.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);}
				   //cs(txtConsName.getText
(),txtAddr1.getText());
			   }*/




		   if(e.getSource()==ad)
		   {
			try
			{

				txtCMemoNo.setText("");
				txtCMemoDt.setText("");
				txtConsName.setText("");
				txtAddr1.setText("");
				txtPhNo.setText("");
				txtBookDtold.setText("");
				txtPrintDt.setText("");
				//txtCMemoNo.setText("");
				txtOldDlryDt.setText("");
				adr2.setText("");
				adr3.setText("");
				tot.setText("");
				//stnry.setText("");
				//rmrk.setText("");

				Connection 
con1=DriverManager.getConnection("jdbc:odbc:Agency");
		 		Statement 
stmt1=con1.createStatement();
				ResultSet 
rs1=stmt1.executeQuery("SELECT Max(Cons_No) FROM NewCon");
				int nextcono = rs1.getInt
("Cons_No");
				System.out.println
(nextcono);
				nextcono=nextcono+1;
				txtConsNo.setText
("nextcono");


				con1.close();
		    }
		    catch(Exception e4){}

		 }
	   }



}


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
Write a sql query to find n'th maximum in the database table. Oracle3
DAL in oracle  1
 
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