MySQL数据类型转换函数CAST与CONVERT的用法

最新推荐文章于 2026-01-09 14:20:30 发布

转载最新推荐文章于 2026-01-09 14:20:30 发布 · 184 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/flywang/p/8978841.html

文章标签：

#数据库 #java

本文详细解析了一种基于SQL的商户推荐算法，该算法通过综合考量销售数量、咨询次数及其它因素，对商户进行评分并排序，以实现智能推荐。算法中引入了权重分配策略，确保推荐结果的公正性和准确性。

<select id="findAllRecommendSupplier" resultType="java.util.Map">
SELECT s.supplier_id AS supplierId ,s.main_products AS mainProducts
,s.group_id AS groupId,s.head_url AS supplierHead,
s.repair_center_name AS repairCenterName,s.shop_url AS shopUrl
,s.manager_phone AS managerPhone, s.service_tel AS serviceTel,
s.pro_name AS proName ,s.city_name AS cityName ,s.area_name AS
areaName ,s.detailed ,shop_profile AS shopProfile,s.company AS
supplierName,s.head_url AS headUrl
FROM w_supplier_sort w
LEFT JOIN s_supplier s ON w.supplier_id = s.supplier_id
LEFT JOIN s_user u ON w.supplier_id = u.id
WHERE s.city_number = #{cityNumber,jdbcType=VARCHAR} AND
UNIX_TIMESTAMP(NOW())*1000 < s.end_time
AND s.main_products is not NULL AND u.user_state = 0 AND u.account_state = 0
ORDER BY convert((sell_number /#{sellSum,jdbcType=BIGINT} * #{sellFaciend,jdbcType=DECIMAL} +
call_number/#{callSum,jdbcType=BIGINT} * #{callFaciend,jdbcType=DECIMAL}),decimal(18,10))
DESC
</select>