<select id="selctBeanInfo" resultType="com.cn.UserInfo" parameterType="java.lang.Integer"> select * from user_info where status = 0 and TIMESTAMPDIFF(DAY,date_add(add_time, interval 3 YEAR),NOW())>= 0 </select>