code can't work

[joseph okon]

import javax.swing.*;
import java.rmi.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;
 
public class ChinoBest  extends JFrame implements ActionListener
{
   static JFrame f;
static JPanel pa,Pz,Px;

 

 
String rqty;
String gqty;
int value1;
int value2;
String sum;

JLabel inven,Stockdate,details_good,w_price,r_price,qty,descript,i_total,error;
JLabel salesrecpt,saledate,s_good,rate,s_qty,s_total,s_price;
JLabel chInvent,acct,profit,qtyrem,qtybut,amt,gain,item;

JTextField StockdateField,details_goodField,w_priceField,r_priceField,descriptField,qtyField,i_totalField;
JTextField saledateField,s_goodField,rateField,s_qtyField,s_totalField,s_priceField;
JTextField itemField,qtybutField,qtyremField,amtField,gainField;
 

GridBagLayout gl;
   GridBagConstraints gbc;
Connection con;
   PreparedStatement stat;
   Statement stmt;
        ResultSet rs;

 
public static void main(String args[])
{
   ChinoBest cb=new ChinoBest();
   cb.show();
}
 
public ChinoBest()
{
  f=new JFrame("ChinoBest's Inventory");
  JTabbedPane tab=new JTabbedPane();
  
 pa= new JPanel();
tab.addTab("Stocks",null,pa,"Enter details of goods here");
f.getContentPane().add(tab,BorderLayout.CENTER);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setSize(200,200);
f.setVisible(true); 
  try
 {
   UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
 }
 catch(Exception ex) {
System.err.println("Could not swap LookAndFeel");
}


 
gl = new GridBagLayout();
gbc = new GridBagConstraints();
pa.setLayout(gl);
pa.setBackground(Color.GREEN);
pa.setBounds(100,150,100,100);
 




 JLabel inven= new JLabel("List Of Stocks");
JLabel Stockdate = new JLabel("Date");
JLabel details_good =new JLabel("Name/Detail");
JLabel w_price = new JLabel("Wholesale Price");
JLabel r_price =new JLabel("Retail Price");
JLabel qty = new JLabel("Goods Quantity");
JLabel descript = new JLabel("Description");
JLabel i_total= new JLabel("Total Stockprice");
 
JTextField StockdateField =new JTextField(20);
JTextField details_goodField =new JTextField(20);
JTextField w_priceField=new JTextField(20);
JTextField r_priceField=new JTextField(20);
JTextField qtyField= new JTextField(9);
JTextField descriptField =new JTextField(20);
JTextField i_totalField =new JTextField(7);
 
JButton btotal=new JButton("Enter");
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 4;
gl.setConstraints(Stockdate,gbc);
pa.add(Stockdate);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 4;
gl.setConstraints(Stockdate,gbc);
pa.add(Stockdate);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 6;
gl.setConstraints(details_good,gbc);
pa.add(details_good);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 6;
gl.setConstraints(details_goodField,gbc);
pa.add(details_goodField);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 8;
gl.setConstraints(w_price,gbc);
pa.add(w_price);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 8;
gl.setConstraints(w_priceField,gbc);
pa.add(w_priceField);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 10;
gl.setConstraints(r_price,gbc);
pa.add(r_price);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 10;
gl.setConstraints(r_priceField,gbc);
pa.add(r_priceField);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 12;
gl.setConstraints(qty,gbc);
pa.add(qty);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 12;
gl.setConstraints(qtyField,gbc);
pa.add(qtyField);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 14;
gl.setConstraints(descript,gbc);
pa.add(descript);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 3;
gbc.gridy = 14;
gl.setConstraints(descriptField,gbc);
pa.add(descriptField);
 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 1;
gbc.gridy =16;
gl.setConstraints(i_total,gbc);
pa.add(i_total);

gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx =3;
gbc.gridy = 16;
gl.setConstraints(i_totalField,gbc);
pa.add(i_totalField);
 
 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx =1;
gbc.gridy = 18;
gl.setConstraints(btotal,gbc);
pa.add(btotal);
btotal.addActionListener(this);

 
Px= new JPanel();
tab.addTab("SALES",null,Px,"Submit details of goods sold here");
Px.setLayout(gl);
Px.setBackground(Color.YELLOW);
Px.setBounds(100,150,100,100);

JLabel salerecpt= new JLabel("Sales Of Stocks");
JLabel saledate = new JLabel("Date");
JLabel s_good = new JLabel("Goods");
JLabel s_price = new JLabel("Price sold");
JLabel rate =new JLabel("Rate");
JLabel s_qty = new JLabel("Goods Quantity");
JLabel s_total= new JLabel("Total price");
 
JTextField saledateField =new JTextField(10);
JTextField s_goodField =new JTextField(20);
JTextField s_priceField=new JTextField(20);
JTextField rateField=new JTextField(20);
JTextField s_qtyField= new JTextField(20);
JTextField s_totalField=new JTextField(20);
 
JButton bsale=new JButton("Submit");
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 0;
gbc.gridy = 0;
gl.setConstraints(saledate,gbc);
Px.add(saledate);
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 1;
gbc.gridy = 0;
gl.setConstraints(saledateField,gbc);
Px.add(saledateField);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 3;
gl.setConstraints(s_good,gbc);
Px.add(s_good);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 3;
gl.setConstraints(s_goodField,gbc);
Px.add(s_goodField);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 6;
gl.setConstraints(s_price,gbc);
Px.add(s_price);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 6;
gl.setConstraints(s_priceField,gbc);
Px.add(s_priceField);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 8;
gl.setConstraints(rate,gbc);
Px.add(rate);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 8;
gl.setConstraints(rateField,gbc);
Px.add(rateField);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 10;
gl.setConstraints(s_qty,gbc);
Px.add(s_qty);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 10;
gl.setConstraints(s_qtyField,gbc);
Px.add(s_qtyField);
 

gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy =13;
gl.setConstraints(s_total,gbc);
Px.add(s_total);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx =4;
gbc.gridy = 13;
gl.setConstraints(s_totalField,gbc);
Px.add(s_totalField);

 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx =1;
gbc.gridy = 15;
gl.setConstraints(bsale,gbc);
Px.add(bsale);
bsale.addActionListener(this);

 
Pz= new JPanel();
tab.addTab("Account",null,Pz,"Check details of Account here");
Pz.setLayout(gl);
Pz.setBackground(Color.BLUE);
Pz.setBounds(100,150,100,100);

JLabel acct= new JLabel("Accounts");
JLabel profit = new JLabel("Profits");
JLabel qtyrem = new JLabel("Remaining Goods");
JLabel qtybut = new JLabel("Goods sold");
JLabel gain=new JLabel("Gains");
JLabel item = new JLabel("Goods");
JLabel amt= new JLabel("Total Amount");
 
JTextField qtybutField =new JTextField(20);
JTextField qtyremField =new JTextField(20);
JTextField itemField=new JTextField(20);
JTextField gainField=new JTextField(20);
JTextField amtField= new JTextField(20);
 
JButton bgain=new JButton("Gain");
JButton pen=new JButton("Check");
 
 
gbc.anchor = GridBagConstraints.NORTH;
gbc.gridx = 0;
gbc.gridy = 0;
gl.setConstraints(acct,gbc);
Pz.add(acct);

gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 5;
gl.setConstraints(item,gbc);
Pz.add(item);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 5;
gl.setConstraints(itemField,gbc);
Pz.add(itemField);
 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 7;
gbc.gridy = 5;
gl.setConstraints(pen,gbc);
Pz.add(pen);
pen.addActionListener(this);

 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 8;
gl.setConstraints(qtyrem,gbc);
Pz.add(qtyrem);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 8;
gl.setConstraints(qtyremField,gbc);
Pz.add(qtyremField);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 1;
gbc.gridy = 11;
gl.setConstraints(qtybut,gbc);
Pz.add(qtybut);
 
gbc.anchor = GridBagConstraints.CENTER;
gbc.gridx = 4;
gbc.gridy = 11;
gl.setConstraints(qtybutField,gbc);
Pz.add(qtybutField);
 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 0;
gbc.gridy = 14;
gl.setConstraints(profit,gbc);
Pz.add(profit);
 

 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 4;
gbc.gridy = 17;
gl.setConstraints(amt,gbc);
Pz.add(amt);
 
gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 1;
gbc.gridy = 20;
gl.setConstraints(bgain,gbc);
Pz.add(bgain);
bgain.addActionListener(this);

gbc.anchor = GridBagConstraints.SOUTH;
gbc.gridx = 4;
gbc.gridy = 20;
gl.setConstraints(amtField,gbc);
Pz.add(amtField);

 

try
 {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStocks","","");
  stmt=con.createStatement();
  rs=stmt.executeQuery("SELECT *FROM Stocks");
   while(rs.next())
   {
    rs.getRow();
   }
   con.close();
 }
 catch(Exception e)
 {
  System.out.println("Error : "+e);
 }
}

public void actionPerformed(ActionEvent ae) 
{
try
 {
  Object source =ae.getSource();
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStocks","","");
 if(source == "btotal" )
 {
   try
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStocks","","");
      stat=con.prepareStatement("INSERT INTO Stocks(date1,details_good,w_price,r_price,qty1,descript,i_total) VALUES(?,?,?,?,?,?,?)");
      String Stockdate=StockdateField.getText();
      String details_good=details_goodField.getText();
      String w_price=w_priceField.getText();
      String r_price=r_priceField.getText();
      String qty=qtyField.getText();
      String descript=descriptField.getText();
      String i_total=i_totalField.getText();
    stat.setInt(1,Integer.parseInt(Stockdate));
    stat.setString(2,details_good);
    stat.setDouble(3,Double.parseDouble(w_price));
    stat.setDouble(4,Double.parseDouble(r_price));
    stat.setInt(5,Integer.parseInt(qty));
    stat.setString(6,descript);
    stat.setDouble(7,Double.parseDouble(i_total));
    stat.executeUpdate();
     while(rs.next())
     {
      rs.insertRow();
     }
     con.commit();
     con.setAutoCommit(true);
     con.close();
     error.setText("Row Inserted");
    } //end of try block
    catch(Exception e)
    {
     System.out.println("Error1" +e);
     error.setText("Row cannot be inserted");
    } //end of catch block
    } //end of if block
 

 if(source == "bsale" )
 {
   try
    {
      
      con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStocks","","");
      stat=con.prepareStatement("INSERT INTO Sales VALUES(?,?,?,?,?,?)");
      String saledate=saledateField.getText();
      String s_good=s_goodField.getText();
      String s_price=s_priceField.getText();
      String rate=rateField.getText();
      String s_qty=s_qtyField.getText();
      String s_total=s_totalField.getText();
    stat.setInt(1,Integer.parseInt(saledate));
    stat.setString(2,s_good);
    stat.setDouble(3,Double.parseDouble(s_price));
    stat.setInt(4,Integer.parseInt(rate));
    stat.setInt(5,Integer.parseInt(s_qty));
    stat.setDouble(6,Double.parseDouble(s_total));
    stat.executeUpdate();
     while(rs.next())
     {
      rs.insertRow();
     }
     con.commit();
     stat.close();
     con.close();
    
     error.setText("Row Inserted");
    }
    catch(Exception e)
    {
     System.out.println("Error1" +e);
     error.setText("Row cannot be inserted");
    }
          }
 
 


 

  if(source == "pen")
  {
   try
   {
String str1="SELECT qty1 FROM Stocks WHERE descript =?";
String str="SELECT qty2 FROM Sales WHERE s_good =?";
con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStocks","","");
stmt=con.createStatement();
rs=stmt.executeQuery(str);
rs=stmt.executeQuery(str1);
s_qty.setText(Integer.toString(rs.getInt(1)));
qty.setText(Integer.toString(rs.getInt(2)));
rqty="qty-s_qty";
qtyrem.setText(rqty);

   }
   catch(Exception e)
    {
     System.out.println("Error " + e);
    }
   }
   
   
 




if(source == "bgain")
  {
   try
   {
String str1="SELECT qty1 FROM Stocks WHERE descript=?";
String str="SELECT qty2 FROM Sales WHERE s_good =?";
con=DriverManager.getConnection("jdbc  :-o	  dbc:MyStock","","");
stmt=con.createStatement();
rs=stmt.executeQuery(str);
rs=stmt.executeQuery(str1);
s_qty.setText(Integer.toString(rs.getInt(1)));
qty.setText(Integer.toString(rs.getInt(2)));

sum="(s_qty/qty) *100";
gqty=String.valueOf(sum);
amtField.setText(gqty);

   }
   catch(Exception e)
    {
     System.out.println("Error " + e);
    }
}
}
catch(Exception e){ System.out.println("Not connecting"); }
 

}
 
}  

[edited to add code tags]
[ October 29, 2005: Message edited by: Jeanne Boyarsky ]

[Ernest Friedman-Hill]

Hi,

Welcome to JavaRanch!

"Can't work" isn't very specific. What do you do to run this? What happens? What do you expect to happen instead?

If it's an error that happens while the program is running, would it be possible for you to narrow down the code to show only the part relevant to the problem?