Answer / durgesh kumar

import java.awt.*; ///for gui
import java.awt.event.*; // for event handling
import java.awt.MenuItem.*; // menu item
import java.sql.*; // for sql quiries
import sun.jdbc.odbc.*; // for creaing jdbc connection
import java.io.*; // for getting data in and out in the
database
public class MarkDelivery extends Frame implements
ActionListener /// actionlistener is used to perform any
action such as clicking on buuton
{

Label l1,l2,l3,l4,l5,l6,l7; // for creating label
Button exit,save,next,top,prev,botm,ad; // for
declaring button
TextField
txtCMemoNo,txtConsNo,txtCMemoDt,txtConsName,txtAddr1,txtBook; //for
declaring textfields
String No,adr2,adr3;




public static void main(String sr[])
{
new MarkDelivery().setVisible(true); // making the
constructor visible
}

public MarkDelivery() //declaration of cnostructor
{
super("Mark Delivery"); // to print it on the
title bar
Statement stmt; //declaring statement
ResultSet rs; // rs will store the results from the db
//PreparedStatement pst;
Connection con; //declaration for connection
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //
creating driver

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);//setting the size of frame in
the window
setBackground(Color.lightGray);
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);

l1=new Label("Booking No");
l1.setBounds(30,90,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("Cashmemo Date");
l3.setBounds(520,60,130,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);

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

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






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); ///registering the save
button for action to be performed
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);



}

public void actionPerformed(ActionEvent e) // call
of action performed method
{
if(e.getSource()==exit)
{
this.dispose(); // it will close the window
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()));
// gets the text from the text field which has integer vale
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);}
//cs(txtConsName.getText
(),txtAddr1.getText());
}




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

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

txtSvNo.setText("");
txtSvDt.setText("");
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){}

}*/
}



}
s///please specify in which line do u have the problem
actually this program will create a form and the data
provided will be stored in the database.

Find out the list of roles which gives access to all t-codes in SAP? Thanks in advance.

0 Answers  

---

Beautiful is for 012345678 9 and a code for similar word containing the same alphabets

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 to find the list of users who have two codes su01 and pfcg? thank in advance all.

0 Answers  

---

Write code to add functions, which would work as get and put properties of a class?

0 Answers  

---

---

In LSMW , what does the following error mean and how to rectify it : Incorrect interface data for set 78 in method C . This error is occuring in idoc processing step of LSMW.

0 Answers   Wipro,

---

I have a file which contains so many lines and variable number of lines are treated as a record. For example *first ooooo xxxxx ttttt mmmm vvvvvvv *end uuu bbbb *first kkkkvvvvvv nnnn mmmmm kkkkk fffff gggg ffff kkkk lllll *end. Here the lines from *first to *end are treated as a record. The number of lines between *first and *end is not same for all the records. Suppose there are 100 records (or number of records are not predefined)like the format given in the above example. Now the entire file needs to split into two files, first having 40 and remaining in the second file. Can we split using sort utility? If possible then what is the sort card?

0 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 Answers  

---

how to write test case for a text field that should be mandatory

1 Answers   PayPal,

---

Devise a program to implement the Fibonacci sequence.

0 Answers   Tech Mahindra,

---

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,

---

what full form name of B.K.U.

0 Answers  

---