Now I entity class Alarm correlation table Alarm, now I would like to request a second table GROUPVPN two fields, can add the corresponding fields in the entity class? I also have associated entity class list 2 Groupvpn, SQL should be how to write, excuse me? I list traversal is the form of [object, the object, the objcet] or something, because my machine more CARDS, write or want to figure it out first operating time 10 minutes - -,,,

I think is: select a. *, b.s time, b.e time from alarm a and b groupvpn

List=executing SQL statements

If (a list. The size () & gt; 0 & amp; & The list!=null) {
Object [] Object=(Objectp []) list. Get (I);
Alarm Alarm=object [0];
Alarm. SetStime (object [1]);
Alarm. SetEtime (object [2]);

}
Don't know that right

CodePudding user response:

Select a. *, b.s time, b.e time from alarm a and b groupvpn
Lack of related conditions in this statement, a. field=b.
Otherwise, the formation of cartesian product