コード例 #1
0
  private void initPSID() {
    // psForSelectMINOwnerName = agentName.rlAPI.getPreparedStatementID("SELECT MIN(" +
    // RelationalUtil.getAlias("ownerName") + ") FROM Alert");//No I18N

    psForSelectMINSource =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN(" + RelationalUtil.getAlias("source") + ") FROM Alert "); // No I18N

    psForSelectMINEntity =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("entity")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + "=?"); // No I18N

    psForSelectNEXTOwnerName =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("ownerName")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("ownerName")
                + ">?"); // No I18N

    psForSelectNEXTSource =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("source")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + ">?"); // No I18N

    psForSelectNEXTEntity =
        agentName.rlAPI.getPreparedStatementID(
            "SELECT MIN("
                + RelationalUtil.getAlias("entity")
                + ") FROM Alert where "
                + RelationalUtil.getAlias("source")
                + "=? AND "
                + RelationalUtil.getAlias("entity")
                + ">?"); // No I18N
  }