Package realcix20.utils

Examples of realcix20.utils.DAO

320
321
322
323
324
325
326
327
328
329
330
331
332
   
    private PublicKey getPublicKey() {
       
            PublicKey publicKey = null;
       
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_KEYPAIR_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next())
                    publicKey = (PublicKey)rs.getObject("PUBKEY");
                rs.close();
            } catch (Exception e) {
View Full Code Here
340
341
342
343
344
345
346
347
348
349
350
351
352
    private PrivateKey getPrivateKey() {
       
       
            PrivateKey privateKey = null;
       
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_KEYPAIR_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next())
                    privateKey = (PrivateKey)rs.getObject("PRIKEY");
                rs.close();
            } catch (Exception e) {
View Full Code Here
1433
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
1445
1446
   
    public static String getBalanceLD() {
       
            String balanceLD = null;           
            String lt = "X";
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_DEFLD_SQL);
            dao.setObject(1, lt);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
                    balanceLD = rs.getString("DEFLD");
                }
                rs.close();
View Full Code Here
1453
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
    }
   
    public static String getLD(Row taxRow) {
       
            String ld = null;
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_LD_FROM_PA_SQL);
            dao.setObject(1, ObjectUtil.findNewCell(taxRow, "TAX", "NS").getColumnValue().toString());
            dao.setObject(2, ObjectUtil.findNewCell(taxRow, "TAX", "P").getColumnValue().toString());
            dao.setObject(3, ObjectUtil.findNewCell(taxRow, "TAX", "PA").getColumnValue().toString());
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
                    ld = rs.getString("LD");
                }
                rs.close();
View Full Code Here
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
       
    }
   
    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
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526
1527
       
    }
   
    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
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
                }
                if (!findComponent) {
                    Vector parameters = relationManager.getParameters(childComponentExt);
                    if (parameters != null) {
                        String sql = relationManager.getSQL(childComponentExt, parameters);
                        DAO dao = DAO.getInstance();
                        dao.query(sql);
                        for (int i = 0; i < parameters.size(); i++) {

                            String parameter = (String)parameters.get(i);
                            StringTokenizer st = new StringTokenizer(parameter, ".");
                            String tableName = (String)st.nextElement();
                            String columnName = (String)st.nextElement();
                            ComponentExt tempComponentExt = relationManager.findComponentExt(tableName, columnName);
                            JComponent tempComponent = tempComponentExt.getComponent();                                   
                            dao.setObject(i+1, ComponentManager.getValue(tempComponent));

                        }
                        ResultSet rs = dao.executeQuery();
                        try {                                   
                            if (rs.next()) {
                                ResultSetMetaData rsmd = rs.getMetaData();
                                for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                                    ComponentExt tempComponentExt = relationManager.findComponentExt(column.getTableName(), rsmd.getColumnName(i));
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
                whereValues.add(ObjectUtil.findNewCell(row, pkColumn.getTableName(), pkColumn.getColumnName()).getColumnValue());
            }
        }
        sb.delete(sb.lastIndexOf("AND"), sb.lastIndexOf("AND") + 3);
        String sql = sb.toString();
        DAO dao = DAO.getInstance();
        dao.query(sql);
        for (int i = 0; i < whereValues.size(); i++) {
            dao.setObject(i + 1, whereValues.get(i));
        }
        ResultSet rs = dao.executeQuery();
        try {
            while (rs.next()) {
                Row childRow = new Row(rs);
                row.getRowSet().getRows().add(childRow);
                getRows().add(childRow);
View Full Code Here
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
            sb.delete(sb.lastIndexOf(","), sb.lastIndexOf(",") + 1);
            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()) {
                Column column = (Column)columnIter.next();
                if (column.getTableName().equals(mainTableName)) {
                    Object value = getNewCellValue(column, row);
                    dao.setObject(currentParameter, value);
                    currentParameter++;
                }
            }
           
            result = dao.executeUpdate();
           
            if (test) {
                dao.rollback();
            }
            else {
                if (!result) {
                    dao.rollback();
                }
                else {
                   
                    dao.commit();
                   
                    if (isSlayerMaster()) {
                    
                        Iterator rowIter = row.getRowSet().getRows().iterator();
                        while (rowIter.hasNext()) {

                            Row childRow = (Row)rowIter.next();
                            if (childRow != row) {
                                if (!childRow.isDelete())
                                    classInsert_Child(childRow, false);
                            }

                        }
                       
                    }                                                       
                   
                }                   
            }
           
            dao.setAutoCommit(true);
                       
            return result;
       
    }
View Full Code Here
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
            sb.delete(sb.lastIndexOf(","), sb.lastIndexOf(",") + 1);
            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()) {
                Column column = (Column)columnIter.next();
                if (column.getTableName().equals(tableName)) {                   
                    Object value = getNewCellValue(column, row);
                    dao.setObject(currentParameter, value);
                    currentParameter++;
                }
            }
           
            result = dao.executeUpdate();
           
            if (test)
                dao.rollback();
            else {
                if (!result)
                    dao.rollback();
                else
                    dao.commit();
            }
           
            dao.setAutoCommit(true);
           
            return result;
       
    }
View Full Code Here
TOP

Related Classes of realcix20.utils.DAO

  • com.jgoodies.forms.factories.DefaultComponentFactory
  • com.jgoodies.forms.layout.CellConstraints
  • com.jgoodies.forms.layout.ColumnSpec
  • com.jgoodies.forms.layout.FormLayout
  • com.jgoodies.forms.layout.RowSpec
  • info.clearthought.layout.TableLayout
  • org.jdesktop.swingx.decorator.AlternateRowHighlighter
  • org.jdesktop.swingx.decorator.HighlighterPipeline
  • org.jdesktop.swingx.decorator.RolloverHighlighter
  • org.jdesktop.swingx.JXTable
    • Copyright © 2018 www.massapicom. 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.