plzzzzzzzzz xplain this code

import java.awt.*;
import java.awt.event.*;
import java.awt.MenuItem.*;
import java.sql.*;
import java.util.Date;
import sun.jdbc.odbc.*;
import java.io.*;
public class RefillBooking 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
txtBookingNo,txtConsNo,txtBookingDt,txtConsName,txtAddr1,txt
PhNo,txtBookDtold,txtPrintDt,txtCMemoNo,txtOldDlryDt,adr2,ad
r3,tot,stnry,rmrk;
Date date=new Date();
String ConsName;
String Addr1;


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

public RefillBooking()
{
super("Refill Booking");
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("Booking 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 (mm/dd/yyyy)");
l3.setBounds(520,60,190,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);

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

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

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

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

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

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)
{
int bkflag=1;
try
{
Connection
con=DriverManager.getConnection("jdbc:odbc:Agency");
PreparedStatement
pst=con.prepareStatement("INSERT INTO RefillBooking VALUES
(?,?,?,?)");
pst.setInt
(1,Integer.parseInt(txtBookingNo.getText()));
pst.setInt
(2,Integer.parseInt(txtConsNo.getText()));
pst.setString
(3,txtBookingDt.getText());
pst.setInt(4,bkflag);

/* pst.setString
(4,txtConsName.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()==show)
{

System.out.println("entered if
body");

try
{

//to bring consumer's
details
Connection
con2=DriverManager.getConnection("jdbc:odbc:Agency");
int consumer=Integer.parseInt
(txtConsNo.getText());
PreparedStatement
ps2=con2.prepareStatement("SELECT * FROM NewCon WHERE
Cons_No=?");
ps2.setInt(1,consumer);
ResultSet rs2=
ps2.executeQuery();
while(rs2.next())
{
System.out.print
("entered while"+rs2.getString(2));
txtConsName.setText
(rs2.getString("Cons_Name"));
txtAddr1.setText
(rs2.getString("Adress1"));
txtPhNo.setText
(""+rs2.getInt("Ph_No"));
adr2.setText
(rs2.getString("Adress2"));
adr3.setText
(rs2.getString("Adress3"));
rmrk.setText("");
}


//Statement
stmt3=con2.createStatement();
//ResultSet
rs3=stmt3.executeQuery("SELECT
CMemoNo,CMemo_Date,DeliveryDate FROM CashMemo where
Cons_No="+consumer);

con2.close();
}
catch(Exception e2)
{System.out.println(e2);}

}

if(e.getSource()==ad)
{
int newbkno=0;
System.out.println("entered if body");
try
{
//to clear textboxes
txtConsName.setText("");
txtAddr1.setText("");
txtBookingNo.setText("");
txtPhNo.setText("");
adr2.setText("");
adr3.setText("");
rmrk.setText("");
txtConsNo.setText("");
txtBookingDt.setText("" + date);
txtBookDtold.setText("");
txtPrintDt.setText("");
txtCMemoNo.setText("");
txtOldDlryDt.setText("");

//to generate bookin no
System.out.println("entered the
try:");
Connection
con1=DriverManager.getConnection("jdbc:odbc:Agency");
Statement
stmt1=con1.createStatement();
ResultSet rs1=stmt1.executeQuery
("SELECT BookingNo FROM RefillBooking ");
while(rs1.next())
{

txtBookingNo.setText
(""+rs1.getInt(1));

}

newbkno=Integer.parseInt
(txtBookingNo.getText());

System.out.println(newbkno);
newbkno=newbkno+1;
txtBookingNo.setText(""+newbkno);
}
catch(Exception e4){System.out.println(e4);}

}




}


}


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Programming Code AllOther Interview Questions

Is it possible to write JAVA program without including any of the packages,such as "import java.io.*"; bcoz I instantly wrote a code without "import..." statement and runned the program on command Line & it worked. the code is: class Person { String name; int age; Person(String s,int a) { name = s; age = a; } accept() { System.out.println(name+"Hi!!!!!"); System.out.println(age); } } class Demo { public static void main(Strings args[])throws IOException { String name = args[0]; int age = Integer.parseInt(args[1]); Person p = new Person(name,age); p.accept(); } }

0 Answers  


i have two internal tables with customer and credit amount in one table then customer and debit amount in another table. now i need output in single list as customer, credit amount, debit amount and (credit - debit). help me please

1 Answers  


how to test the orientation of the layout in android.to note any changes in the ui design when change orientation

0 Answers  


How to get the version(major,minor,revision ) of VB6.0 delphi code .I am able to fetch dll file of vb6.0 but not vba file .Can u send me the code snippet in delphi to get the value for vb6.0.

0 Answers  


You have been asked to install a servlet engine (tomcat, glassfish, etc.) for a companies servlets. Assuming the company has an existing web/DBMS server (which may or may not be on the same server), explain in detail how would you implement the development project and a deployment solution.

0 Answers  






How can we write an algorithm for show max and min from two integer inputs ? without using if() , without any functions ...

1 Answers  


Hello, Can anyone tell me the source code for FLAMES game in Control Language Programming(CLP)of AS/400.

1 Answers  


How can you print an address of a variable?

0 Answers   TCS,


Write a Program to find the reverse of a given number.

0 Answers   InterGraph,


Could u please tell me any UNIX scripts that 'll lead to find the network latency of the servers.?or else any unix command to find the network latency of a server?Thnx in advance...

0 Answers   Cap Gemini,


import java.awt.*; import java.awt.event.*; public class Agency extends Frame implements ActionListener { Label l1,l2,l3,l4; Button b1; TextField t1,t2; String s1,s2,s3,s4; public static void main(String args[]) { new Agency().setVisible(true); } public Agency() { super("Gas Agency Package"); setSize(1280,800); setBackground(Color.lightGray); setLayout(null); // setLayout(new BorderLayout()); t1=new TextField(20); t1.setBounds(440,150,200,30); t1.setBackground(Color.white); t2=new TextField(20); t2.setBounds(440,180,200,30); t2.setBackground(Color.white); t2.setEchoChar('*'); l1=new Label("Gas Agency Package"); l1.setBounds(400,30,300,50); l1.setFont(new Font("TimesRoman",Font.BOLD,25)); l1.setAlignment(Label.CENTER); l2=new Label("Enter your ID and Passoword"); l2.setFont(new Font("TimesRoman",Font.BOLD,20)); l2.setBounds(270,80,300,50); l3=new Label("Enter ID"); l2.setFont(new Font ("TimesRoman",Font.BOLD,20)); l3.setBounds(270,150,120,50); l4=new Label("Enter Passoword"); l2.setFont(new Font ("TimesRoman",Font.BOLD,20)); l4.setBounds(270,180,140,50); add(l1); add(l2); add(l3); add(t1); add(l4); add(t2); b1=new Button("Login"); b1.setBackground(Color.white); b1.setBounds(400,280,100,70); b1.addActionListener(this); add(b1); } public void actionPerformed(ActionEvent e) { if(e.getSource()==b1) { s3="svce"; s4="svce"; s1=t1.getText(); s2=t2.getText(); if(s1.equals(s3) && s2.equals(s4)) { //System.out.println("password is correct"); MenuForm m= new MenuForm(); m.setVisible(true); //this.dispose(); } else { System.out.println("password not correct"); } this.dispose(); } } } plzzzzzzz xplain me this java code like why i m including this packages n the whole code plzzzzzz

0 Answers  


Write a program in prolog to compute the factorial of a number using iteration/tail recursion?

1 Answers  


Categories