Mybatis中的查询相关例子

	
		
		
		
		
		
		
		
		
	
	
	
        select job_log_id, job_name, job_group, invoke_target, job_message, status, exception_info, create_time 
		from sys_job_log
    
	
	
		
		
			
				AND job_name like concat('%', #{jobName}, '%')
			
			
				AND job_group = #{jobGroup}
			
			
				AND status = #{status}
			
			
				AND invoke_target like concat('%', #{invokeTarget}, '%')
			
			
				and date_format(create_time,'%y%m%d') >= date_format(#{params.beginTime},'%y%m%d')
			
			
				and date_format(create_time,'%y%m%d') <= date_format(#{params.endTime},'%y%m%d')
			
		
	
	
	
		
	
	
	
		
		where job_log_id = #{jobLogId}
	
	
	
 		delete from sys_job_log where job_log_id = #{jobLogId}
 	
 	
 	
 		delete from sys_job_log where job_log_id in
 		
 			#{jobLogId}
         
 	
 	
 	
        truncate table sys_job_log
    
 	
 	
 		insert into sys_job_log(
 			job_log_id,
 			job_name,
 			job_group,
 			invoke_target,
 			job_message,
 			status,
 			exception_info,
 			create_time
 		)values(
 			#{jobLogId},
 			#{jobName},
 			#{jobGroup},
 			#{invokeTarget},
 			#{jobMessage},
 			#{status},
 			#{exceptionInfo},
 			sysdate()
 		)