mainstores.java

Stores management System

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * Pendents.java
 *
 * Created on Apr 29, 2009, 11:39:55 AM
 */

package raja;
import java.util.*;
import java.text.SimpleDateFormat;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author Administrator
 */
public class MainStores extends javax.swing.JFrame  {

    /** Creates new form Pendents */
    public MainStores() {
        initComponents();
        try{
			Class.forName("com.mysql.jdbc.Driver");
			con=DriverManager.getConnection("jdbc:mysql://localhost/raja","root","htp123456");
			st=con.createStatement();
	}
        catch(Exception e){
			System.out.println("Error1 is:"+e);
	}

    }
    void setDetails(){
		try{
                        Object[] options= {"Yes","No"};
                        JOptionPane.showConfirmDialog(null, "Are you sure you want to 'Save'?","Select one",JOptionPane.YES_NO_OPTION);
			String s="insert into mainstores values("+ERDateTextField.getText()+",'"+ERTextField.getText()+"','"+ERItemCodeComboBox.getSelectedItem()+"','"+ERLoCodeComboBox.getSelectedItem()+"','"+ERLoCodeTextField.getText()+"','"+ERWeightTextField.getText()+"','"+ERStWeightTextField.getText()+"','"+ERNameLoComboBox.getSelectedItem()+"','"+ERNameTextField.getText()+"')";
			int result = st.executeUpdate (s);;
		}
		catch(Exception e){
                    JOptionPane.showMessageDialog(null, "Check enterd values"+"\n"+e+"","Error",JOptionPane.ERROR_MESSAGE);
			
		}
	}

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        MainStoresTabbedPane = new javax.swing.JTabbedPane();
        EarRingPanel = new javax.swing.JPanel();
        ERDateLabel = new javax.swing.JLabel();
        ERDateTextField = new javax.swing.JTextField();
        ERItemCodeLabel = new javax.swing.JLabel();
        ERItemCodeComboBox = new javax.swing.JComboBox();
        ERLoCodeLabel = new javax.swing.JLabel();
        ERLoCodeComboBox = new javax.swing.JComboBox();
        ERLoCodeTextField = new javax.swing.JTextField();
        ERWeightLabel = new javax.swing.JLabel();
        ERWeightTextField = new javax.swing.JTextField();
        ERGramWeightLabel = new javax.swing.JLabel();
        ERStWeightLabel = new javax.swing.JLabel();
        ERStWeightTextField = new javax.swing.JTextField();
        ERGramStWeightLabel = new javax.swing.JLabel();
        ERNameLabel = new javax.swing.JLabel();
        ERNameLoComboBox = new javax.swing.JComboBox();
        ERNameTextField = new javax.swing.JTextField();
        ERSaveButton = new javax.swing.JButton();
        ERResetButton = new javax.swing.JButton();
        ERTextField = new javax.swing.JTextField();
        PendentsPanel = new javax.swing.JPanel();
        ERDateLabel1 = new javax.swing.JLabel();
        ERDateTextField1 = new javax.swing.JTextField();
        ERItemCodeLabel1 = new javax.swing.JLabel();
        ERItemCodeComboBox1 = new javax.swing.JComboBox();
        ERLoCodeLabel1 = new javax.swing.JLabel();
        ERLoCodeComboBox1 = new javax.swing.JComboBox();
        ERLoCodeTextField1 = new javax.swing.JTextField();
        ERWeightLabel1 = new javax.swing.JLabel();
        ERWeightTextField1 = new javax.swing.JTextField();
        ERGramWeightLabel1 = new javax.swing.JLabel();
        ERStWeightLabel1 = new javax.swing.JLabel();
        ERStWeightTextField1 = new javax.swing.JTextField();
        ERGramStWeightLabel1 = new javax.swing.JLabel();
        ERNameLabel1 = new javax.swing.JLabel();
        ERNameLoComboBox1 = new javax.swing.JComboBox();
        NameTextField1 = new javax.swing.JTextField();
        ERSaveButton1 = new javax.swing.JButton();
        ERResetButton1 = new javax.swing.JButton();
        ERTextField1 = new javax.swing.JTextField();
        RingsPanel = new javax.swing.JPanel();
        ERDateLabel2 = new javax.swing.JLabel();
        ERDateTextField2 = new javax.swing.JTextField();
        ERItemCodeLabel2 = new javax.swing.JLabel();
        ERItemCodeComboBox2 = new javax.swing.JComboBox();
        ERLoCodeLabel2 = new javax.swing.JLabel();
        ERLoCodeComboBox2 = new javax.swing.JComboBox();
        ERLoCodeTextField2 = new javax.swing.JTextField();
        ERWeightLabel2 = new javax.swing.JLabel();
        ERWeightTextField2 = new javax.swing.JTextField();
        ERGramWeightLabel2 = new javax.swing.JLabel();
        ERStWeightLabel2 = new javax.swing.JLabel();
        ERStWeightTextField2 = new javax.swing.JTextField();
        ERGramStWeightLabel2 = new javax.swing.JLabel();
        ERNameLabel2 = new javax.swing.JLabel();
        ERNameLoComboBox2 = new javax.swing.JComboBox();
        NameTextField2 = new javax.swing.JTextField();
        ERSaveButton2 = new javax.swing.JButton();
        ERResetButton2 = new javax.swing.JButton();
        ERTextField2 = new javax.swing.JTextField();
        BanglesPanel = new javax.swing.JPanel();
        ERDateLabel3 = new javax.swing.JLabel();
        ERDateTextField3 = new javax.swing.JTextField();
        ERItemCodeLabel3 = new javax.swing.JLabel();
        ERItemCodeComboBox3 = new javax.swing.JComboBox();
        ERLoCodeLabel3 = new javax.swing.JLabel();
        ERLoCodeComboBox3 = new javax.swing.JComboBox();
        ERLoCodeTextField3 = new javax.swing.JTextField();
        ERWeightLabel3 = new javax.swing.JLabel();
        ERWeightTextField3 = new javax.swing.JTextField();
        ERGramWeightLabel3 = new javax.swing.JLabel();
        ERStWeightLabel3 = new javax.swing.JLabel();
        ERStWeightTextField3 = new javax.swing.JTextField();
        ERGramStWeightLabel3 = new javax.swing.JLabel();
        ERNameLabel3 = new javax.swing.JLabel();
        ERNameLoComboBox3 = new javax.swing.JComboBox();
        NameTextField3 = new javax.swing.JTextField();
        ERSaveButton3 = new javax.swing.JButton();
        ERResetButton3 = new javax.swing.JButton();
        ERTextField3 = new javax.swing.JTextField();
        ChainsPanel = new javax.swing.JPanel();
        ERDateLabel4 = new javax.swing.JLabel();
        ERDateTextField4 = new javax.swing.JTextField();
        ERItemCodeLabel4 = new javax.swing.JLabel();
        ERItemCodeComboBox4 = new javax.swing.JComboBox();
        ERLoCodeLabel4 = new javax.swing.JLabel();
        ERLoCodeComboBox4 = new javax.swing.JComboBox();
        ERLoCodeTextField4 = new javax.swing.JTextField();
        ERWeightLabel4 = new javax.swing.JLabel();
        ERWeightTextField4 = new javax.swing.JTextField();
        ERGramWeightLabel4 = new javax.swing.JLabel();
        ERStWeightLabel4 = new javax.swing.JLabel();
        ERStWeightTextField4 = new javax.swing.JTextField();
        ERGramStWeightLabel4 = new javax.swing.JLabel();
        ERNameLabel4 = new javax.swing.JLabel();
        ERNameLoComboBox4 = new javax.swing.JComboBox();
        NameTextField4 = new javax.swing.JTextField();
        ERSaveButton4 = new javax.swing.JButton();
        ERResetButton4 = new javax.swing.JButton();
        ERTextField4 = new javax.swing.JTextField();
        SClapPanel = new javax.swing.JPanel();
        ERDateLabel5 = new javax.swing.JLabel();
        ERDateTextField5 = new javax.swing.JTextField();
        ERItemCodeLabel5 = new javax.swing.JLabel();
        ERItemCodeComboBox5 = new javax.swing.JComboBox();
        ERLoCodeLabel5 = new javax.swing.JLabel();
        ERLoCodeComboBox5 = new javax.swing.JComboBox();
        ERLoCodeTextField5 = new javax.swing.JTextField();
        ERWeightLabel5 = new javax.swing.JLabel();
        ERWeightTextField5 = new javax.swing.JTextField();
        ERGramWeightLabel5 = new javax.swing.JLabel();
        ERStWeightLabel5 = new javax.swing.JLabel();
        ERStWeightTextField5 = new javax.swing.JTextField();
        ERGramStWeightLabel5 = new javax.swing.JLabel();
        ERNameLabel5 = new javax.swing.JLabel();
        ERNameLoComboBox5 = new javax.swing.JComboBox();
        NameTextField5 = new javax.swing.JTextField();
        ERSaveButton5 = new javax.swing.JButton();
        ERResetButton5 = new javax.swing.JButton();
        ERTextField5 = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("Main Stores");
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowOpened(java.awt.event.WindowEvent evt) {
                formWindowOpened(evt);
            }
        });

        ERDateLabel.setText("Date          :");

        ERDateTextField.setToolTipText("Date");
        ERDateTextField.setFocusable(false);
        ERDateTextField.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                ERDateTextFieldActionPerformed(evt);
            }
        });

        ERItemCodeLabel.setText("Item Code :");

        ERItemCodeComboBox.setMaximumRowCount(5);
        ERItemCodeComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "H1", "H2", "H3", "H4", "H5", "H6", "H7", "H8", "D1" }));
        ERItemCodeComboBox.setToolTipText("Select Item Code");

        ERLoCodeLabel.setText("Location Code :");

        ERLoCodeComboBox.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "WS1", "WS2", "SC" }));
        ERLoCodeComboBox.setToolTipText("Select Location");