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){}
}
}
}
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);} } } }
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 MarkDelivery extends Frame implements ActionListener { Label l1,l2,l3,l4,l5,l6,l7; Button exit,save,next,top,prev,botm,ad; TextField txtCMemoNo,txtConsNo,txtCMemoDt,txtConsName,txtAddr1,txtBook ingNo,adr2,adr3; public static void main(String sr[]) { new MarkDelivery().setVisible(true); } public MarkDelivery() { super("Mark 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.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); 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) { 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);} //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){} }*/ } }
Write a Program to find whether the given number is a Armstrong number.
Main frame : I have a PS file. 4 records. I need toread a particular field of that file and then add it up. then write the added field along with all other fields
Write code to add functions, which would work as get and put properties of a class?
How can you print an address of a variable?
What is the coding about how to recognize color in fuzzy logic using Matlab R2009b?
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.
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.
How can we write an algorithm for show max and min from two integer inputs ? without using if() , without any functions ...
Write a program that implements a date class containing day, month and year as data members. Implement assignment operator and copy constructor in this class.
i am doing my final year project about programming use verilog ,i am new about it so got problem,i want to record the readings of a waveform every 2us use the verilog code ,every ten readings i need to add them together after that i need to compare this series of number to get which one is the biggest , right now i don't know how to use code to store the readings every 2us on a waveform ,pls help me thanks a lot .