<? The XML version="1.0" encoding="utf-8"?> 
 
WARNING - @ MBG. Generated 
This element is automatically generated by MyBatis Generator, do not modify. 
This element was generated on Mon Mar 30 20:44:51 CST 2020. 
--> 
 

 

Select fame. Fame_id, fame. Fame_name, fame. Fame_level, engineer_name, getfame. Get_time, getfame. Engineer_id 
The from fame 
The join getfame on fame. Fame_id=getfame. Fame_id 
Join the engine on getfame. Engineer_id=engineer. Engineer_id 
 

Select fame. Fame_id, fame. Fame_name, 
Fame. Fame_level engineer_name, 
Getfame get_time, getfame. Engineer_id 
The from engineer join getfame on engineer. Engineer_id=getfame. Engineer_id 
And getfame. Engineer_id=# {engineerId} 
The join fame on getfame. Fame_id=fame. Fame_id 
And getfame. Fame_id=# {fameId} 
 
 

CodePudding user response:

You can take the SQL out come the results look at the database, the first without conditions just doing even, returns the two tables according to the conditions on the intersection, the second SQL not only done within the company, and even on conditions within the contains two conditions you wrote, id is equal and the and conditions, the connection of time if you want to get the intersection first and then to filter, is in the final add a where clause, all of the connection if is increased when connection condition, use and,

CodePudding user response:

SQL statements in the program run, mybatis log print the execution of SQL, but service with data but an exception is thrown, this kind of circumstance should be a database field is arguably not mapped to a pojo fields, check repeatedly several times, however, are in correspond to it's embarrassing