List of filterSQL() Examples

Examples of filterSQL()

nu.lazy8.ledger.jdbc.DataConnection.filterSQL()
Description of the Method @param in Description of the Parameter @return Description of the Return Value

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      if (isSortByAccType) {
        select = select + " ORDER BY IsInBalanceReport DESC,SortOrder,APP.Account.Account";
      } else {
        select = select + " ORDER BY APP.Account.Account";
      }
      ResultSet rs = st.executeQuery(dc.filterSQL(select));
      if (rs.next()) {
        //count how many rows
        int numRows = 0;
        rs.last();
        numRows = rs.getRow();

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      DataConnection dc = new DataConnection(null);
      if (dc == null || !dc.bIsConnectionMade) {
        return;
      }
      Statement st = dc.con.createStatement();
      ResultSet rsAccounts = st.executeQuery(dc.filterSQL(
          "SELECT APP.Account.Account FROM APP.Account WHERE " +
          "(IsAsset=0 AND (APP.Account.Account<3000 OR APP.Account.Account>=10000)) " +
          "OR (IsAsset=1 AND (APP.Account.Account<1000 OR APP.Account.Account>=3000)) "));
      int numEuBasErrors = 0;
      if (rsAccounts.next()) {

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      if (rsAccounts.next()) {
        rsAccounts.last();
        numEuBasErrors = rsAccounts.getRow();
      }
      st = dc.con.createStatement();
      rsAccounts = st.executeQuery(dc.filterSQL(
          "SELECT CompId,APP.Account.Account,AccDesc,IsAsset FROM APP.Account"));
      int numRows = 0;
      if (rsAccounts.next()) {
        rsAccounts.last();
        numRows = rsAccounts.getRow();

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

                defaultIsAsset = ACCOUNT_TYPE_ASSET;
              }
            }
          } else {
            Statement st2 = dc.con.createStatement();
            ResultSet rsSumAccounts = st2.executeQuery(dc.filterSQL(
                "SELECT Sum(Amount.Amount * ((2 * Amount.IsDebit) - 1) ) AS SumOfAmount1 " +
                "FROM Amount WHERE CompId=" + rsAccounts.getInt(1)
                 + " AND Amount.Account=" + AccountNum));
            if (oldIsAsset == 0) {
              defaultIsAsset = ACCOUNT_TYPE_INCOME;

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

                }
              }
            }
          }
          Statement st3 = dc.con.createStatement();
          st3.executeUpdate(dc.filterSQL(
              "UPDATE APP.Account SET IsAsset=" + defaultIsAsset + " WHERE CompId="
               + rsAccounts.getInt(1) + " AND APP.Account.Account=" + AccountNum));
        }
      }
    } catch (Exception eee) {

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

          Statement st ;
          PreparedStatement prepSt;
          DataConnection.AddDefaultAccountTypes(0);
          //copy old Customer table into new Customer2 table
          st = dc.con.createStatement();
          ResultSet rsOldCustomers = st.executeQuery(dc.filterSQL(
              "SELECT CompId,CustId,CustName,CustDesc  FROM Customer"));
          while (rsOldCustomers.next()) {
            prepSt = dc.con.prepareStatement("INSERT INTO Customer2 (CompId,CustId,CustName,CustDesc,DefaultAcc) VALUES (?,?,?,?,?)");
            prepSt.setInt(1, rsOldCustomers.getInt(1));
            prepSt.setInt(2, rsOldCustomers.getInt(2));

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

            return;
          }
          //copy old Activity table into new Activity2 table
          //UniqNumGenerator uniqnum = new UniqNumGenerator(); // commented out since never used
          Statement st = dc.con.createStatement();
          ResultSet rsOldTrans = st.executeQuery(dc.filterSQL(
              "SELECT CompId,Act_id,RegDate,InvDate,Notes,FileInfo FROM Activity ORDER BY CompId,Act_id"));
          rsOldTrans.last();
          int numRecs=rsOldTrans.getRow();
          rsOldTrans.beforeFirst();
          while (rsOldTrans.next()) {

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      DataConnection dc = new DataConnection(null);
      if (dc == null || !dc.bIsConnectionMade) {
        return;
      }
      //get rid of all uniq num posts for period ids
      dc.con.createStatement().executeQuery(dc.filterSQL(
        "DELETE FROM UniqNum WHERE UniqName LIKE 'PeriodId=%'"));
      //adjust the periodid for each activity
      UniqNumGenerator uniqnum = new UniqNumGenerator();
      ResultSet rsPeriods=null;
      String select="SELECT CompId,Act_id,InvDate FROM Activity2 ";

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      ResultSet rsPeriods=null;
      String select="SELECT CompId,Act_id,InvDate FROM Activity2 ";
      if (inCompId>0)
        select+=" WHERE CompId=" + inCompId;
      select+=" ORDER BY CompId,Act_id";
      ResultSet rsOldTrans = dc.con.createStatement().executeQuery(dc.filterSQL(select));
      int lastCompId=-1;
      rsOldTrans.last();
      int numRecs=rsOldTrans.getRow();
      rsOldTrans.beforeFirst();
      while (rsOldTrans.next()) {

View Full Code Here

Examples of nu.lazy8.ledger.jdbc.DataConnection.filterSQL()

      rsOldTrans.beforeFirst();
      while (rsOldTrans.next()) {
        if (lastCompId!=rsOldTrans.getInt(1)){
          //get all the periods for the CompId
          lastCompId=rsOldTrans.getInt(1);
          rsPeriods=dc.con.createStatement().executeQuery(dc.filterSQL(
            "SELECT StartPeriod,EndPeriod FROM AccountingPeriods WHERE CompId=" + lastCompId));
        }
        Date invoiceDate=rsOldTrans.getDate(3);
        int periodId=0;
        rsPeriods.beforeFirst();

View Full Code Here

0 1 2 3 4

TOP

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.