Package org.blueoxygen.common.dal

Examples of org.blueoxygen.common.dal.DbBean.execute()

331
332
333
334
335
336
337
338
339
340
341
                db.connect();
                String date = "";
                Calendar cal = new GregorianCalendar();
                date =cal.get(Calendar.YEAR) + "-" + (cal.get(Calendar.MONTH) + 1) + "-" + cal.get(Calendar.DATE)  ;
                String mySQL = "INSERT INTO pos (create_date, pembulatan) VALUES ('" + date + "','" + pembulatan + "')";
                db.execute(mySQL);

                //mySQL = "INSERT INTO pos_transaction (create_date) VALUES ('" + date + "')";
                //db.execute(mySQL);

                if(paymentType.getSelectedItem().equals("Cash")){
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
                //mySQL = "INSERT INTO pos_transaction (create_date) VALUES ('" + date + "')";
                //db.execute(mySQL);

                if(paymentType.getSelectedItem().equals("Cash")){
                    mySQL = "INSERT INTO pos_transaction(paymentType, totalPayment, totalReturn, create_date) VALUES('" + paymentType.getSelectedItem() + "'," + pay + "," + payReturn + ",'" + date + "')";
                    db.execute(mySQL);                           
                }else{
                    mySQL = "INSERT INTO pos_transaction(paymentType, name, creditCardNo, create_date) VALUES('" + paymentType.getSelectedItem() + "','" + txtName.getText() + "','" + txtNumber.getText() + "','" + date + "')";
                    db.execute(mySQL);
                }
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
                if(paymentType.getSelectedItem().equals("Cash")){
                    mySQL = "INSERT INTO pos_transaction(paymentType, totalPayment, totalReturn, create_date) VALUES('" + paymentType.getSelectedItem() + "'," + pay + "," + payReturn + ",'" + date + "')";
                    db.execute(mySQL);                           
                }else{
                    mySQL = "INSERT INTO pos_transaction(paymentType, name, creditCardNo, create_date) VALUES('" + paymentType.getSelectedItem() + "','" + txtName.getText() + "','" + txtNumber.getText() + "','" + date + "')";
                    db.execute(mySQL);
                }

                int id = 0;
                mySQL = "SELECT MAX(id) from pos";
                ResultSet rs = db.execSQL(mySQL);                      
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
                }

                int a = model.getRowCount();
                for(int i=0 ; i<a ; i++){
                    mySQL = "INSERT INTO product_pos (posId, Quantity, productCode, pos_transId) VALUES (" + id + "," + model.getValueAt(i,3) + ",'" + model.getValueAt(i,0) + "'," + transId + ")";
                    db.execute(mySQL);                       
                }                           

                db.close();
            } catch (SQLException e) {     
                e.printStackTrace();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.