Package realcix20.utils

Examples of realcix20.utils.DAO.update()

940
941
942
943
944
945
946
947
948
949
950
//            System.err.println("taxRow.isAdd() = " + taxRow.isAdd());
//            System.err.println("taxRow.isModify() = " + taxRow.isModify());
//            System.err.println("taxRow.isDelete() = " + taxRow.isDelete());
                       
            if ( (taxRow.isDelete()) && (!taxRow.isAdd()) ) {
                dao.update(Resources.DELETE_RITAXI_SQL);
                dao.setObject(1, oldr);
                dao.setObject(2, oldri);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);
View Full Code Here
949
950
951
952
953
954
955
956
957
958
959
                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);
                dao.setObject(3, taxt);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);               
View Full Code Here
956
957
958
959
960
961
962
963
964
965
966
                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);
                dao.setObject(5, taxi);
View Full Code Here
965
966
967
968
969
970
971
972
973
974
975
                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);
                dao.setObject(4, tax);
                dao.setObject(5, taxi);
View Full Code Here
487
488
489
490
491
492
493
494
495
496
497
            String firstTime = String.valueOf(System.currentTimeMillis());
            GlobalValueManager.setValue("firsttimedate", firstTime);
            Resources.LANGUAGE = GlobalValueManager.getApplicationLang();
            //set LC to LC XR
            DAO dao = DAO.getInstance();
            dao.update(Resources.INSERT_XR_SQL);
            dao.setObject(1, ObjectUtil.findNewCell(currentRow, "FAMILY", "LC").getColumnValue());
            dao.setObject(2, ObjectUtil.findNewCell(currentRow, "FAMILY", "LC").getColumnValue());
            dao.setObject(3, 1);
            StringBuffer bb = new StringBuffer("1970-01-01 01:01:01");
            dao.setObject(4, bb.toString());
View Full Code Here
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
//            System.err.println("r = " + r + "  rDate = " + rDate + "  txt256  = " + txt256);
            String ruser = GlobalValueManager.getValue("SESSION.LOGINUSER");
            String at = GlobalValueManager.getValue("APPLICATION.AT");
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.INSERT_R_SQL);
            dao.setObject(1, r);
            dao.setObject(2, at);
            dao.setObject(3, rDate);
            String now = TimeManager.getTime(System.currentTimeMillis());
            dao.setObject(4, now);
View Full Code Here
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
    }
   
    public static void deleteRI(int r) {
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_RI_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();
       
    }
   
View Full Code Here
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
1528
    }
   
    public static void deleteR(int r) {
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.DELETE_R_SQL);
            dao.setInt(1, r);
            dao.executeUpdate();
       
    }      
   
View Full Code Here
499
500
501
502
503
504
505
506
507
508
509
            sb.append(")");
            String sql = sb.toString();
           
            //Insert rows
            DAO dao = DAO.getInstance();
            dao.update(sql);
            dao.setAutoCommit(false);
           
            int currentParameter = 1;
            columnIter = columns.iterator();
            while (columnIter.hasNext()) {
View Full Code Here
580
581
582
583
584
585
586
587
588
589
590
            sb.append(")");
            String sql = sb.toString();
           
            //Insert rows
            DAO dao = DAO.getInstance();
            dao.update(sql);
            dao.setAutoCommit(false);
           
            int currentParameter = 1;
            columnIter = columns.iterator();
            while (columnIter.hasNext()) {
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.