id, volume, controller, stars, comments, brand, powder_info, machine_name, machine, user, timestamp_ id, powder_number, spoon_picture, bar_code, brand, series, level, version_, age_range, weight_per_spoon, milk_volume_per_spoon, powder_ratio, density, type, status_, created_on INSERT INTO MILK_MAKING_RECORD (VOLUME,CONTROLLER,STARS,COMMENTS,BRAND,POWDER_INFO,MACHINE_NAME,MACHINE,USER,TIMESTAMP_) VALUES (#{volume},#{controller},#{stars},#{comments},#{brand},#{powder_info},#{machine_name},#{machine},#{user},NOW()) UPDATE MILK_MAKING_RECORD SET STARS = #{0}, COMMENTS = #{1} WHERE ID = #{2} SELECT DATE_FORMAT(timestamp_, #{4}) AS #{3}, SUM(volume) AS volume FROM milk_making_record WHERE = #{0}]]> AND AND controller = #{2} AND user = #{5} AND machine = #{6} GROUP BY #{3} SELECT DATE_FORMAT(timestamp_, #{4}) AS #{3}, SUM(volume) AS volume FROM milk_making_record WHERE = #{0}]]> AND AND controller = #{2} AND machine = #{5} GROUP BY #{3} SELECT FROM MILK_MAKING_RECORD WHERE ID = #{0} SELECT FROM MILK_MAKING_RECORD WHERE USER = #{0} SELECT COUNT(1) count,SUM(VOLUME) total FROM MILK_MAKING_RECORD WHERE USER = #{0} INSERT INTO MILK_POWDER_INFO (POWDER_NUMBER,SPOON_PICTURE,BAR_CODE,BRAND,SERIES,LEVEL,VERSION_,AGE_RANGE, WEIGHT_PER_SPOON,MILK_VOLUME_PER_SPOON,POWDER_RATIO,DENSITY,TYPE,STATUS_,CREATED_ON) VALUES (#{powder_number},#{spoon_picture},#{bar_code},#{brand},#{series},#{level},#{version_},#{age_range},#{weight_per_spoon}, #{milk_volume_per_spoon},#{powder_ratio},#{density},#{type},#{status_},NOW()) SELECT FROM MILK_POWDER_INFO WHERE BAR_CODE = #{0} AND UPPER(STATUS_) = 'APPROVED' SELECT series FROM MILK_POWDER_INFO WHERE BRAND LIKE #{brand} AND UPPER(STATUS_) = 'APPROVED' ORDER BY CONVERT(SERIES USING GBK) ASC SELECT level FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT series, level, type, id, powder_ratio, weight_per_spoon FROM MILK_POWDER_INFO WHERE BRAND LIKE #{0} AND UPPER(STATUS_) = 'APPROVED' ORDER BY CONVERT(SERIES USING GBK) ASC SELECT level,type,id,powder_ratio,weight_per_spoon FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT type FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT density FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT powder_ratio FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT id FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT weight_per_spoon FROM MILK_POWDER_INFO WHERE SERIES LIKE #{0} ORDER BY CONVERT(LEVEL USING GBK) ASC SELECT brand FROM MILK_POWDER_INFO WHERE STATUS_ = 'approved' GROUP BY BRAND SELECT FROM MILK_POWDER_INFO WHERE BRAND = #{0} AND SERIES = #{1} AND LEVEL = #{2} SELECT timestamp_ FROM MILK_MAKING_RECORD WHERE CONTROLLER = 'machine' ORDER BY ID DESC LIMIT 1 SELECT machine_mac FROM MACHINE WHERE OWNER = #{0} INSERT INTO milk_making_record (volume, controller, machine, timestamp_, user) VALUE (#{volume}, 'machine', #{machine}, #{timestamp_}, #{user}) INSERT INTO MILK_IMAGES ( IMAGE_MILK_ID,IMAGE_FRONT,IMAGE_BAR,IMAGE_FEED ) VALUES ( #{image_Milk_ID},#{image_Front},#{image_Bar},#{image_Feed} ) SELECT FROM MILK_POWDER_INFO WHERE BAR_CODE = #{0}