a.id AS "id", a.user_id AS "userId", a.create_date AS "createDate", a.start_date AS "startDate", a.end_date AS "endDate", a.url AS "url", a.file_name AS "fileName", u.login_name AS "loginName" JOIN jeesite_sys_user u ON a.user_id = u.id SELECT FROM region_export a WHERE a.id = #{id} SELECT FROM region_export a ORDER BY a.create_date desc SELECT FROM region_export a ORDER BY ${page.orderBy} INSERT INTO region_export( id, user_id, create_date, start_date, end_date, url , file_name ) VALUES ( #{id}, #{userId}, #{createDate}, #{startDate}, #{endDate}, #{url}, #{fileName} ) UPDATE region_export SET user_id = #{userId}, start_date = #{startDate}, end_date = #{endDate}, url = #{url}, file_name = #{fileName} WHERE id = #{id} DELETE FROM region_export WHERE id = #{id}