Package realcix20.utils

Examples of realcix20.utils.DAO.query()

1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
    public static int getMAXRIByR(int r) {
       
            int maxRI = -1;
           
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_MAXRI_BY_R_SQL);
            dao.setInt(1, r);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next()) {
                    maxRI = rs.getInt(1);
View Full Code Here
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
    public static int getMAXR() {
       
            int maxR = -1;
           
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_MAX_R_FROM_R_SQL);
            ResultSet rs = dao.executeQuery();
            try {
                if (rs.next())
                    maxR = rs.getInt(1);
                rs.close();
View Full Code Here
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
    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();
            String lc = FamilyClass.getLocalCurrency();
            double xr = TaxClass.getXR(lc, tc, rDate);
            double lamt = tamt * xr;
            dao.query(Resources.INSERT_RI_VALUE_SQL);
            dao.setObject(1, r);
            dao.setObject(2, ri);
            dao.setObject(3, txt256);
            dao.setObject(4, ld);
            dao.setObject(5, tc);
View Full Code Here
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
       
            DAO dao = DAO.getInstance();
            String lc = FamilyClass.getLocalCurrency();
            double xr = TaxClass.getXR(lc, tc, rDate);
            double lamt = tamt * xr;
            dao.query(Resources.INSERT_RI_VALUE_SQL);
            dao.setObject(1, r);
            dao.setObject(2, ri);
            dao.setObject(3, txt256);
            dao.setObject(4, ld);
            dao.setObject(5, tc);
View Full Code Here
1409
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
    public static double getXR(String lc, String tc, String rDate) {
       
            double xr = 1.0;
       
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_XR_SQL);
            dao.setObject(1, lc);
            dao.setObject(2, tc);
            dao.setObject(3, lc);
            dao.setObject(4, tc);
            dao.setObject(5, rDate);
View Full Code Here
321
322
323
324
325
326
327
328
329
330
331
    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();
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
       
       
            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();
View Full Code Here
1434
1435
1436
1437
1438
1439
1440
1441
1442
1443
1444
    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");
View Full Code Here
1454
1455
1456
1457
1458
1459
1460
1461
1462
1463
1464
   
    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 {
View Full Code Here
326
327
328
329
330
331
332
333
334
335
336
                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();
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.