private int insertUnassignedRule() throws SQLException {
  PreparedStatement ruleStatement;
  String unassignedRuleSqlStatement="INSERT INTO " + SQL.RULES + " (RULE_NAME, DESCRIPTION, RULE) VALUES ('%s','%s','%s')";
  unassignedRuleSqlStatement=String.format(unassignedRuleSqlStatement,UNASSIGNED_RULE_NAME,UNASSIGNED_RULE_DESCRIPTION,UNASSIGNED_RULE);
  ruleStatement=prepareStatement(unassignedRuleSqlStatement,new String[]{"RULE_INTERNAL_ID"});
  ruleStatement.execute();
  return getInternalId(ruleStatement);
}

private int insertUnassignedRule ( ) throws SQLException { PreparedStatement ruleStatement ; String unassignedRuleSqlStatement = "INSERT INTO " + SQL . RULES + " (RULE_NAME, DESCRIPTION, RULE) VALUES ('%s','%s','%s')" ; unassignedRuleSqlStatement = String . format ( unassignedRuleSqlStatement , UNASSIGNED_RULE_NAME , UNASSIGNED_RULE_DESCRIPTION , UNASSIGNED_RULE ) ; ruleStatement = prepareStatement ( unassignedRuleSqlStatement , new String [ ] { "RULE_INTERNAL_ID" } ) ; ruleStatement . execute ( ) ; return getInternalId ( ruleStatement ) ; }
inserts a new unassigned rule in the database . note , we do not have to check and see if there is an unassigned rule in the rules table already since we only call this method if we haven ' t created an unassigned group yet .
