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()

      st = dcc.con.createStatement();
      st.executeUpdate(dcc.filterSQL("DELETE FROM UniqNum WHERE CompId=" + companyId));
      st = dcc.con.createStatement();
      st.executeUpdate(dcc.filterSQL("DELETE FROM AccountingPeriods WHERE CompId=" + companyId));
      st = dcc.con.createStatement();
      st.executeUpdate(dcc.filterSQL("DELETE FROM AccountType WHERE CompId=" + companyId));
      if (deleteCompanyDef) {
        st = dcc.con.createStatement();
        st.executeUpdate(dcc.filterSQL("DELETE FROM Company WHERE CompId=" + companyId));
      }
      EditBus.send(new CompanyListChanged(null, "no parameters"));

View Full Code Here

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

      st.executeUpdate(dcc.filterSQL("DELETE FROM AccountingPeriods WHERE CompId=" + companyId));
      st = dcc.con.createStatement();
      st.executeUpdate(dcc.filterSQL("DELETE FROM AccountType WHERE CompId=" + companyId));
      if (deleteCompanyDef) {
        st = dcc.con.createStatement();
        st.executeUpdate(dcc.filterSQL("DELETE FROM Company WHERE CompId=" + companyId));
      }
      EditBus.send(new CompanyListChanged(null, "no parameters"));
    } catch (Exception e) {
      Log.log(Log.DEBUG, null, "Error in RemoveCompanyFromDatabase= " + e);
    }

View Full Code Here

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

  public static void FillHashTablesWithAccountTypes(Hashtable NumToName,
      Hashtable NumToBalance, Hashtable NameToNum, ArrayList AccNums, int CompId) {
    try {
      DataConnection dc = new DataConnection(null);
      Statement st = dc.con.createStatement();
      ResultSet rs = st.executeQuery(dc.filterSQL(
          "SELECT AccTypeId,TypeName,IsInBalanceReport FROM AccountType " +
          "WHERE CompId=" + CompId + " ORDER BY IsInBalanceReport DESC,SortOrder"));
      boolean isInBalance = false;
      while (rs.next()) {
        if (AccNums != null) {

View Full Code Here

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

    try {
      DataConnection dc = DataConnection.getInstance(view);
      if (dc == null || !dc.bIsConnectionMade) {
        return false;
      }
      PreparedStatement stmt = dc.con.prepareStatement(dc.filterSQL(
          "SELECT * FROM Amount where CompId=? and Account=?"));
      stmt.setInt(1, ((Integer) cc.comboBox.getSelectedItemsKey()).intValue());
      stmt.setInt(2, textField1.getInteger().intValue());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {

View Full Code Here

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

    try {
      DataConnection dc = DataConnection.getInstance(view);
      if (dc == null || !dc.bIsConnectionMade) {
        return false;
      }
      PreparedStatement stmt = dc.con.prepareStatement(dc.filterSQL(
          "SELECT * FROM APP.Account where CompId=? and Account=?"));
      stmt.setInt(1, ((Integer) cc.comboBox.getSelectedItemsKey()).intValue());
      stmt.setInt(2, textField1.getInteger().intValue());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {

View Full Code Here

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

    try {
      DataConnection dc = DataConnection.getInstance(view);
      if (dc == null || !dc.bIsConnectionMade) {
        return false;
      }
      PreparedStatement stmt = dc.con.prepareStatement(dc.filterSQL(
          "SELECT * FROM Activity2 where CompId=?"));
      stmt.setInt(1, textField1.getInteger().intValue());
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {
        CannotUpdateMessage();

View Full Code Here

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

        CannotUpdateMessage();
        return false;
      }
      stmt.close();
      rs.close();
      stmt = dc.con.prepareStatement(dc.filterSQL(
          "SELECT * FROM Account where CompId=?"));
      stmt.setInt(1, textField1.getInteger().intValue());
      rs = stmt.executeQuery();
      if (rs.next()) {
        CannotUpdateMessage();

View Full Code Here

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

        CannotUpdateMessage();
        return false;
      }
      stmt.close();
      rs.close();
      stmt = dc.con.prepareStatement(dc.filterSQL(
          "SELECT * FROM Customer2 where CompId=?"));
      stmt.setInt(1, textField1.getInteger().intValue());
      rs = stmt.executeQuery();
      if (rs.next()) {
        CannotUpdateMessage();

View Full Code Here

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

    try {
      DataConnection dc = DataConnection.getInstance(null);
      if (dc == null || !dc.bIsConnectionMade) {
        return;
      }
      PreparedStatement stmt = dc.con.prepareStatement(dc.filterSQL(
          "INSERT INTO Company (CompId,Name) VALUES(?,?)"));
      stmt.setInt(1, iCompId);
      stmt.setString(2, sCompName);
      stmt.executeUpdate();
      stmt.close();

View Full Code Here

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

    try {
      DataConnection dc = DataConnection.getInstance(null);
      if (dc == null || !dc.bIsConnectionMade) {
        return;
      }
      PreparedStatement stmt = dc.con.prepareStatement(dc.filterSQL(
          "UPDATE Company set Name=? where CompId=?"));
      stmt.setString(1, sCompName);
      stmt.setInt(2, iCompId);
      stmt.executeUpdate();
      stmt.close();

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.