a.id AS "id", a.name AS "name", a.dept_name AS "deptName", a.admin_name AS "adminName", a.introduction AS "introduction", a.start_time AS "startTime", a.end_time AS "endTime", a.create_date AS "createDate", a.create_by AS "createBy.id", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" SELECT FROM cku_project a WHERE a.id = #{id} SELECT FROM cku_project a a.del_flag = #{DEL_FLAG_NORMAL} AND a.name LIKE concat('%',#{name},'%') AND a.dept_name LIKE concat('%',#{deptName},'%') AND a.admin_name LIKE concat('%',#{adminName},'%') ORDER BY ${page.orderBy} ORDER BY a.create_date desc,id asc SELECT FROM cku_project a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM cku_project a a.del_flag = '0' AND #{year} between DATE_FORMAT(start_time,'%Y') and DATE_FORMAT(end_time,'%Y') ORDER BY a.start_time asc INSERT INTO cku_project( id, name, dept_name, admin_name, introduction, start_time, end_time, create_date, create_by, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{name}, #{deptName}, #{adminName}, #{introduction}, #{startTime}, #{endTime}, #{createDate}, #{createBy.id}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE cku_project SET name = #{name}, dept_name = #{deptName}, admin_name = #{adminName}, introduction = #{introduction}, start_time = #{startTime}, end_time = #{endTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE cku_project SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}