Package realcix20.utils

Examples of realcix20.utils.DAO.executeUpdate()

844
845
846
847
848
849
850
851
852
853
854
                Object value = getOldCellValue(column, row);
                dao.setObject(currentParameter, value);
                currentParameter++;
            }
           
            result = dao.executeUpdate();
           
            if (test)
                dao.rollback();
            else {
                if (!result)
View Full Code Here
946
947
948
949
950
951
952
953
954
955
956
                dao.setObject(1, oldr);
                dao.setObject(2, oldri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);
                dao.executeUpdate();
            } else if ( (!taxRow.isAdd()) && (!taxRow.isDelete()) ) {
               
                dao.update(Resources.DELETE_RITAXI_SQL);
                dao.setObject(1, oldr);
                dao.setObject(2, oldri);
View Full Code Here
955
956
957
958
959
960
961
962
963
964
965
                dao.setObject(1, oldr);
                dao.setObject(2, oldri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);               
                dao.executeUpdate();
                dao.update(Resources.INSERT_RITAXI_SQL);
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
View Full Code Here
963
964
965
966
967
968
969
970
971
972
973
                dao.setObject(2, ri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);
                dao.setObject(6, sign);
                dao.executeUpdate();
            } else if ( (taxRow.isAdd()) && (!taxRow.isDelete()) ) {
                dao.update(Resources.INSERT_RITAXI_SQL);
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, taxt);
View Full Code Here
972
973
974
975
976
977
978
979
980
981
982
                dao.setObject(2, ri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);
                dao.setObject(6, sign);
                dao.executeUpdate();
            }
       
    }
       
    private static Vector getNSAndPAndPA(Row taxRow) {
View Full Code Here
500
501
502
503
504
505
506
507
508
509
510
            dao.setObject(7, 1.0);
            dao.setObject(8, bb.toString());
            dao.setObject(9, ObjectUtil.findNewCell(currentRow, "FAMILY", "FAMILY").getColumnValue());
            dao.setObject(10, bb.toString());
            dao.setObject(11, ObjectUtil.findNewCell(currentRow, "FAMILY", "FAMILY").getColumnValue());
            dao.executeUpdate();                    
            DialogManager.showMessageDialog(this, sb.toString());
            DialogManager.showMessageDialog(this, TxtManager.getTxt("INFORMATION.PLEASELOGIN"));
            dispose();
            new LoginFrame();
        }
View Full Code Here
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
            dao.setObject(5, ruser);
            dao.setObject(6, now);
            dao.setObject(7, ruser);
            dao.setObject(8, txt256);
//            System.err.println("dao.getStatmt = " + dao.getPstmt());
            dao.executeUpdate();
       
    }
   
    public static void insertri_balance(Row taxRow, int r, int ri, String ld, String txt256, String tc, double tamt, String rDate) {
            DAO dao = DAO.getInstance();
View Full Code Here
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
            dao.setObject(8, xr);
            dao.setObject(9, lamt);
            dao.setObject(10, null);
            dao.setObject(11, null);
            dao.setObject(12, null);
            dao.executeUpdate();
    }
   
    public static void insertri(Row taxRow, int r, int ri, String ld, String txt256, String tc, double tamt, String rDate) {
       
            DAO dao = DAO.getInstance();
View Full Code Here
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
            dao.setObject(8, xr);
            dao.setObject(9, lamt);
            dao.setObject(10, ObjectUtil.findNewCell(taxRow, "TAX", "NS").getColumnValue().toString());
            dao.setObject(11, ObjectUtil.findNewCell(taxRow, "TAX", "P").getColumnValue().toString());
            dao.setObject(12, ObjectUtil.findNewCell(taxRow, "TAX", "PA").getColumnValue().toString());
            dao.executeUpdate();
       
    }
   
    public static double getXR(String lc, String tc, String rDate) {
       
View Full Code Here
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
    public static void deleteRI(int r) {
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_RI_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();
       
    }
   
    public static void deleteR(int r) {
       
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.