a.id AS "id", a.inter_name AS "interName", a.inter_url AS "interUrl", a.inter_own AS "interOwn", a.create_time AS "createTime", a.description AS "description", a.version AS "version", a.method AS "method", a.category_id AS "categoryId", a.params AS "params" SELECT FROM api_interface a WHERE a.id = #{id} SELECT FROM api_interface a AND a.inter_name = #{interName} AND a.inter_url = #{interUrl} AND a.inter_own = #{interOwn} AND a.create_time = #{createTime} AND a.description = #{description} AND a.version = #{version} AND a.method = #{method} AND a.category_id = #{categoryId} AND a.params = #{params} ORDER BY ${page.orderBy} SELECT FROM api_interface a ORDER BY ${page.orderBy} INSERT INTO api_interface( id, inter_name, inter_url, inter_own, create_time, description, version, method, category_id, params ) VALUES ( #{id}, #{interName}, #{interUrl}, #{interOwn}, #{createTime}, #{description}, #{version}, #{method}, #{categoryId}, #{params} ) UPDATE api_interface SET inter_name = #{interName}, inter_url = #{interUrl}, inter_own = #{interOwn}, create_time = #{createTime}, description = #{description}, version = #{version}, method = #{method}, category_id = #{categoryId}, params = #{params} WHERE id = #{id} DELETE FROM api_interface WHERE id = #{id}