SQLException:Column not found? (help me:(

SQLException:Column not found? (help me:(

import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class Mini2 extends JFrame implements ActionListener
{
    String userid="data",password="1234";
    String url="jdbc:odbc:miniprojek";
    Statement stmt;
    Connection con;
    JLabel lblCode,lblName,lblPrice,lblSupplier;
    JTextField txtCode,txtName,txtPrice,txtSupplier;
    JButton btnInsert,btnDisplay,btnSearch,btnDelete,btnExit;
    JTextArea txtDisplay;
    Container c;
    public Mini2()
        {
            super("Store Data");
            setSize(300,400);
            setVisible(true);
            c=getContentPane();
            c.setLayout(new FlowLayout());

            lblCode=new JLabel("Stock Code:");
            lblName=new JLabel("Stock Name:");
            lblPrice=new JLabel("Price per Unit:");
            lblSupplier=new JLabel("Supplier:");

            txtCode=new JTextField(20);
            txtName=new JTextField(20);
            txtPrice=new JTextField(20);
            txtSupplier= new JTextField(20);

            c.add(lblCode);
            c.add(txtCode);
            c.add(lblName);
            c.add(txtName);
            c.add(lblPrice);
            c.add(txtPrice);
            c.add(lblSupplier);
            c.add(txtSupplier);

            btnInsert=new JButton("Insert");
            btnDisplay=new JButton("Display");
            btnSearch=new JButton("Search");
            btnDelete=new JButton("Delete");
            btnExit=new JButton("Exit");
            c.add(btnInsert);
            c.add(btnDisplay);
            c.add(btnSearch);
            c.add(btnDelete);
            c.add(btnExit);
            btnInsert.addActionListener(this);
            btnDisplay.addActionListener(this);
            btnSearch.addActionListener(this);
            btnDelete.addActionListener(this);
            btnExit.addActionListener(this);

            txtDisplay=new JTextArea();
            txtDisplay.setColumns(20);
            c.add(txtDisplay);
        }
    public void actionPerformed(ActionEvent a)
    {
        if(a.getActionCommand() =="Insert")
            insertData();
            if(a.getActionCommand()=="Display")
                accessData();
                if(a.getActionCommand()=="Search")
                    searchData();
                    if(a.getActionCommand()=="Delete")
                    deleteData();
                if(a.getActionCommand()=="Exit")
                {
                    dispose();
                    try{ stmt.close();
                         con.close();
                         System.exit(0);
                    }catch(Exception e){}
                    }
        }

    public void getConnection()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(java.lang.ClassNotFoundException e)
        {
            System.err.print("ClassNotFoundException:");
            System.err.println(e.getMessage());
        }
        try
        {
            con = DriverManager.getConnection(url,userid,password);
        }
        catch(SQLException ex)
        {
            System.err.println("SQLException:"+ex.getMessage());
        }
    }

        public void insertData()//insert data
        {
            String insertString1;
            String Stock_Code=txtCode.getText();
            String Stock_Name = txtName.getText();
            String Price =txtPrice.getText();
            String Supplier =txtSupplier.getText();
            insertString1 = "insert into stock values('"+Stock_Code+"','"+Stock_Name+"','"+Price+"','"+Supplier+"')";
            int codeNum = Integer.parseInt(Stock_Code);

            try
            {
                stmt = con.createStatement();
                stmt.executeUpdate(insertString1);
            }catch(SQLException ex)
            {
                System.err.println("SQLException:"+ex.getMessage());
            }
            JOptionPane.showMessageDialog(null,"Data Inserted into stock Table");
            txtCode.setText("");
            txtName.setText("");
            txtPrice.setText("");
            txtSupplier.setText("");
        }

        public void accessData()
        {
            txtDisplay.setText("");
            txtDisplay.setText("\tDisplay Output");
            txtDisplay.append("\nStock Code\tStock Name\tPrice per Unit\tSupplier\n");

            String result = "";
            String selectString;
            selectString ="select*from stock";
            try
            {
                stmt=con.createStatement();
                ResultSet rs=stmt.executeQuery(selectString);
                while(rs.next())
                {
                    int code=rs.getInt("Stock_Code");
                    String name = rs.getString("Stock_Name");
                    String price = rs.getString("Price");
                    String supplier = rs.getString("Supplier");
                    result+=code+"\t"+name+"\t"+price+"\t"+supplier+"\n";
                }
                txtDisplay.append(result);
            }catch(SQLException ex)
            {
                System.err.println("SQLException:"+ex.getMessage());
            }
        }

        public void searchData()
            {
                txtDisplay.setText("");
                txtDisplay.setText("\tDisplay Output");
                txtDisplay.append("\nStock Code\tStock Name\tPrice per Unit\tSupplier\n");

                String result = "";
                String searchString;
                String code1 = txtCode.getText();

                searchString ="select * from stock where Stock_Code ="+code1;
                int codeNum = Integer.parseInt(code1);
                try
                {
                    stmt=con.createStatement();
                    ResultSet rs=stmt.executeQuery(searchString);
                    while(rs.next())
                    {
                        int code=rs.getInt("Stock_Code");
                        String name = rs.getString("Stock_Name");
                        String price = rs.getString("Price");
                        String supplier = rs.getString("Supplier");
                        result=code+"\t"+name+"\t"+price+"\t"+supplier+"\n";
                    }
                    txtDisplay.append(result);
                }catch(SQLException ex)
                {
                    System.err.println("SQLException:"+ex.getMessage());
                }
        }
        public void deleteData()
        {
            String stockcode = txtCode.getText();
            try{
                Statement stmt = con.createStatement();
                String deleteString = "delete from stock where Stock_Code="+stockcode;
                int codeNum = Integer.parseInt(stockcode);
                int delete = stmt.executeUpdate(deleteString);
            }
            catch (SQLException s)
            {
            System.out.println("SQL statement is not executed!");
            }
            JOptionPane.showMessageDialog(null,"Record is deleted");
        }

        public static void main(String args[])
        {
            Mini2 obj = new Mini2();
            obj.getConnection();
        }
}//end of class


![access database][1]


  [1]: http://i.stack.imgur.com/9fz98.jpg
View Answers









Related Tutorials/Questions & Answers:

Ads