a.id AS "id", a.params_name AS "paramsName", a.params_type AS "paramsType", a.params_limit AS "paramsLimit", a.create_time AS "createTime", a.interface_id AS "interfaceId", a.remarks AS "remarks" SELECT FROM api_params a WHERE a.id = #{id} SELECT FROM api_params a AND a.params_name = #{paramsName} AND a.params_type = #{paramsType} AND a.params_limit = #{paramsLimit} AND a.create_time = #{createTime} AND a.interface_id = #{interfaceId} AND a.remarks = #{remarks} ORDER BY ${page.orderBy} SELECT FROM api_params a ORDER BY ${page.orderBy} INSERT INTO api_params( id, params_name, params_type, params_limit, create_time, interface_id, remarks ) VALUES ( #{id}, #{paramsName}, #{paramsType}, #{paramsLimit}, #{createTime}, #{interfaceId}, #{remarks} ) UPDATE api_params SET params_name = #{paramsName}, params_type = #{paramsType}, params_limit = #{paramsLimit}, create_time = #{createTime}, interface_id = #{interfaceId}, remarks = #{remarks} WHERE id = #{id} DELETE FROM api_params WHERE id = #{id}