peter petros

Hi everyone,
I need help with an issue I’m facing.

The figure below shows a portion of my model.


Currently, I want to match records from MSG_EXC_REC with those in ERROR_MESSAGE.
Previously, we relied solely on the MSG_ID field for matching. However, we’ve observed that ERROR_MESSAGE contains multiple records with the same MSG_ID.
To resolve this, we’ve decided to use the following criteria for matching:

MSG_ID

DOMAIN

CORRE_ID

MSG_TYPE

SENDER (if in MSG_EXC_REC the value is BE in ERROR it van be ZZZ.BE)

RECIPIENT(if in MSG_EXC_REC the value is BE in ERROR it van be ZZZ.BE)

Moreover, in case of matching we get the record with the minimum received date from ERROR_MESSAGE having M_MIN_DATE <= MSG_REC_DATE.

My existing code can be found below :
 public List<MessageResultType> addErrorMessageInformationToMessages(List<MessageResultType> msgList) {    List<String> messageIds = msgList.stream()        .map(MessageResultType::getMessageId)        .filter(Objects::nonNull)        .collect(Collectors.toList());    List<ErrorMessage906> ie906errors = search906Messages(messageIds); // .... } public List<ErrorMessage906> search906Messages(List<String> messageIds) {    List<ErrorMessage906> ret;    List<Object[]> results = new ArrayList<>();    BatchUtils.doInBatch(messageIds, 1000, batch -> {      StringBuffer qryStr = new StringBuffer() //          .append(              "SELECT "                  + " er.MSG_ID, "                  + " er1.ID, "                  + " er1.ERROR_TYPE, "                  + " er1.POINTER, "                  + " er1.REASON, "                  + " er1.ORIGINAL_VALUE "                  + " FROM ERROR_MESSAGE er "                  + " INNER JOIN ERROR_MESSAGE_906 er1 "                  + " ON (er.ID = er1.EM_ID) "                  + " WHERE "          );      String inMessageIdList = NativeQuerySupport.inClause(batch);      qryStr.append("  er.MSG_ID IN ").append(inMessageIdList); //      Query query = em.createNativeQuery(qryStr.toString());      results.addAll(query.getResultList());    });    ret = results.stream()        .map(erm -> ErrorMessage906.toModel(erm))        .collect(Collectors.toList());    return ret;  }

Below you can find also a helper class to split in batches
public class BatchUtils {  public static <T, C extends Collection<T>> List<C> split(C collection, int batchSize) {    AtomicInteger counter = new AtomicInteger();    Map<Integer, List<T>> grouped = collection.stream()        .collect(Collectors.groupingBy(it -> counter.getAndIncrement() / batchSize));    return grouped.values().stream()        .map(list -> (C) createCollection(collection, list))        .collect(Collectors.toList());  }  @SuppressWarnings("unchecked")  private static <T, C extends Collection<T>> C createCollection(C col, Collection<T> elements)      throws RuntimeException {    C newCollection;    if (col instanceof List) {      newCollection = (C) new ArrayList<>(elements);    } else if (col instanceof Set) {      newCollection = (C) new HashSet<>(elements);    } else if (col instanceof Queue) {      newCollection = (C) new LinkedList<>(elements);    } else {      throw new IllegalArgumentException("Unsupported collection type: " + col.getClass());    }    return newCollection;  }  public static <T, C extends Collection<T>> void doInBatch(C list, int batchSize, Consumer<C> function) {    List<C> batchedList = split(list, batchSize);    batchedList.forEach(function);  } }

To support the modifications
I have created a new class
import java.time.LocalDateTime; public class ErrorMessageCriteria {  private String messageId;  private String domain;  private String msgType;  private String sender;  private String recipient;  private String correlId;  private LocalDateTime minDate;  public ErrorMessageCriteria(String messageId, String domain, String msgType, String sender, String recipient,      String correlId, LocalDateTime minDate) {    this.messageId = messageId;    this.domain = domain;    this.msgType = msgType;    this.sender = sender;    this.recipient = recipient;    this.correlId = correlId;    this.minDate = minDate;  }  public String getMessageId() {    return messageId;  }  public String getDomain() {    return domain;  }  public String getMsgType() {    return msgType;  }  public String getSender() {    return sender;  }  public String getRecipient() {    return recipient;  }  public String getCorrelId() {    return correlId;  }  public LocalDateTime getMinDate() {    return minDate;  } }

and I have modified the code as below
public List<MessageResultType> addErrorMessageInformationToMessages(List<MessageResultType> msgList) {    List<ErrorMessageCriteria> criteria906 = new ArrayList<>();    for (MessageResultType message : msgList) {      if (message.getMessageId() != null) {        ErrorMessageCriteria criteria = new ErrorMessageCriteria(            message.getMessageId(),            message.getDomain(),            message.getMessageType(),            message.getSender(),            message.getRecipient(),            message.getCorrelId(),            message.getMinDate()        );        if (message.getMessageType().contains("906") ) {          criteria906.add(criteria);        }      }    }    List<ErrorMessage906> ie906errors = criteria906.isEmpty() ? new ArrayList<>()        : search906Messages(criteria906); //... }  public List<ErrorMessage906> search906Messages(List<ErrorMessageCriteria> criteriaList) {    return searchMessages(        criteriaList, ErrorMessage906::toModel, "ERROR_MESSAGE_906",        "er1.ID, er1.ERROR_TYPE, er1.POINTER, er1.REASON, er1.ORIGINAL_VALUE"    );  } private <T> List<T> searchMessages(List<ErrorMessageCriteria> criteriaList, Function<Object[], T> mapper, String tableName, String columns) {    List<Object[]> results = new ArrayList<>();    StringBuilder queryTemplate = buildQuery(tableName, columns);    for (ErrorMessageCriteria criteria : criteriaList) {      Query query = em.createNativeQuery(queryTemplate.toString());      setQueryParameters(query, criteria);      results.addAll(castResultList(query.getResultList(), Object[].class));    }    return results.stream().map(mapper).collect(Collectors.toList());  }  private StringBuilder buildQuery(String tableName, String columns) {    return new StringBuilder()        .append("SELECT er.MSG_ID, ")        .append(columns)        .append(" FROM ERROR_MESSAGE er ")        .append(" INNER JOIN ").append(tableName).append(" er1 ON er.ID = er1.EM_ID ")        .append(" WHERE er.MSG_ID = ?messageId ")        .append("  AND er.DOMAIN = ?domain ")        .append("  AND er.MSG_TYPE = ?msgType ")        .append("  AND SUBSTR(er.SEND_C_CODE, INSTR(er.SEND_C_CODE, '.') + 1) = ?sender ")        .append("  AND SUBSTR(er.REC_C_CODE, INSTR(er.REC_C_CODE, '.') + 1) = ?recipient ")        .append("  AND (?correlId IS NULL OR er.CORREL_ID = ?correlId) ")        .append("  AND er.MSG_REC_DATE = ( ")        .append("      SELECT MIN(em2.MSG_REC_DATE) ")        .append("        FROM ERROR_MESSAGE em2 ")        .append("       WHERE em2.MSG_ID = er.MSG_ID ")        .append("         AND em2.DOMAIN = er.DOMAIN ")        .append("         AND em2.MSG_TYPE = er.MSG_TYPE ")        .append("         AND em2.SEND_C_CODE = er.SEND_C_CODE ")        .append("         AND em2.REC_C_CODE = er.REC_C_CODE ")        .append("         AND (?correlId IS NULL OR em2.CORREL_ID = er.CORREL_ID) ")        .append("         AND em2.MSG_REC_DATE >= ?minDate)");  }  private void setQueryParameters(Query query, ErrorMessageCriteria criteria) {    query.setParameter("messageId", criteria.getMessageId());    query.setParameter("domain", criteria.getDomain());    query.setParameter("msgType", criteria.getMsgType());    query.setParameter("sender", criteria.getSender());    query.setParameter("recipient", criteria.getRecipient());    query.setParameter("correlId", criteria.getCorrelId());    query.setParameter("minDate", Timestamp.valueOf(criteria.getMinDate()));  }  private <T> List<T> castResultList(List<?> rawList, Class<T> clazz) {    List<T> resultList = new ArrayList<>();    for (Object obj : rawList) {      if (clazz.isInstance(obj)) {        resultList.add(clazz.cast(obj));      } else {        throw new ClassCastException("Unexpected result type: " + obj.getClass().getName());      }    }    return resultList;  }

However, with this approach, I would need to execute one query per row of criteria.
Is there a more efficient way to perform this matching in batches? Additionally, in cases where multiple rows match, I’d like to apply a date comparison to determine the best match.

Any guidance would be greatly appreciated!

There are materialised views in db.
The code is just a demo class for explaining what is the issue.

Hi all,
I have three materialized views in my project
MV_MSG_EXC_REC_HISTORY : Summarizes message data for the past two years up to the beginning of the current year.
MV_MSG_EXC_REC_RECENT : Summarizes message data from the beginning of the current year up to the current day.
MV_MSG_EXC_REC_CURRENT_DAY : Summarizes messages for the current day, grouping by minute-level timestamps and updating based on the nearest half-hour.

From the ui of the application I have two criteria, let it be "From" and "To"
I want when user adds these criteria to translate it to Java in a Map<String, Pair<LocalDateTime, LocalDateTime>> which contains the name of the MV, the start_date and end_date in order to construct queries like below :
eg.
select SUM(CNT)  from MV_MSG_EXC_REC_HISTORY where min_date >= start_date   and min_date <= end_date;

I want to have 4 cases :
1. Both dates are filled then -> where min_date >= start_date and min_date <= end_date
2. Left date is null then  -> where min_date <= end_date
3. Right date is null then -> where min_date >= start_date
4. Both dates null then -> no where clause

Examples :
Supposing I have the below ranges for all the cases
MV_MSG_EXC_REC_HISTORY: 2022-01-01T00:00 - 2023-12-31T23:59:59.999
MV_MSG_EXC_REC_RECENT: 2024-01-01T00:00 - 2024-11-04T23:59:59.999
MV_MSG_EXC_REC_CURRENT_DAY: 2024-11-05T00:00 - 2024-11-05T07:30:00
====================
Case 1
And user selects the below from UI
From: 2023-01-01T00:00:03
To: 2024-10-10T03:56:04.235

I want to make a Map<String, Pair<LocalDateTime, LocalDateTime>> like
Map<String, Pair<LocalDateTime, LocalDateTime>> dateRanges = new HashMap<>(); dateRanges.put(MV_MSG_EXC_REC_HISTORY, Pair.of(LocalDateTime.of(2023, 1, 1, 0, 0), null)); dateRanges.put(MV_MSG_EXC_REC_RECENT, Pair.of(null, LocalDateTime.of(2024, 10, 10, 3, 57)));
(the left date should be floored in minute level and the right date to be ceiled to next minute)

Case 2
And user selects the below from UI
From: 2023-01-01T00:00:03
To: 2024-12-31T03:56:04.235 (larger than current_date)
====================
Map<String, Pair<LocalDateTime, LocalDateTime>> dateRanges = new HashMap<>(); dateRanges.put(MV_MSG_EXC_REC_HISTORY, Pair.of(LocalDateTime.of(2023, 1, 1, 0, 0), null)); dateRanges.put(MV_MSG_EXC_REC_RECENT, Pair.of(null, null)); dateRanges.put(MV_MSG_EXC_REC_CURRENT_DAY, Pair.of(null, null));

Case 3
I have the below ranges
MV_MSG_EXC_REC_HISTORY: 2022-01-01T00:00 - 2023-12-31T23:59:59.999
MV_MSG_EXC_REC_RECENT: 2024-01-01T00:00 - 2024-11-04T23:59:59.999
MV_MSG_EXC_REC_CURRENT_DAY: 2024-11-05T00:00 - 2024-11-05T07:30:00
====================
And user selects the below from UI
From: 2023-01-01T00:00:03
To: 2024-11-03T03:56:04.235 (smaller than current_date)
====================
Map<String, Pair<LocalDateTime, LocalDateTime>> dateRanges = new HashMap<>(); dateRanges.put(MV_MSG_EXC_REC_HISTORY, Pair.of(LocalDateTime.of(2023, 1, 1, 0, 0), null)); dateRanges.put(MV_MSG_EXC_REC_RECENT, Pair.of(null, null)); dateRanges.put(MV_MSG_EXC_REC_CURRENT_DAY, Pair.of(null, LocalDateTime.of(2024, 11, 3, 3, 57)));


My code is below :
import java.io.Serializable; public class Pair<L, R> implements Serializable {    private static final long serialVersionUID = 1L;    private L left;    private R right;    public Pair() {}    public Pair(L left, R right) {        this.left = left;        this.right = right;    }    public static <L, R> Pair<L, R> of(L left, R right) {        return new Pair<>(left, right);    }    public L left() {        return left;    }    public R right() {        return right;    }    public L getLeft() {        return left;    }    public R getRight() {        return right;    }    @Override    public int hashCode() {        final int prime = 31;        int result = 1;        result = prime * result + ((left == null) ? 0 : left.hashCode());        result = prime * result + ((right == null) ? 0 : right.hashCode());        return result;    }    @Override    public boolean equals(Object obj) {        if (this == obj) return true;        if (obj == null || getClass() != obj.getClass()) return false;                Pair<?, ?> other = (Pair<?, ?>) obj;        if (left == null) {            if (other.left != null) return false;        } else if (!left.equals(other.left)) return false;        if (right == null) {            if (other.right != null) return false;        } else if (!right.equals(other.right)) return false;        return true;    } }

import java.time.LocalDateTime; import java.util.AbstractMap; import java.util.ArrayList; import java.util.LinkedHashMap; import java.util.List; import java.util.Map; class Main {    private static final String MV_MSG_EXC_REC_HISTORY = "MV_MSG_EXC_REC_HISTORY";    private static final String MV_MSG_EXC_REC_RECENT = "MV_MSG_EXC_REC_RECENT";    private static final String MV_MSG_EXC_REC_CURRENT_DAY = "MV_MSG_EXC_REC_CURRENT_DAY";    private List<Pair<String, Object>> params;    public static void main(String[] args) {        // Example usage of getDbMvRanges        Map<String, Pair<LocalDateTime, LocalDateTime>> ranges = getDbMvRanges();        ranges.forEach((key, value) -> {            System.out.println(key + ": " + value.getLeft() + " - " + value.getRight());        });        System.out.println("====================");                // Example usage of getUiDates        Pair<LocalDateTime, LocalDateTime> uiDates = getUiDates();        System.out.println("\nFrom: " + uiDates.getLeft());        System.out.println("To: " + uiDates.getRight());                System.out.println("====================");                // Example usage of getMvNames         LocalDateTime currentTime = LocalDateTime.now();        Map<String, Pair<LocalDateTime, LocalDateTime>> mvNames = getMvNames(currentTime);        mvNames.forEach((key, value) -> {            System.out.println(key + ": " + value.getLeft() + " - " + value.getRight());        });    }    private static Pair<LocalDateTime, LocalDateTime> getUiDates() {        LocalDateTime fromDate = LocalDateTime.of(2024, 1, 1, 0, 0, 0);        LocalDateTime toDate = LocalDateTime.of(2024, 10, 10, 3, 56, 4, 235_000_000);        return Pair.of(fromDate, toDate);    }        private static Map<String, Pair<LocalDateTime, LocalDateTime>> getDbMvRanges() {        Map<String, Pair<LocalDateTime, LocalDateTime>> ranges = new LinkedHashMap<>();                // Define the date ranges based on your requirements        ranges.put(MV_MSG_EXC_REC_HISTORY, Pair.of(            LocalDateTime.of(2022, 1, 1, 0, 0),            LocalDateTime.of(2023, 12, 31, 23, 59, 59, 999_000_000)        ));        ranges.put(MV_MSG_EXC_REC_RECENT, Pair.of(            LocalDateTime.of(2024, 1, 1, 0, 0),            LocalDateTime.of(2024, 11, 4, 23, 59, 59, 999_000_000)        ));        ranges.put(MV_MSG_EXC_REC_CURRENT_DAY, Pair.of(            LocalDateTime.of(2024, 11, 5, 0, 0),            LocalDateTime.of(2024, 11, 5, 7, 30, 0, 0)        ));        return ranges;    }            private static Map<String, Pair<LocalDateTime, LocalDateTime>> getMvNames(LocalDateTime currentTime) {        Map<String, Pair<LocalDateTime, LocalDateTime>> mvNamesWithDateRanges = new LinkedHashMap<>();                Pair<LocalDateTime, LocalDateTime> dateRange = getUiDates();        LocalDateTime fromUiDateTime = dateRange.getLeft();        LocalDateTime toUiDateTime = dateRange.getRight();        // Define the ranges based on the current time        Map<String, Pair<LocalDateTime, LocalDateTime>> ranges = getDbMvRanges();        // If dates are missing or "from" is after "to", return empty map        if (fromUiDateTime == null || toUiDateTime == null || fromUiDateTime.isAfter(toUiDateTime)) {            return mvNamesWithDateRanges;        }        // Iterate over the ranges and check if the UI dates fall within any of these ranges        for (Map.Entry<String, Pair<LocalDateTime, LocalDateTime>> entry : ranges.entrySet()) {            LocalDateTime rangeStart = entry.getValue().getLeft();            LocalDateTime rangeEnd = entry.getValue().getRight();            boolean fromInRange = !fromUiDateTime.isBefore(rangeStart) && !fromUiDateTime.isAfter(rangeEnd);            boolean toInRange = !toUiDateTime.isBefore(rangeStart) && !toUiDateTime.isAfter(rangeEnd);            if (fromInRange || toInRange) {                mvNamesWithDateRanges.put(entry.getKey(), entry.getValue());            }        }        // Check if "to" is greater than the current time        if (toUiDateTime.isAfter(currentTime)) {            mvNamesWithDateRanges.put(MV_MSG_EXC_REC_CURRENT_DAY, ranges.get(MV_MSG_EXC_REC_CURRENT_DAY));        }        // Check for specific entries and add "MV_MSG_EXC_REC_RECENT" if both are present        boolean containsHistory = mvNamesWithDateRanges.containsKey(MV_MSG_EXC_REC_HISTORY);        boolean containsCurrentDay = mvNamesWithDateRanges.containsKey(MV_MSG_EXC_REC_CURRENT_DAY);        if (containsHistory && containsCurrentDay) {            mvNamesWithDateRanges.put(MV_MSG_EXC_REC_RECENT, ranges.get(MV_MSG_EXC_REC_RECENT));        }        return mvNamesWithDateRanges;    } }

can you help me please to do the getMvNames to works as expected ?
as now it works with MV ranges

Thanks a lot

Thanks a lot for your post

Hi, I have a class as follow :

public class ConsistencyRule {  public enum Operator {    LT("<"), LE("<="), EQ("="), MT(">"), ME(">=");    private final String operationSymbol;    Operator(String operationSymbol) {      this.operationSymbol = operationSymbol;    }    public static Operator fromValue(String v) {      return valueOf(v);    }    public String getOperationSymbol() {      return operationSymbol;    }  }  final private List<String> leftOperands;  final private List<String> rightOperands;  final private Operator operator;  public ConsistencyRule(List<String> leftOperands, Operator operator,      List<String> rightOperands) {    this.leftOperands = leftOperands;    this.operator = operator;    this.rightOperands = rightOperands;  } public static class Builder {    final private List<String> leftOperands = new ArrayList<>();    final private List<String> rightOperands = new ArrayList<>();    private Operator operator;    public Builder operator(Operator operator) {      this.operator = operator;      return this;    }    public Builder leftOperand(String operand) {      leftOperands.add(operand);      return this;    }    public Builder rightOperand(String operand) {      rightOperands.add(operand);      return this;    }    public ConsistencyRule build() {      Assert.isTrue(CommonUtils.isNotEmpty(leftOperands));      Assert.isTrue(CommonUtils.isNotEmpty(rightOperands));      Assert.notNull(operator);      return new ConsistencyRule(leftOperands, operator, rightOperands);    }  } }


Until now, I had expressions with the operator on penultimate position ie BBB-CCC-DDD-LE-CC

String rule = "BBB-CCC-DDD-LE-CC"; List<String> ruleSteps = Splitter.on("-").omitEmptyStrings().trimResults()              .splitToList(rule); String rightOperand = ruleSteps.get(ruleSteps.size() - 1); Operator operator = Operator.fromValue(ruleSteps.get(ruleSteps.size() - 2)); List<String> leftsOperands = new ArrayList<>(); for (int i = 0; i < ruleSteps.size() - 2; i++) {            leftsOperands.add(ruleSteps.get(i)); } ConsistencyRule consistencyRule = new ConsistencyRule(leftsOperands, operator, Arrays.asList(rightOperand));

Now the operator can be on previous positions such as BBB-CCC-DDD-LE-AA-CC

Could you help me please ?

Carey Brown wrote:What library are you using to interface with excel? POI?

yes I am using org.apache.poi

Hello,
I have a LocalDateTime field which I pass it as parameter in a method setCell of an interface (for creating excel) as below :

             Cell sent = row.getCell(3);  sent.setCellValue(Objects.toString(message.getSendDate(), null)));

When I open the excel I see that the column with the date cannot be sorted as expected as the value is defined as String
2023-06-23T16:01:19.797

Is there any way to replace the T with a space ?

import java.time.*; import java.util.Objects;   class HelloWorld { private static LocalDateTime removeT(LocalDateTime t){       LocalDate currentDate = t.toLocalDate();   LocalTime currentTime = t.toLocalTime();   LocalDateTime fromDateAndTime = LocalDateTime.of(currentDate, currentTime);   return fromDateAndTime; }    public static void main(String[] args) {                // create an LocalDateTime object        LocalDateTime lt = LocalDateTime.now() ;          // print result        System.out.println("LocalDateTime : " + lt + "\n");        System.out.println("LocalDateTime : " + removeT(lt));    } }

The method setCellValue is able to have as parameter one of the following classes
Date, LocalDate, LocalDateTime, Calendar

Could you help me please ?
Thanks in advance

Hi all,
I want to make an integration test and as first step I have to insert some data to a table.

Let the table be 'TABLE_1' with the columns id (number) and comment (blob).

I want to insert value 1 and a empty test.xlsx file.

@TestSuite(name = "IT Tests") @RunWith(TestRunner.class) public class CallWS{  @Inject  private JdbcClient jdbcClient;  @TestCase(name = "IT Test 1")  public void test1() {               // The value is larger but I have limitation on my post        String base64Comment = "UEsDBBQABgAIAAAAIQCkU8XPTgEAAAgEAAAT.......";        jdbcClient.createQuery(            "INSERT INTO TABLE1(ID, COMMENT)"                + " VALUES (1, '" + base64Comment + "')")            .executeUpdate();  } }

But I get the following error :
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01704: string literal too long

And I dont know if it is what I need.

Can I make somehow differently ?

For example creating a File and without having all this string ?

Thanks in advance for your help

Hi all,
I am working on a multimodule application as follow :


I want to read the file configuration.properties from TestService.java

I have created the following code :

 private Properties getPropertiesByFilename(String filename) {    Properties props = new Properties();    try {      props.load(          Thread.currentThread().getContextClassLoader().getResourceAsStream(filename));    } catch (IOException e) {      e.printStackTrace();    }    return props;  }

and I call the method
Properties properties = getPropertiesByFilename("configuration.properties");

The problem is that I get NullPointerException as I cannot find the file.

I tried to move the file in the same path with TestService.java and it works as expected

Any ideas how to solve this problem ?

Thanks in advance

Thanks a lot for your answer

Hi all, I am trying to make a method to return Map<Pair<String, String>, Set<String>>.
But I don't know how ..

Suppose I have a class called Person with attributes Name and Surname
public class Person {    private String name;    private String surname;        public Person(String name, String surname) {        this.name = name;        this.surname = surname;    }    public String getName() {        return name;    }    public String getSurname() {        return surname;    } }

I also have a method which returns a list of Person objects

public List<Person> getPersons(){      List<Person> people = List.of(        new Person("ADAM", "JOHNSON"),        new Person("OLIVER", "SMITH"),        new Person("JOHN", "JOHNSON"),        new Person("ADAM", "JOHNSON"),        new Person("OLIVER", "JONES")      );    return people; }
 
I want to make a method returning the map which consists of
Key : a Pair object phase_name and distinct Person name
Value : an ordered set of surnames for the specific phase and Person name

public Map<Pair<String, String>, Set<String>> getData(){    List<Person> personFullNames;    List<String> allPhases = Arrays.asList("PHASE_1"); // it will be extended for more phases later    Map<Pair<String, String>, Set<String>> map = new HashMap<>();    Set<String> set = new HashSet<>(); personFullNames = new ArrayList<>(); for(String phase : allPhases){  personFullNames.addAll(getPersons()); }    // I don't know how to do it ..    return map; }

Expected, something like that :
  Map<Pair<"PHASE_1", "ADAM">, SET<"JOHNSON">>
  Map<Pair<"PHASE_1", "OLIVER">, SET<"JONES","SMITH">>
  Map<Pair<"PHASE_1", "JOHN">, SET<"JOHNSON">>

Thanks in advance for your help

Hi all, I would like to save an image in an Image variable of a class.

My class is the Student

public class Student {    protected String Fname;    protected String Lname;    protected String Gender;    protected Date Dob;    protected Image img;    public Student(String Fname, String Lname, String Gender, Date Dob) {        this.Fname     = Fname;        this.Lname     = Lname;        this.Gender    = Gender;        this.Birthday  = Dob; this.img = img;    } //getters and setters }


And in a form I have declared an array list : List<Student> list;
And an JDesktopPane with a label included lbl_image   and a button called jMenuItem1

private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                                  JFileChooser chooser = new JFileChooser();        chooser.showOpenDialog(null);        File f = chooser.getSelectedFile();                filename = f.getAbsolutePath();        ImageIcon imageIcon = new ImageIcon(new ImageIcon(filename).getImage().getScaledInstance(lbl_img.getWidth(), lbl_img.getHeight(), Image.SCALE_DEFAULT));        lbl_img.setIcon(imageIcon);      try {            File image = new File(filename);            FileInputStream fis = new FileInputStream (image);            ByteArrayOutputStream bos= new ByteArrayOutputStream();            byte[] buf = new byte[1024];            for(int readNum; (readNum=fis.read(buf))!=-1; ){                bos.write(buf,0,readNum);            }            person_image=bos.toByteArray();        }        catch(Exception e){            JOptionPane.showMessageDialog(null,e);        }          }        
How can I set the img to the database ?

Hi all,
I have 20 jtable with names TABLE_1, ... ,TABLE_20   (in a pannelTab)
In these tables I have data of list   List<STUDENT> students based on some criteria.

Moreover, I am using 20 DefaultTableModel called model1, ...model20

I want to click on a button and edit a row of the STUDENT but I don;t know how can I
get the current tab in order to use the appropriate model.

Could you help me please with an example ?

   private void EditStudentButtonActionPerformed(java.awt.event.ActionEvent evt) {                                                    }    

Paul Clapham wrote:In general I would recommend not mixing AWT components (e.g. Applet) with Swing components (e.g. JLabel). If you do you will see strange things happening. And in specific... do you have a question about that code? It's hard to do much without a question to answer.

I changed my code to

import java.awt.*; import java.awt.event.*; import java.awt.image.*; import javax.swing.*; public class pUZZLE extends JApplet implements ActionListener { Image image; ImageIcon icon; JButton buttons[ ], blankButton,newGame; JPanel grid; JPanel spots[]; int currentBlankSpot; int movecounter = 0; JLabel moves_label; public void init( ) { setSize( 600,600); setLayout( new FlowLayout() ); buttons = new JButton[9]; newGame = new JButton("New Game"); grid = new JPanel( new GridLayout(3,3) ); setupPanels( ); setupImage( ); grid.setSize(450,450); add(newGame); add(grid); moves_label = new JLabel("moves: "+Integer.toString(movecounter)); add(moves_label,"South"); newGame.addActionListener(this); } public void setupPanels( ) { spots = new JPanel[9]; blankButton = new JButton( " "); blankButton.setBackground( Color.BLACK ); for( int i=0; i<spots.length; i++ ) { spots[i] = new JPanel( new BorderLayout( )); grid.add(spots[i]); } } public void setupImage( ) { image = getImage(getCodeBase(), "numbers.jpg"); MediaTracker tracker = new MediaTracker(this); tracker.addImage(image,1); try{ tracker.waitForAll(); } catch(Exception e) { } BufferedImage bimage = new BufferedImage( image.getWidth(null),image.getHeight(null),BufferedImage.TYPE_INT_ARGB); Graphics g = bimage.getGraphics( ); g.drawImage(image,0,0,this); int width=image.getWidth(this); int height=image.getHeight(this); System.out.println( width + " h = " + height ); int count = 0; for( int i=0; i<3; i++ ) for( int j=0; j<3; j++ ) { BufferedImage window = bimage.getSubimage(i*width/3,j*height/3,width/3,height/3); setupButton( count++, window ); } spots[spots.length-1].add(blankButton); currentBlankSpot = spots.length-1; } public void setupButton( int id, Image img ) { buttons[id] = new JButton( new ImageIcon(img) ); buttons[id].addActionListener(this); buttons[id].setMargin(new Insets(0,0,0,0) ); buttons[id].setContentAreaFilled(false); spots[id].add(buttons[id],BorderLayout.CENTER); } public void actionPerformed(ActionEvent ae ) { Object src = ae.getSource(); if( newGame == src ) { movecounter = 0; moves_label.setText("moves: "+ Integer.toString( movecounter)); init(); repaint(); return; } for( int i=0; i><buttons.length; i++ ) { if( buttons[i] == src ) { if( currentBlankSpot - 1 == i || currentBlankSpot - 3 == i || currentBlankSpot + 1 == i || currentBlankSpot + 3 == i ) { movecounter++; moves_label.setText("moves: "+Integer.toString( movecounter)); spots[currentBlankSpot].removeAll(); spots[i].removeAll(); spots[currentBlankSpot].add(buttons[i]); spots[i].add(blankButton); buttons[currentBlankSpot] = buttons[i]; buttons[i] = blankButton; currentBlankSpot = i; repaint(); return; } } } } }


Questions
1. I want the new game button to start the game from the beginning.
I call init() but the image is not initialised.

2. I would like the order of panels to be vertical structured like :
New Game
Grid
moves

Could someone help me please?>

Hi,
I want to make an applet game like this on url :


webpage

Could someone help me please ???

I am trying to write code but I don;t know good java.
My code is :

import javax.swing.*; import java.applet.*; import java.awt.*; import java.awt.event.*; import java.lang.reflect.*; public class SApplet extends Applet implements ActionListener { TextField input,output; Label label1,label2, label3, label4, label5, label6; JButton[] buttons = new JButton[9]; JLabel lbl; int num, sum = 0,i; int[] test = {2,1,3,8,7,5,6,4,0}; int metrhths = 0; Label metrhthsl; public void init(){ GridLayout layout = new GridLayout(4,3); setLayout(layout); Label keno = new Label(""); Label keno2 = new Label(""); metrhthsl = new Label("moves: "+Integer.toString(metrhths)); for(i=0;i<9;i++){ buttons[i]=new JButton(Integer.toString(test[i])); add(buttons[i]); buttons[i].addActionListener(this); } add(keno); add(metrhthsl); add(keno2); } public int getArrayIndex(int[] myArray, int myObject) { int ArraySize = Array.getLength(myArray); for (int i = 0; i < ArraySize; i++) { if (myArray[i] == myObject) { return(i); } } return(-1); } public void actionPerformed(ActionEvent ae){ metrhths +=1; metrhthsl.setText("moves: "+Integer.toString(metrhths)); //add(metrhthsl); Object source = ae.getSource(); String label = ae.getActionCommand(); int labelint = Integer.parseInt(label); int index=getArrayIndex(test, labelint); if((buttons[index+1].getText()).equals("0")){ // if(source==buttons[1]){ int[] test2 = {1,1,3,8,7,5,6,4,0}; for(i=0;i<9;i++){ buttons[i].setText(Integer.toString(test2[i])); } } } }

thanks a lot