Good day IT Enthusiasts and Pros! I want to ask if any of you has an idea of making a web-based application that involves sales quotation and proposal generation? I badly need some tutorials or some pieces of advice on how to make it in PHP especially involving payments using paypal, bitpal and etc.. Some helpful codes from you might help me a lot. I've been searching over the web about source codes with no success. Please do share your ideas about this. Thank you

I have made a code like this sir JamesCherrill

String bsave="Insert into itemsold (itemid, qpurchase,qamount) values(?,?,?)"; 
             preps=conn.prepareStatement(bsave);
             final int batchSize= 1000;
             int count=0;
             Object [][] temp = new Object[data.length+1][5];
             for(int i=0; i<data.length; i++)
             {
                 for(int j=0;j<5;j++)
                 {
                     //temp[i][j]= data[i][j];
                   // cashier.tbsalesrec.getValueAt(i, j);
                    preps.setObject(1, cashier.tbsalesrec.getValueAt(i, 0).toString());
                    preps.setObject(2, cashier.tbsalesrec.getValueAt(i, 3).toString());
                    preps.setObject(3, cashier.tbsalesrec.getValueAt(i, 4).toString());
                    preps.addBatch();

                    if(++count % batchSize == 0)
                    {
                        preps.executeBatch();
                    }
                 }
             }
             preps.executeBatch();
             preps.close();

            JOptionPane.showMessageDialog(null, "Transaction Saved");

I have a code like this sir JamesCherrill

String bsave="Insert into itemsold (itemid, qpurchase,qamount) values(?,?,?)"; 
             preps=conn.prepareStatement(bsave);
             final int batchSize= 1000;
             int count=0;
             Object [][] temp = new Object[data.length+1][5];
             for(int i=0; i<data.length; i++)
             {
                 for(int j=0;j<5;j++)
                 {
                     //temp[i][j]= data[i][j];
                   // cashier.tbsalesrec.getValueAt(i, j);
                    preps.setObject(1, cashier.tbsalesrec.getValueAt(i, 0).toString());
                    preps.setObject(2, cashier.tbsalesrec.getValueAt(i, 3).toString());
                    preps.setObject(3, cashier.tbsalesrec.getValueAt(i, 4).toString());
                    preps.addBatch();

                    if(++count % batchSize == 0)
                    {
                        preps.executeBatch();
                    }
                 }
             }
             preps.executeBatch();
             preps.close();

            JOptionPane.showMessageDialog(null, "Transaction Saved");

yeah.. i want to get the data from the JTable and insert it in mysql using a batch query

Hello Professionals out there, i am making a point-of-sales systems in java. And i have a jTable named "tbitempurchase" wherein I add the ordered items using an add button.I also have a table in mysql database named "itemSold". Now my problem goes like this, I want to insert the data added from the "tbitempurchase" to mySQL table "itemSold" all at once using a save button with a batch insert query. And i just don't know how to do it. Please, i need help with this. It would be an honor to receive generous and wise comments from you guys.

Hi Guys, I need some help about join queries in SQLite manager. I wanna have some sample queries on joining one or more tables with relationship of course. PLEASE I NEED THIS FOR OUR PROJECT. Thanks. It would be an honor hearing from professionals out there. :)

Hi.. I want to seek help about database in SQL and Jtable in Netbeans. In our sales inventory system, we have these tables in database namely 'stockmasterlist' and 'pricemasterlist'. They are relational since they have in common with regards to their 'ProductNumber'. Now, since they are of different tables but relational, I wanted to display both of their values in ONE JTABLE in Netbeans. So that, everytime the owner wants to see every detail of his product(Not only the name and description but as well the price, quantity, etc), he could just directly see it in one JTABLe. Please, Please please, I need this part for my project. Thanks a lot guys!

You have to know what it is you mean by event diagram. An event table is basically a catalog of use-cases. Each event will have a trigger, source, response, and some sort of destination. What you are asking is quite vague and each owner, manager, supplier, and cashier will have multiple events with multiple use-cases.

Thank you for that generous response sir Stuggie. The business is a convinient store and not that very large that is why im thinking it's the owner, manager and the cashier are only involved. The manager can be purchaser and the stockman that will take care of the stocks. The cashier will do his/her usual job which cater and recieve customer orders. And lastly the owner has the full access on his/her products from adding, modifying, removing of products to managing the accounts.
Thanks for that comment sir

It will be an honor if I could recieve great ideas from you guys..

Hey there... I wanted to ask help in making an event diagram for our sales inventory system. What could be the diagram flow in the system of a convinient store having an owner, manager, supplier and cashier. that is if the manager will work as a purchaser and a stockman as well.. it will be made in ms visio.. thanks pros!